Sunday, 18 May 2014

How to check when was executed the last runstats in a specific table

How to check when was executed the last runstats in a specific table

How to check when was executed the last runstats in a specific table

Check the column STATS_TIME in the table syscat.table to get when was executed the last runstats



TABLE NAME:
 TABLE_X
SCHEMA NAME: SCHEMA_X


Checking  when was executed the last runstats for all tables in a specific schema 
 db2 "select substr(tabname,1,30), STATS_TIME from syscat.tables where tabschema='SCHEMA_X'"


Checking  when was executed the last runstats in a specific table 
 db2 "select substr(tabname,1,30), STATS_TIME from syscat.tables where tabname='TABLE_X'"


Checking  when was executed the last runstats for all tables in the whole database
db2 "select substr(tabname,1,30), STATS_TIME from syscat.tables

No comments:

Post a Comment