DB2 - Problem description
Problem IT21820 | Status: Closed |
LATCHES SUCH AS SQLO_LT_SQLP_DBCB__READBUFSEM ARE NOT BEING REPORTED IN MON_GET_EXTENDED_LATCH_WAIT | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
The MON_GET_EXTENDED_LATCH_WAIT table function isn't reporting all latches that have been involved in extended latch waits. For example, the following stack shows an EDU involved in a wait: sqloXlatchConflict sqloxltc_track sqlpgrlg sqlpReadLogForCC sqldGetCurrentlyCommitted sqliLockUncond sqldRowFetch sqldRowFetch sqldRowFetch sqlritaSimplePerm sqlritaSimplePerm sqlritaSimplePerm sqlriSectInvoke sqlrr_process_fetch_request sqlrr_open sqljsParseRdbAccessed sqljsSqlam sqljsSqlam sqljsSqlam sqljsDriveRequests sqljsDrdaAsInnerDriver RunEDU RunEDU EDUDriver sqloEDUEntry Waiting on latch type: (SQLO_LT_SQLP_DBCB__ReadBufSem) - Address: (0xa00030000199140), Line: 1553, File: sqlpgrlg.C However the ReadBufSem latch isn't reported by MON_GET_EXTENDED_LATCH_WAIT. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users below v11.1 Fixpack 2 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to fixpack 2 in v11 to overcome the problem. * **************************************************************** | |
Local Fix: | |
Use "db2pd -latches" to see current latch information. | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT17841 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.08.2017 12.10.2017 12.10.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |