Page 1 of 1
how many records we can filter out using joinkeys?
Posted: Mon Jun 03, 2024 1:54 pm
by LearnMainframe
Hi,
Anyone know how many records we can filter out using joinkeys?
Re: how many records we can filter out using joinkeys?
Posted: Mon Jun 03, 2024 3:30 pm
by enrico-sorichetti
if there is a limit, the syncsort manuals will tell
Re: how many records we can filter out using joinkeys?
Posted: Sat Jun 15, 2024 4:09 pm
by Vibha
There is no limit on number fo records because of JOINKEYS, I've used it for millions of records.
Re: how many records we can filter out using joinkeys?
Posted: Sat Jun 15, 2024 4:34 pm
by 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
Re: how many records we can filter out using joinkeys?
Posted: Tue Jul 02, 2024 12:53 pm
by LearnMainframe
We could process 5 million records without any error. Thanks everyone who helped.