給詳細解釋F1,F2,F3,F4,F5,F6等

[ccbzzp]

------------------------------ Command Entered ------------------------------
REORGCHK ON TABLE DB2ADMIN.BSDPTMS;
-----------------------------------------------------------------------------


Doing RUNSTATS ....





Table statistics:



F1: 100 * OVERFLOW / CARD < 5

F2: 100 * TSIZE / ((FPAGES-1) * (TABLEPAGESIZE-76)) > 70

F3: 100 * NPAGES / FPAGES > 80



CREATOR NAME CARD OV NP FP TSIZE F1 F2 F3 REORG

--------------------------------------------------------------------------------

DB2ADMIN BSDPTMS 42 0 2 2 3024 0 75 100 ---

--------------------------------------------------------------------------------



Index statistics:



F4: CLUSTERRATIO or normalized CLUSTERFACTOR > 80

F5: 100 * (KEYS * (ISIZE+8) + (CARD-KEYS) * 4) / (NLEAF * INDEXPAGESIZE) > 50

F6: (100-PCTFREE) * (INDEXPAGESIZE-96) / (ISIZE+12) ** (NLEVELS-2) * (INDEXPAGESIZE-96) / (KEYS * (ISIZE+8) + (CARD-KEYS) * 4) < 100



CREATOR NAME CARD LEAF LVLS ISIZE KEYS F4 F5 F6 REORG

--------------------------------------------------------------------------------

Table: DB2ADMIN.BSDPTMS

DB2ADMIN BSDPTMSBNS 42 1 1 10 14 100 - - ---

--------------------------------------------------------------------------------



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.

[richardluopeng]

什么意思 ？？

[liangxinf]

是啊

[m505]

手册里有...
F1: 100*OVERFLOW/CARD < 5
overlow溢出的记录数，card记录总数
溢出的记录数应该不超过5%

F2:
100*TSIZE / ((FPAGES-1) * (TABLEPAGESIZE-76)) > 68
tsize表的实际大小，即记录数*(记录平均长度+10)
fpages分配的页数，分母计算的是分配的空间
表的实际大小应该大于分配空间的68%

F3：
100*NPAGES/FPAGES > 80
有数据的页应该大于分配页数的80%

F4:
CLUSTERRATIO or normalized CLUSTERFACTOR > 80
索引的聚合度应大于80%，当然如果表上的索引很多，有可能某些索引达不到

F5:
100 * (KEYS * (ISIZE+8) + (CARD-KEYS) * 4) / (NLEAF * INDEXPAGESIZE) > 50
为索引项保留的空间应小于50%

F6:
F6: (100-PCTFREE) * (INDEXPAGESIZE-96) / (ISIZE+12) ** (NLEVELS-2) * (INDEXPAGESIZE-96) / (KEYS * (ISIZE+8) + (CARD-KEYS) * 4) < 100
判断重建索引是否会产生更少层次的索引树

*号代表建议reorg，f1-f3, f4-f6就好像投票 :)