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 2: Install and configure communications for the Warehouse Proxy Agent

IBM Tivoli Monitoring, Version 6.3 Fix Pack 2

---

Configure an ODBC data source for a DB2 data warehouse

A DB2 for Linux, UNIX and Windows client on Windows requires an ODBC connection to the data warehouse. For the Warehouse Proxy Agent, you must configure the ODBC connection manually.

• If the warehouse database is remote from the Warehouse Proxy Agent, catalog the remote database before you configure the ODBC data source. The ODBC connection does not work if the remote database has not been cataloged prior to performing this procedure.

• This procedure uses default values for the data source name, warehouse alias, and warehouse user ID. (Default values are used in configuration procedures for warehousing components.) Substitute different values if you do not want to use the default values.

Complete the following procedure to set up an ODBC connection for a Warehouse Proxy Agent on Windows to a local or remote Tivoli Data Warehouse.

1. On the computer where the Warehouse Proxy Agent is installed, open the Control Panel.

2. Click Administrative Tools → Data Sources (ODBC)

3. Click Add in the System DSN tab in the ODBC Data Source Administrator window.

4. Select IBM DB2 ODBC DRIVER from the list.

5. Click Finish.

6. In the ODBC DB2 Driver - Add window, perform the following steps:

   1. Enter ITM Warehouse in Data source name.

   2. Enter Warehous in Database Alias.

      If the Tivoli Data Warehouse is located on a remote computer, ensure that the database alias matches the alias that you used when cataloging the remote data warehouse. See Cataloging a remote data warehouse.

      If local, ensure that the database alias matches the name used for the warehouse database.

   3. Click OK.

7. Test the ODBC database connection before continuing:

   1. In the ODBC Data Source Administrator window, select ITM Warehouse.

   2. Click Configure.

   3. In the CLI/ODBC Settings - ITM Warehouse window, you see the data source name, ITM Warehouse.

   4. Enter ITMUser for the User ID.

   5. Type a password for the user in the Password field. The default password is itmpswd1.

   6. Click Connect.

   7. A Connection test successful message is displayed.

   8. Click OK.

   9. Click OK to close the window.

Parent topic:

Step 2: Install and configure communications for the Warehouse Proxy Agent

---

+

Search Tips   |   Advanced Search