|
Evan, The worst offending job is using CPYF and CPYFRMQRYF to move some of the records around, it probably copies about 10+ million records. One other job does use blocking where it can but a lot of what it has to do doesn't allow the blocking to help too much. I am sure that this could be helped some by redesigning these apps but it is only a few that really cause the problem and they are only run a few times a month so we have minimized the impact with how we schedule them. Scott Mildenberger > -----Original Message----- > From: Evan Harris [mailto:spanner@ihug.co.nz] > Sent: Monday, July 01, 2002 2:32 PM > To: midrange-l@midrange.com > Subject: RE: disk arms (was RE: Tips for user ASP) > > > Hi Scott > > as a matter of interest are these jobs designed to take advantage of > blocking/sequential access to minimize disk access ? > > Anyone - is there a way to see that blocking is being > utilized other than > trying to use the open files WRKJOB display ? > > Regards > Evan Harris >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.