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

It also sounds like you may have to check the job queue etc that the job is submitted to, and the job description used for the job. Depending on the application needs does this have to be a single threaded job queue or can multiple jobs run at once? Also, since this seems to be a time sensitive (maybe even synchronous by your description) have you considered submitting call parameters to a data queue, and setting your RPG program up to receive the data queue entry and process it? That would avoid all the job start/end activity which is very expensive in terms of system resources and make the processing go much faster.

Jim Oberholtzer
CEO/Chief Technical Architect
Agile Technology Architects, LLC


On 12/3/2010 11:47 AM, Gary L Peskin wrote:

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