How to resolve the error "WER488A JOIN CAPACITY EXCEEDED"
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 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?
- 2 Answers
- 8707 Views
- I also Faced
- E-Mail Answers
Answer Posted / Reena
The WER488A JOIN CAPACITY EXCEEDED error usually occurs when trying to join two large files using SYNCSORT with JOINKEYS and the sort key is too long or there are multiple duplicates. To resolve this issue, consider the following steps:
1. Split the input files into smaller pieces and process them individually if possible.
2. Increase the maximum join capacity by modifying the SORTMAX option in your JCL (Job Control Language).
3. Use a different method to compare the two files if the sort key is too large, such as comparing after sorting the individual files.
4. Remove or reduce duplicates in the input files before joining them using SYNCSORT.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
