Maximum records that SORT can processed

ABaluchamy · New User Joined: 29 Dec 2006 Posts: 34 Location: INDIA

I am trying to execute the following sort card with the input files having 120 million records.

JOINKEYS FILES=F1,FIELDS=(1,45,A)
JOINKEYS FILES=F2,FIELDS=(1,45,A)
JOIN UNPAIRED,ONLY,F1
SORT FIELDS=(1,45,CH,A)

My job fails with return code U0016 also i could see the message

WER219I DYNALLOC FAILED RC=(970C) - 3390
WER046A SORT CAPACITY EXCEEDED

Is there anyway to make the sort successful or SYNCSORT itself
unable to handle such volume of records.

anyone please help me. Thanks in advance.

expat · Posted: Tue Apr 07, 2009 2:40 pm Post subject:

What does the manual say about the error codes and messages issued ?

ABaluchamy · New User Joined: 29 Dec 2006 Posts: 34 Location: INDIA

As per manual, it seems intermediate storage space is not available. But how do i increase the storage space. I have tried adding JNF1WKnn DD's.

dbzTHEdinosauer · Posted: Tue Apr 07, 2009 4:07 pm Post subject:

One of Syncsort's selling points is their HYPERSORT. Look at that.

leo_sangha · New User Joined: 11 Aug 2005 Posts: 85 Location: England

Can you post your JCL ?

WER046A - is because not enough intermediate storage is allocated.
What is the space allocated for sort working files, SORTWKnn ?

dbzTHEdinosauer · Posted: Tue Apr 07, 2009 4:29 pm Post subject:

the volume of records that can be sorted has nothing to do with the sort product---------it is dependent upon your hardware.

expat · Posted: Tue Apr 07, 2009 4:31 pm Post subject:

As a last resort, and many many years ago - I have allocated six TAPE SORTWKnn statements. And that really is a last resort as the elapsed time rises very sharply, but at least it got the job done.

ABaluchamy · New User Joined: 29 Dec 2006 Posts: 34 Location: INDIA

Here is my job

leo_sangha · New User Joined: 11 Aug 2005 Posts: 85 Location: England

Clearly you havent used any work files ?
There are many existing topics in this forum which will guide you.

ABaluchamy · New User Joined: 29 Dec 2006 Posts: 34 Location: INDIA

I have tried using that also.. missed to copy that particular JCL. Irrespective of work files i have used, i am getting SORT CAPACITY EXCEEDED message. Also I could see the message like

dick scherrer · Posted: Wed Apr 08, 2009 8:43 am Post subject:

Hello,

You need to post the complete jcl and sort control statements that you are currently using as well as any diagnostics generated by running that jcl amd sort control info.

Why is the dynalloc parameter used, or is it simply always used on your system?

You may also need to consider using MAXSORT. . .

Terry Heinze · Posted: Wed Apr 08, 2009 8:52 am Post subject:

Anand B,
Aren't there any examples in the Syncsort documentation showing how to handle large volume sorts?

ABaluchamy · New User Joined: 29 Dec 2006 Posts: 34 Location: INDIA

Dick,

This is my complete job

anandinmainframe · Active User Joined: 31 May 2007 Posts: 171 Location: India

Anand,
Do Check your I/P Files because i have experienced this ABEND U0016. most of the times issue with the I/P file

expat

ABaluchamy · New User Joined: 29 Dec 2006 Posts: 34 Location: INDIA

Yeah, I have tried using tape work datasets also.. no result.

Anuj Dhawan · Posted: Wed Apr 08, 2009 12:41 pm Post subject:

leo_sangha · New User Joined: 11 Aug 2005 Posts: 85 Location: England

dick scherrer · Posted: Wed Apr 08, 2009 11:30 pm Post subject:

Hi Anand,

You have asked for more than 2 complete 3390 devices for sortwk. You need to talk with your storage management people to see if there is that much space available in that dataclas or if there is some other you could use for this job.

Something you might consider is sorting the 2 files separately (with MAXSORT if necessary) and then run this process to join. You can tell the join that the files are already in sequence and prevent sorting them as part of the join.

Alissa Margulies