DB2 - Problem description
Problem IC76846 | Status: Closed |
DB2HMON AGENT AND DB2THROT DEADLOCK BETWEEN LATCH AND SEMAPHORE,LEADING TO DB2HMON HOLDING THE OLDEST TRANSACTION | |
product: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problem description: | |
When DB2HMON agent has deadlocked with db2throt process, the database very likely will run out of logfiles at some point in time, by DB2HMON holding the oldest transaction. Reaching NUM_LOG_SPAN nor FORCE APPLICATION will get the agent out of the hang. The instance needs to be stopped with db2_kill to clean the situation. The needed crash recovery afterwards might need longer to complete, as more logfiles need to be processed. Stack for the DB2HMON agent: 0: _semtimedop_sys() 1: semtimedop() 2: sqloWaitEDUWaitPost() 3: SqlthStartStopControlEDU::stopEDU() 4: SqlthControllerManager::cancelAControlSubscription() 5: SqlthJobControl::~SqlthJobControl() 6: SqlthJobControl::~SqlthJobControl() 7: SqlthJob::~SqlthJob() 8: SqlthJob::~SqlthJob() 9: SqlthJobManager::removeJob() 10: sqlrRunstatsTerminateJobServices() 11: sqlrLocalRunstats() ... db2throt shows the following stack: 0: _nanosleep_sys() 1: _nanosleep() 2: sqloSpinLockConflict() 3: SqlthControllerManager::HAS_NEW_JOB_STARTED_OR_COMPLETED() 4: SqlthControllerManager::asyncControllerMain() 5: SqlthStartStopControlEDU::_asyncControllerMain() 6: sqloCreateEDU() 7: sqloSpawnEDU() 8: SqlthStartStopControlEDU::startEDU() 9: SqlthControllerManager::newControlSubscription() 10: SqlthJobControl::setPriority() ... | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See error description above. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.1 Fix Pack 11. * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows | |
Solution | |
First fixed in DB2 Version 9.1 Fix Pack 11. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC77015 IC78547 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.06.2011 08.12.2011 08.12.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.1.FP11 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.1.0.11 |