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 IC62948 Status: Geschlossen

Load with COPY YES option into a Range Partitioned table may trap in
rare timing scenarios.

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
When the target table is a (non-MDC) Range Partitioned table, 
and Load is invoked with the COPY YES option, in rare timing 
scenarios it's possible for the Load to trap (likely with 
sqluTransformMergeRequestio or sqluTransformMergeFSCRRequest in 
the stack), or it's possible for the Load to panic with a 
BADPAGE error (likely with similar functions in the stack). The 
exact stack that is generate may differ, but will involve the 
Load 'db2lbm' or 'db2lrid' edus. 
 
This is caused by a rare timing scenario where both the db2lbm 
and db2lrid EDUs are manipulating the same Load data-page 
concurrently. 
 
The problem is more likely to occur when the number of ranges is 
very large.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* BAD PAGE DETECTED IN SQLB_VERIFY_PAGE WHILE EXEUCTING        * 
* LOADAGAINST A RANGE PARTITIONED TABLE                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When the table is a (non-MDC) RP table, and Load has theCOPY * 
* YES flag, extents are only sent to the copy image ifthey are * 
* either completely full, or at the end of Load Phasewe are    * 
* flushing all the partially filled extents. In thelatter      * 
* scenario, some special logic exists to send thesepartially   * 
* filled extents over to a BufferManipulator EDU tofirst to    * 
* merge the partially filled extent with any pages incontainer * 
* that were previously victimized (ie. MDC/RP Loadcaching      * 
* algorithm) and then over to the MediaWriter EDUwithout       * 
* actually writing the extent to container (since itwas        * 
* previously flushed to container). This logic                 * 
* willinadvertently recycle a transfer-buffer twice, and if    * 
* enoughranges exist the transfer-buffer might be reused by    * 
* theRidder twice (whilst one of the transfer-buffers has not  * 
* yetbeen flushed out). When this happens we can see           * 
* differenttypes of errors such as bad-pages, or even          * 
* traps.The problem is exacerbated by the fact that the number * 
* of RPranges was so huge (I know this because the             * 
* extent-cachingwas automatically disabled for the table (the  * 
* 'cachingdisabled at startup' message in the db2diag.log)     * 
* because ofthis), so the number of partially filled extents   * 
* flushed atthe end of Load Phase was huge, increasing the     * 
* probabilityof encountering it.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Any user encountering this APAR should upgrade to This       * 
* APARis fixed in DB2 LUW Version 9.5 fixpack 6                * 
****************************************************************
Local-Fix:
No Local Fix.
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
This APAR is fixed in DB2 LUW Version 9.5 fixpack 6
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC63845 IC64633 IC69146 JR36829 IC69148 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
02.09.2009
13.09.2010
13.09.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP6
Problem behoben lt. FixList in der Version