home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList