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.
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
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
Yes
No
Powered by
