Reputation: 4943

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

Subject says it all. Looking to capture sql submitted to DB2.

Upvotes: 4

Answers (4)

Paul Morgan

Reputation: 32578

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

Upvotes: 1

Mike Wills

Reputation: 21275

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.

screen shot of iSeries Navigator

Upvotes: 0

Peter Miehle

Reputation: 6080

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

Upvotes: 0

Raj More

Reputation: 48048

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

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

Upvotes: 0

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

Answers (4)

Related Questions