Re: Additional 16 megabytes of storage allocated for this job... why?

[Jose Luis Calvo <jlcalvo@xxxxxxxxxxxxx>]

May be this is related with the number of cursors that remains opened in
the de QZDASOINIT job. The OS/400 does not close (hard close) the cursor
that you close, really it does a soft close and retain the cursor open
for reuse.

You can control this behavior with the parameters OPEN_CURSOR_THRESHOLD
and OPEN_CURSORCLOSE_COUNT in a QAQQINI file.

 
On Thu, 2005-11-10 at 12:22 -0600, TitanRebel wrote:
> In many QZDASOINIT jobs, we find the PWS0083 message:
> 
> Additional 16 megabytes of storage allocated for this job.
> 
> Is this message "normal", or does it point to a memory leak.  We are 
> using our own implementation of connection pooling, and some JDBC 
> connections can potentially stay in memory and used over and over for 
> quite a long time (days).  Is this a problem?
> 
> Do we need to close and open new JDBC connections more frequently to 
> allow these jobs to release the resources (I'm just assuming that they 
> would release the resources after closing the JDBC Connection)?
> 
> Thanks,
> 
> Ken