MVSFORUMS.com

[sonika2008]

hi,

can anyone please provide me the MAXSORT syntax.
I want to sort the millions of record.

[Nic Clouston]

Looking at the DFSort manual I could not see a MAXSORT keyword - MAX yes, MAXLIM yes but no MAXSORT. Is it SYNCSORT you use?
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

[Frank Yaeger]

sonika2008,

Which sort product are you using?

If you're using DFSORT, it does not have a MAXSORT function. I'm not sure why you think you need a MAXSORT function to sort "millions of records". DFSORT can use memory objects, up to 255 work data sets, etc. so sorting millions of records in the normal way is not really a problem unless your resources are constrained to the point that a normal sort won't work. Have you run into a problem sorting the records or are you just assuming you will?
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

[sonika2008]

I am using the syncsort .I have run the job, and its giving U016 abend .

EXEC PGM=SYNCSORT,
PARM='MSG=AP,DYNALLOC=(SYSDA,NNN)'

can you please tell me what is the max no for NNN is used in DYNALLOC?

[Bill Dennis]

Here is a simple MAXSORT but you need to read the manual to understand how the files and options work.

[amargulies]

[sonika2008]

Thanks for your response.
My job run successfully , I used 200 in DYNALLOC for SYSDA.
but my concerns is I have to execute the 300M records for other tables, so I am looking for other options, and I found that with the help of MAXSORT I can run millinos of records, but not able to find any document or JCL of MAXSORT.

[amargulies]