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.
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:
- 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.
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.
- 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.
Parent topic:
Specify where tables and indices are created