How to resolve this error when user clicks on the PA task, and tries to open one of teh data collection PA chart collection panel
Monday, December 16, 2013
Tuesday, December 3, 2013
Fw: KFWITM217E Request error : [ IBM ] [CLI Driver] [DB2/Linux SQL0204N
This is because the CPU Utilization related PA tables are not created in the TDW.
To resolve this - Open the Historical Collection Configuration Panel and Enable the TPA hist collection attributes
This snap below is from ITM 6.2.2. - but a similar panel should show up for ITM 6.2.3 and above as well.
Login to the database and get a list of all the tables - this will tell that the CPU_Utilization LT _ Fcast table is missing !
Once the above is configured - the LT( Linear Trending ) related tables should get created once the Summarization and Pruning runs and the tables gets created.
Summarization and Pruning has to be set for these attributes,
The Summarization Scheduler job has to run ( in my case I have set it to 15 minutes ) for the tables to get created.
After the
1) LT Historical tasks were set.
2 ) Summarization task /job ( set to 15 mins in my case ) were set.
3 ) After checking that the tables got created in the DB.
> CPU_Utilization_LT_Fcast ITMUSER T 2013-12-03-06.40.12.023534
> CPU_Utilization_LT_Status ITMUSER T 2013-12-03-06.40.08.096000
> Disk_Utilization_LT_Fcast ITMUSER T 2013-12-03-06.40.11.025363
> Disk_Utilization_LT_Status ITMUSER T 2013-12-03-06.40.09.028300
Subscribe to:
Posts (Atom)