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

CALL TO SYSPROC.REORGCHK_IX_STATS('T','ALL') MAY
PRODUCE INCORRECT RESULTS

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
The sysproc.REORGCHK_IX_STATS procedure returns two different 
outputs when its runs against a single table and 
against all tables. The results returned when run against all 
tables is not correct. 
 
Sample output 
 
CALL sysproc.REORGCHK_IX_STATS('T','VENTAS.VENTA') 
 
 
TABLE_SCHEMA    TABLE_NAME    INDEX_SCHEMA    INDEX_NAME 
INDCARD    NLEAF    NUM_EMPTY_LEAFS    NLEVELS 
NUMRIDS_DELETED    FULLKEYCARD    LEAF_RECSIZE 
NONLEAF_RECSIZE   LEAF_PAGE_OVERHEAD    NONLEAF_PAGE_OVERHEAD 
F4    F5    F6    F7    F8    REORG 
VENTAS      VENTA    VENTAS      IX_VENTA_02 
2036380584    908722    9    3    22113685    7341552    11 
11    3206    3206    100    68    0    1    0    ----- 
VENTAS      VENTA    VENTAS      IX_VTA_ARTICULO 
2036381326    675996    0    3    1205830    243038    5    5 
4452    4452    33    95    0    0    0    *---- 
VENTAS      VENTA    VENTAS      IX_VENTA_03 
2036381326    689965    9    3    684651    98844    14    14 
2936    2936    98    89    0    0    0    ----- 
VENTAS      VENTA    VENTAS      IX_VTA_ARTCT 
2036381326    684180    0    3    1836419    1418327    15    15 
2936    2936    11    89    0    0    0    *---- 
VENTAS      VENTA    VENTAS      IX_VENTA_01 
2036380584    853148    27    4    24976958    7341552    11 
11    3206    3206    100    73    224    1    0    --*-- 
VENTAS      VENTA    VENTAS      PK_VENTA 
2036380584    1485009    966    3    40876480    2036380584    8 
8    3534    3534    100    89    0    1    0    ----- 
 
CALL sysproc.REORGCHK_IX_STATS('T','ALL') 
 
 
TABLE_SCHEMA    TABLE_NAME    INDEX_SCHEMA    INDEX_NAME 
INDCARD    NLEAF    NUM_EMPTY_LEAFS    NLEVELS 
NUMRIDS_DELETED    FULLKEYCARD    LEAF_RECSIZE 
NONLEAF_RECSIZE    LEAF_PAGE_OVERHEAD    NONLEAF_PAGE_OVERHEAD 
F4    F5    F6    F7    F8    REORG 
 
VENTAS      VENTA    VENTAS      IX_VENTA_02 
2036380584    908722    9    3    0    7341552    -1    -1    -1 
-1    100    -1    -1    0    0    ----- 
VENTAS      VENTA    VENTAS      IX_VTA_ARTICULO 
2036381326    675996    0    3    0    243038    -1    -1    -1 
-1    33    -1    -1    0    0    ----- 
VENTAS      VENTA    VENTAS      IX_VENTA_03 
2036381326    689965    9    3    0    98844    -1    -1    -1 
-1    98    -1    -1    0    0    ----- 
VENTAS      VENTA    VENTAS      IX_VTA_ARTCT 
2036381326    684180    0    3    0    1418327    -1    -1    -1 
-1    11    -1    -1    0    0    ----- 
VENTAS      VENTA    VENTAS      IX_VENTA_01 
2036380584    853148    27    4    0    7341552    -1    -1 
-1    -1    100    -1    -1    0    0    ----- 
VENTAS      VENTA    VENTAS      PK_VENTA 
2036380584    1485009    966    3    0    2036380584    -1    -1 
-1    -1    100    -1    -1    0    0    ----- 
 
