Thank you David,

I will try it and if I will find something new about the performance issue, I will let you know.


Regards,
Tomer

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of David Gibbs
Sent: Thursday, February 02, 2012 4:59 PM
To: Java Programming on and around the IBM i
Subject: Re: AS400/DB2 - caching specific query

On 2/2/2012 1:39 AM, Tomer Sason wrote:
We are using AS400JDBCConnectionPool to get the connection. It is
written in the documentation that "You must start tracing before
connecting to the system ...". Is there a way to specify the debug
mode for a specific connection that created by the pool or for the
entire pool?

If you set the trace level to SERVER_TRACE_DEBUG_SERVER_JOB, for the data source, you should get the debug information that you need.

david


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-2022 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.