EasyManua.ls Logo

IBM E027SLL-H - Tivoli Monitoring - PC - Nonlinear Tasks Take too Long to Complete

IBM E027SLL-H - Tivoli Monitoring - PC
310 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Loading...
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

Table of Contents

Related product manuals