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 3: Configure communications between the Tivoli Enterprise Portal Server and the data warehouse

IBM Tivoli Monitoring, Version 6.3 Fix Pack 2


Configure a Windows portal server (ODBC connection)

The procedure described in this section uses the Manage Tivoli Enterprise Monitoring Services window to configure an ODBC connection between a Windows portal server and the data warehouse. You do not need to configure the ODBC data source through the Control Panel in Windows.

Catalog the remote warehouse database before you configure the Windows portal server to connect to the database.

The ODBC connection does not work if the remote database has not been cataloged prior to performing this procedure.


Complete the following procedure to configure a portal server on Windows to connect to a DB2 for Linux, UNIX and Windows data warehouse:

  1. Log on to the Windows system where the portal server is installed and begin the configuration:

    1. Click Start → Programs → IBM Tivoli Monitoring → Manage Tivoli Monitoring Services. The Manage Tivoli Enterprise Monitoring Services window is displayed.

    2. Right-click Tivoli Enterprise Portal Server and click Reconfigure.

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

  3. Click Yes on the message asking if you want to reconfigure the warehouse information for the Tivoli Enterprise Portal Server.

  4. Select DB2 from the list of databases and click OK.

    The following configuration window is displayed.

    Figure 1. Configure DB2 Data Source for Warehouse window

  5. 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 the following table.


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

    Field Default value Description
    Data Source Name ITM Warehouse Name of the data source.
    Database User ID ITMUser Name of the Windows OS user that the portal server will use to access the Tivoli Data Warehouse database.
    Database Password itmpswd1 Password for the Windows user. If your environment requires complex passwords (passwords that require both alpha and numeric characters), specify a password that complies with these requirements.
    Reenter Password itmpswd1 Confirm the password by entering it again.

  6. Click OK.


Parent topic:

Step 3: Configure communications between the Tivoli Enterprise Portal Server and the data warehouse

+

Search Tips   |   Advanced Search