CODEWITHSUNDEEP
sqljdbcdb2invokewebsphere-process-server
Sergey
Sergey

Reputation: 21

Need to view final SQL operator generated by the JDBC Adapter

"Service Invoke" primitive (WID) taking part in outbound processing with JDBC Adapter.
How can I check the final SQL select which this whole processing sends to DB?
May be db2 provide some way to do that ?

Upvotes: 0

Views: 36

Answers (2)

Sergey
Sergey

Reputation: 21

this helps Enabling trace for a Websphere-managed datasource

p.s. thanx to mustaccio's answer - he gaves me the idea of searching in the right direction

Upvotes: 0

mustaccio
mustaccio

Reputation: 19011

You can enable the JDBC trace by adding the traceFile option to the JDBC URL:

jdbc:db2://<hostname>:<port>/<dbname>:traceFile=/tmp/jdbc.trc;

More info in the manual.

Upvotes: 0

Related Questions