IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Tivoli Data Warehouse solution using DB2 for Linux, UNIX, and Windows
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Supported components
This section illustrates the warehouse solution using DB2 for Linux, UNIX and Windows.
Figure 1 presents the options for a Tivoli Data Warehouse solution using DB2 for Linux, UNIX and Windows for the warehouse database. The diagram summarizes the supported operating system platforms for the various warehousing components, the supported database products, and the connections between components. For more specific information about supported operating systems and database products, including product names and versions, see Hardware and software requirements.Figure 1. Tivoli Data Warehouse solution using DB2 for Linux, UNIX and Windows
An asterisk (*) next to a database client indicates that you must manually install the client if it does not already exist.
In the following discussion, numbered product components correspond to the numbers on the diagram.
Tivoli Data Warehouse on DB2 for Linux, UNIX and Windows
A Tivoli Data Warehouse database on DB2 for Linux, UNIX and Windows can be installed on supported Windows, Linux, or any UNIX platform that is supported by DB2 for Linux, UNIX and Windows. Ensure that the DB2 TCP/IP listeners are active in order to accept connections from a DB2 client or JDBC driver.
Warehouse Proxy Agent
A Warehouse Proxy Agent on Linux or AIX communicates with the warehouse database through a JDBC connection. Install a Type 4 driver (DB2 for Linux, UNIX and Windows JDBC Universal Driver) on the computer where the Warehouse Proxy Agent is located.
A Warehouse Proxy Agent on Windows communicates with the warehouse database through an ODBC connection. The ODBC driver is included with the DB2 for Linux, UNIX and Windows client. If the Tivoli Data Warehouse is located on a remote computer, install a DB2 client on the local computer where the Warehouse Proxy Agent is located. Also, catalog the remote node and database on the local computer.
Tivoli Enterprise Portal Server
A Tivoli Enterprise Portal Server on Windows, Linux, or AIX can connect to a DB2 for Linux, UNIX and Windows data warehouse through a DB2 for Linux, UNIX and Windows client installed on the portal server. If the portal server database (designated as TEPS database in the diagram) uses DB2 for Linux, UNIX and Windows, the DB2 client already exists. Manually install a DB2 for Linux, UNIX and Windows client on the portal server only if the portal server database uses Microsoft SQL Server.
A portal server on Windows communicates with the warehouse database through an ODBC connection. The ODBC driver is included with the DB2 for Linux, UNIX and Windows client. Catalog the remote warehouse node and database on the portal server.
A portal server on Linux or AIX uses the DB2 for Linux, UNIX and Windows CLI interface, a proprietary connection, to communicate with the warehouse database. If the warehouse database is installed on a different computer from the portal server, catalog the remote database and remote node on the portal server.
Summarization and Pruning Agent
The Summarization and Pruning Agent communicates with the warehouse database through a JDBC connection from any supported operating system. Install a DB2 for Linux, UNIX and Windows Type 4 JDBC driver (DB2 for Linux, UNIX and Windows JDBC Universal Driver) on the computer where the Summarization and Pruning Agent is located.
Parent topic:
Tivoli Data Warehouse solution using DB2 for Linux, UNIX, and Windows