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 | |
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 |