Wrong status in ILM Partitions table may cause trouble when trying use ILM
book
Article ID: 143534
calendar_today
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
When trying to drop a partition, some issues may occur : - Unable to disconnect the users from the partition which is supposed to get dropped - Unable to switch current partition to the next one
Environment
Release : 12.1
Component : AUTOMATION ENGINE
Cause
Check the ILM status on the partition in question : select IPH_State from IPH where IPH_PARTITION=<number>
If the the status is different than "1" then there is an issue.
Resolution
Change IPH table status in order to delete the ILM partition.
To do so, run the SQL query : update IPH set IPH_State=1 where IPH_PARTITION=<number>; commit;