Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    111

    Arrow Unanswered: Table: Last access time

    Team,

    We have create_time, stats_time for a table.
    How to check the last accessed or used time for a table.

    I tried db2pd it does not work in FP13. IBM broke in FP13 and fixed in FP14.

    By the by from where DB2PD collects the information of last access or scanned number for a table or index.

    Let me know.

    Thanks
    R

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    are you sure you can get last access time through db2pd.
    i think only lock tables, last runstats can be seen with db2pd

    Rahul

Posting Permissions

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