Troubleshooting
Problem
Optim Performance Manager (OPM) was deactivated or removed and some monitors and watchdogs were left behind. When user tries to remove them SQL20453N is returned.
Symptom
A DB2 call fails as follows:
db2 -v "call SYSPROC.ADMIN_TASK_REMOVE(<OPM_ROUTINE_NAME>,NULL)"
call SYSPROC.ADMIN_TASK_REMOVE(<OPM_ROUTINE_NAME>,NULL)
SQL20453N The task "OPM_D1IQZ7_WLMS_EVMON_WATCHDOG" cannot be removed because
it is currently executing. SQLSTATE=5UA01
Since OPM has been removed the expectation is that no OPM related processes should be executing. Therefore the SQL20453N should not be returned.
Cause
As part of the procedure to remove OPM from DB2 some OPM watchdogs were left behind. Those tasks will remain active and only a manual clean up will get rid of them
Environment
Linux, Unix and Windows where OPM was removed from DB2 LUW
Diagnosing The Problem
Using the following query to identify any OPM task that is executing:
db2 -v "select varchar(name, 40) as Name, status, begin_time, end_time from systools.admin_task_status where name like '%OPM%' and status != 'COMPLETE'"
Any attempt to remove the items listed in this query will fail as indicated.
Resolving The Problem
1. Turn off the watchdog before trying to remove
To do this you need to update the task with max_invocations to 0 :
db2 -v "CALL SYSPROC.ADMIN_TASK_UPDATE(<OPM_ROUTINE_NAME>,null,null,0,null,null,null)"
2. Restart the instance
3. Try to remove the task again
db2 -v "call SYSPROC.ADMIN_TASK_REMOVE(<OPM_ROUTINE_NAME>,NULL)"
Note. Under certain circumstances you might need to turn ON or OFF the administrative task scheduler using the registry DB2_ATS_ENABLE.
Related Information
Was this topic helpful?
Document Information
Modified date:
08 July 2021
UID
swg21591861