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



Everyone,
Why do our QZDASOINIT jobs (from JDBC) open the same files repeatedly
until the job has 100+, 200+, 300+, and even 400+ files open?. Bryan
Dietz' WRKODBCJOB command shows all the files.
If IBM's recommendation solves our issue, I will be very happy and share
our success with you on this forum:

IBM's recommendation is:
A JDBC application should close the statement handle after it is done
with the results set. These days, for performance reasons, the
connection is commonly left open or returned to a connection pool. It
is important to close statement handles so that not too many resources
are tied up on the system.

The following has a code snippet of closing both the statement handle
and the connection handle:
http://publib.boulder.ibm.com/infocenter/iseries/v6r1m0/topic/rzahh/jdbc
rs.htm
Search for:
The AS400JDBCConnectionPool class represents a pool of
AS400JDBCConnection objects that are available for use by a Java(tm)
program as part of IBM(r) Toolbox for Java support for the JDBC 2.0
Optional Package API.

Search also for:
You cannot change the connection pool data source after you have
requested a connection and the pool is in use. To reset the connection
pool data source, first call close() on the pool.
Return connections to an AS400JDBCConnectionPool by using close() on the
AS400JDBCConnection object.
Note: When connections are not returned to the pool, the connection pool
continues to grow in size and connections are not reused.
Set properties on the pool by using methods inherited from
ConnectionPool. Some of the properties that you can set include:
* maximum number of connections to allow in the pool
* maximum lifetime of a connection
* maximum inactivity time of a connection.





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.