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 |
