I am using SYNCSORT with JOINKEYS to compare 2 files.
I am Getting error - > WER488A JOIN CAPACITY EXCEEDED
There are 2 files to be compared with about 2 million records each. LRECL is 3665.
Can somebody give a pointer as to how to resolve this problem?
I do not have SYNCSORT manual with me although searching for it for a long time.
Number of records in both the files are exactly 2 million each. JOINKEY is on 1st 10 bytes. Please find the complete sort card and
spool messages below.
I would appreciate any help in solving this problem. Thanks in advance.
-- Jaggi.
Code:
SYNCSORT FOR Z/OS 1.2.3.0R U.S. PATENTS: 4210961, 5117495 (C) 2005 SYNCSO
XXXXX INC. z/OS 1.8.0
PRODUCT LICENSED FOR CPU SERIAL NUMBER 36FAB, MODEL 2094 715 LICEN
I do not have SYNCSORT manual with me although searching for it for a long time
that' s odd and very unpleasant for everybody ...
how have You done your work until now ???
( writing sort control statements )
if the company You work for is a licensed user
it should have all the the relevant documentation
and should make it available in order to let people do their work
very mild hint
the forums are not a manual reading service
As per the SyncSort for z/OS 1.2 Programmer's Guide:
WER488A JOIN CAPACITY EXCEEDED
EXPLANATION: SyncSort is unable to complete the join application because of insufficient memory. This may be due to a user error in specifying the JOINKEYS fields, or the application may be very large relative to the amount of available memory.
In order to join all records with equal JOINKEYS in SORTJNF1 with all records with matching JOINKEYS in SORTJNF2, SyncSort retains all the equally keyed SORTJNF2 records in memory to join with the next equally keyed record from SORTJNF1. The available amount of memory is determined by the available system resources and the region size and may not be sufficient if there are very many equally keyed records in SORTJNF2.
ACTION: First examine the fields specified for the JOINKEYS FILE=F2 statement and correct any errors. If the fields were incorrectly specified, then many records may have been incorrectly determined to be equally keyed.
If the JOINKEYS statement for F2 is correct, and if you believe that SORTJNF1 does not contain many equally keyed records that match the large number of equally keyed records in SORTJNF2, then this problem may be easily corrected by reversing the F1 and F2 definitions such that SORTJNF1 has many equally keyed records, but SORTJNF2 does not. To do this, reverse the DDNAMEs of the two files and change the JOINKEYS, REFORMAT, and JOIN UNPAIRED statements accordingly.
If this does not solve the problem, then the total region size must be raised high enough to contain all of the SORTJNF2 equally keyed records.
Contact SyncSort for z/OS Product Services for assistance, if necessary.