Seem like something that SAS should do without being told.... My checking of SAS options didn't find the settings other than the ones I mentioned in original note.
> -----Original Message----- > From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On > Behalf Of Martin Packer > Sent: Tuesday, January 19, 2021 1:09 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: DFSORT and SAS > > 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://urldefense.com/v3/__https://mainframeperformancetopics.com__; > !!JmPEgBY0HMszNaDT!- > jCPCp1oJgGvSG9Dtcsgk0O8m66pT5PMrB2L1_5At3l0h-ggJZr4QQ7JjmRfNQ$ > > Mainframe, Performance, Topics Podcast Series (With Marna Walle): > https://urldefense.com/v3/__https://anchor.fm/marna- > walle__;!!JmPEgBY0HMszNaDT!- > jCPCp1oJgGvSG9Dtcsgk0O8m66pT5PMrB2L1_5At3l0h-ggJZr4QQ5GMlQQ6Q$ > > Youtube channel: > https://urldefense.com/v3/__https://www.youtube.com/channel/UCu_65 > HaYgksbF6Q8SQ4oOvA__;!!JmPEgBY0HMszNaDT!- > jCPCp1oJgGvSG9Dtcsgk0O8m66pT5PMrB2L1_5At3l0h-ggJZr4QQ5uyw0NKQ$ > > > > 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 ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
