Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2016
    Posts
    14

    Answered: Can we monitor who executed Query on DB

    Hello all,

    Can we monitor who executed query on database ?

    From which IP some one executed query on Database ?

    is it possible ?

    db2 v9.7 fp7

    Thanks.

  2. Best Answer
    Posted by mark.bb

    "
    Code:
    SELECT c.session_auth_id, c.application_id, substr(q.stmt_text, 1, 50) text
    FROM SYSIBMADM.MON_CURRENT_SQL q
    join table (MON_GET_CONNECTION(null, -2)) c on q.application_id=c.application_id and q.coord_member=c.coord_member
    "


  3. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    112
    Provided Answers: 13

  4. #3
    Join Date
    Apr 2016
    Posts
    14
    Hello Mark,
    Thanks for you quick response,

    Can you please help in detail with query.

  5. #4
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    112
    Provided Answers: 13
    Code:
    SELECT c.session_auth_id, c.application_id, substr(q.stmt_text, 1, 50) text
    FROM SYSIBMADM.MON_CURRENT_SQL q
    join table (MON_GET_CONNECTION(null, -2)) c on q.application_id=c.application_id and q.coord_member=c.coord_member
    Regards,
    Mark.

Tags for this Thread

Posting Permissions

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