home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
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 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList