DB2 - Problembeschreibung
Problem IT07816 | Status: Geschlossen |
FOUND SELF DEAD LATCH FOR THE EDUS HANDLING THE ALTER TABLESPACE SWITCH ONLINE STATEMENT | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
From Application Snapshot: Application handle = 131133 Client login ID = db2inst1 Configuration NNAME of client = prddw3 Process ID of client application = 13320 Coordinator agent process or thread ID = 25 Most recent operation = Execute Immediate Dynamic SQL statement text: ALTER TABLESPACE TEMPSPACE2 SWITCH ONLINE Subsection status = Executing Execution elapsed time (seconds) = 43909 Agent process/thread ID = 233 From Stack: ====================== ? 0x00002AAAAC553BC7 _Z30sqlbTrackMultipleModificationsP20SQLB_DIRECT_WRITE_CB + 0x00ab 0x00002AAAAB8A7020 _Z35sqlbCheckTrackMultipleModificationsP20SQLB_DIRECT_WRITE_CB + 0x0058 0x00002AAAAC579D6E _Z18sqlbDMSDirectWriteP20SQLB_DIRECT_WRITE_CB + 0x01d8 0x00002AAAAB8BE28C _Z18sqlbInitPoolHeaderP12SQLB_GLOBALSP12SQLB_POOL_CB + 0x0160 0x00002AAAAC58C232 _Z15sqlbDMSInitPoolP12SQLB_GLOBALSP12SQLB_POOL_CB + 0x01fc 0x00002AAAAB8BDBCA _Z16sqlbDMSStartPoolP12SQLB_GLOBALSP12SQLB_POOL_CB + 0x05ea 0x00002AAAAC574580 _Z26sqlbSwitchTablespaceOnlinetP12SQLB_GLOBALS + 0x00aa ? Summary: Found in 6 stacks of a total of 743 stacks in 251 files Found in: ./13999.233.002.stack.txt -- db2agntp(TIS_STGP) -- 2015-03-04-10.55.17.599303(Signal #10) ./13999.233.002.stack.txt -- db2agntp(TIS_STGP) -- 2015-03-04-10.57.18.680600(Signal #10) ./13999.233.002.stack.txt -- db2agntp(TIS_STGP) -- 2015-03-04-11.01.43.761363(Signal #12) Latch: <LatchInformation> Waiting on latch type: (SQLO_LT_SQLB_POOL_CB__readLatch) - Address: (0x2aab833ccc90), Line: 4032, File: sqlbpacc.C Holding Latch type: (SQLO_LT_SQLB_POOL_CB__readLatch) - Address: (0x2aab833ccc90), Line: 2139, File: /view/db2_v97fp9_linuxamd64_s131204/vbs/engn/include/sqlbistorag e_inlines.h HoldCount: 1 Holding Latch type: (SQLO_LT_SQLB_POOL_CB__writeLatch) - Address: (0x2aab833ccca0), Line: 2158, File: /view/db2_v97fp9_linuxamd64_s131204/vbs/engn/include/sqlbistorag e_inlines.h HoldCount: 1 </LatchInformation> These shows that the edu with thread id 233 handling the ALTER TABLESPACE SWITCH ONLINE statement is having self dead latch. It seems it has no knowledge that the latch was already obtained previously, and continues waiting for it. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL USERS * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to latest fix pack. * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 19.03.2015 08.10.2015 08.10.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.7.0.11 |