Troubleshooting
Problem
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.
|
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.
[{"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"DB Connections\/Connection Pooling","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF012","label":"IBM i"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.0;8.5.5;8.0;7.0","Edition":"Base;Network Deployment","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSNVBF","label":"Runtimes for Java Technology"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Java SDK","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21318451