System MVS/P390 - Mainframe FOCUS Version 7.3.0A

Hi,
I'm joining two files TIER00DJ and CNTRPRCD:

JOIN TIER_SID IN TIER00DJ TO ALL TIER_SID IN CNTRPRCD AS J2

I'm holding TIER00DJ and it has 1,709 records.

The CNTRPRCD file is indexed on joined field (which is P3 - numeric field). This file contains 2,522 records.

Potentially I can have 4,310,098 records after I join. I'm expecting to have more than 3,000,000 rows anyway. I haven't had this issue before; this is first time the input files are as large.

The error I'm getting is the HIPER LEFT; output file/join result is too large.

I use following settings:
SET EXTSORT = ON
SET AUTOTABLEF = ON
SET SAVEMATRIX=OFF

I know the output file is too large but I can't think of work around to accomplish such task that would work beside join.

Any help/work around is greatly appreciated.

Thanks,
Alaga

This message has been edited. Last edited by: <Emily McAllister>,

See if you can't make FOCSORT bigger.

Ginny,

I have increased FOCSORT and it didn't change anything. Job is still failing with the same error.

Thank you for suggestion though.
Alaga

Some questions: What is the actual FOCUS error you're getting? You'll see something like '(FOC' followed by some numbers. What type of file is CNTRPRCD? Is it a hold file like TIER00DJ or is it some other file type (ie: flat, database, etc). Does TIER_SID occur only once in TIER00DJ or can it occur multiple times?

Ginny,

I increased FOCSORT (see below) and it did the trick.
//FOCSORT DD UNIT=(SYSDA,10),
// SPACE=(CYL,(100,20))
//FOCSORT DD SPACE=(CYL,(100,20))

Thank you so much for your help.
Alaga

Good job, Alaga. I am happy that my suggestion worked for you.

Jessica,

The issue has been resolved by increasing FOCSORT size.

If you need additional info let me know.

Thanks,
Alaga

How can i increase FOCSORT limit.where it is located ?

quote:

Originally posted by Alaga:
Ginny,

I have increased FOCSORT and it didn't change anything. Job is still failing with the same error.

Thank you for suggestion though.
Alaga