DB2 - Problem description
| Problem IC72288 | Status: Closed |
DB2 CAN TRAP SQLBAFLSHFORDLSUBSET DURING ROLLFORWARD INITIALIZATION | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - 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 PROBLEM SUMMARY see ERROR DESCRIPTION | |
| Local Fix: | |
n/a | |
| Solution | |
The complete fix for this problem first appears in DB2 UDB Version 9.7 FixPak 3. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.10.2010 16.11.2010 16.11.2010 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7. | |
| Problem solved according to the fixlist(s) of the following version(s) | |