AWA: New ILM Partion is showing up in History

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

After an ILM switchover, the active partition is showing up in history instead of as an active partition.

 

 

Resolution

Provide the following results to support when opening a case - this will allow us to more quickly provide the queries to resolve:

1.) The PWP Log from the ILM partiton being activated.

2.) The results of the following SQL statements:
select * from USER_TAB_PARTITIONS -- make sure this is done for the correct schema owner.
select * from IPH
select * from UC_SYS
select * from ISTMT
select * from IDS
select * from ovw, oh where OH_Idnr=OVW_OH_Idnr and upper(dbms_lob.substr(oh_name,256,1))='UC_ILM_SETTINGS';