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


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