Hi all

Ver DB2 7.2.4 os Win NT

Can i find out a way to determine how much space has taken by a table in a database . We are using db2 7.2.4 on win nt

regards

Rajeev

The output of REROGCHK

HTH

Sathyaram

Hi Sathyaram

Thank you for your help. I had run a reorgchk on one table and the result is as follows

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

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

EKL CALL_REG001 112261 8308 11163 11163 - 42322396 7 93 100 *--

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



Index statistics:



F4: CLUSTERRATIO or normalized CLUSTERFACTOR > 80

F5: 100 * (KEYS * (ISIZE + 9) + (CARD - KEYS) * 5) / ((NLEAF - NUM EMPTY LEAFS) * INDEXPAGESIZE) > 50

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

F7: 100 * (NUMRIDS DELETED / (NUMRIDS DELETED + CARD)) < 20

F8: 100 * (NUM EMPTY LEAFS / NLEAF) < 20



SCHEMA NAME CARD LEAF ELEAF LVLS ISIZE NDEL KEYS F4 F5 F6 F7 F8 REORG

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

Table: EKL.CALL_REG001

EKL CLREG1_PK 112261 1505 0 3 19 0 112261 34 50 14 0 0 **---

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

Is that means the total size of this particular table is 42MB. ?

regards

Rajeev