ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

AWA: New ILM Partion is showing up in History

book

Article ID: 145850

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine 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';