Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: Question with REORGCHK output.

    Hi Colleagues,

    Somebody can expalin me the output reorgchk for example.

    what mean this columns?
    CARD OV NP FP ACTBLK TSIZE F1 F2 F3 REORG
    52616 0 2300 24608 - 8681640 0 8 9 -**
    138115 0 16081 54752 - 44611144 0 20 29 -**
    511 0 36 39 - 99645 0 65 92 -*-

    Somebody can explain me this, please.

    Estad¡sticas de ¡ndice:

    F4: CLUSTERRATIO o CLUSTERFACTOR normalizado > 80
    F5: 100 * (KEYS * (ISIZE + 9) + (CARD - KEYS) * 5) / ((NLEAF - NUM EMPTY LEAFS -1) * (INDEXPAGESIZE - 96) > MIN(50, (100- PCTFREE))
    F6: (100 - PCTFREE) * ( FLOOR[ (100 - min(10, pctfree)) / 100 * (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

    CARD LEAF ELEAF LVLS ISIZE NDEL KEYS F4 F5 F6 F7 F8 REORG
    52616 2074 1124 4 28 267 52616 59 51 +++ 0 54 *---*
    138115 2872 1060 4 28 25761 138124 98 70 570 15 36 --*-*
    2107 25 13 2 10 155 2107 100 90 8 6 52 ----*
    I need understand the mean of position "*"

    Thank you for advanced.

  2. #2
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18

  3. #3
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    Excuseme i have DB2 V8.

    Thank you.

  4. #4
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    Always put your DB2-version+fixpack and Operating System when you post.

    For V8 look at:
    DB2 Universal Database
    then search for reorgchk

Posting Permissions

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