How to enable a JDBC trace for toolbox driver
 Technote (troubleshooting)
 
Problem(Abstract)
This document describes how to set a JDBC™ trace for the AS/400® database driver, jt400 also known as the toolbox driver.

This is from IBM® Technical Document entitled:
"Enabling Java™ Toolbox and JDBC Tracing with an External Trace Property"

 
Resolving the problem
Here are the instructions to enable the jt400 trace on the IBM® WebSphere® Application Server.
Add the custom following properties to the JDBC DataSource. 

Parameter name Parameter value
trace true
toolboxTrace all

For more information on the parameters that may be specified for the jt400 data source, see the JDBC Trace Instructions in the document, The All-In-One Toolbox JDBC Tracing Guide
(We need to have the trace taken for all categories.  This will include the data  stream.)  

Alternatively, you can enable the trace using a jvm -D parameters. See the Java Virtual Machine (JVM) Properties in The All-In-One Toolbox JDBC Tracing Guide. To set the parameters, use the following instructions.

Using the administrative console
1. Start the administrative console.
2. Select Servers > Application Servers > server_name.
3. Under Server Infrastructure, expand Java and Process Management and click Process Definition.
4. Under Additional properties, click Java Virtual Machine.
5. In the Generic JVM™ arguments field, enter
 -Dcom.ibm.as400.access.Trace.file=C:\temp\trace.out
and
-Dcom.ibm.as400.access.Trace.category=all
6. Click Apply and Save.
7. Stop and restart the server.

Modifying the server.xml file for the profile
1. Make a backup copy of the server.xml file before modifying the file.
2. Find genericJvmArguments= in the file. In the quoted phrase, insert :-Dcom.ibm.as400.access.Trace.file=C:\temp\trace.out
For example:
genericJvmArguments="-Dcom.ibm.as400.access.Trace.file=C:\temp\trace.out"
3. Save the changes.
4. Stop and restart the server.


To control where the trace is written set these settings in the Generic JVM arguments of the Application Server.
-Dcom.ibm.as400.access.Trace.file=C:\temp\trace.out  



For more information on these properties, you may also refer to, jt400 System Properties document.



 
 
Cross Reference information
Segment Product Component Platform Version Edition
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: 6.1
Software edition:
Reference #: 1318451
IBM Group: Software Group
Modified date: Sep 17, 2008