DB2 - Problembeschreibung
Problem IC79046 | Status: Geschlossen |
INSTANCE MIGHT ABEND ON HP IN RESTORE OF LOAD COPY IMAGE CONTAINING LONG FIELD DATA DURING ROLLFORWARD | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
During rollforward, if a load copy that contains long field data is being restored, the following trap might occur from the prefetcher: 1201 2011-07-07-15.35.45.643377-240 I61279A378 LEVEL: Warning 1202 PID : 2372 TID : 21 PROC : db2sysc 1203 INSTANCE: instance NODE : 000 1204 EDUID : 21 EDUNAME: db2pfchr (SAMPLE) 1205 FUNCTION: DB2 UDB, RAS/PD component, pdEDUIsInDB2KernelOperation, probe:600 1206 DATA #1 : String, 12 bytes 1207 _Z7sqlplrq 1208 DATA #2 : String, 4 bytes 1209 sqlp The stack that identifies this issue: sqlplrq sqlbDMSMapAndWrite sqlbDMSDirectWrite sqlbDirectWrite sqlbServiceDirectWriteRequest sqlbPFPrefetcherEntryPoint sqbPrefetcherEdu It is because the prefetcher is attempting to obtain a long field lock but it cannot. This only occurs on HP | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * HP only * **************************************************************** * PROBLEM DESCRIPTION: * * see error description * **************************************************************** * RECOMMENDATION: * * upgrade to v97 fp5, or perform a PIT rollforward to avoid * * the load copy restore * **************************************************************** | |
Local-Fix: | |
perform PIT rollforward to before the load copy image | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
problem fixed in v97 fp5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 04.10.2011 02.01.2012 02.01.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP5, 9.7.FP5 | |
Problem behoben lt. FixList in der Version | |
9.7.0.5 |