Problems Enabling JDBC trace

Daniel_Cruz

Hi all,

Due to some DB connection problems using DD, we want to enable JDBC trace. We are using DB2 8.2 and a JDBC type 4 driver (pure Java) version 2.3.63. In order to do this, we are doing the following (according to IBM DB2 documentation)

<database db="//lxasaja.adif.sir:50001/dbipcr01:traceFile=c:\\jcc.trc;"
name="adif_int_database"
password="ppcr"
user="ppcr"
vendor="ibm"
use-db2-driver-type="universal"/>

The DD log generated is as follows:

DAS: Try connecting using jdbc:db2://lxrwpsp3.renfe.sir:60000/dbipcr01:traceFile=c:\\jcc_OPER_PRO.trc;...
DAS:
Connected to jdbc:db2://lxrwpsp3.renfe.sir:60000/dbipcr01
DAS: Driver IBM DB2 JDBC Universal Driver Architecture
DAS: Version 2.3.63
DAS: Connected to [//lxrwpsp3.renfe.sir:60000/dbipcr01:traceFile=c:\\jcc_OPER_PRO.trc;]


There doesn't seem to be any problem, however the file c:\jcc_OPER_PRO.trc is not created. File system permissions are right; we've also tried in c:\temp (Everyone - Full control permissions set) and we get the same result: nothing. :-)

Has anyone faced this problem before? Please enlighten us!

Daniel_Cruz

I apologize because there is an error: the log snippet doesn't match with c:\\jcc.trc, but the meaning doesn't change.