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 a Warehouse Proxy Agent on Windows (ODBC connection)

Use the procedure in this section to configure a Warehouse Proxy Agent on Windows to connect to a DB2 for Linux, UNIX, and Windows data warehouse.

  1. Log on to the Windows system where the Warehouse Proxy Agent is installed and begin the configuration:

    1. Click Start → Programs → IBM Tivoli MonitoringManage Tivoli Monitoring Services.

      The Manage Tivoli Enterprise Monitoring Services window is displayed.

    2. Right-click Warehouse Proxy and click Configure Using Defaults.

      Click Reconfigure if the Warehouse Proxy is installed on the same computer as the portal server.

    3. Click OK on the message regarding connection to a hub monitoring server.

  2. The next two windows (entitled Warehouse Proxy: Agent Advanced Configuration) contain the settings for the connection between the Warehouse Proxy Agent and the hub monitoring server. These settings were specified when the Warehouse Proxy Agent was installed. Click OK on each window to accept the settings.

  3. Select DB2 from the list of selectable databases (see Figure 1), and click Next.

    Figure 1. Warehouse Proxy Database Selection screen

    The following configuration window is displayed.

    Figure 2. Configure DB2 Data Source for Warehouse Proxy window

  4. Click OK to accept all default information on this window, or change one or more default values and then click OK. The fields on this window are described in Table 1.

    The values for the data source name, database name, and database user ID and password must match the values that you used when configuring an ODBC connection for the Warehouse Proxy Agent.


    Configuration information for the Tivoli Data Warehouse database on DB2 for Linux, UNIX and Windows

    Field Default value Description
    ODBC DSN ITM Warehouse Name of the data source.
    Username ITMUser Name of the user that the Warehouse Proxy Agent will use to access the Tivoli Data Warehouse database.
    Password itmpswd1 Password that the Warehouse Proxy Agent will use to access the Tivoli Data Warehouse database. If your environment requires complex passwords (passwords that require both alpha and numeric characters), specify a password that complies with these requirements.
    Confirm Password itmpswd1 Confirm the password by entering it again.
    Test Connection   Test the connection to the Tivoli Data Warehouse Database based on the completed fields above: ODBC DSN, Username, and Password.

    Test Connection is not available if configuring remotely from the Tivoli Enterprise Portal.

    Warehouse TEMS List   Environment variable containing a space delimited list of TEMS names, which are given during the configuration of HTEMS or RTEMS. A TEMS name in this field indicates that all the agents connected to this TEMS will have their historical data sent to this Warehouse Proxy Agent. This variable is used when the ITM environment contains multiple Warehouse Proxy Agents and the workload has to be balanced using specific Warehouse Proxy Agents.
    Use Batch   Batch inserts can greatly increase the data insertion rate of the Warehouse Proxy Agent. This is especially true if the proxy and the warehouse are located on different hosts. Batch inserts are supported for ODBC warehouse connections. Using batch inserts is recommended in all configurations, but they will place increased load on the data warehouse.
    Database Compression   If the database compression mode is supported by the database, the Warehouse Proxy Agent will create all tables and indexes in the Tivoli Data Warehouse with compression enabled. This option reduces the storage costs of the Tivoli Data Warehouse.
    Warehouse Compression for Z/OS Sources   Select this option for the Warehouse Proxy server to allow clients installed on Z/OS machines to send compressed data.
    Warehouse Compression for Distributed Sources   Select this option for the Warehouse Proxy server to allow clients installed on distributed machines (Linux/UNIX, Windows) to send compressed data.

  5. Click OK.


Parent topic:

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

+

Search Tips   |   Advanced Search