Re: Prestart job problem

[Jim Oberholtzer <midrangel@xxxxxxxxxx>]

Richard,

You don't really need another subsystem.  What you need to do is add 
another subsystem memory pool.  Steps are:
CHGSHRPOOL POOL(*SHRPOOL12)
           SIZE(3000)
           ACTLVL(10)
           PAGING(*CALC)
           TEXT('For my Java Jobs')
Pick a shared pool, size, and activity level (number of jobs that will 
be active at once)  that makes sense to you.
Add the memory to the subsystem in question.  I picked QBATCH, use the 
correct one for you.

CHGSBSD SBSD(QBATCH)  POOLS((2 *SHRPOOL12 10))

Now the part most folks miss; change the routing step used for the job 
to use the new memory pool.  To find the routing step display the 
subsystem and pick option 7.  It may list several routing steps.  You 
want the one the prestart jobs use.  Check the job description for the 
prestart job.  That may give you a clue about the routing data that is 
used.   I usually change the default first then test to see if that 
routes properly.  In the case of QBATCH the routing step is 9999, so;

CHGRTGE SBSD(QBATCH)
        SEQNBR(9999)
        POOLID(2)
You may have to fully qualify the name of the subsystem, in this example 
I did not.

Now restart the jobs.  They should route to your new memory pool.  Be 
sure to watch it and tune it for a day or two.  Add or subtract memory 
as appropriate and change the activity level so it is just high enough 
to not cause wait transitions.(Active or Wait to ineligible)

Creating a new subsystem is the exact same series of steps once you run 
the CRTSBSD command first.

Keep tuned for a System i News article I wrote about this entire 
process.  It goes into much more detail.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 10/16/2011 9:01 AM, Richard Reeve wrote:
> All,
>
>       I'm looking for a sanity check........
>
>       We have an application that runs both on the i (using RPG) and from a windows server (using Java).  The DB resides on the i.  All DB updates from the server side are done via stored procedures that update that database using SQL.
>
>       Recently, I have noticed a terrible response time (from green screen as well as through the Java application) and think that I see the problem.....The prestart job that processes the SQL transactions is running in the base pool (which is where everything else runs as well) and at times there is an indexing issue.  I know that the indexing issue must be addressed, but in the mean time I'm thinking that I could segregate the prestart job(s) to alleviate the the poor response times that are being caused by these troubled prestart jobs.
>
>       Would it not make better sense to define the subsystem (and therefor memory pool) that the prestart job runs in to be different than where all the other jobs (both batch and interactive) run?  At times these prestart jobs are consuming upward of 70% of the resources.
>
>       Any advice/places to look for additional info would be much appreciated. 
>   
> Warmest Regards,
>
> Richard Reeve
>
> P.S.  Unfortunately, we are still on 5.4  :o(
> --