EQUALS adds an internal sort field of 4 bytes to hold an input sequence number, which is what you appear to be having trouble with. You haven't mentioned it, but removing EQUALS will solve your problem.
If that's not feasible you can, if necessary, use some fancy stuff to add your own, say, a 6 or 8-byte sequence field on the fly, and use it as the least-significant key (i.e. so you can remove the EQUALS keyword and avoid the limit). btw, EQUALS adds significant overhead to the sort, besides the limitation. Don't use it just for fun. If SYNCSORT doesn't have this limitation, it must be using a bigger sequence field. Maybe you could ask IBM to allow for that. sas On Thu, Jan 12, 2023 at 1:02 PM Charles Hardee <charleshhar...@gmail.com> wrote: > I have plenty of SORTWKxx DDs. > I don't think that is the problem. > > I am getting an IEX121A message. > According to the DFSORT Messages, Codes and Diagnosis Guide for z/OS 2.5: > > ICE121A FILE SIZE IS TOO LARGE > Explanation > Critical. The amount of data to be sorted exceeded > a DFSORT implementation limit for the maximum > number of records that can be sorted. DFSORT cannot > handle the amount of data regardless of environmental > factors, such as the amount of work data set space > provided. Specific implementation limits include: > > 1. EQUALS in effect - 4294967295 records > > 2. VLSHRT in effect - 2147483647 records > > 3. Blockset technique not selected - 2147483647 records > > System action > The program terminates. > > Programmer response > For cases 1 and 2, perform the sort on subsets of the > data set containing less than the indicated maximum > number of records. Then merge the sorted subsets > into a single data set. > > For case 3, rerun the job with a SORTDIAG DD > statement to get message ICE800I, which indicates > the reason Blockset could not be used. If possible, > remove the condition preventing the use of Blockset. > Alternatively, perform the sort on subsets of the > data set containing less than the indicated maximum > number of records. Then merge the sorted subsets > into a single data set. > > My record count is roughly 250,000 more than the "implementation maximum" > of 4294967295. > > As I indicated, this is a program doing several internal sorts against the > data so splitting, sorting and merging externally is not an option. > > Chuck > > On Thu, Jan 12, 2023 at 11:33 AM Farley, Peter < > 0000031df298a9da-dmarc-requ...@listserv.ua.edu> wrote: > > > Apologies for the typo, the Syncsort option is DYNALLOC, not DYNALOC. > > > > -----Original Message----- > > From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf > > Of Farley, Peter > > Sent: Thursday, January 12, 2023 12:12 PM > > To: IBM-MAIN@LISTSERV.UA.EDU > > Subject: Re: DFSORT maximum input records > > > > Not sure if DFSORT has an equivalent option, but Syncsort has a parameter > > DYNALOC that can change the maximum number of SORTWKnn DD's it will > > allocate. Our local Syncsort default is 64, but for really big sorts > (when > > we get the Syncsort equivalent "too big to sort" message, which says > "SORT > > CAPACITY EXCEEDED") we use DYNALOC(SYSDA,255). > > > > HTH > > > > Peter > > > > -----Original Message----- > > From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf > > Of Charles Hardee > > Sent: Thursday, January 12, 2023 11:43 AM > > To: IBM-MAIN@LISTSERV.UA.EDU > > Subject: DFSORT maximum input records > > > > Hello Listers, > > > > I've searched the IBM-MAIN archives and found nothing to help me so I > > thought I'd better ask the question. > > > > I am trying to sort roughly 4295217295, records using DFSORT. > > DFSORT issues a message that I have exceeded the sort input record > maximum. > > It appears that this maximum is 4294967295. > > > > Since this is a program calling sort internally, and does so several > > times, I cannot do the "normal" thing of splitting the file down into > > smaller files, sort them, then merge them back together. > > > > Anyone have any thoughts on this? > > > > Thanks, > > Chuck > > -- > > > > > > This message and any attachments are intended only for the use of the > > addressee and may contain information that is privileged and > confidential. > > If the reader of the message is not the intended recipient or an > authorized > > representative of the intended recipient, you are hereby notified that > any > > dissemination of this communication is strictly prohibited. If you have > > received this communication in error, please notify us immediately by > > e-mail and delete the message and any attachments from your system. > > > > > > ---------------------------------------------------------------------- > > 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 > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
