IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Specify where tables and indices are created

IBM Tivoli Monitoring, Version 6.3 Fix Pack 2


Environment variables

There are two variables that must be set in the Warehouse Proxy Agent environment file to specify the table space for the table and the indices.

KHD_DEFAULT_TABLE_CONTAINER

Name of the database container where tables should be placed.

KHD_DEFAULT_INDEX_CONTAINER

Name of the database container where indices should be placed. For DB2, when an index container is specified both the index and table containers must be database managed table spaces.
There are two variables that must be set in the Summarization and Pruning Agent environment file to specify the table space for the table and the indices:

KSY_DEFAULT_TABLE_CONTAINER

Name of the database container where tables should be placed.

KSY_DEFAULT_INDEX_CONTAINER

Name of the database container where indices should be placed. For DB2, when an index container is specified both the index and table containers must be database managed table spaces.
After the variables in the Warehouse Proxy Agent are set, run the Warehouse Proxy Agent. After the variables in the Summarization and Pruning Agent are set, schedule the Summarization and Pruning Agent to run at least every day. You will see the tables and indices created in the table spaces specified in the variables.


Parent topic:

Specify where tables and indices are created

+

Search Tips   |   Advanced Search