RUNSTATS

[balajipn]

Hi,

Is there a way to find out whether RUNSTATS was not run against a DB2 table?.

Thanks in Advance,
Balaji Neelakantan.

 

[stevexff]

RUNSTATS updates the values in catalog tables SYSCOLDIST and SYSCOLDISTATS. You can run a query against these tables to find out. No row = no RUNSTATS.

 

[sathyarams]

If RUNSTATS has been run on a table, an entry for it will appear in SYSSTAT.TABLES ....

HTH

Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

 

[balajipn]

Hi Steve & Sathya,

Thanks for your answers.

I did some research on this and found that RUNSTATS is updating the following DB2 catalog tables.

SYSCOLUMNS
SYSINDEXES
SYSINDEXPART
SYSTABLEPART
SYSTABLES
SYSTABLESPACE
SYSDBAUTH
SYSSTOGROUP
SYSCOLDIST
SYSCOLDISTSTATS
SYSCOLSTATS
SYSINDEXSTATS
SYSTABSTATS
SYSLOBSTATS

Hope this information will be useful for everyone.

Thanks,
Balaji.