0

"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 ?

SiggyF
  • 22,088
  • 8
  • 43
  • 57
Sergey
  • 21
  • 7

2 Answers2

0

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.

mustaccio
  • 18,234
  • 16
  • 48
  • 57
  • thanx but not any trace file appeared after adding that magic into *.import file and even after redeployment my program on the server – Sergey Apr 10 '15 at 07:13
0

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

Sergey
  • 21
  • 7