Configuration Manager - Commerce - Database

Use the Database panel of the Configuration Manager to configure WebSphere Commerce to work with your database.

In the WebSphere Commerce instance creation wizard, the fields described here appear on the Database and Schema panels.

The fields that are displayed on the Database page differ significantly when you run Configuration Manager on different operating systems.

To move quickly to the panel for which you want help, click one of the following links:

Database panel
Schema panel

Complete the fields in the Database panel

Database

This option is available in the Instance Creation wizard only. Select one of the available options:

If you want to create the WebSphere Commerce database and populate the database, select Create a new DB2 database or Oracle tablespace.
If you want to create and populate a tablespace in the WebSphere Commerce database, select Create a new DB2 database or Oracle tablespace.
The Oracle database must be created before you install WebSphere Commerce by following the instructions in the IBM Knowledge Center.
If you want to use an existing WebSphere Commerce database or tablespace, select Use an existing DB2 database or Oracle tablespace.
When you use an existing WebSphere Commerce database, ensure that the Database name field on the Schema panel of the Instance Creation wizard matches the name of the existing WebSphere Commerce database.
Notes on using an existing database:
- Ensure that the schema user exists on the database machine.
- Ensure that the existing database is empty. Instance creation fails if the tables in the existing database contain any data.
- The existing WebSphere Commerce database or tablespace must be a database or tablespace for WebSphere Commerce Version 8.0. Databases or tablespaces from prior versions of WebSphere Commerce must be migrated before they can be used as a WebSphere Commerce 8.0 database or tablespace. Migration instructions are provided in the IBM Knowledge Center.

Database type

Select the product that you want to use as your database management system.

Selecting Oracle as your database type enables the following fields:

Oracle SID

The Oracle database SID. The Oracle SID is not the same as the Oracle Service Name.

The name that you provide in the Oracle SID field must be the same as the name you provide in the Database name field.

Database server port

Enter the port number on which your remote database server is running. The default port is 1521.

Full path to datafile

Enter the full path to the WebSphere Commerce datafile (.DBF file) on the Oracle server. The default path is,

Oracle_installdir/database/wcs.dbf

tablespace Name

Enter the name of the tablespace for Configuration Manager to create and populate in the Oracle database you created for use by the WebSphere Commerce Server.

Temporary tablespace

Enter the name of the temporary tablespace for Configuration Manager to create in the WebSphere Commerce database that you created for use by the WebSphere Commerce Server.

Database administrator name

DB2 Enter the local operating system user ID for your database administrator, the database instance owner ID. This name is an existing user ID that is associated with the existing DB2 instance.

Oracle Enter the Oracle ID for the database administrator. You cannot use the Oracle ID SYS as the database administrator name.

Database administrator password

Enter the password of the database administrator.

Database administrator home directory

Enter the home directory of the database administrator ID. The home directory is used to locate the profile of the database administrator during environment setup for instance creation.

This field is not displayed if you chose to use Oracle database.

Database name

Enter the name of the database to create, or enter the name of an existing database that you want to associate with the instance that you are creating.

DB2 The database name must contain 8 characters or fewer.

Oracle The name that you provide in the Database name field must be the same as the name you provide in the Oracle SID field.

Remote

Select this check box if your database server software is on a different machine than your WebSphere Commerce Server.

Note: If you installed your database server on a different node than WebSphere Commerce (for example, if you are configuring a three-node environment), then you must select this check box.

Selecting this check box enables the following fields:

Database server host name

Enter the fully qualified host name of the machine that hosts your database software.

Database node name

Enter the node name that you used when you cataloged the node for your remote database. If you did not catalog a node for your remote database, Configuration Manager catalogs a node for you.

Do not use db2 anywhere in the node name. A node name that contains db2 causes instance creation to fail.

The node name must contain 8 characters or less.

Database server port

Enter the port number on which your remote database server is running. The default port is 50000.

Advanced Options

The Advanced Options check box is available in the Instance Creation wizard.

Select Advanced Options to set the advanced settings for the database during instance creations.

If you selected DB2 as the database type, the following fields are available:

Default application heap (4KB): Enter the number of 4 KB blocks you would like the default application heap to use for the WebSphere Commerce database.
SQL statement heap (4KB): Enter the number of 4 KB blocks you would like the SQL statement heap to use for the WebSphere Commerce database.
Max. appl. control heap size (4KB): Enter the number of 4 KB blocks you would like the maximum application control heap size to be for the WebSphere Commerce database.
Max storage for lock list (4KB): Enter the number of 4 KB blocks you would like the maximum storage for the lock list to be for the WebSphere Commerce database.

If you selected Oracle as the database type, the following fields are available:

tablespace Size (MB): Enter the tablespace size (in MB) you would like defined when Configuration Manager creates and populates the WebSphere Commerce database.

pureScale database

Select this option if you want to use a pureScale database.

Generate properties file only

This check box displays in the Instance Creation wizard only.

Select this check box if you do not want to create an instance but you want to populate a properties file. The properties file can be used with the CreateInstance Ant target to create a WebSphere Commerce instance.

The properties file is found in WC_installdir/instances/instance_name/properties/createInstance.properties.

Complete the fields in the Schema panel:

Schema

This option is available in the Instance Creation wizard if you chose to use an existing database. Select one of the options available:

If you want to create the WebSphere Commerce schema in the database, select Create WebSphere Commerce schema.
If you want to use an existing WebSphere schema, select Use existing WebSphere Commerce schema. If you choose to use an existing WebSphere Commerce schema, ensure that no bootstrap data or stored procedures exist. Otherwise, this target does not run successfully.
Only tables, views, and indexes can exist in the schema at the time of instance creation. If there are constraints, stored procedures, or if the database was previously populated, instance creation fails.

Oracle instance userid

Enter the Oracle user ID of the user who issues Oracle commands.

Database user name

DB2 Enter an existing operating system user ID to use for this database. The user ID must be defined on the system on which DB2 Universal Database is installed. The user ID must be able to access the database and have the following DB2 Universal Database permissions:

createtab
binadd
connect

The user ID must also have permissions to create tables in the target tablespaces.

Oracle Enter the Oracle user ID for this database that the Instance Creation wizard creates in this process. Do not enter an existing Oracle user ID.

Database user password

Enter the password that is associated with the user name for this database.

Confirm Database user password

Confirm the password to be used for the database user ID.

Database user home directory

Enter the home directory of the database user ID. The home directory is used to locate the profile of the database user during environment setup for instance creation.

Generate properties file only

This check box displays in the Instance Creation wizard only.

The properties file is found in WC_installdir/instances/ instance_name/properties/createInstance.properties.