I invented the world's worst way to sort: Create a VSAM KSDS with the proper characteristics and size. REPRO a single record from the input into the VSAM KSDS, by using a COUNT(1). Then REPRO all the rest into it using a SKIP(1). The REPRO the data out of the KSDS into the desired data set, then delete the VSAM KSDS.
Perhaps the a worse way that that would be to load the data into a DB2 table, then do a SELECT * FROM table ORDER BY variable. I guess that I should patent the above!? -- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * [email protected] * www.HealthMarkets.com Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] > On Behalf Of Mike Schwab > Sent: Wednesday, October 03, 2012 8:26 AM > To: [email protected] > Subject: Re: Help with DF-Sort not being able to allocat enough work > data set space > > On Wed, Oct 3, 2012 at 5:27 AM, Hunkeler Peter (KIUP 4) > <[email protected]> wrote: > <deleted> > > Is there any other option I could try, or am I stuck to > > DYNALLOC=(SYSDA,nnn) with a reasonably high "nnn"? > > -- > > Peter Hunkeler > > You could split the input file into parts by number of records or the > high part of the key, sort each part, then merge the parts (or > concatenate the datasets in key range order). > -- > Mike A Schwab, Springfield IL USA > Where do Forest Rangers go to get away from it all? > > ---------------------------------------------------------------------- > 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
