Set database and instance configuration values

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

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.

Value Purpose
LOGPRIMARY Number of primary transaction logs. In a production environment, this value should be larger than the default value.
LOGSECOND Number of secondary log files. In a production environment, this value should be larger than the default value.
NEWLOGPATH Location of transaction logs. To improve performance, the logs should be placed on a separate physical disk from the tables and indexes.
LOGFILSIZ Size of transaction log files. In a production environment, this value should be larger than the default value.
LOCKTIMEOUT Defaults to infinite wait, which can cause Warehouse Proxy and Summarization and Pruning processing to appear to be locked up. This should be set to a reasonable value such as 120 seconds.

Parent topic:
Step 1: Create the Tivoli Data Warehouse database

+
Search Tips | Advanced Search

Value	Purpose
LOGPRIMARY	Number of primary transaction logs. In a production environment, this value should be larger than the default value.
LOGSECOND	Number of secondary log files. In a production environment, this value should be larger than the default value.
NEWLOGPATH	Location of transaction logs. To improve performance, the logs should be placed on a separate physical disk from the tables and indexes.
LOGFILSIZ	Size of transaction log files. In a production environment, this value should be larger than the default value.
LOCKTIMEOUT	Defaults to infinite wait, which can cause Warehouse Proxy and Summarization and Pruning processing to appear to be locked up. This should be set to a reasonable value such as 120 seconds.