IBM E027SLL-H - Tivoli Monitoring - PC, Troubleshooting Manual

Page: 238 / 310

Nonlinear tasks take too long to complete
If nonlinear tasks are taking too long to complete, you can create indexes on the
_PA
table in the data warehouse. Creating an index reduces the time required to
store the results of the analysis in an output attribute table.
To add an index to the
_PA
table, run the appropriate command from the database
command prompt on the computer where the Tivoli Data Warehouse is running.
Create an index for each of the nonlinear attribute groups:
v DB2
CREATE INDEX DB2INST1.ITMIXFCMEM ON DB2INST1. attribute_group_name _PA
("System_Name" ASC) ALLOW REVERSE SCANS
v
Oracle
CREATE INDEX ITMIXFCMEM ON attribute_group_name _PA (System_Name ASC)
v
MS SQL
CREATE INDEX ITMIXFCMEM ON attribute_group_name _PA (System_Name ASC)
v
DB2 on z/OS
CREATE INDEX ITMIXFCMEM ON attribute_group_name _PA (System_Name ASC)
Create an index for each of the nonlinear attribute groups, adding the suffix _PA to
the name of each group:
v
KPA_GENERIC_D32_NLT_STATUS_PA
v
KPA_GENERIC_D64_NLT_STATUS_PA
v
KPA_GENERIC_I32_NLT_STATUS_PA
v
KPA_GENERIC_I64_NLT_STATUS_PA
v
KPA_GENERIC_D32_NLT_FCAST_PA
v
KPA_GENERIC_D64_NLT_FCAST_PA
v
KPA_GENERIC_I32_NLT_FCAST_PA
v
KPA_GENERIC_I64_NLT_FCAST_PA
v CPU_Utilization_NLT_Fcast_PA
v
Mem_Utilization_NLT_Fcast_PA
v Disk_Utilization_NLT_Fcast_PA
v
Net_Traffic_In_NLT_Fcast_PA
v
Net_Traffic_Out_NLT_Fcast_PA
v
CPU_Utilization_NLT_Status_PA
v
Mem_Utilization_NLT_Status_PA
v
Disk_Utilization_NLT_Status_PA
v
Net_Traffic_In_NLT_Status_PA
v
Net_Traffic_Out_NLT_Status_PA
For example, for the KPA_GENERIC_D32_NLT_FCAST attribute group in DB2, use
the following command:
CREATE INDEX DB2INST1.ITMIXFCMEM ON DB2INST1.KPA_GENERIC_D32_NLT_FCAST_PA
("System_Name" ASC) ALLOW REVERSE SCANS
220
IBM Tivoli Monitoring: Troubleshooting Guide