|
Problem IT36721
|
Status: Closed |
REORGCHK F6 REPORTING INCORRECT VALUES
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
REORGCHK can calculate the value for formula F6 incorrectly
resulting in a bad value being returned. Instead of returning a
percentage or '+++', garbage may be returned as in the following
example
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: HING.T1
3.1e+08 -1 -1 -1 -
-1 0 0 0 ---
----------------------------------------------------------------
------------------------
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 INDCARD LEAF ELEAF LVLS NDEL
KEYS LEAF_RECSIZE NLEAF_RECSIZE LEAF_PAGE_OVERHEAD
NLEAF_PAGE_OVERHEAD PCT_PAGES_SAVED F4 F5 F6 F7 F8 REORG
----------------------------------------------------------------
----------------------------------------------------------------
-----------------------------------------------
Table: HING.T1
Index: HING.I1
3.1e+08 3e+07 961 8 2e+08
-1 152 152 324
324 0 -1 1 -368s?M40 40 0 -*-*-
----------------------------------------------------------------
----------------------------------------------------------------
----------------------------------------------- |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5 FP7 or later *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5 FP7 or later *
**************************************************************** |
| Comment |
Upgrade to 11.5 FP7 or later |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.04.2021
21.11.2021
21.11.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
