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 IC72288 Status: Geschlossen

DB2 CAN TRAP SQLBAFLSHFORDLSUBSET DURING ROLLFORWARD
INITIALIZATION

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
DB2 can trap with following stack while initializing 
rollforward. 
 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x09000000075AA214 
sqlbaflshForDLSubSet__FP9SQLP_LSN8iT2P12SQLB_GLOBALS + 0xD8 
0x090000000615BAF8 
sqlbaflshForFwdRecoveryDL__FP9SQLP_LSN8P12SQLB_GLOBALS + 0x14 
0x090000000615BA10 
sqlbaflshForFwdRecoveryDL__FP9SQLP_LSN8P12SQLB_GLOBALS@glue140 + 
0x70 
0x090000000537BB0C sqlpgasn__FPcUi + 0x11CC 
0x090000000745A3F8 
sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x270 
0x0900000007459E20 @49@sqloRunGDS__Fv + 0xDC 
0x0900000007458D94 sqloInitEDUServices + 0x180 
0x0900000004EE7D18 
@49@sqloSystemControllerMain__FCUiPFv_iPFi_vPPvCPi + 0x630 
0x09000000074536BC sqloRunInstance + 0xA8 
0x00000001000029F4 DB2main + 0x92C 
0x0000000100003D50 main + 0x10 
</StackTrace> 
 
Problem is that we try to flush a buffer pool which we have not 
started yet. 
 
 
db2diag.log shows: 
 
2010-10-25-08.48.07.548347+000 I18786A340        LEVEL: Warning 
PID    : 1237116              TID  : 1          PROC : db2loggr 
(XXX) 11 
INSTANCE: db2t31              NODE : 011 
FUNCTION: DB2 UDB, buffer pool services, sqlbInitEDU, probe:890 
MESSAGE : ZRC=0x8002014A=-2147352246=SQLB_BUFF_NOT_STARTED 
          "Bufferpool not started" 
 
2010-10-25-08.48.07.548690+000 I19127A301        LEVEL: Warning 
PID    : 1237116              TID  : 1          PROC : db2loggr 
(XXX) 11 
INSTANCE: db2t31              NODE : 011 
FUNCTION: DB2 UDB, data protection services, sqlpgasn, probe:358 
MESSAGE : Ignore error -2147352246 from sqlbInitEDU() 
 
... 
 
2010-10-25-08.48.07.976541+000 I22638A345        LEVEL: Event 
PID    : 1237116              TID  : 1          PROC : db2loggr 
(XXX) 11 
INSTANCE: db2t31              NODE : 011 
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, 
probe:10 
START  : Invoking /db2/db2t31/sqllib/bin/db2cos from oper system 
services sqloEDUCodeTrapHandler 
 
2010-10-25-08.48.13.987867+000 E25266A519         LEVEL: Severe 
PID     : 1237116              TID  : 1           PROC : 
db2loggr (XXX) 11 
INSTANCE: db2t31               NODE : 011 
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, 
probe:10 
MESSAGE : ADM0503C  An unexpected internal processing error has 
occurred.  ALL 
          DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN 
SHUTDOWN. 
          Diagnostic information has been recorded.  Contact IBM 
Support for 
          further assistance. 
 
2010-10-25-08.48.13.988127+000 E25786A652         LEVEL: Severe 
PID     : 1237116              TID  : 1           PROC : 
db2loggr (XXX) 11 
INSTANCE: db2t31               NODE : 011 
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, 
probe:20 
DATA #1 : Signal Number Recieved, 4 bytes 
11 
DATA #2 : Siginfo, 64 bytes 
0x0FFFFFFFFFFFD6A0 : 0000 000B 0000 0000 0000 0033 0000 0000 
...........3.... 
0x0FFFFFFFFFFFD6B0 : 0000 0000 0000 0000 0000 0000 0000 0010 
................ 
0x0FFFFFFFFFFFD6C0 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x0FFFFFFFFFFFD6D0 : 0000 0000 0000 0000 0000 0000 0000 0000 
................
Problem-Zusammenfassung:
USERS AFFECTED: All 
 
PROBLEM DESCRIPTION: 
 
see ERROR DESCRIPTION 
 
PROBLEM SUMMARY 
 
see ERROR DESCRIPTION
Local-Fix:
n/a
Lösung
The complete fix for this problem first appears in 
DB2 UDB Version 9.7 FixPak 3.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
29.10.2010
16.11.2010
16.11.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version