Results 1 to 2 of 2

Thread: Runstats

  1. #1
    Join Date
    Sep 2006
    Posts
    105

    Unanswered: Runstats

    Hi all,

    How to find when was the last runstats happened in a database......is there any command to view for that....last reorg can be viewed using LIST HISTORY command....similar to that....any commands for runstats?

    Any help.....

    Thanks
    Meena.s

  2. #2
    Join Date
    Dec 2005
    Posts
    273
    The time of the last RUNSTATS is stored in the column STATSTIME ( rsp. STATS_TIME ) of several system tables ( eg. SYSCAT.TABLES )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •