Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2010
    Posts
    4

    Question Unanswered: Getting transaction information from DB2

    Hi I need to get on daily basis the following information
    to determine what updates have been made using SQL insert, update or delete statements? even the information down to the row/field level including the userid that performed the update time and date. Can you point me the best way to get this information!! Thanks!

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Have you looked at the audit facilities?
    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
  •