Wrong status in ILM Partitions table may cause trouble when trying use ILM
Article ID: 143534
Updated On:
Products
CA Automic Workload Automation - Automation Engine
CA Automic One Automation
CA Automic Oracle
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
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.
select IPH_State from IPH where IPH_PARTITION=<number>
If the the status is different than "1" then there is an issue.
Environment
Release : 12.1
Component : AUTOMATION ENGINE
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;
Then the partition can be dropped.
To do so, run the SQL query :
update IPH set IPH_State=1 where IPH_PARTITION=<number>;
commit;
Then the partition can be dropped.
Feedback
Powered by
