Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2012
    Posts
    4

    Unanswered: tracking the queries fired

    Hi,

    I am connect to db2 on a particular ip, with my client , client is just inbuilt in eclipse itself , now 5 more people connect with same credentials as I ..Now I want to track their queries in other words what queries do they fire,,..??Can I do that,,,..?AND IF yes THEN how..?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You can use a Statement Event Monitor

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If they are all using dynamic SQL, then you can also use a Snapshot for Dynamic SQL. See the doc for details.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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