Results 1 to 5 of 5

Thread: DML Statments

  1. #1
    Join Date
    Feb 2007
    Posts
    31

    Unanswered: DML Statments

    Hi,
    I want to track all the DML statments which are fired in the UDB database.Is there any tables available or any method ..?

    For eg: In oracle we have v$sql table.Same thing do we have in UDB.
    Iam using db2 v.8.1 and fix pack
    Regards
    Mohan

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    look for db2audit
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  3. #3
    Join Date
    Feb 2007
    Posts
    31
    Thanks for the info.Is that db2audit is will consume memeory space..? Thanks.
    Regards
    Mohan

  4. #4
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    yup, v9 viper2 beta db2audit is far more efficient and robust as that of its ancestor v8
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  5. #5
    Join Date
    Feb 2007
    Posts
    31
    Do we have only this method db2audit..? or else do we have any other method?
    Regards
    Mohan

Posting Permissions

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