Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: Question about reorg and runstats

    Good afternoon,
    DB2 V8
    AIX 5.3
    Is there any way to know when was the last time you run reorg and runstats on a table?

    Thank you very much and best regards.
    DBA DB2 for LUW

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    For the statistics time check stats_time in sysstat.tables (I hope I remember the column name correctly).
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    Thank you N_I

    For statistics this is the filed, but reorg where can look this information?

    Greetings.
    DBA DB2 for LUW

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    reorg -> list history reorg all and notify log

Posting Permissions

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