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