IBM E027SLL-H Troubleshooting Guide - Page 238

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