WebSphere Enterprise Service Bus, Version 6.2.0 Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows


Database configuration (Part 2) panel for Common database configuration

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 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.
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 Database
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 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 V9
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:
  • 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:
  • jt400.jar
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)

For i5/OS operating system 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:
  • db2_classes.jar
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 Client
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 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:
  • ifxjdbc.jar
  • ifxjdbcx.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.
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 Embedded
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.
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)

Table 9 lists the fields you must complete on the Database configuration (Part 2) panel when you select Microsoft SQL Server (DataDirect) or Microsoft SQL Server (Microsoft) as your database product.
Table 9. Required Common database configuration fields for Microsoft SQL Server DataDirect and Microsoft SQL Server (Microsoft)
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:
  • sqlserver.jar
  • base.jar
  • util.jar
Also, the file spy.jar must be available in the following location relative to the location of the JDBC driver class path files:
  • For Linux operating systemFor UNIX operating system ../spy/spy.jar
  • For Windows operating system ..\spy\spy.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.
Database server name Enter the database server name.
Server port Accept the default value of 1433 or enter the correct server port number.

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 9i
Field 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 11g
Field 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.

concept Concept topic

Terms of use | Feedback


Timestamp icon Last updated: 21 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic//com.ibm.websphere.wesb620.doc/doc/cins_common_database.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).