From the above output we see the diffrences in columns 
NUMRIDS_DELETED,LEAF_RECSIZE, NONLEAF_RECSIZE, 
LEAF_PAGE_OVERHEAD, NONLEAF_PAGE_OVERHEAD, F4, F5, F6, F7, F8, 
REORG.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users prior to DB2 V10 FP1                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* CALL TO SYSPROC.REORGCHK_IX_STATS('T','ALL') MAY PRODUCE     * 
* INCORRECT RESULTS                                            * 
*                                                              * 
* The sysproc.REORGCHK_IX_STATS procedure returns two          * 
* different                                                    * 
* outputs when its runs against a single table and             * 
*                                                              * 
* against all tables. The results returned when run against    * 
* all                                                          * 
* tables is not correct.                                       * 
*                                                              * 
*                                                              * 
*                                                              * 
* Sample output                                                * 
*                                                              * 
*                                                              * 
*                                                              * 
* CALL sysproc.REORGCHK_IX_STATS('T','VENTAS.VENTA')           * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
* TABLE_SCHEMA    TABLE_NAME    INDEX_SCHEMA    INDEX_NAME     * 
*                                                              * 
* INDCARD    NLEAF    NUM_EMPTY_LEAFS    NLEVELS               * 
*                                                              * 
* NUMRIDS_DELETED    FULLKEYCARD    LEAF_RECSIZE               * 
*                                                              * 
* NONLEAF_RECSIZE   LEAF_PAGE_OVERHEAD                         * 
* NONLEAF_PAGE_OVERHEAD                                        * 
* F4    F5    F6    F7    F8    REORG                          * 
*                                                              * 
* VENTAS      VENTA    VENTAS      IX_VENTA_02                 * 
*                                                              * 
* 2036380584    908722    9    3    22113685    7341552    11  * 
*                                                              * 
* 11    3206    3206    100    68    0    1    0    -----      * 
*                                                              * 
* VENTAS      VENTA    VENTAS      IX_VTA_ARTICULO             * 
*                                                              * 
* 2036381326    675996    0    3    1205830    243038    5     * 
* 5                                                            * 
* 4452    4452    33    95    0    0    0    *----             * 
*                                                              * 
* VENTAS      VENTA    VENTAS      IX_VENTA_03                 * 
*                                                              * 
* 2036381326    689965    9    3    684651    98844    14      * 
* 14                                                           * 
* 2936    2936    98    89    0    0    0    -----             * 
*                                                              * 
* VENTAS      VENTA    VENTAS      IX_VTA_ARTCT                * 
*                                                              * 
* 2036381326    684180    0    3    1836419    1418327    15   * 
* 15                                                           * 
* 2936    2936    11    89    0    0    0    *----             * 
*                                                              * 
* VENTAS      VENTA    VENTAS      IX_VENTA_01                 * 
*                                                              * 
* 2036380584    853148    27    4    24976958    7341552    11 * 
*                                                              * 
* 11    3206    3206    100    73    224    1    0    --*--    * 
*                                                              * 
* VENTAS      VENTA    VENTAS      PK_VENTA                    * 
*                                                              * 
* 2036380584    1485009    966    3    40876480    2036380584  * 
* 8                                                            * 
* 8    3534    3534    100    89    0    1    0    -----       * 
*                                                              * 
*                                                              * 
*                                                              * 
* CALL sysproc.REORGCHK_IX_STATS('T','ALL')                    * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
* TABLE_SCHEMA    TABLE_NAME    INDEX_SCHEMA    INDEX_NAME     * 
*                                                              * 
* INDCARD    NLEAF    NUM_EMPTY_LEAFS    NLEVELS               * 
*                                                              * 
* NUMRIDS_DELETED    FULLKEYCARD    LEAF_RECSIZE               * 
*                                                              * 
* NONLEAF_RECSIZE    LEAF_PAGE_OVERHEAD                        * 
* NONLEAF_PAGE_OVERHEAD                                        * 
* F4    F5    F6    F7    F8    REORG                          * 
*                                                              * 
*                                                              * 
*                                                              * 
* VENTAS      VENTA    VENTAS      IX_VENTA_02                 * 
*                                                              * 
* 2036380584    908722    9    3    0    7341552    -1    -1   * 
* -1                                                           * 
* -1    100    -1    -1    0    0    -----                     * 
*                                                              * 
* VENTAS      VENTA    VENTAS      IX_VTA_ARTICULO             * 
*                                                              * 
* 2036381326    675996    0    3    0    243038    -1    -1    * 
* -1                                                           * 
* -1    33    -1    -1    0    0    -----                      * 
*                                                              * 
* VENTAS      VENTA    VENTAS      IX_VENTA_03                 * 
*                                                              * 
* 2036381326    689965    9    3    0    98844    -1    -1     * 
* -1                                                           * 
* -1    98    -1    -1    0    0    -----                      * 
*                                                              * 
* VENTAS      VENTA    VENTAS      IX_VTA_ARTCT                * 
*                                                              * 
* 2036381326    684180    0    3    0    1418327    -1    -1   * 
* -1                                                           * 
* -1    11    -1    -1    0    0    -----                      * 
*                                                              * 
* VENTAS      VENTA    VENTAS      IX_VENTA_01                 * 
*                                                              * 
* 2036380584    853148    27    4    0    7341552    -1    -1  * 
*                                                              * 
* -1    -1    100    -1    -1    0    0    -----               * 
*                                                              * 
* VENTAS      VENTA    VENTAS      PK_VENTA                    * 
*                                                              * 
* 2036380584    1485009    966    3    0    2036380584    -1   * 
* -1                                                           * 
* -1    -1    100    -1    -1    0    0    -----               * 
*                                                              * 
*                                                              * 
*                                                              * 
* From the above output we see the diffrences in columns       * 
*                                                              * 
* NUMRIDS_DELETED,LEAF_RECSIZE, NONLEAF_RECSIZE,               * 
*                                                              * 
* LEAF_PAGE_OVERHEAD, NONLEAF_PAGE_OVERHEAD, F4, F5, F6, F7,   * 
* F8,                                                          * 
* REORG.                                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10 FP1                                       * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
13.06.2012
21.11.2012
21.11.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.1 FixList
10.5.0.1 FixList