Collecting DB2 JDBC Driver Tracing Configuration in WAS

The DB2 JDBC driver allows trace configuration through the following data source custom properties. 

traceLevel – Set to “-1” by default to capture all JDBC driver trace data.

                

If the value is null and the WAS.database=all or com.ibm.ws.db2.logwriter=all is included in the WAS trace specification, then the trace will be integrated with the WebSphere Application Server trace.

Append the following to a WebSphere connection pool trace:

WAS.database=all OR com.ibm.ws.db2.logwriter=all

The “WAS.database=all” trace property allows an integrated trace to enabled and disabled during runtime.