DB2 - Problembeschreibung
Problem IC89241 | Status: Geschlossen |
INSTANCE ABEND DURING DATABASE ROLLFORWARD | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
During a database rollforward, we may encounter an unexpected End of File (EOF) while prefetching pages if an automatic DMS tablespace is repeatedly being expanded during the rollforward. The DMS tablespace needs to have been created prior to v97 (i.e. a migrated database) for this to occur. Example db2diag.log messages: 2012-12-05-13.31.11.045535-420 E627148A511 LEVEL: Info PID : 49545328 TID : 27768 PROC : db2sysc0 INSTANCE: db2inst1 NODE : 000 DB :SAMPLE APPHDL : 0-9 APPID:*LOCAL.db2inst1.121205200111 AUTHID : db2inst1 EDUID : 27768 EDUNAME: db2redow (SAMPLE) 0 FUNCTION: DB2 UDB, buffer pool services, sqlbGrowLastRange,probe:60 MESSAGE : ADM6102I Table space "USERSPACE2" (ID "3") was successfully extended by "33554432" bytes. 2012-12-05-13.31.11.454924-420 I627660A388 LEVEL: Warning PID : 49545328 TID : 16460 PROC : db2sysc0 INSTANCE: db2inst1 NODE : 000 EDUID : 16460 EDUNAME: db2pfchr (SAMPLE) 0 FUNCTION: DB2 UDB, RAS/PD component, pdEDUIsInDB2KernelOperation, probe:600 DATA #1 : String, 22 bytes sqlbReadPageInternal DATA #2 : String, 4 bytes sqlb 2012-12-05-13.31.11.455395-420 I628049A454 LEVEL: Severe PID : 49545328 TID : 16460 PROC : db2sysc0 INSTANCE: db2inst1 NODE : 000 EDUID : 16460 EDUNAME: db2pfchr (SAMPLE) 0 FUNCTION: DB2 UDB, RAS/PD component, pdResilienceIsSafeToSustain, probe:800 DATA #1 : String, 37 bytes Trap Sustainability Criteria Checking DATA #2 : Hex integer, 8 bytes 0x200000000000884C DATA #3 : Boolean, 1 bytes false Example Stack: <StackTrace> -------Frame------ ------Function + Offset------ 0x090000000DFBCC7C sqlmStopWaitTimeInterval__FCUlP8sqeAgentCbN23@glue57C + 0x24C 0x090000000DECF348 sqlmStopInterval__FCUlP8sqeAgentCi@glue57A + 0x1FC 0x09000000116A27F8 sqlbReadPageInternal + 0x48 0x09000000116A65CC sqlbReadPage + 0x170 0x09000000116BA48C .sqlbGetPageFromDisk.fdpr.clone.2031__FP11SQLB_FIX_CBi + 0x694 Nested signal handlers detected <SignalDetails> <Siginfo_t length="64"> 07000000 01BFDEAC 00000000 00000002 00000000 00000FEA 00000000 00000000 FFFFFFFF FFFFFFFF 00000000 00000000 07000000 01BFE0C8 00000000 00000000 </Siginfo_t> Signal #117440512 (unknown signal name); si_code: 0 (SI_USER:Sent by kill, sigse nd, raise.) </SignalDetails> | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Any doing rollforward involving DMS automatic storage * * tablespaces * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please upgrade to V9.7 Fixpack 8 or later * **************************************************************** | |
Local-Fix: | |
The workaround is to db2set DB2_AVOID_PREFETCH=ON This can have a negative performance impact, so do not leave this set after the rollforward is completed. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows | |
Lösung | |
This problem is first fixed in V9.7 Fixpack 8 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 20.12.2012 09.05.2013 09.05.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP8 | |
Problem behoben lt. FixList in der Version | |
9.7.0.8 |