Results 1 to 7 of 7

Thread: db2audit usage

  1. #1
    Join Date
    Oct 2005
    Location
    pune(india)
    Posts
    24

    Unanswered: db2audit usage

    Hi,

    Has anyone in forum used DB2AUDIT utility.
    I need information about when my db2 objects were last reffered.
    Is in any way db2audit is helpful and solve the purpose.
    Appreciate any sort of help on this.

    Or is there any other way i can find out the requisite info.

    I am using db2 v8 fp2 on AIX 5.

    Many thanks,
    Sinwar

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Can you let u know why you want to know the last referred time of a table ?

    This may help to give a reasonable answer

    Sorry

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

  3. #3
    Join Date
    Oct 2005
    Location
    pune(india)
    Posts
    24
    Sathya,
    we are updating all stats on a devlopment server and need to know which tables are never being or when for last time were reffered.So that we can omit them and also it will be helpfull in our other process of replications of tables under new instances....

    looking forward for your reply..

    Thnx,
    Sinwar

  4. #4
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    If you are concerned with running RUNSTAT/REORG you can use the LIST HISTORY command for RUNSTAT/REORG. It will tell you when the tables were UPDATED in terms of statistics.

  5. #5
    Join Date
    Oct 2005
    Location
    pune(india)
    Posts
    24
    Quote Originally Posted by JAYANTA_DATTA
    If you are concerned with running RUNSTAT/REORG you can use the LIST HISTORY command for RUNSTAT/REORG. It will tell you when the tables were UPDATED in terms of statistics.

    Well jayant, i need to know when was the object used for any select,insert etc purpose..which i cannot find in the list history command option.
    Do have any idea how to go about it and finding out the requisite info...

    I am going thru DB2AUDIT facility ..hope will conclude any substantial solution..

    Welcome your advise on this...

    Thanks,
    Sinwar

  6. #6
    Join Date
    Oct 2005
    Location
    pune(india)
    Posts
    24
    Db2audit solved the purpose..but unfortunately it will give me the required info after starting the db2audit facility.That means henceforth i can find when was select etc done on my table last time.

    Thanks all for giving me direction esp DBA-junior.

    Sinwar

  7. #7
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    IMHO, you should be using table event monitor ... This will give you a list of all tables that were referenced since the last activation of the database ..

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

Posting Permissions

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