Enabling Db2 Driver Connection Tracing for Web Viewer 12.1

Products

• Output Management Web Viewer

Issue/Introduction

This article shows how to enable Db2 driver connection tracing in Web Viewer 12.1 for troubleshooting and monitoring.

Environment

• Output Management Web Viewer 12.1
• DB2

Cause

Enable tracing of the DB2 connection

Resolution

Prerequisites

• Free writable memory based on traceFileCount x traceFileSize. (e.g. 200 Mb x 30 ~ 6 GB)
• Access to Web Viewer 12.1 Installation location.
• User with ability to restart Web Viewer 12.1.

 Steps

1. Open the location in variable CAOMWV12_HOME/config.
2. Copy the current WVProfile.properties file to some other location.
3. Edit the WVProfile.properties file in text editor and append the following tracing parameters to the PERSISTENCE.JDBCURL variable then Save and close the file.
4. Restart Web Viewer 12.1 Tomcat.

 

<CURRENT_JDBCURL>;traceFile=C:/temp/db2trace.log;traceLevel=512;traceFileAppend=true;traceFileCount=30;traceFileSize=209715200;traceOption=1;

 

Parameter	Description
traceFile	Path to the trace file. Must be writable.
traceLevel	Specifies what to trace. The data type of this property is int.
traceFileAppend	Specifies whether to append to or overwrite the file that is specified by the traceFile property
traceFileCount	Specifies the maximum number of trace files for circular tracing.
traceFileSize	Specifies the maximum size of each trace file, for circular tracing.
traceOption	1 - To enable circular tracing. 0 - single file tracing and that there is no limit to the size of the file

Additional Information

More information

You can customize these settings for more detailed tracing. See IBM documentation:

“Common IBM Data Server Driver for JDBC and SQLJ properties for all supported database products.”.

Working configuration Setenv.bat:

@echo off

REM Add DB2 JCC trace properties

set CATALINA_OPTS=%CATALINA_OPTS% -Ddb2.jcc.traceFile=C:/Users/hg667152/ISO/CA_OM_Web_Viewer_ISO_253/config/db2jcc_trace.log -Ddb2.jcc.traceLevel=TRACE_ALL

IBM Documentation

Problem diagnosis with the IBM Data Server Driver for JDBC and SQLJ

Common IBM Data Server Driver for JDBC and SQLJ properties for all supported database products