Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399

    Unanswered: how to explain reorgchk report?

    could you tell me where to find explaination for all columns in the reorgchk output? what does it mean if there are only '---'s there? what does it mean that REORG column has '--*' ?

    thanks in advance
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    --*
    " * " means that particular parameter is below the RECOMMENDED level. So a REORG can help to increase the parameter value to achieve the RECOMMENDED value. For example if your CLUSTERFACTOR is 70, whereas the recommended value is 80%, then you will see *--. Now after REORG if your clusterfactor improves to 90% then the REORGCHK will show you ---.

    Jayanta Datta
    DB2 UDB DBA
    IBM India, Global Delivery
    New Delhi

  3. #3
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    Quote Originally Posted by JAYANTA_DATTA
    --*
    " * " means that particular parameter is below the RECOMMENDED level. So a REORG can help to increase the parameter value to achieve the RECOMMENDED value. For example if your CLUSTERFACTOR is 70, whereas the recommended value is 80%, then you will see *--. Now after REORG if your clusterfactor improves to 90% then the REORGCHK will show you ---.
    what does the position of the * tells us? '*--' vs. '-*-' or in case of indexes '-*---' and '---*-' ? could not find any documentation on this. could you provide a link or smth? thanks in advance
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by MarkhamDBA
    could not find any documentation on this. could you provide a link or smth?
    DB2 Universal Database
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    Quote Originally Posted by n_i
    got it. thx.

    I guess no matter what the position of * is, the action would have to be the same - reorg and runstats on this table and/or index, and then rebind. Is that right?
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  6. #6
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    No, that would be wrong.

    The output of reorgchk shows something like F1, F2, and so on. The position of the '*' corresponds to the parameter being represented, i.e. '*--' means that parameter F1 is off while F2 and F3 are fine. Likewise, '-*-' means that only condition F2 is not met.

    Now, why would it be wrong to always reorg if there is a '*' somewhere? The thing is that you can only have 1 cluster index for a table. If the rows are ordered by column A, you cannot have an ordering also for column B (except for rare cases and column correlations/functional dependencies). So if you reorg the table to cluster according to an index on column A, you will get '*' on the clustering factor for an index on column B. Thus, you should understand what each of the indicators shown by reorgchk is telling you and whether it matters for you.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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