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

DB2 CAN TRAP SQLBAFLSHFORDLSUBSET DURING ROLLFORWARD INITIALIZATION

Produkt:
DB2 FOR LUW / DB2FORLUW / 910 - 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                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 UDB LUW V9.1 FP10.                             * 
****************************************************************
Local-Fix:
n/a
verfügbare FixPacks:
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Lösung
Update to DB2 UDB LUW V9.1 FP10.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC72287 IC72288 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.10.2010
14.06.2011
14.06.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.1.FP10
Problem behoben lt. FixList in der Version
9.1.0.10 FixList