Re: Prestart job problem -- MIDRANGE-L

Jim

Great info, but not going to help in this case I think...assuming that
more than just this app uses QZDASOINIT.

The OP said that "All DB updates from the server side are done via
stored procedures that update that database using SQL."

So I think he's dealing with QZDASOINIT jobs running in the QUSRWRK subsystem...

Richard, take a look at this article showing you step by step on how
to route certain QZDASOINIT jobs to their own pool...
http://www.centerfieldtechnology.com/publications/archive/August%202005%20Newsletter.pdf

HTH,
Charles

On Mon, Oct 17, 2011 at 6:40 AM, Jim Oberholtzer <midrangel@xxxxxxxxxx> wrote:

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(
--

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.