IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Tivoli Data Warehouse solution using Oracle > Step 5: Install and configure communications for 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 an Oracle data warehouse.

  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 Oracle.

  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 Oracle is 1521).

    3. If the name of the Tivoli Data Warehouse database is not WAREHOUS, replace WAREHOUS with the actual name.

  5. Specify the JDBC Driver. The Oracle JDBC Type 4 driver name is oracle.jdbc.driver.OracleDriver.

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

    The Oracle JDBC driver JAR file name and default location after downloading from the Web are as follows: 

      doracleinstalldir/jdbc/lib/ojdbc14.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.

  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 Tivoli Performance Analyzer

+

Search Tips   |   Advanced Search