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

--*
" * " 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 Universal Database

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?

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.