IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Tivoli Data Warehouse solution using Oracle > Step 2: Install and configure communications for the Warehouse Proxy Agent
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Configure a Warehouse Proxy Agent on Linux or UNIX (JDBC connection)
Use this procedure to configure a Warehouse Proxy Agent on Linux or UNIX to connect to an Oracle data warehouse.
- Log on to the computer where the Warehouse Proxy Agent is installed and begin the configuration.
- Run...
cd install_dir/bin
./itmcmd manage [-h install_dir]
...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.
- Right-click Warehouse Proxy and click Configure.
The Configure Warehouse Proxy window is displayed.
Figure 1. Configure Warehouse Proxy window (Database Type pane)
- In the Database drop-down list, select Oracle.
- Select the Agent Parameters check box.
Figure 2. Configure Warehouse Proxy window (Agent Parameters pane)
- Add the name and directory location of the JDBC driver JAR file to the JDBC JARS list box:
- Click Add to display the file browser window. Navigate to the location of the JDBC driver JAR file on this computer and select the file. The Oracle JDBC driver JAR file name and default location after downloading from the Web are as follows:
oracleinstalldir/jdbc/lib/ojdbc14.jar
- Click OK to close the browser window and add the driver file to the list.
If you need to delete an entry from the list, select the entry and click Delete.
- Change the default value displayed in the JDBC URL field if it is not correct. The default Tivoli Data Warehouse URL for Oracle is as follows:
jdbc:oracle:thin:@localhost:1521:WAREHOUS
- If the Tivoli Data Warehouse is installed on a remote computer, specify the host name of the remote computer instead of localhost.
- Change the port number if it is different.
- If the name of the Tivoli Data Warehouse database is not WAREHOUS, replace WAREHOUS with the actual name. (See Create the warehouse database on Oracle.)
- Verify the JDBC driver name, which is displayed in the JDBC Driver field. (Note that the JDBC Driver field displays the driver name, in contrast to the driver JAR file that is listed in the JDBC JARS field.)
The Oracle JDBC Type 4 driver name is as follows:
oracle.jdbc.driver.OracleDriver
- If necessary, change the entries in the Username and Password fields to match the user name and password that were created for the Tivoli Data Warehouse. (See Create the warehouse database on Oracle.) The default user name is itmuser and the default password is itmpswd1.
- Check the Use Batch check box if you want the Warehouse Proxy Agent to submit multiple execute statements to the Tivoli Data Warehouse database for processing as a batch.
In some situations, such as crossing a network, sending multiple statements as a unit is more efficient than sending each statement separately. Batch processing is one of the features provided with the JDBC 2.0 API.
- Click Test connection to ensure you can communicate with the Tivoli Data Warehouse database.
- Click Save to save your settings and close the window.
Parent topic:
Step 2: Install and configure communications for the Warehouse Proxy Agent