Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2009
    Posts
    153

    Unanswered: how to find the user

    Hi Experts,

    When i used db2pd i got the queries executed.How can i find the person or IP from which the statement is executed and when?

    TIA

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Statements in the dynamic cache can be potentially executed by many users, connecting from different IP addresses. To see who is _currently_ executing which statement, use db2pd -apinfo or the application snapshot.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jan 2009
    Posts
    153
    Hi Nick,
    Thanks for the reply. I didnt find db2pd -apinfo or application snapshot.

    Please help

  4. #4
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    db2pd -d <db> -apinfo works for db2v9.5 FP1 and later.

    I mostly use get snapshot for applications on <db>

    or SYSIBMADM.SNAPAPPL_INFO

    regards

    DBFinder

  5. #5
    Join Date
    Jan 2009
    Posts
    153
    Thanks DBFinder :-)

Posting Permissions

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