Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Last Access Time on a table.

    Hi guys,

    Can we find the last access time on a table.
    We need a list of access time on tables in a database


    Thanks
    DBFinder

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You need auditing facilities for that. Obviously, DB2 doesn't track such information because it is a hot-spot and potential bottle-neck. Also, you have to decide which semantics you want to have:
    - only data modifications
    - also read operations
    - what happens with rolled back transactions? include those, too?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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