Is there an IBM Iseries/DB2 equivalent to SQL Profiler?

Subject says i开发者_StackOverflow中文版t all. Looking to capture sql submitted to DB2.

Take a look at the Iseries SQL Exit Points which will allow you to log any submitted SQL. The only problem is you will have to write your own programs to do the logging:

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=%2Frzaik%2Frzaikodbcexitprog.htm

If you have Java support enabled, you can use SQL PL Profiler.

http://www.ibm.com/developerworks/data/library/techarticle/dm-0406rielau/index.html

i use the DB2 Command Center with a graphical view of the generated tree

In iSeries Navigator, there is SQL Performance Monitor. I haven't ever been able to figure it out, but it might be what you are looking for.