For WIN NT, you've got the stats_time column in each of syscat.tables
and syscat.indexes


Regards,

Anand

-----Original Message-----
From: Hannis James D (GE Comm Fin)
[mailto:db2udbdba-ezmlmshield-x59635971.[Email address protected]
Sent: Thursday, August 23, 2007 8:43 PM
To: LazyDBA Discussion
Subject: RE: When runstats ran

Assuming you are refering to z/OS DB2:

SYSIBM.SYSTABLES_HIST
SYSIBM.SYSINDEXES_HIST

-----Original Message-----
From: Jim & Jackie Woltz
[mailto:db2udbdba-ezmlmshield-x11686422.[Email address protected]
Sent: Thursday, August 23, 2007 9:35 AM
To: LazyDBA Discussion
Subject: When runstats ran


Can anyone tell me what table to look in to see when runstats was last
ran for 1. table, 2. index



Thanks



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page