IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Tivoli Data Warehouse solution using DB2 for Linux, UNIX, and Windows > Step 5: Install and configure communications for the Tivoli Performance Analyzer

IBM Tivoli Monitoring, Version 6.3 Fix Pack 2

Configure Tivoli Performance Analyzer on Linux or UNIX (JDBC connection)

Use this procedure to configure Tivoli Performance Analyzer on Linux or UNIX to connect to a DB2 for Linux, UNIX, and Windows data warehouse on any operating system.

  1. To begin the configuration, log on to the computer where Tivoli Performance Analyzer is installed.

    1. Run...

      ...where install_dir is the installation directory for IBM Tivoli Monitoring. The default installation directory is /opt/IBM/ITM. The Manage Tivoli Enterprise Monitoring Services window is displayed.

    2. Right-click Performance Analyzer and click Configure. The Configure Tivoli Performance Analyzer window is displayed.

  2. Set the Database Type to DB2.

  3. Type the username and the password. The entries in these fields are used to connect to the Tivoli Data Warehouse.

  4. Review all the defaults in the Agent Configuration window and change as required.

    1. If the Tivoli Data Warehouse is installed on a remote computer, specify the host name of the remote computer instead of localhost.

    2. Change the port number if necessary (the default port number for DB2 is 50000).

    3. If the name of the Tivoli Data Warehouse database is not WAREHOUS, replace WAREHOUS with the actual name. (See Create the warehouse database on DB2 for Linux, UNIX and Windows.)

      when specifying the DB2 for Linux, UNIX, and Windows database name on Linux and UNIX, case is ignored. In other words, it makes no difference whether you provide the database name in lowercase or uppercase.

  5. Specify the JDBC Driver. The default driver name for DB2 is com.ibm.db2.jcc.DB2Driver.

  6. Specify the JDBC Driver Path, which should be provided as a list of JAR files with the full path separated by ":".

    The driver files names for DB2 for Linux, UNIX, and Windows are: 

      db2jcc.jar
db2jcc_license_cu.jar

    Fast path: You can use the Browse button to specify the path. In such a case a file list is added at the end of the JDBC Driver Path text field, separated from the existing content by a path separator.

    For compatibility with version 6.1.1 it is also possible to provide a single directory name containing all the JAR files which should be used, although this solution is not recommended. Ensure that the directory does not contain the db2jcc4.jar file. Performance Analyzer only supports Java version 1.5 and requires the db2jcc.jar file. Including db2jcc4.jar in the classpath may prevent the agent from being successfully configured.

  7. You can use the Test connection button to check whether the connection can be initiated.

  8. Click Next to proceed to the Advanced Configuration window.

    1. You can enable Advanced Configuration to specify TDW Schema and Configuration schema. If you do not select Enable advanced configuration, all of these options are greyed out.

    2. You can also choose whether you want the agent to initialize PA tables.

      Setting Initialize PA tables to YES will remove and recreate all previously created tables deleting all user tasks and reverting each OS task to its default.

    3. Use the Bypass connection tests option to finish the configuration without running connection tests.

  9. Click Save to save your settings and close the window.


Parent topic:

Step 5: Install and configure communications for the Tivoli Performance Analyzer

+

Search Tips   |   Advanced Search