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

Did you do a RUNSTATS after the REORG?

Andy

yes, I did runstats and rebind, also for index I always have the '*'

Thanks

Is it a MDC table or a regular table?

Andy

Thanks for your reply, it is regular table

What are the values to TSIZE,FP, and what is the pagesize of the table?

Andy

TSIZE : 453625
FP: 72
F1: 0
F2: 39
F3: 100

16K Page size

What is the cardinality of the table?

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

Andy