Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    15

    Unanswered: How to find out total space taken by a table in a database on db2 7.2

    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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    The output of REROGCHK

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Aug 2003
    Posts
    15
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •