DB2 Trace/Profiler

[jpillonel]

Hello,

I'm just going to DB2 and I'm looking for a similar tool like MS SQL Profiler.

I would like on some databases in the same instance, trace every update,delete statement from the user X. Loging the trace in a table or a file ...

It's quite esy on MS SQL and on Oracle, but I don't find the same tool for DB2.

Thanks for your help !

 

[gregsimpson]

Hi,

easy here too. Use an event monitor.

http://publib.boulder.ibm.com/infoc...topic=/com.ibm.db2.udb.doc/admin/r0005991.htm

Cheers
Greg

 

[jpillonel]

Thanks for this answer, but I take a look of this tool and I don't find any way to log every SQL update, insert and delete statement.

With the wizard you can choose the user but you have to find after on point 5, which kind of SQL statement you like to report.

Thanks for your help

 

[blom0344]

I've never used it, but perhaps what you want is DB2 Query Patroller?

Ties Blom

 

[gregsimpson]

db2trc ?

Cheers
Greg