Hi,

Hi use the following query to get the last statistics updated time for a
table.

1) db2 "select substr (NAME,1,10) , STATS_TIME from SYSIBM.SYSTABLES where
name='TABLE_NAME'"

Note :- replace TABLE_NAME with your tablename.

Gajanan Thakare


-----Original Message-----
From: Jim & Jackie Woltz
[mailto:db2udbdba-ezmlmshield-x11686422.[Email address protected]
Sent: Thursday, August 23, 2007 8:05 PM
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


DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Pvt. Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Pvt. Ltd. does not accept any liability for virus infected mails.

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