Enabling DB2 Universal JDBC Driver (JCC) tracing on WebSphere Application Server V5
 Technote (troubleshooting)
 
Problem(Abstract)
It is possible to enable tracing of the DB2® Universal JDBC™ Driver, also known as the JCC driver, on WebSphere® Application Server V5 releases. This is useful when experiencing problems with applications that use a WebSphere data source to connect to DB2 V8 using the Universal Driver.
 
Resolving the problem
Follow these steps to enable the tracing:
  1. Select the data source that uses the Universal Driver from the WebSphere administrative console.
  2. Click Custom Properties on the data source configuration screen.
  3. Enter value -1 (TRACE_ALL) for the traceLevel property. This is recommended for most problem determination because it generates the maximum amount of trace data. If only specific trace data is needed, it is possible to enable only certain types of tracing.

    Here are the values to enter for the traceLevel property, based on the type of trace data that is needed:
Trace Level Desired traceLevel Property
TRACE_NONE 0
TRACE_CONNECTION_CALLS 1
TRACE_STATEMENT_CALLS 2
TRACE_RESULT_SET_CALLS 4
TRACE_DRIVER_CONFIGURATION 16
TRACE_CONNECTS 32
TRACE_DRDA_FLOWS 64
TRACE_RESULT_SET_META_DATA 128
TRACE_PARAMETER_META_DATA 256
TRACE_DIAGNOSTICS 512
TRACE_SQLJ 1024
TRACE_ALL -1

4. Enter a fully-qualified directory and file name for the trace output for the traceFile property; for example, C:\DB2\jcctrace.log

5. Save the configuration. There is no need to restart the Application Server. The tracing begins the next time the data source is used.

6. The resulting trace file can be analyzed to determine the cause of the problem after reproducing the problem.

 
 
Cross Reference information
Segment Product Component Platform Version Edition
Data & Information Management DB2 Universal Database for Linux- UNIX and Windows Application Programming - JDBC Platform Independent 8 Enterprise
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): Windows
Software version: 5.1.1.2
Software edition:
Reference #: 1181878
IBM Group: Software Group
Modified date: Oct 13, 2004