When you select your database product on the Database configuration
panel in the Profile Management Tool, a follow-up panel asks you for
database-specific information. This panel, which does not appear if
you selected Derby Embedded when configuring a stand-alone server
profile is called the Database configuration (Part 2) panel It
contains slightly different fields and default values, depending on
your database product selection.
You must complete this panel even if you chose to postpone creating
a new database or adding tables to an existing one by selecting the Delay
execution of database scripts check box on the Database
configuration (Part 2) panel. The values you choose on
this panel are added to the database configuration scripts that the
Profile Management Tool creates and stores in the directory you specified
in the Database script output directory field
on the previous panel.
Restriction: You cannot create a new
database if you are using DB2® for z/OS® V8 or V9, Oracle 9i, Oracle
10g, or 11g. If you select one of these databases and the option Create
a new local database, the Next button
is disabled. Make different selections on the Database configuration
panel.
Choose the link for your database product from the following list
to determine how to complete the Database configuration (Part 2) panel:
Important: If you are creating or augmenting a stand-alone
server profile and selected the Derby Embedded database product, no
additional database configuration is necessary.
When you have completed the Database configuration (Part 2) panel,
click Next. The tool checks that a valid database
connection exists. If the tool identifies an error, you must correct
the problem before continuing by either making sure the database is
up and running or altering parameters in order to make a good connection.
The Profile summary panel is displayed. Depending on the topic
from which you accessed this one, return to one of the following steps:
Derby Network Server
Table 1 lists the fields you
must complete on the Database configuration (Part 2) panel when you
select Derby Network Server as your database product.
Important: If you choose Derby Network Server as your database
product, after profile creation or augmentation completes, ensure
that the server is running on the host and port you specified during
profile creation, even if the database host is local.
Table 1. Required Common database configuration fields
for Derby Network ServerField |
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. |
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 1527 or
enter the correct server port number. |
DB2 Universal Database
Table 2 lists the fields you
must complete on the Database configuration (Part 2) panel when you
select DB2 Universal Database™ as your database product.
Table 2. Required
Common database configuration fields for DB2 Universal DatabaseField |
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. |
Location (directory) of JDBC driver
classpath files |
Accept the default value of install_root/universalDriver_wbi/lib on Linux®, UNIX® or i5/OS® platforms,
or install_root\universalDriver_wbi\lib on Windows® platforms, or browse
to the location on your system that contains the following files: - db2jcc.jar
- db2jcc_license_cu.jar or db2jcc_license_cisuz.jar
An error message is displayed if the files cannot be found
at the specified location. |
JDBC driver type |
Accept the default value of 4 or select
the radio button beside the correct JDBC driver type. |
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 50000 or
enter the correct server port number. |
DB2 for z/OS V8 and V9
Table 3 lists the fields you
must complete on the Database configuration (Part 2) panel when you
select DB2 for z/OS V8 and V9 as your database product.
Table 3. Required Common database configuration fields
for DB2 for z/OS V8 and V9Field |
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. |
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. |
Database alias name |
Enter the database alias name. |
Connection location |
Enter the connection location. |
Storage group name |
Enter the storage group name. |
DB2 UDB
for iSeries (Toolbox)
Table 4 lists the fields you
must complete on the Database configuration (Part 2) panel when you
select DB2 UDB for iSeries® (Toolbox) as your database product.
This selection is also valid for DB2 for i5/OS (Toolbox).
Table 4. Required Common database configuration fields for DB2 UDB for iSeries (Toolbox)
or DB2 for i5/OS (Toolbox)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. |
Location (directory) of JDBC driver
classpath files |
Accept the default value of /QIBM/ProdData/HTTP/Public/jt400/lib on i5/OS platforms, or browse to
the location on your system that contains the following file:
An error message is displayed if the file cannot be found
at the specified location. |
Database server host name (for example
IP address) |
Enter the database server host name. |
Database collection name |
Accept the default value of WPRCSDB or
enter the correct schema name. To prevent naming conflicts within
the specified database, specify a schema name whose first three characters
are unique from the names of other schemas residing in the database. |
DB2 UDB for iSeries (Native)
Note: On i5/OS platforms: This
database configuration applies only to i5/OS platforms.
Table 5 lists the fields you
must complete on the Database configuration (Part 2) panel when you
select DB2 UDB for iSeries (Native) as your database product.
This selection is also valid for DB2 for i5/OS (Native).
Table 5. Required Common database configuration fields for DB2 UDB for iSeries (Native)
or DB2 for i5/OS (Native)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. |
Location (directory) of JDBC driver
classpath files |
Accept the default value of /QIBM/ProdData/Java400/ext on i5/OS platforms, or browse to
the location on your system that contains the following file:
An error message is displayed if the file cannot be found at
the specified location. |
Database server host name (for example
IP address) |
Enter the database server host name. |
Database collection name |
Accept the default value of WPRCSDB or
enter the correct schema name. To prevent naming conflicts within
the specified database, specify a schema name whose first three characters
are unique from the names of other schemas residing in the database. |
DB2 Universal
Runtime Client
Table 6 lists
the fields you must complete on the Database configuration (Part 2)
panel when you select DB2 Universal
Runtime Client as your database product.
Table 6. Required
Common database configuration fields for DB2 Universal
Runtime ClientField |
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. |
Location (directory) of JDBC driver
classpath files |
Enter the location on your system that contains
the db2java.zip file. An error message is displayed if the
file 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 50000 or
enter the correct server port number. |
DB2 node name (must be 8 characters
or less) |
Enter the DB2 node
name. |
Informix Dynamic
Server
Table 7 lists
the fields you must complete on the Database configuration (Part 2)
panel when you select Informix® Dynamic
Server as your database product.
Table 7. Required
Common database configuration fields for Informix Dynamic 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. |
Location (directory) of JDBC driver
classpath files |
Enter the location on your system that contains
the following files:
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. |
Database server name |
Enter the database server name. |
Server port |
Accept the default value of 1526 or
enter the correct server port number. |
Event service instance name |
Enter the correct event service instance name. |
Microsoft SQL
Server (Embedded)
Table 8 lists the fields
you must complete on the Database configuration (Part 2) panel when
you select Microsoft® SQL
Server Embedded as your database product.
Note: Microsoft SQL Server (Embedded)
Table 8. Required Common database configuration fields
for Microsoft SQL Server
EmbeddedField |
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. |
Database server host name (for example
IP address) |
Accept the default value of localhost or
enter the correct database server host name. |
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 ID. |
Confirm password |
Confirm the password. |
Microsoft SQL
Server (DataDirect) and Microsoft SQL
Server (Microsoft)
Oracle 9i
Table 10 lists the fields you
must complete on the Database configuration (Part 2) panel when you
select Oracle 9i as your database product.
Table 10. Required
Common database configuration fields for Oracle 9iField |
Action needed |
Directory of database server installation |
Enter or browse for the database server installation.
Required when the Delay execution of database scripts option
is selected in the previous screen. |
Password for database authentication |
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 ojdbc14.jar. An error message is displayed if the
files cannot be found at the specified location. |
JDBC driver type |
Click OCI or Thin. |
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. |
Admin user name |
Enter the user ID that has privileges to create
and drop databases and users. 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 ID. |
Confirm password |
Confirm the password. |
Oracle 10g or 11g
Table 11 lists the fields
you must complete on the Database configuration (Part 2) panel when
you select Oracle 10g or 11g as your database product.
Table 11. Required Common database configuration fields
for Oracle 10g or 11gField |
Action needed |
Directory of database server installation |
Enter or browse for the database server installation.
Required when the Delay execution of database scripts option
is selected in the previous screen. |
Password for database authentication |
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 ojdbc14.jar. An error message is displayed if the
files cannot be found at the specified location. |
JDBC driver type |
Click OCI or Thin. |
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. |
Admin user name |
Enter the user ID that has privileges to create
and drop databases and users. 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 ID. |
Confirm password |
Confirm the password. |