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 1: Create the Tivoli Data Warehouse database
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
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.
For specific instructions on how to create a DB2 database, see the DB2 for Linux, UNIX and Windows documentation or have a database administrator create the database for you.
When you create the warehouse database using DB2, follow these guidelines:
- Create the database with UTF-8 encoding and a page size of 8K.
- Create a name for the warehouse database, and an operating system (OS) user account (user name and password) that the warehousing components (portal server, Warehouse Proxy Agent, and Summarization and Pruning Agent) can use to access the data warehouse. In these instructions, this user account is referred to as the warehouse user.
- Consider using the default values shown in Table 1 for the warehouse name and warehouse user. The default values are used in the configuration procedures for connecting the warehousing components to the warehouse database. (For example, see the entries in Figure 2.)
Default values for Tivoli Data Warehouse parameters
Parameter Default value Tivoli Data Warehouse database name WAREHOUS User name itmuser User password itmpswd1
- Give the warehouse user administrative authority to the database initially. After that, you can optionally limit the authority of the warehouse user to just the privileges required for interacting with the data warehouse. See the following sections for information about creating and limiting the authority of the warehouse user.
- Create a warehouse user on Windows
- Create a warehouse user on Linux or UNIX
- Limit the authority of the warehouse user
- For a Tivoli Data Warehouse on Linux or AIX, ensure that the DB2 for Linux, UNIX and Windows server is configured for TCP/IP communications. See Activating the DB2 listeners on a UNIX DB2 server.
Parent topic:
Step 1: Create the Tivoli Data Warehouse database