Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    76

    Unanswered: SQL Profiler in DB2?

    Hi All,

    Is there any tool of DB2/third pary which perform similar to SQL-Profiler in SQL Server?

    Or is there any way to trace each and every request to DB2 server and view its details like, requested information, client m/c ip, user id, status of request (success/fail) etc...?

    Thanks a lot,
    Jai

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    That's called "snapshot monitor". See the administrator manuals.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    It depends on what information you need to capture ...

    Is it for performance ? Then event monitors will be useful... (The presentation http://www.gseukdb2.org.uk/downloads/0405event.zip should be of help)

    If it is for auditing, db2audit would be a good choice

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

Posting Permissions

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