How to resolve the error "WER488A JOIN CAPACITY EXCEEDED" I am usi

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?

Question Posted / shaikkalesha

2 Answers
8706 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to resolve the error "WER488A JOIN CAPACITY EXCEEDED" I am using SYNCSORT with JOI..

Answer / 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

How to resolve the error "WER488A JOIN CAPACITY EXCEEDED" I am using SYNCSORT with JOI..

Answer / vamsi

exchange the files sortf1 to sortf2 will solve this
problem..

Is This Answer Correct ?

0 Yes

1 No

Post New Answer