MVSFORUMS.com

ramu_mohan21

Hi Board,
In my installation we are using SYNCSORT. When I ran the JOB with less number of records it was executed fine. But when more number records are encountered it has got abended with

ramu_mohan21 · Posted: Wed Dec 01, 2004 4:50 am Post subject:

In addition to the above mentioned information I am supplying some more information. At this SORT step REGION=1M, COND=(0,NE) have been kept. Do I need to change REGION parameter with anyother value?
If I need to change the REGION parameter what value should be kept. REGION=?
(Or) Anyother solution is available?
_________________
Best Regards,
----------------
Rammohan Pabba
Software Engineer

Phantom · Posted: Wed Dec 01, 2004 5:31 am Post subject:

Ramu,

ramu_mohan21 · Posted: Wed Dec 01, 2004 6:26 am Post subject:

Hi Phantom,
I changed my Sort Card as you suggested and I increased the REGION=3M also. Still I am getting the same abend. Is there is any other way to resolve this error.
_________________
Best Regards,
----------------
Rammohan Pabba
Software Engineer

Phantom · Posted: Wed Dec 01, 2004 6:37 am Post subject:

Ramu,

What is the size of the Input file (No. of records) ?

Did u allocate any SORTWORK datasets yourself ? If so, remove the SORTWK datasets. Its better to let SORT allocate the WORK datasets dynamically depending on the file size.

Thanks,
Phantom

kolusu · Posted: Wed Dec 01, 2004 6:38 am Post subject:

ramu_mohan21,

I am assuming that your input file is a tape. Since you are sorting you need SORTWORK datasets also. Post your JCL and entire SYSOUT messages from your sort step.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

ramu_mohan21 · Posted: Wed Dec 01, 2004 6:47 am Post subject:

Hi Kolusu,
Yes you are right. The input file is Tape File.

Phantom · Posted: Wed Dec 01, 2004 6:54 am Post subject:

Ramu,

ramu_mohan21 · Posted: Wed Dec 01, 2004 6:59 am Post subject:

Hi Kolusu,
Here are the SORTWORKs mentioned below and also I included in my JCL with REGION=3M at SORT STEP.

kolusu · Posted: Wed Dec 01, 2004 7:00 am Post subject:

ramu_mohan21,

You need to post SYSOUT messages but not JES messages. As phantom mentioned you have a syntax error on your include cond.

Your control cards should be as follows

Phantom · Posted: Wed Dec 01, 2004 7:01 am Post subject:

Ramu,

Do u have atleast one space before the INCLUDE & SORT operators in the instream SYSIN card ? If not you will end up with syntax error.

Thanks,
Phantom

ramu_mohan21 · Posted: Wed Dec 01, 2004 7:24 am Post subject:

Hi Kolusu & Phantom,
I'm sorry for not posting the SYSOUT message.
Here is the SYSOUT message shown below:

ramu_mohan21 · Posted: Wed Dec 01, 2004 9:00 am Post subject:

Hi Kolusu & Phantom,
Now the job has been completed successfully. The problem has been resolved. Thank you very much for suggesting me the efficient solution.
_________________
Best Regards,
----------------
Rammohan Pabba
Software Engineer

kolusu · Posted: Wed Dec 01, 2004 9:47 am Post subject:

Ramu_mohan21,

You can also add FILSZ parm to your sort which provides an estimate of the number of input file records for a sort or merge operation.This parameter helps the sort optimize its performance. In most cases, SORT can determine the file size automatically, so FILSZ isn't needed. Sometimes SORT cannot determine the file size (1) when an E15 supplies all of the input records and (2) when the input is a data set on tape that isn't managed by SMS.

Since your input is on tape, you can provide an estimate of the total no: of records. Right now if your input file has 20 million records (20000000) then take into consideration for 20% of growth of current no: of records.

Phantom · Posted: Wed Dec 01, 2004 10:11 am Post subject:

Good that everything is working fine now.

Just Go thro' the DFSORT flow diagram that was provided in my previous post. Always try to minimize the records that are being processed (using SKIPREC, STARTREC, INCLUDE/OMIT etc...) so that the job uses less resources & be more efficient.

Thanks,
Phantom