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

ACCESS PLANS CONTAINING INDEX ORING BETWEEN MDC AND NON MDC INDEX MAY NOT
FETCH ALL ROWS FROM SECOND EXECUTION ONWARDS

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
The problem might occur for access plans containing index ORing 
between two different indexes on the same MDC table, when one 
index is a regular index and the other index is a block index. 
 
The first open, fetch, and close operation on a statement with 
such an access plan is working correctly and returns all 
applying rows. All further open, fetch, and close operations on 
the same statement may fail to return all applying rows. 
 
An example of a vulnerable access plan: 
 
                             FETCH 
                             (   4) 
                             37.6199 
                             5.72592 
                           /---+----\ 
                       386.443       1247 
                       RIDSCN   TABLE: DB2V977 
                       (   5)         T1 
                       15.6706        Q1 
                          2 
       +----------------++-----------------+ 
     62.7736          415.667               1 
     SORT             SORT               SORT 
     (   6)           (   8)             (  10) 
     7.62301          7.97268           0.0758158 
        1                1                  0 
       |                |                  | 
     62.7736          415.667               1 
     IXSCAN           IXSCAN             IXSCAN 
     (   7)           (   9)             (  11) 
     7.61205          7.85609           0.0749869 
        1                1                  0 
       |                |                  | 
      1247             1247               1247 
 INDEX: DB2V977   INDEX: DB2V977     INDEX: SYSIBM 
       I1               I1         MDC / BLOCK INDEX 
       Q1               Q1                 Q1
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 4.                      * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 Version 10.5 Fix Pack 4.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.05.2014
06.11.2014
09.04.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList