DB2 - Problembeschreibung
Problem IC67296 | Status: Geschlossen |
ROLLFORWARD FAILS WITH MESSAGE: SQL1042C AN UNEXPECTED SYSTEM ERROR OCCURRED. SQLSTATE=58004 | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * all users * **************************************************************** * PROBLEM DESCRIPTION: * * see APAR information * **************************************************************** * RECOMMENDATION: * * Customers must upgrade to V97 fixpack 3 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
This problem is fixed in V97 fixpack 3 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC67471 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 17.03.2010 13.05.2010 13.05.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP3 | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |