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?. Brian
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.
midrange.com
