× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi Mike

If you want to see the network traffic, try Wireshark - free sniffer for ethernet stuff. Pete brought up the ODBC trace stuff - there is a diagnostics tab when you configure a DSN. It has lots of trace options, including STRDBG, which doesn't do a debug of the program behind the procedure, I don't think, instead, it adds all those optimizer messages to the job log. Also a job trace, I think - other options. See what is there.

Of course, if you don't use a DSN, these are probably options in the connection string.

HTH
Vern

On 5/21/2013 8:41 PM, Mike Cunningham wrote:
Is there a way to turn on a trace for a call to a DB2 stored procedure (all SQL - no RPG) coming from an external server running a perl app on a linux server connecting using the IBM iSeries ODBC driver.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.