SQL Profiler in DB2?

jsp2999 · #1 (**permalink**) 03-03-05, 12:35

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

n_i · #2 (**permalink**) 03-03-05, 12:43

That's called "snapshot monitor". See the administrator manuals.

sathyaram_s · #3 (**permalink**) 03-03-05, 13:55

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

Internet Services

Web Development

Digital Marketing

Consumer Tech