Logging dynamic SQL with query params

[kofa]

Hi All,

we're new to DB2 (using Express-C on Windows). We'd like to monitor the
SQL that Hibernate (a Java ORM) generates, along with query params. It
was quite simple to do so with MySQL, but we haven't found a way to do
that with DB2.
This is how far we got:
create event monitor sqlmonitor for statements write to file
'f:\tmp\db2sql'
set event monitor sqlmonitor state = 1
.... issue some sql ...
db2evmon -db minibar -evm sqlmonitor >sql.txt
grep "Text" sql.txt

This is quite inconvenient, and does not give us query params (we could
get the parameterless statements from Hibernate's own log in a much
simpler way).
It seems we're using the wrong tool - but which one is the right one?

TIA,
Kofa

[kofa]

we're new to DB2 (using Express-C on Windows). We'd like to monitor the

SQL that Hibernate (a Java ORM) generates, along with query params.

To answer my own question: the JDBC driver can be set to trace
commands.
http://www-128.ibm.com/developerwork...m-0506fechner/

<blush>Sorry for the noise</blush>

Kofa

[Kofa]

kofa wrote:

we're new to DB2 (using Express-C on Windows). We'd like to monitor the
SQL that Hibernate (a Java ORM) generates, along with query params.

To answer my own question: the JDBC driver can be set to trace
commands.
http://www-128.ibm.com/developerwork...m-0506fechner/

<blush>Sorry for the noise</blush>

Kofa

Still not good enough.
Here's an excerpt from the log:
[ibm][db2][jcc][Time:1155024677 451][Thread:main][Connection@c9d9 2c]
prepareStatemen t (select productimp_.id, productimp_.act ive as
active6_, productimp_.cod e as code6_, productimp_.des cription as
descript4_6_, productimp_.sto ck as stock6_, productimp_.adH ocPrice as
adHocPrice6_, productimp_.cos tPrice as costPrice6_,
productimp_.cat egory as category6_, productimp_.sup plier as supplier6_,
productimp_.typ e as type6_ from Product productimp_ where
productimp_.id= ?) called
[ibm][db2][jcc][Time:1155024677 451][Thread:main][Connection@c9d9 2c]
prepareStatemen t () returned PreparedStateme nt@106dc2d
[ibm][db2][jcc][Time:1155024677 451][Thread:main][PreparedStateme nt@106dc2d]
setLong (1, 522) called
[ibm][db2][jcc][Time:1155024677 451][Thread:main][PreparedStateme nt@106dc2d]
executeQuery () called

Not very easy to read (params shown on a separate line, in an even more
verbose fashion than we could get directly from Hibernate). The same
thing with MySQL:
Query select productimp_.id, productimp_.act ive as active6_,
productimp_.cod e as code6_, productimp_.des cription as descript4_6_,
productimp_.sto ck as stock6_, productimp_.adH ocPrice as adHocPrice6_,
productimp_.cos tPrice as costPrice6_, productimp_.cat egory as
category6_, productimp_.sup plier as supplier6_, productimp_.typ e as
type6_ from Product productimp_ where productimp_.id= 522

Any ideas (without costly third-party tools)?

TIA,
Kofa