Results 1 to 8 of 8

Thread: reorg help

  1. #1
    Join Date
    Feb 2007
    Posts
    9

    Unanswered: reorg help

    Hi,

    I am using DB2 8.2 / AIX, I ran the reorgchk and it listed one table with F2 *, after I done the reorg still I am able to see the same table in reorgchk report with F2 *

    Can someone help me out why this happens

    Thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Did you do a RUNSTATS after the REORG?

    Andy

  3. #3
    Join Date
    Feb 2007
    Posts
    9
    yes, I did runstats and rebind, also for index I always have the '*'

    Thanks

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Is it a MDC table or a regular table?

    Andy

  5. #5
    Join Date
    Feb 2007
    Posts
    9
    Thanks for your reply, it is regular table

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What are the values to TSIZE,FP, and what is the pagesize of the table?

    Andy

  7. #7
    Join Date
    Feb 2007
    Posts
    9
    TSIZE : 453625
    FP: 72
    F1: 0
    F2: 39
    F3: 100

    16K Page size

  8. #8
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What is the cardinality of the table?

    Also, what id the average row size of the table?

    Andy

Posting Permissions

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