|
Problem IC67296
|
Status: Closed |
ROLLFORWARD FAILS WITH MESSAGE: SQL1042C AN UNEXPECTED SYSTEM ERROR OCCURRED. SQLSTATE=58004 |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
This problem happens when trying to rollforward a database that
contains a table with XML column(s).
If the table is unavailable for any reason, rollforward will
fail when trying to reorg that table.
In the db2diag.log, the following records were recorded:
2010-02-04-15.40.26.912561-300 I131497E3139 LEVEL: Severe
PID : 25566 TID : 47401540774208PROC :
db2sysc
INSTANCE: simap NODE : 000 DB : SPDB
APPHDL : 0-52 APPID: *LOCAL.simap.100204204023
AUTHID : SIMAP
EDUID : 266 EDUNAME: db2redom (SPDB)
FUNCTION: DB2 UDB, buffer pool services, sqlbDMScheckObjAlloc,
probe:790
MESSAGE : ZRC=0x8402001A=-2080243686=SQLB_EMP_MAP_INFO_END "EMP
MAP INFO END"
DATA #1 : signed integer, 4 bytes
2
DATA #2 : signed integer, 4 bytes
1
DATA #3 : signed integer, 8 bytes
0
DATA #4 : unsigned integer, 4 bytes
1
DATA #5 : unsigned integer, 4 bytes
0
DATA #6 : unsigned integer, 4 bytes
2
DATA #7 : Fix control block, PD_TYPE_SQLB_FIX_CB, 168 bytes
accessMethod: SQLB_POOL_RELATIVE
fixMode: 2 SQLBOLD/SQLBOLDS
buffptr: 0x00002b1cd5a73000
bpdPtr: 0x00002b1cd2e04280
dmDebugHdl: 1
objectPageNum: 0
empDiskPageNum: 768
unfixFlags: 0
dirtyState: SQLBCLEAN
fixInfoFlags: SQLB_PI_READ_FROM_DISK
regEDUid: 0
Pagekey: {pool:2;obj:4;type:70} PPNum:0
Obj: {pool:2;obj:4;type:70} Parent={2;4}
lifeLSN: 000000000251AE4B
tid: 0 0 0
extentAnchor: 768
initEmpPages: 0
poolPage0: 0
poolflags: 3122
objectState: 827
lastSMP: 0
pageSize: 4096
extentSize: 32
bufferPoolID: 1
partialHash: 1174667266
bufferPool: 0x00002b1cd2bba5a0
pdef: 0x00002b1cd2dcf280
glob: 0x00002b1ca20ba7e0
DATA #8 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {tbspSeed:2;obj:4;type:70} PPNum:0 OPNum:0
begoff: 48
datlen: 4048
pagebinx: 1490
revnum: 1280
pagelsn: 000000000251B7CB flag: a
future32: 0
cbits1to31: 0
cbits32to63: 0
DATA #9 : Dumped object of size 4096 bytes at offset 0, 57 bytes
/home/hotel50/simap/sqllib/db2dump/25566.266.000.dump.bin
CALLSTCK:
[0] 0x00002B1C6F6D9404 pdLog + 0x18C
[1] 0x00002B1C6FB77969
_Z20sqlbDMScheckObjAllocP16SQLB_OBJECT_DESCmiiPPjP12SQLB_GLOBALS
+ 0xF7D
[2] 0x00002B1C6F9E0420 _Z17sqlbGetDiskPageIDP11SQLB_FIX_CBPj +
0x2C0
[3] 0x00002B1C6FAD8DAE _Z19sqlbGetPageFromDiskP11SQLB_FIX_CBi
+ 0x34A
[4] 0x00002B1C6F9DC08C _Z7sqlbfixP11SQLB_FIX_CB + 0x25C8
[5] 0x00002B1C6F3FA707 _Z11sqlbFixPageP11SQLB_FIX_CBiji +
0x277
[6] 0x00002B1C6F42D9AB
_Z15sqldcsl_fixPageP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP14SQLDCSL
_FIX_CB
+ 0x207
[7] 0x00002B1C6F42C5DB
_Z18sqldcsl_fetchFirstP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16SQLD
CSL_FETCH_CB
+ 0x17F
[8] 0x00002B1C6F42CEBC
_Z16sqldcsl_fetchRowP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16SQLDCS
L_FETCH_CB
+ 0x16E
[9] 0x00002B1C6F432028
_Z33sqldcsl_reorgNonEmptyPageAndSlotsP16SQLD_REORGCSL_CB + 0x51C |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all users *
****************************************************************
* PROBLEM DESCRIPTION: *
* see APAR information *
****************************************************************
* RECOMMENDATION: *
* Customers must upgrade to V97 fixpack 3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
This problem is fixed in V97 fixpack 3 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC67471
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.03.2010
13.05.2010
13.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
