Configuration Manager - Commerce - Database

Use the Database page 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. Note: The Database panel does not apply to OS/400 users and is not displayed for the Instance Creation wizard on OS/400.

The fields displayed on the Database page differ significantly when running Configuration Manager on different operating systems. To move quickly to the section of this page applicable to your operating system, click one of the following links:

AIX, Solaris Operating Environment, Linux and Windows users

Complete the fields as follows:

WebSphere Commerce database
This is only available in the Instance Creation wizard.
Select one of the options available here as follows:
  • DB2 If you want to create the WebSphere Commerce database and populate the database, select Create a new database or tablespace.
  • Oracle If you want to create and populate a tablespace in the WebSphere Commerce database, select Create a new database or tablespace.

    The Oracle database must have been created before installing WebSphere Commerce by following the instructions in WebSphere Commerce Installation Guide.

  • If you want to use an existing WebSphere Commerce database, select Use an existing database or tablespace.

    The existing WebSphere Commerce database must be a database for WebSphere Commerce 5.5. Databases for WebSphere Commerce Version 5.4 and lower must be migrated before they can be used as a WebSphere Commerce 5.5 database. Migration instructions are provided in WebSphere Commerce Migration Guide.

    Important: You cannot use an existing WebSphere Commerce Payments database as the WebSphere Commerce database. WebSphere Commerce and WebSphere Commerce Payments must use different databases or tablespaces. If WebSphere Commerce and WebSphere Commerce Payments share the same database or tablespace, WebSphere Commerce Payments will not start.

    When using an existing WebSphere Commerce database, ensure that the database name in the Database name field on Schema panel of the Instance Creation wizard matches the name of the existing WebSphere Commerce database.

Database administrator name
DB2 Enter the local operating system user ID for your database administrator.
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.
AIXSun Solaris Operating Environment Database administrator home directory
Enter the home directory of the database administrator ID.
Database name
Enter the name of the database to create for this instance, 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 20 characters or fewer. On AIX and Solaris Operating Environment, this database will be cataloged remotely at a node named after your WebSphere Commerce machine's host name as the following:

rdatabase_name
Database type
Select the product you will be using as your database management system.

Selecting Oracle as your database type enables the following fields:

Oracle SID
The Oracle database SID. The Service Name field is only available if you have selected Oracle in the Database Type field.
AIXSun Solaris Operating Environment Oracle instance userid
Enter the Oracle user ID of the user who issues Oracle commands.
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 the following:
Oracle_installdir/database/wcs.dbf
Tablespace name
Enter the name of the tablespace that Configuration Manager will create and populate in the Oracle database you created for use by WebSphere Commerce server in WebSphere Commerce Installation Guide
Temporary Tablespace
Enter the name of the temporary tablespace that Configuration Manager will create in the WebSphere Commerce database you created for use by WebSphere Commerce server in WebSphere Commerce Installation Guide
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.
Oracle Enter the Oracle user ID for this database that the Instance Creation wizard will create. Do not enter an existing Oracle user ID.

Important: The WebSphere Commerce database user ID must be different from the WebSphere Commerce Payments database user ID. Using the same user ID for the WebSphere Commerce and WebSphere Commerce Payments databases will cause connection pool problems, causing WebSphere Commerce Payments to functions incorrectly. Using the same user ID may also prevent the WebSphere Commerce Payments instance from being created correctly.

Database user password
Enter the password associated with the user name for this database.
Oracle Confirm Database user password
Confirm the password to be used for the Oracle database user ID that the Instance Creation wizard will create.
Use staging server
Select this check box if you want to use this database for your staging server. 
Set as active database
Select this check box if this database is the database you want to use with your WebSphere Commerce instance. After you have created your instance you can create additional databases and select the one that you want to use for your instance.

This check box is selected by default.

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

Note: If you have installed your database server on a different node than WebSphere Commerce (for example, if you are configuring a three-node environment), 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.
DB2 Database server port
Enter the port number on which your remote database server is running.
The default port is 50000.
DB2 Database node name
Enter the node name that you used when cataloging the node for your remote database. If you have not already cataloged a node for your remote database, Configuration Manager will catalog a node for you.

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

Select Advanced Options to set the advanced settings when creating and populating the WebSphere Commerce database during instance creations.

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

Default application heap (4KB)
Enter the number of 4KB blocks you would like the default application heap to use for the WebSphere Commerce database.
SQL statement heap (4KB)
Enter the number of 4KB 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 4KB 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 4KB blocks you would like the maximum storage for the lock list to be for the WebSphere Commerce database.

Oracle 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.


OS/400 users

Relational Database Name
Select the name of the database to use for WebSphere Commerce. The Relational Database Names can be checked by issuing the WRKRDBDIRE command from an OS/400 command line.
Instance Logon password
Enter the password for the new instance user profile that will be created. The password must be 10 characters or less.
Confirm password
Re-enter the instance logon password.
 Use staging server
Select this check box if you want to use this database for your staging server.
 Remote
This check box will be selected if you selected a remote database in the Relational Database Name.

If this check box is selected, the following fields display:

Database server host name
This field displays the host name of the node where the select database exists.