Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Location
    pune(india)
    Posts
    24

    Unanswered: last table reference time and date

    hi guys,

    How can i find when was the db2 objects(tables,view,aliases) in my database were last reffered(in terms of date and time).Is there any parameter i can check out or any query that might be of any help???

    I am using db2 v8 fixpack 2 on AIX 5.

    thanks in advance

    cheers,
    Sinwar
    Last edited by sinwar; 03-24-06 at 05:44.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    AFAIK, it is not possible

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Mar 2005
    Posts
    108
    DB2audit may serve this purpose but never used it.

Posting Permissions

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