This message is probably not related to your java and only tangentially related to your stored procedure.
If your RPG is simply submitting a job, there will be no wait for the submitted job to finish. On the other hand, if your RPG submits a job and then blocks on a data queue, for example, to wait on output from the submitted job, your java will be waiting, too. This is generally not a good idea, particularly when using a single-threaded job queue.
Just holding the jdbc connection will not cause AS400 to allocate more memory. If this message is generated in the jdbc job (QZDASOINIT or some variation), allocating more memory is usually because of large temporary indexes or large result sets being generated. If you are using native jdbc, this allocation may be done in your java job. In your stored procedure, it could be the RPG program ALLOC'ing large quantities of memory.
-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
Sent: Friday, December 03, 2010 8: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.
midrange.com
