DB2 FOR LUW / DB2FORLUW / 950 - DB2

Problem description: 
***************** 
REORGCHK and SYSPROC.REORGCHK_IX_STATS  showing different 
output: 
CALL 
SYSPROC.REORGCHK_IX_STATS('T','GXXXXX.STG_GEN_CLAIM_XXXXXXX_XX_X 
X_XXXX_XXXX') 
 
 
Result set 1 
-------------- 
 
TABLE_SCHEMA      TABLE_NAME 
                INDEX_SCHEMA      INDEX_NAME        INDCARD 
NLEAF     NUM_EMPTY_LEAFS      NLEVELS 
 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
  --------- 
GXXXXX                 STG_GEN_CLAIM_XXXXXXX_XX_XX_XXXX_XXXX 
 GXXXXX                PKXC_ZKEL_BK      153872     192 
0                                 2 
 
 
 
 
NUMRIDS_DELETED  FULLKEYCARD   LEAF_RECSIZE  NONLEAF_RECSIZE 
LEAF_PAGE_OVERHEAD   NONLEAF_PAGE_OVERHEAD       F4     F5    F6 
   F7   F8    REORG 
 
   0                         1230976            7 
  7                          2132                          2132 
                                  100     0    -1     0     0 
 -*--- 
 
 
 
REORGCHK CURRENT STATISTICS ON TABLE 
GXXXXX.STG_GEN_CLAIM_XXXXXXX_XX_XX_XXXX_XXXX 
 
Table statistics: 
 
F1: 100 * OVERFLOW / CARD < 5 
F2: 100 * (Effective Space Utilization of Data Pages) > 70 
F3: 100 * (Required Pages / Total Pages) > 80 
 
SCHEMA.NAME 
                   CARD                     OV 
NP                 FP ACTBLK               TSIZE            F1 
  F2        F3       REORG 
---------------------------------------------------------------- 
------------------------ 
Table: GXXXXX.STG_GEN_CLAIM_XXXXXXX_XX_XX_XXXX_XXXX       153872 
                 0                    496                496 
 -                8001344         0      99        100 
--- 
---------------------------------------------------------------- 
------------------------ 
 
Index statistics: 
 
F4: CLUSTERRATIO or normalized CLUSTERFACTOR > 80 
F5: 100 * (Space used on leaf pages / Space available on 
non-empty leaf pages) > MIN(50, (100 - PCTFREE)) 
F6: (100 - PCTFREE) * (Amount of space available in an index 
with one less level / Amount of space required for all keys) < 
100 
F7: 100 * (Number of pseudo-deleted RIDs / Total number of RIDs) 
< 20 
F8: 100 * (Number of pseudo-empty leaf pages / Total number of 
leaf pages) < 20 
 
SCHEMA.NAME 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
------------------------------ 
Table: GXXXXX.STG_GEN_CLAIM_XXXXXXX_XX_XX_XXXX_XXXX 
Index: GXXXXX.PKXC_ZKEL_BK 
 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
------------------------------ 
 
 
INDCARD    LEAF     ELEAF    LVLS    NDEL      KEYS 
LEAF_RECSIZE     NLEAF_RECSIZE   LEAF_PAGE_OVERHEAD 
NLEAF_PAGE_OVERHEAD        F4     F5    F6    F7    F8 
REORG 
153872       192      0          2         0          153872 
       7                    7                     2132 
                   2132                               100     93 
   -      0      0        ----- 
 
 
 
 
CLUSTERRATIO or normalized CLUSTERFACTOR (F4) will indicate 
REORG is necessary 
for indexes that are not in the same sequence as the base table. 
When multiple 
indexes are defined on a table, one or more indexes may be 
flagged as needing 
REORG.  Specify the most important index for REORG sequencing. 
 
Tables defined using the ORGANIZE BY clause and the 
corresponding dimension 
indexes have a '*' suffix to their names. The cardinality of a 
dimension index 
is equal to the Active blocks statistic of the table.

REORGCHK and REORGCHK_IX_STATS show different values for 
FULLKEYCARD and F5 in DPF

DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

02.06.2011
08.03.2012
08.03.2012