I want to find the failed sql statement in application.
run command 'db2 get snapshot for all applications'
get below information
Application name = db2wlmd
Dynamic SQL statements attempted = 18
Static SQL statements attempted = 7
Failed statement operations = 3
I want to find these 3 failed sql statements. Would you please let me know how? Thanks.
This topic has been locked.
Pinned topic How to find the failed sql statement in application
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
nivanov1 100000H9H7231 Posts
Re: How to find the failed sql statement in application2013-03-27T15:18:04ZThis is the accepted answer. This is the accepted answer.Not sure why you would want to do that. db2wlmd is an internal DB2 process -- the Workload Manager.
You can create an event monitor for statements and filter the output for the issuing application name and the statement SQLCODE (returned as a part of the SQLCA element).
quchl 270004HEVH3 Posts
Re: How to find the failed sql statement in application2013-03-28T07:29:03ZThis is the accepted answer. This is the accepted answer.