SAS application programs often invoke multiple PROC SORT requests (some thru SQL-type invocations, or otherwise) and so there really should not be an OPTION FILESZ=Ennnnnnn necessary, given the SAS program-invoked method (i.e., SAS generates the OPTION and SORT statements.)
And so you should see evidence in SORT diagnostic output messages where the SAS/DFSORT request is invoked where you really should see the SORT statement and any preceding OPTION statement which is where you would see the file-size (estimated) directive. So, if the OP codes a //SORTDIAG DD DUMMY statement and if there is no OPTION statement followed by the SORT FIELDS=(....) invocation directive, then you need to open a SAS support TRACK and be ready to provide the entire job-output along with the SASLOG, also to include your PROC OPTIONS; output for their review/diagnosis. Something is not right with the SAS/DFSORT invocation diagnostics output contributed in this IBM-MAIN group post. Regards, Scott Barry SBBTech LLC On Tue, 19 Jan 2021 21:23:21 +0000, Gibney, Dave <[email protected]> wrote: >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 <[email protected]> On >> Behalf Of Martin Packer >> Sent: Tuesday, January 19, 2021 1:09 PM >> To: [email protected] >> 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: [email protected] >> >> 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" <[email protected]> >> To: [email protected] >> Date: 19/01/2021 20:14 >> Subject: [EXTERNAL] Re: DFSORT and SAS >> Sent by: IBM Mainframe Discussion List <[email protected]> >> >> >> >> 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 <[email protected]> On >> > Behalf Of Sri h Kolusu >> > Sent: Tuesday, January 19, 2021 11:37 AM >> > To: [email protected] >> > 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 [email protected] with the message: INFO IBM-MAIN >> >> ---------------------------------------------------------------------- >> For IBM-MAIN subscribe / signoff / archive access instructions, >> send email to [email protected] 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 [email protected] with the message: INFO IBM-MAIN > >---------------------------------------------------------------------- >For IBM-MAIN subscribe / signoff / archive access instructions, >send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
