DB2 - Problem description
Problem IT34534 | Status: Closed |
Db2 Administrative Task Scheduler stops executing scheduled tasks | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Db2 ATS ("administrative task scheduler") might stop executing scheduled task after running ADMIN_TASK_UPDATE routine under specific timing conditions. SYSTOOLS.ADMINTASKSTATUS administrative view report no new execution entries as the result. A backtrace from db2acd process (its process ID is reported e.g. in "db2pd -edus") will show one thread with db2HmonAtsPollDatabase on the stack waiting in AtsList::lockIt -> ossLockGetConflict ossLockGetConflict AtsList::lockIt AtsDaemon::removeTaskFromPending AtsDbInfo::refreshTasks db2HmonAtsPollDatabase and another in a stack with AtsTask::lockIt -> ossLockGetConflict: ossLockGetConflict AtsTask::lockIt AtsDaemon::run AtsThread::entryPoint Backtrace can be obtained using OS tools (e.g. gstack on Linux or procstack on AIX). | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Db2 version 11.5 Mod 5 Fix Pack 0 or higher. * **************************************************************** | |
Local Fix: | |
Killing db2acd process will restart ATS as db2acd will be automatically respawned: $ kill | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Db2 version 11.5 Mod 5 Fix Pack 0 or higher. * **************************************************************** | |
Comment | |
Problem first fixed in Db2 version 11.5 Mod 5 Fix Pack 0 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 14.10.2020 19.11.2020 19.11.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |