I'd ask over on MXG-L if there are methods for SAS to pass the record count and average record length estimate to DFSORT.
Cheers, Martin Martin Packer Systems Investigator & Performance Troubleshooter, IBM +44-7802-245-584 email: martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPacker Blog: https://mainframeperformancetopics.com Mainframe, Performance, Topics Podcast Series (With Marna Walle): https://anchor.fm/marna-walle Youtube channel: https://www.youtube.com/channel/UCu_65HaYgksbF6Q8SQ4oOvA From: "Gibney, Dave" <gib...@wsu.edu> To: IBM-MAIN@LISTSERV.UA.EDU Date: 19/01/2021 20:14 Subject: [EXTERNAL] Re: DFSORT and SAS Sent by: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> Thank you. Adding the suggested parm allowed my job to succeed. Ultimately, there where 15,890,801 records. I looked again and there was not an ICE118I issued in the original job. I really don't know how, or what controls SAS (v9) passes to the HOST SORT Thanks again for the assistance. > -----Original Message----- > From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On > Behalf Of Sri h Kolusu > Sent: Tuesday, January 19, 2021 11:37 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: DFSORT and SAS > > > ICE752I 0 FSZ=0 RE IGN=0 C AVG=188 0 WSP=0 E DYN=2313 16352 > > Dave, > > When DFSORT is invoked via program, it needs to know how many records it > is sorting so that it can optimally allocate resources needed to sort that > data. Since the program is feeding the records DFSORT does not have a clue > and the resources allocated are not enough to complete the sort and hence > the message ICE046A 0 SORT CAPACITY EXCEEDED - RECORD COUNT 6956799 > > Generally, DFSORT can automatically determine the input file size. However, > in a few cases, such as when an E15 supplies all of the input records or > when information about a tape data set is not available from a tape > management system, DFSORT cannot determine an accurate file size. > > Your joblog does not show one of the important message. You should have > gotten an ICE118I message > > ICE118I UNKNOWN FILE SIZE - RECOMMEND SPECIFYING FILSZ=EN TO > REDUCE RISK OF > FAILURE OR DEGRADED PERFORMANCE > > INVALID URI REMOVED > nter/en/SSLTBW_2.3.0/com.ibm.zos.v2r3.icem100/mb00083.htm__;!!JmPEg > BY0HMszNaDT!9_LGpASIz6lgFy3pDduAe2DC4jQhXQBtSHYnTd10a0weZdx0ie > 4mdHNVwnuilA$ > > DFSORT failed after processing about 6,956,799 . So if you know how many > records you are going to process, then you can pass an estimated filesize > via DFSPARM like this > > //DFSPARM DD * > OPTION FILSZ=E10000000 > /* > > Since DFSORT already processed about 6.9 million records, I just estimated > that you have 10 million records. You can change that number depending on > your input file. > > > Further if you have any questions please let me know > > Thanks, > Kolusu > DFSORT Development > IBM Corporation > > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
