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


No comments:

Post a Comment