ITCAM for SOA 7.2

Creating an IBM DB2 Universal Database connection

To create a database connection for IBM® DB2 Universal Database™, complete the following steps:

Figure 1. Specifying database connection parameters for an IBM DB2 v9.1 connection.
This figure shows the database connection parameters for the DB2 example connection.
  1. In the Select a database manager area, expand the DB2® UDB node and then select the appropriate version that is installed. For example, V9.1.

    For DB2 9.5 or DB2 9.7: If your warehouse database uses DB2 version 9.5 or DB2 version 9.7, you can select version 9.1 from the list and then specify the version 9.5 or 9.7 JDBC driver.

  2. In the JDBC Driver field, select DB2 JDBC Driver.
  3. In the Connection URL details area, complete the following steps:
    1. In the Hostname field, specify the fully qualified hostname of the system where the database is located, for example, mymachine01.raleigh.ibm.com.

      If the database is located on your local workstation, specify localhost.

    2. In the Specify the database name field, enter the appropriate database name, for example, WPROXY. If you are not sure which name to specify, see your database administrator for assistance.
    3. In the Port field, accept the default port number of 50000, or change it to a different port.
    4. In the JDBC Driver Class field, accept the default class for this JDBC driver as com.ibm.db2.jcc.DB2Driver.
    5. In the Class Location field, specify the JAR files, all on a single line, separated by semicolons.
      Example:
      • <DB2_HOME>\java\db2jcc.jar
      • <DB2_HOME>\java\db2jcc_license_cu.jar
      • <DB2_HOME>\java\db2jcc_license_cisuz.jar

      The <DB2_HOME> variable is the directory path where the IBM DB2 Driver for JDBC is installed, for example, C:\Program Files\IBM\SQLLIB.

    6. The value in the Connection URL field is composed of the values in the Hostname, Port, and Specify the database name fields.
  4. In the User information area, select the appropriate DB2 user ID and password that was used to configure the warehouse database. For example, the default user ID when installing IBM Tivoli® Monitoring is ITMUser.
Parent topic: Creating a database connection

Feedback