Hi Everybody!

I am working on DB2 UDB v8.2 FP 7 on Windows 2003 Standard Edition.

I am doing a REORGCHK with current statistics on all my tables using (REORGCHK current statistics on table all) but the output it is generating is all blank. No values are recorded against any of the table.

DO I need to do a RUNSTATS before I do REORGCHK with current statistics? I don't want to run REORGCHK with update statistics since its a prod environment and there are tons of tables in this database.

Thanks
Anks

You cannot do a serious check for need of reorganisation without
current statistics !!

You could use the 'shrlevel change' option of runstats in V7 so that other users of the table can read from and write to the table while statistics are calculated.

Example:
runstats on table db2inst1.emp with distribution and detailed indexes all shrlevel change

You can generate a script for all tables in the database in this fashion...

However, as you are on v8 you can use the 'allow write access' option ...

select 'runstats on table db2inst1.'||tabname||' with distribution and detailed indexes all allow write access;' from syscat.tables where tabschema = 'DB2INST1';

HTH.

Thanks to both of you.

anks