Step 1: Create the Tivoli Data Warehouse database

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

Step 1: Create the Tivoli Data Warehouse database

This section provides guidelines for creating a Tivoli Data Warehouse database using DB2 for Linux, UNIX and Windows.
Complete the tasks described in the following table to create a Tivoli Data Warehouse database using DB2 for Linux, UNIX and Windows and to make it accessible to clients.

Tasks for creating the Tivoli Data Warehouse database

Task Procedure
Create the Tivoli Data Warehouse database on one of the supported Windows, Linux, or UNIX operating systems.
To comply with the assumptions described in the introduction to this chapter, create the warehouse database on a different computer from the Tivoli Enterprise Portal Server.
For guidance on planning the size and disk requirements for the warehouse database, see Plan considerations for the Tivoli Data Warehouse.
For information about creating the warehouse database using DB2, see Create the warehouse database on DB2 for Linux, UNIX and Windows.
Create an operating system (OS) user account (user name and password) with administrator authority on the computer where the warehouse database is located.
The warehousing components (portal server, Warehouse Proxy Agents, and Summarization and Pruning Agent) will use this OS user account to access the database. Create only one user account for all warehousing components to use. This user is referred to in this chapter as the warehouse user.
Create a warehouse user on Windows
Create a warehouse user on Linux or UNIX
(Optional) Restrict the authority of the warehouse user.
Initially, the warehouse user is created with OS administrative authority. Use the referenced procedure if you want to limit the authority of the warehouse user to just those privileges required to access and use the data warehouse.
Limit the authority of the warehouse user
(Tivoli Data Warehouse on Linux or AIX only)
Activate the DB2 for Linux, UNIX and Windows TCP/IP listeners on the DB2 server where the Tivoli Data Warehouse is installed.
The TCP/IP listener processes on the DB2 for Linux, UNIX and Windows server must be active in order to accept connections from a DB2 for Linux, UNIX and Windows client or JDBC driver. The DB2 listeners are automatically activated on Windows systems. Perform the referenced procedure to activate the DB2 listeners if the warehouse database is located on a Linux or AIX system.
Activating the DB2 listeners on a UNIX DB2 server

Create the warehouse database on DB2 for Linux, UNIX and Windows
This section provides guidelines for creating the Tivoli Data Warehouse database on DB2 for Linux, UNIX and Windows.

Create a warehouse user on Windows
Complete the steps in this section on the computer where the warehouse database is installed to create a Windows OS user with Administrator authority.

Create a warehouse user on Linux or UNIX
Complete the procedure in this section on the computer where the warehouse database is installed to create a Linux or UNIX OS user with administrative authority to the warehouse.

Limit the authority of the warehouse user
If you do not want the warehouse user to have broad administrative authority, you can limit the authority of the warehouse user to just those privileges required for accessing and using the data warehouse. These more limited privileges include the authority to create and update tables, to insert or delete information from the tables, to create indexes for the tables, and to grant public authority to the tables.

Set database and instance configuration values
The default values for many of the configuration values for the DB2 for Linux, UNIX and Windows database and the DB2 for Linux, UNIX and Windows instance may not be acceptable for a production environment.

Activating the DB2 listeners on a UNIX DB2 server
The TCP/IP listener processes on the DB2 for Linux, UNIX and Windows server where the Tivoli Data Warehouse database is installed must be active in order to accept connections from a DB2 for Linux, UNIX and Windows client or a JDBC Type 4 driver (DB2 for Linux, UNIX and Windows JDBC Universal Driver).

Parent topic:
Tivoli Data Warehouse solution using DB2 for Linux, UNIX, and Windows

+
Search Tips | Advanced Search

Task	Procedure
Create the Tivoli Data Warehouse database on one of the supported Windows, Linux, or UNIX operating systems. To comply with the assumptions described in the introduction to this chapter, create the warehouse database on a different computer from the Tivoli Enterprise Portal Server.	For guidance on planning the size and disk requirements for the warehouse database, see Plan considerations for the Tivoli Data Warehouse. For information about creating the warehouse database using DB2, see Create the warehouse database on DB2 for Linux, UNIX and Windows.
Create an operating system (OS) user account (user name and password) with administrator authority on the computer where the warehouse database is located. The warehousing components (portal server, Warehouse Proxy Agents, and Summarization and Pruning Agent) will use this OS user account to access the database. Create only one user account for all warehousing components to use. This user is referred to in this chapter as the warehouse user.	Create a warehouse user on Windows Create a warehouse user on Linux or UNIX
(Optional) Restrict the authority of the warehouse user. Initially, the warehouse user is created with OS administrative authority. Use the referenced procedure if you want to limit the authority of the warehouse user to just those privileges required to access and use the data warehouse.	Limit the authority of the warehouse user
(Tivoli Data Warehouse on Linux or AIX only) Activate the DB2 for Linux, UNIX and Windows TCP/IP listeners on the DB2 server where the Tivoli Data Warehouse is installed. The TCP/IP listener processes on the DB2 for Linux, UNIX and Windows server must be active in order to accept connections from a DB2 for Linux, UNIX and Windows client or JDBC driver. The DB2 listeners are automatically activated on Windows systems. Perform the referenced procedure to activate the DB2 listeners if the warehouse database is located on a Linux or AIX system.	Activating the DB2 listeners on a UNIX DB2 server