IBM Tivoli Monitoring, Version 6.3

Tivoli Data Warehouse solutions: common procedures

This chapter contains information and procedures for Tivoli® Data Warehouse solutions that use any of the supported database platforms: IBM® DB2 for Linux, UNIX, and Windows, Microsoft SQL Server, and Oracle.

Read the chapter pertaining to the database platform you are using for the Tivoli Data Warehouse before performing any of these procedures.

Configuring the Summarization and Pruning Agent (JDBC connection)
Use this procedure to configure the Summarization and Pruning Agent to connect to a Tivoli Data Warehouse database created on any of the supported database platforms and operating systems.
Configuring the Warehouse Proxy Agent on Linux or UNIX: command-line procedure
Complete the steps in this section to configure the Warehouse Proxy Agent from the command-line on Linux or UNIX.
Configuring the Summarization and Pruning Agent on Linux or UNIX: command-line procedure
Complete the steps in this section to configure the Summarization and Pruning Agent from the command-line on Linux or UNIX.
Starting the Summarization and Pruning Agent
This section contains instructions for starting the Summarization and Pruning Agent.
Installing and configuring multiple Warehouse Proxy Agents
IBM Tivoli Monitoring supports multiple Warehouse Proxies within a single hub monitoring server environment. The provision for multiple warehouse proxies provides for greater scalability and performance in historical data collection.
Running the warehouse agents autonomously
Both the Warehouse Proxy Agent and Warehouse Summarization and Pruning Agent can run in autonomous ("unmanaged") mode.
Testing the connection between the portal server and the Tivoli Data Warehouse
To test the connection between the Tivoli Enterprise Portal Server and the Tivoli Data Warehouse database, use the Tivoli Enterprise Portal to create a custom SQL query to the warehouse database and display the results. The procedure described in this section creates an SQL query to the WAREHOUSELOG table, a status table that is created in the warehouse database when the Warehouse Proxy Agent starts.
Tuning the performance of the Warehouse Proxy
This section contains the environment variables that control how the Warehouse Proxy works.
Configuring the Warehouse Proxy Agent and Summarization and Pruning Agent using the new graphical interface
The database administrator must create an empty database that will serve as the Data Warehouse database and provide the database name, username and password to the IBM Tivoli Monitoring administrator. The IBM Tivoli Monitoring administrator creates the ODBC or JDBC Data Source using the credentials provided. Then, the IBM Tivoli Monitoring administrator must configure the Warehouse Proxy Agent and the Summarization and Pruning Agent to use the ODBC or JDBC Data Source. The Warehouse Proxy Agent uses ODBC on Windows systems. On Unix and Linux, the Warehouse Proxy Agent uses JDBC. The Summarization and Pruning Agent always uses JDBC.
Installing and configuring the Warehouse Proxy Agent and Summarization and Pruning Agent in silent mode, using the silent response file
A silent installation runs on its own and does not require you to provide input to dialog boxes or monitor the installation. This configuration option allows for an unattended and automatic installation and configuration of the Warehouse Proxy Agent and Summarization and Pruning Agent as well as the remote configuration of these two agents. Configuration of the Warehouse Proxy Agent and Summarization and Pruning Agent takes place during the setup of the IBM Tivoli Monitoring infrastructure, or manually later.
Installing and configuring the Warehouse Proxy Agent in silent mode on UNIX, using the silent response file
A silent installation runs on its own and does not require you to provide input to dialog boxes or monitor the installation. This reduces the time spent on installation and configuration.
Installing and configuring the Summarization and Pruning Agent in silent mode on UNIX, using the silent response file
A silent installation runs on its own and does not require you to provide input to dialog boxes or monitor the installation. This reduces the time spent on installation and configuration.
Upgrading the Warehouse Proxy Agent and Summarization and Pruning Agent in silent mode, using the silent response file
A silent installation runs on its own and does not require you to provide input to dialog boxes or monitor the installation. This reduces the time spent on upgrading.
Upgrading the Warehouse Proxy Agent and Summarization and Pruning Agent using remote deploy
You can upgrade the Warehouse Proxy Agent or the Summarization and Pruning Agent by remotely deploying bundles containing the installation image and other prerequisites.
Warehouse Proxy Agent silent install response file sample
Warehouse Proxy Agent silent config response file sample
Summarization and Pruning Agent silent install response file sample
Summarization and Pruning Agent silent config response file sample
Configuring the Warehouse Proxy Agent using the Tivoli Enterprise Portal
This function allows you to remotely configure the Warehouse Proxy Agent using the Tivoli Enterprise Portal. You can use this function anytime the Warehouse Proxy Agent configuration needs to be changed.
Configuring the Summarization and Pruning Agent using the Tivoli Enterprise Portal
This function allows you to remotely configure the Summarization and Pruning Agent using the Tivoli Enterprise Portal. You can use this function anytime the Summarization and Pruning Agent configuration needs to be changed.
Remotely starting and stopping the Warehouse Proxy Agent using the Tivoli Enterprise Portal
This function allows you to remotely manage the Warehouse Proxy Agent using the Tivoli Enterprise Portal. You can use this function anytime the Warehouse Proxy Agent needs to be started or stopped.
Remotely starting and stopping the Summarization and Pruning Agent using the Tivoli Enterprise Portal
This function allows you to remotely manage the Summarization and Pruning Agent using the Tivoli Enterprise Portal. You can use this function anytime the Summarization and Pruning Agent needs to be started or stopped.
Remotely deploying the Warehouse Proxy Agent
This function allows you to remotely deploy the Warehouse Proxy Agent. You can use this function anytime the Warehouse Proxy Agent needs to be installed remotely.
Remotely deploying the Summarization and Pruning Agent
This function allows you to remotely deploy the Summarization and Pruning Agent. You can use this function anytime the Summarization and Pruning Agent needs to be installed remotely.
WAREHOUSELOG and WAREHOUSEAGGREGLOG tables
The WAREHOUSELOG table lets you know how many exports succeed and how many failed because of an ODBC error or a timeout value issue.

Feedback