How to enable JDBC driver's capability to capture spy and snoop logs.

How to enable JDBC driver's capability to capture spy and snoop logs.

book

Article ID: KB0092816

calendar_today

Updated On: 01-13-2017

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database -
Not Applicable -

Description

Description:
The JDBC driver has logging capability to capture the communication between the application client and the driver (Spy) and the communication between the driver and the database server (Packet logging or Snoop). 

Issue/Introduction

How to enable JDBC driver's capability to capture spy and snoop logs.

Resolution

To enable Spy and Snoop, add the following to the connection parameters to your DB URL.


For Snoop : ddtdbg.ProtocolTraceEnable=true;ddtdbg.ProtocolTraceMaxline=16;ddtdbg.ProtocolTraceLocation=Snoop;ddtdbg.ProtocolTraceShowTime=true;


If connecting to DB/2, please also include the following option:


ddtdbg.ProtocolTraceEBCDIC=true

For Spy : spyAttributes=(log=(file)Spy.log;timestamp=yes);

This will create log files SnoopX.out and Spy.log in the application's working directory. There could be more than one SnoopX.log file. 

Additional Information

http://knowledgebase.progress.com/articles/Article/000024854