DB2 - Problembeschreibung
Problem IC79999 | Status: Geschlossen |
DB2 MAY TRAP IN SQLBGETMEMBINDINGFORPOOL WHEN STARTING UP WITH HIDDEN BUFFERPOOLS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
In case DB2 has to startup with hidden bufferpools due to a problem with SQLBP.1/2 files, DB2 may trap in qlbGetMemBindingForPool(). Stacktrace: -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00002AE3B0EF40E7 ossDumpStackTraceEx + 0x01f7 (/opt/ibm/db2/V9.5/lib64/libdb2osse.so.1) 0x00002AE3B0EEFBBA _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00b4 (/opt/ibm/db2/V9.5/lib64/libdb2osse.so.1) 0x00002AE3B0EEFC81 _ZN11OSSTrapFile4dumpEmiP7siginfoPv + 0x0009 (/opt/ibm/db2/V9.5/lib64/libdb2osse.so.1) 0x00002AE3AD24BC19 sqlo_trce + 0x0425 (/opt/ibm/db2/V9.5/lib64/libdb2e.so.1) 0x00002AE3AD28DD24 sqloEDUCodeTrapHandler + 0x0138 (/opt/ibm/db2/V9.5/lib64/libdb2e.so.1) 0x0000003A19C0EB10 address: 0x0000003A19C0EB10 ; dladdress: 0x0000003A19C00000 ; offset in lib: 0x000000000000EB10 ; (/lib64/libpthread.so.0) 0x00002AE3ADDEDEBC _Z24sqlbGetMemBindingForPoolP12SQLB_GLOBALSm + 0x0034 (/opt/ibm/db2/V9.5/lib64/libdb2e.so.1) 0x00002AE3ADE030C8 _Z12sqldScanOpenP8sqeAgentP14SQLD_SCANINFO1P14SQLD_SCANINFO2PPv + 0x01b4 (/opt/ibm/db2/V9.5/lib64/libdb2e.so.1) 0x00002AE3AC126201 _Z8sqlrliniP8sqlrr_cbb + 0x05b7 (/opt/ibm/db2/V9.5/lib64/libdb2e.so.1) 0x00002AE3AC040DC1 _Z15sqlrr_appl_initP8sqeAgentP5sqlca + 0x0807 (/opt/ibm/db2/V9.5/lib64/libdb2e.so.1) 0x00002AE3ABCF2D67 _ZN14sqeApplication20InitEngineComponentsEcP8sqeAgentP8SQLE_BWAP 5sqlcaP22SQLESRSU_STATUS_VECTORc + 0x02b5 (/opt/ibm/db2/V9.5/lib64/libdb2e.so.1) 0x00002AE3ABCF1A3B _ZN14sqeApplication13AppStartUsingEP8SQLE_BWAP8sqeAgentccP5sqlca Pc + 0x0523 (/opt/ibm/db2/V9.5/lib64/libdb2e.so.1) ... Before the trap you will see messages like this in db2diag.log: 2011-11-15-07.02.31.213814+060 I1037684E492 LEVEL: Error PID : 20282 TID : 47167091763520PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : STUDERA APPHDL : 0-4555 APPID: *LOCAL.db2inst1.111115060135 AUTHID : DB2INST1 EDUID : 58859 EDUNAME: db2agent (STUDERA) FUNCTION: DB2 UDB, buffer pool services, sqlbReadBufferPoolTable, probe:900 DATA #1 : String, 46 bytes Buffer Pool Headers do not match. Rebuilding. 2011-11-15-07.02.31.216448+060 I1038177E550 LEVEL: Error PID : 20282 TID : 47167091763520PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : STUDERA APPHDL : 0-4555 APPID: *LOCAL.db2inst1.111115060135 AUTHID : DB2INST1 EDUID : 58859 EDUNAME: db2agent (STUDERA) FUNCTION: DB2 UDB, buffer pool services, sqlbGetBufferPoolDefFromDisk, probe:130 MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not exist" DIA8506C Unexpected end of file was reached. 2011-11-15-07.02.31.216626+060 I1038728E545 LEVEL: Error PID : 20282 TID : 47167091763520PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : STUDERA APPHDL : 0-4555 APPID: *LOCAL.db2inst1.111115060135 AUTHID : DB2INST1 EDUID : 58859 EDUNAME: db2agent (STUDERA) FUNCTION: DB2 UDB, buffer pool services, sqlbReadBufferPoolTable, probe:935 MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not exist" DIA8506C Unexpected end of file was reached. 2011-11-15-07.02.31.225393+060 I1039274E539 LEVEL: Severe PID : 20282 TID : 47167091763520PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : STUDERA APPHDL : 0-4555 APPID: *LOCAL.db2inst1.111115060135 AUTHID : DB2INST1 EDUID : 58859 EDUNAME: db2agent (STUDERA) FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:620 DATA #1 : String, 70 bytes Database will come up with hidden buffer pools. totalBufferPoolPages: DATA #2 : signed integer, 8 bytes 64 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 6. * **************************************************************** | |
Local-Fix: | |
n/a | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 9.7 Fix Pack 6. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC80000 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 25.11.2011 06.06.2012 06.06.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP6 | |
Problem behoben lt. FixList in der Version | |
9.7.0.6 |