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.
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 Planning considerations for the Tivoli Data Warehouse. For information about creating the warehouse database using DB2, see Creating 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. |
Creating a warehouse user on Windows |
(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. |
Limiting 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 |