By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,779 Members | 1,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,779 IT Pros & Developers. It's quick & easy.

Viewing last execution Date of Performance utilities (e.g. Runstats, Reorg)

P: n/a
Hi -

Via the UDB / LUW Control Centre I have tried in vain to identify when
a utility was last run.
(e.g. Clicking on a given Table)

Any idea as to how this information can be retrieved?

Thanks

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ian
al**********@btinternet.com wrote:
Hi -

Via the UDB / LUW Control Centre I have tried in vain to identify when
a utility was last run.
(e.g. Clicking on a given Table)

Any idea as to how this information can be retrieved?


RUNSTATS updates the STATS_TIME in syscat.tables and/or syscat.indexes;

REORG is be visible in the database history (use the Journal app or
the LIST HISTORY command).

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.