Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2005
    Posts
    24

    Unanswered: How to trace the database transactions?

    Dear All,

    How to track the database transactions in log file?
    If someone delete some records from the table,may I know how to check who delete this and when?How to trace it?
    May I know we can trace or not?


    Thanks,

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    try using event monitor. See administration guide book for details.
    Hope this helps,
    Grofaty

  3. #3
    Join Date
    Jun 2006
    Posts
    471

    trace

    I think audit will be the tool to use
    Check infocenter for activate of audit and handling this output
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  4. #4
    Join Date
    Aug 2005
    Posts
    24
    Hi grofaty,

    May I know where can I get the event monitor?
    Do u mean window event viewer?

    Thanks.


    Quote Originally Posted by grofaty
    Hi,
    try using event monitor. See administration guide book for details.
    Hope this helps,
    Grofaty

  5. #5
    Join Date
    Jun 2006
    Posts
    471

    event

    event monitor is the db2 tool that will monitor some events
    (as indicated by the name)
    this tool will take snapshots (db2 get snapshot......) to gather specific information from db and clients
    see online infocenter or db2 books about this tool / command
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  6. #6
    Join Date
    Aug 2005
    Posts
    24
    OkThanks a lot for your info,guyprzytula.


    Quote Originally Posted by guyprzytula
    event monitor is the db2 tool that will monitor some events
    (as indicated by the name)
    this tool will take snapshots (db2 get snapshot......) to gather specific information from db and clients
    see online infocenter or db2 books about this tool / command

Posting Permissions

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