Database Configuration page

When you select your database product on the Database Configuration page in the Profile Management Tool, a follow-up page, called the Database Configuration - WSRR page, asks you for database-specific information. It contains slightly different fields and default values, depending on your database product selection.

You must complete this page even if you have selected the Only generate the database scripts to be executed manually after the profile has been created option. The values you choose on the Database Configuration page are added to the database configuration scripts stored in the directory you specified in the Database script output directory field on the previous page (or in the default directory for these scripts if you did not specify a different location).

Choose the link for your database product from the following list to determine how to complete the Database Configuration page:

DB2 Universal or DB2 Express
DB2 for z/OS
Microsoft SQL Server
Oracle

When you have completed the Database Configuration page, click Next. If the Profile Management Tool is creating the database or database tables for you, the tool checks that a valid connection exists to the database. If the tool identifies an error, you must correct the problem before continuing by either making sure that the database is running or altering parameters in order to make a good connection.

The Profile Summary page is displayed. Depending on the topic from which you accessed this one, return to one of the following steps:

Step 17 in the topic Creating advanced stand-alone server profiles
step 3 in the topic Creating typical stand-alone server profiles,
Step 10 in the topic Augmenting stand-alone server profiles

DB2 Universal or DB2 Express®

Table 1 lists the fields you must complete on the Database Configuration page when you select DB2® DataServer as your database product.

Table 1. Required database configuration fields for DB2 DataServer
Field	Action needed
User name to authenticate with the database	Enter the user name to authenticate with the database. The user ID must exist.
Password for database authentication	Enter a password to authenticate with the database.
Confirm password	Confirm the password.
Business Space Schema name	Specify a schema for the Business Space tables, or accept the default value of "BSPACE".
Location (directory) of JDBC driver classpath files	Enter the location, on your system, that contains the following files: db2jcc4.jar db2jcc4_license_cu.jar or db2jcc4_license_cisuz.jar An error message is displayed if the files cannot be found at the specified location.
Database server host name (for example IP address)	Enter the correct database server host name.
Server port	Accept the default value of `50000` or enter the correct server port number.
System administrator user name	The DB2 administrator user ID. Set to db2admin by default
Password	The password for the DB2 administrator.

DB2 for z/OS

Table 2 lists the fields you must complete on the Database Configuration page when you select DB2 for z/OS® as your database product. You cannot create a new database using these database products. The empty database must already exist, the profile creation/augmentation process can, however, configure the tables in it.

Note: You cannot create the database during profile creation. The database must exist, and you can use profile creation to create the tables in it.

Table 2. Required database configuration fields for DB2 for z/OS
Field	Action needed
User name to authenticate with the database	Enter the user name to authenticate with the database.
Password for database authentication	Enter a password to authenticate with the database.
Confirm password	Confirm the password.
Business Space Schema name	Specify a schema for the Business Space tables, or accept the default value of "BSPACE".
Location (directory) of JDBC driver classpath files	Enter the location on your system that contains the following files: db2jcc.jar db2jcc_license_cisuz.jar An error message is displayed if the files cannot be found at the specified location.
Database server host name (for example IP address)	Enter the database server host name.
Server port	Accept the default value of `446` or enter the correct server port number.
Connection location	Enter the connection location.
Storage group name	Enter the storage group name.
Database SQL ID	Enter the SQL ID for the database.

Microsoft SQL Server

Table 3 lists the fields you must complete on the Database Configuration page when you select Microsoft SQL Server as your database product.

Note: The stored procedures for Java™ Transaction API (JTA) must be installed in addition to the JDBC drivers for WSRR or WSRR to work with the Microsoft SQL Server. For more information refer to Installing stored procedures for Java Transaction API.

Note: You cannot create the database during profile creation. The database must exist, and you can use profile creation to create the tables in it.

Table 3. Required database configuration fields for Microsoft SQL Server
Field	Action needed
User name to authenticate with the database	Enter the user name to authenticate with the database.
Password for database authentication	Enter a password to authenticate with the database.
Confirm password	Confirm the password.
Business Space Schema name	Specify a schema for the Business Space tables, or accept the default value of "BSPACE".
Location (directory) of JDBC driver classpath files	Enter the location on your system that contains the following files: sqljdbc.jar sqljdbc4.jar An error message is displayed if the file cannot be found at the specified location. By default the location is to be found under <`SQLServerHome`>/<`MSSQL.INSTANCE`>.
Database server name	Enter the database server name.
Server port	Accept the default value of `1433` or enter the correct server port number.
Admin user name	Enter the user ID that has privileges to create and drop databases and users or accept the default value of `sa`. This ID is required when the Delay execution of database scripts option is NOT selected in the previous screen.
Password	Enter the password for the user Admin user name.
Confirm password	Confirm the password.
Schema name	Enter the database schema name.

Oracle

Table 4 lists the fields you must complete on the Database Configuration page when you select Oracle as your database product. You cannot create a new database using this database product.

Important: You must have a user ID that has SYSDBA privileges before creating any profile.

Note: You cannot create the database during profile creation. The database must exist, and you can use profile creation to create the tables in it.

Table 4. Required database configuration fields for Oracle
Field	Action needed
WSRR database user name	User ID for the database.
Password	Enter a password to authenticate with the database.
Confirm password	Confirm the password.
Location (directory) of JDBC driver classpath files	Enter the location on your system that contains the file ojdbc6.jar. An error message is displayed if the files cannot be found at the specified location.
Database server host name (for example IP address)	Accept the default value of `localhost` or enter the correct database server host name.
Server port	Accept the default value of `1521` or enter the correct server port number.
Oracle Operating System user	Enter the user ID of the Oracle operating system user. This is set to oracle by default.
System administrator user name	This is set to SYSTEM by default.
Password	Enter the password for the system administrator user name.
Confirm password	Confirm the password.