RE: Question about message PWS0083 - Additional 17 megabytes of storage allocated for this job

Be sure that all appropriate PTFs for PWS0083 have been applied. You might
want to run a JDBC trace and examine the output and make sure that all
connections, statements, result sets, etc. are being released and that there
are no handle leaks. Once you submit the job the stored procedure
completes, the closing of the connection that submitted the stored procedure
should release all of the resources even though the submitted job has not
yet run, I believe.

Gary

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-
bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
Sent: Friday, December 03, 2010 6:40 AM
To: Java Programming on and around the iSeries / AS400
Subject: Question about message PWS0083 - Additional 17 megabytes of
storage allocated for this job

Hi
We have a web application which calls lots of AS400 RPGLE stored
procedures for doing some business logic,

I see this message in job log often, and i want to understand some
thing, and would appreciate if some one can help in it,

I think i see these messages after one of the stored procedures submits
a job in batch, and that job goes in a single threaded queue and does
not get complete for about 5- 10 minutes,

Am i to believe that because we are submitting a job from stored
procedure to a job queue to process in batch we are holding up that jdbc
connection causing AS400 to allocate more memory for this JDBC
connection?

I am sure we are closing all the connections after we call the stored
procedures.

Any ideas


Message ID . . . . . . : PWS0083 Severity . . . . . . . : 30

Message type . . . . . : Information

Date sent . . . . . . : 12/03/10 Time sent . . . . . . :
08:40:58



Message . . . . : Additional 17 megabytes of storage allocated for
this
job.

--
Ashish
www.ayurwellness.com
www.mysoftwareneeds.com
--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing
list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/java400-l.