Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC72240 Status: Closed

DB2 CAN TRAP SQLBAFLSHFORDLSUBSET DURING ROLLFORWARD INITIALIZATION

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
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 Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 UDB LUW V9.1 FP10.                             * 
****************************************************************
Local Fix:
n/a
available fix packs:
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

Solution
Update to DB2 UDB LUW V9.1 FP10.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC72287 IC72288 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
27.10.2010
14.06.2011
14.06.2011
Problem solved at the following versions (IBM BugInfos)
9.1.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.10 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.