On Sun, 9 Mar 2008 18:12:19 -0400, David Betten <[EMAIL PROTECTED]> wrote:
>Pawel, > It's really hard to say what is a "good" sorting rate. There are so >many factors that can impact the performance of the sort. File >characteristics, i/o contention, storage resources, etc. I have seen >customer sorts with much higher throughput rates than you and I've seen >some with worse. The DFSORT team is alwasy willing to assist with tuning. >If you can send a note to our hotline ([EMAIL PROTECTED]) we can assist >you. If possible, add //SORTDIAG DD DUMMY to some of the long running sort >steps and send us the sysout. Be sure to send the entire sysout and not >just the DFSORT messages. > Dave, thanks for offering me help. I added //SORTDIAG DD DUMMY to few of our long running jobs and surely send sysout to your hotline (after night batch processing). Thanks, Pawel >Have a nice day, >Dave Betten >DFSORT Development, Performance Lead >IBM Corporation >email: [EMAIL PROTECTED] >DFSORT/MVSontheweb at http://www.ibm.com/storage/dfsort/ > >IBM Mainframe Discussion List <[email protected]> wrote on 03/09/2008 >05:05:33 PM: > >> Hello everybody, >> >> I realize subject is VEEEERY broad and my question VEEEERY general, >but... >> >> Recently in our shop we are reviewing our whole batch processing. >> Most of the time of EOD processing is consumed by sort of many big >sequential >> files. (One such file has approximately order of 10GB, 10mln records) >> I listed few tens of such batch jobs (the longest-lasting ones) >> and computed mean sorting rate. >> It appeared to be about 1GB/min ~ 17MB/sec >> >> I suppose it's very poor result(???). >> >> Can you tell me how much I can improve this? >> >> These batch jobs are little CPU-consuming (~10% of one CPU), >> I suppose that major concern is to: >> >> -limit EXCPS (1) >> -increase throughput rate from DASD to central storage (2) >> >> I realize that sorting whole file in central storage (hiperspace >> sorting) would >> eliminate need to use work files and EXCPS to them. >> How much central storage is needed to handle in-storage sorting for >> let's say 10 GB file??? >> >> How much can I improve (2)? >> >> Can you tell me what is mean sorting rate in your installation? >> Before starting I would just like to know if I can achieve substantial >> improvement. >> >> TIA, >> Pawel Leszczynski >> PKO BP SA >> >> ---------------------------------------------------------------------- >> For IBM-MAIN subscribe / signoff / archive access instructions, >> send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO >> Search the archives at http://bama.ua.edu/archives/ibm-main.html >---------------------------------------------------------------------- >For IBM-MAIN subscribe / signoff / archive access instructions, >send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO >Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
