|
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
|
 |
