DB2: Check when stats was run on a table

 

SELECT STATS_TIME AS RUNSTATS_DATE

    , SUBSTR(TABSCHEMA,1,20) AS SCHEMA

    , SUBSTR(TABNAME,1,60) AS TABLE

    , (DAYS(CURRENT_TIMESTAMP) - DAYS(STATS_TIME)) AS AGE_IN_DAYS

FROM SYSCAT.TABLES

WHERE TABSCHEMA = 'WCS'

    AND TABNAME IN ('USERREG', 'ADDRESS')

WITH UR;

SELECT STATS_TIME AS RUNSTATS_DATE

    , SUBSTR(TABSCHEMA,1,20) AS SCHEMA

    , SUBSTR(TABNAME,1,60) AS TABLE

    , (DAYS(CURRENT_TIMESTAMP) - DAYS(STATS_TIME)) AS AGE_IN_DAYS

FROM SYSCAT.TABLES

WHERE TABSCHEMA = 'WCS'

    AND TABNAME IN ('USERREG')

WITH UR;