Hi,

    Is it necessary to do reorg on system tables and indexes if we get * after executing "reorgchk update statistics on table all"?????

Thanks & Regards

Pawan

Hello Pawan,

Yes, you are right.

SCHEMA NAME CARD OV NP FP ACTBLK TSIZE F1 F2 F3 REORG
----------------------------------------------------------------------------------------
SYSIBM SYSINDEXCOLUSE 506 0 7 7 - 23782 0 97 100 ---
SYSIBM SYSINDEXES 188 89 17 31 - 159988 47 100 54 *-*

* on REORG column suggests a table reorg