Re: What's the fastest way to submit jobs from RPG?

--
--
[ Picked text/plain from multipart/alternative ]
Any time I've had these sorts of performance issues I've only ever found two
things that have helped.

The most bang for the buck comes from removing the K and processing records
in arrival sequence.  This is not always possible,  but too many times I
have seen people process 100% of the records, yet insist the records must be
processed in keyed sequence.

The second method may no longer be as effective as it once was.  Use IP
sequencing and use matching records.  Use the cycle as designed.  Organizing
the files in index order first might also be useful.

Please, no squeals and yelps.  The cycle and matching records is fast.  If
he's looking at an 83 day job, he needs to find 90+% improvements and those
two suggestions often yield those sorts of results.


--------------------------------------------
Booth Martin
MartinB@Goddard.edu
802-454-8315 x235
--------------------------------------------
-------Original Message-------

From: rpg400-l@midrange.com
Date: Friday, February 15, 2002 11:22:04 AM
To: 'rpg400-l@midrange.com'
Subject: What's the fastest way to submit jobs from RPG?

Hi folks,

Program A reads a file and for each record submits about 20 jobs to batch to
update totals further up the hierarchy of records in the file. The batch
jobs are going to a dedicated jobq/subsystem which can have up to 25 active
jobs. At the moment no more than 3 or 4 jobs are active at a time because
Program A is not submitting them fast enough. We have tried submitting the
jobs directly from the RPG program using QCMDEXC and by calling a CLP to
submit them (contrary to (my) expectations, calling the CL was faster). At
the speeds we are seeing at the moment it would take 83 days of continuous
processing to complete the job (we are talking about millions of records).
Is there a way to speed up submission of the batch jobs from program A?

TIA

Martin


*****************************************************************************
**************
" This message contains information that may be privileged or confidential
and
is the property of the Cap Gemini Ernst & Young Group. It is intended only
for
the person to whom it is addressed. If you are not the intended recipient,
you
are not authorized to read, print, retain, copy, disseminate, distribute, or
use
this message or any part thereof. If you receive this message in error,
please
notify the sender immediately and delete all copies of this message ".
*****************************************************************************
**************
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


.
--
[ Content of type unknown/unknown deleted ]
--