How to enable JDBC driver's capability to capture spy and snoop logs.
Article ID: KB0092816
Updated On:
| 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).
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.
Issue/Introduction
How to enable JDBC driver's capability to capture spy and snoop logs.
Additional Information
http://knowledgebase.progress.com/articles/Article/000024854
Feedback
Yes
No
Powered by
