where can i find a date (timestamp) when runstats were done on a table? same for reorg. On z/OS I think it was in some SYSIBM or so table but could not find it for UDB on Unix.

Thanks in advance

For runstats: select stats_time from syscat.tables

For Reorg: This is a little tougher. If the database has been restarted since the reorg, then the information is lost. If the database has remained active then you can do something like this:

select reorg_end from table (snapshot_tbreorg('MYDB',-1)) as x where table_schema = ? and table_name = ? and reorg_status = 4

Andy

thank you, Andy

you can also find reorg info from the history file (list history reorg...)

"select stats_time,tabname,tabschema,nleaf,nlevels from syscat.indexes"


stats_time will tell you when was the last time runstats was done


if nleaf and nlevel has a value -1 then they need runstats if any other value then its ok

thx Bella, i find using list history command better than a query on syscat table

thank you, Oracle. That columns should I look at if I run a query on SYSCAT.TABLES?