SEO

#1 (**permalink**) 02-27-2008, 04:59 AM

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

#2 (**permalink**) 02-27-2008, 04:59 AM

alex.mcshane@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).

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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