Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC76654 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
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.
Problem Summary:
REORGCHK and  REORGCHK_IX_STATS show different values for 
FULLKEYCARD & F5 in DPF
Local Fix:
available fix packs:
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Solution
Fixed in V91 FP11
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC76776 IC78503 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
26.05.2011
22.12.2011
22.12.2011
Problem solved at the following versions (IBM BugInfos)
9.1.FP11
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.11 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.