how many records we can filter out using joinkeys?

[LearnMainframe]

Hi,

Anyone know how many records we can filter out using joinkeys?

[enrico-sorichetti]

if there is a limit, the syncsort manuals will tell

[Vibha]

There is no limit on number fo records because of JOINKEYS, I've used it for millions of records.

[enrico-sorichetti]

There is no limit on number fo records because of JOINKEYS, I've used it for millions of records.

 

pretty primitive answer

not based on FACTS,

all *Sort* products have a record count limit based on the dasd space available for the sortwk datasets
and the relevant *Sort* manuals will tell to customize the *Sort*  jcl/parameters in order to  provide the needed allocation space 

the related error message would be something like "WER.../ICE ... SORT CAPACITY EXCEEDED ... ... "  

the responder was just lucky that his dasd configuration could support the sortwk allocation requests


 

[LearnMainframe]

We could process 5 million records without any error. Thanks everyone who helped.