|
I am looking at reducing the number of jobs (see previous reply) and have made sure no joblogs are created. How do you compress the job table? Martin -----Original Message----- From: ddunfie@net-link.net [mailto:ddunfie@net-link.net] Sent: 15 February 2002 16:32 To: rpg400-l@midrange.com Subject: Re: RE: What's the fastest way to submit jobs from RPG? > David is right.....if you really choose to go this route, make sure you do not create job logs or your system will really bog down as the number of jobs increases. You also may need to compress your job table along the way or your performance will disappear on your system (we learned the hard way during Y2k scanning in batch). This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > -- > [ Picked text/plain from multipart/alternative ] > Are you sure you want to go this route? If you submit 20 jobs for one each > of millions of records, you'll end up with many millions of jobs, which > would put a huge overhead on your system. > > Dave > > -----Original Message----- > From: Saunders, Martin P [mailto:martin.saunders@cgey.com] > Sent: Friday, February 15, 2002 7:40 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. > _______________________________________________ > 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. > > _______________________________________________ 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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.