Page 1 of 1

SYNCSORT limitations

PostPosted: Wed Jun 01, 2011 4:00 pm
by pjagathis
Doesr SYNCSORT having any limitations? If so, how many records can it handle.
(that is, it handle only about 2 billion records or 2 million records)

Re: SYNCSORT limitations

PostPosted: Wed Jun 01, 2011 4:59 pm
by Robert Sample
The limit is going to depend upon how you site uses the product. A single data set cannot exceed 59 volumes, which gives you a starting point for your calculations.

Re: SYNCSORT limitations

PostPosted: Thu Jun 02, 2011 3:09 pm
by pjagathis
ThanX Robert..

Could you please tell me the count?

For example, it can handle only 500,000 records

Such that Syncsort will handle maximum of how much records.

Re: SYNCSORT limitations

PostPosted: Thu Jun 02, 2011 4:34 pm
by Robert Sample
Syncsort will probably handle 4 billion records (2 to the 32nd power) -- although I am not a Syncsort expert or developer and that is just a guess on my part., and it may be able to sort more than that I do know people sort millions of records in files every day using Syncsort (and DFSORT), so half a million records is well within the capabilities of the product. If you are having problems with just half a million, you need to talk to your site support group. The limits that sorts usually reach are not product limits but rather limits based on the site standards as far as number of disk volumes allowed for the sort, or available space on the sort volumes, or CPU limit for the job class, or ....

Re: SYNCSORT limitations

PostPosted: Thu Jun 02, 2011 11:48 pm
by dick scherrer
Hello,

If you have experienced some kind of "volume of data" related error or abend, you need to post the particulars. Post the jcl and control statements submitted along with all of the informatoiinal output generated by the run.

500,000 records is not a very large sort in many places. . .

Re: SYNCSORT limitations

PostPosted: Tue Jun 07, 2011 3:25 pm
by pjagathis
ThanX Robert..