I am trying to diagnose some sql problems on DB2 v9.1. I am using the Activity monitor to check for the SQL statements that I am having the problems with. I can get the SQL statement, but it does not show the values passed into the query statement's parameters:

select * from FBNEXUS.FBCLIENTTRANS clienttran0_ inner join FBNEXUS.FB_OFFICES fboffice1_ on clienttran0_.OFFICEID=fboffice1_.ID where fboffice1_.ID=? and clienttran0_.TRANSDATE=?

Is there a way I can get the values for the parameters passed into this query?

I think statement event monitor might provide this information, but I'm not sure.

I tried to create a statement monitor from the control center. It works, but it does not give me the SQL text let alone the parameter values. There must be some way of doing this. How can I log the SQL statments that get executed on DB2?

Try using the SNAP_GET_DYN_SQL_v91 snapshot.

That probably was a snapshot monitor; what you need is an event monitor.

I have tried the event monitor for statements. Attached is a screenshot of the output I get. Notice that the '?' marks are still in the query. Is there something else I need to configure to show the parameter values?