Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2012
    Posts
    5

    Lightbulb Unanswered: Finding out which user has fired any DML Command for LUW

    Hi Guys,

    I am new to DB2. So a very basic question. I want to find out which/when user has fired any DML command on LUW. As far as i have seen, db2diag does not provide any info about the who has executed which DML command. Only when there is a Lock Escalation it tells which query was fired.

    Thanks in Advance.

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Read about db2 audit, read about event monitors for statements etc.

  3. #3
    Join Date
    Aug 2008
    Posts
    147
    Trace SQL Statements using Event monitors . Read this for a set up steps - Trace sql statements in DB2 database - DBA DB2

    It is possible , depending on how the application authenticates, that you may not find which individiual is connecting - as the authentication may happen at the application level , and just a generic logon is used at the DB2 level
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

Posting Permissions

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