Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to Choose between INREC and OUTREC

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT
View previous topic :: :: View next topic  
Author Message
subdalal

New User


Joined: 27 Sep 2010
Posts: 21
Location: Boudh

PostPosted: Thu Jun 05, 2014 7:41 pm    Post subject: How to Choose between INREC and OUTREC
Reply with quote

Recently, I have come across a number of sorts, some existing, some new, that are using parms and control statements that can cause runtime and cpu degradation, as well as cause unnecessary abends. Below are just a few of those statements and/or parms that have been found to cause issues when not used properly.

The most frequently used sort control statement that is being misused is the OUTREC. In some instances it is being used in conjunction with INREC or in place of INREC. Keep in mind if the intent is to reduce the size of the file entering the sort then use INREC.

Below are some guidelines to consider, in order to determine when to use either the INREC or OUTREC options.

• Use the INREC control statement to delete irrelevant data fields, reformat numeric
fields to a shorter length, or combine numeric fields with arithmetic operations(mul,add,sub) and
functions. Reducing the size of the input records before they are sorted or merged
usually improves performance.
• Use either the OUTREC control statement or the OUTREC parameter of the OUTFIL
control statement to expand the data record, create new numeric fields, realign data
fields, convert and edit numeric data, and change from variable-length format to fixed length
format when creating one output file.
• Use the OUTREC control statement when creating multiple output files with
the same output record formatting.
• Use the OUTREC parameter of the OUTFIL control statement when creating
multiple output files with different output record formatting.
• Use the OUTREC control statement if a numeric field needs to be converted to printable
format so it can be displayed in an OUTFIL header.
There are other reasons to use outrec or Inrec but these cover the vast majority of reasons.

Another parm that can be used are is ELAP for large sorts. The options are Balance, Elap, I/O and CPU. The default if not specifically coded for is Balance. This tells syncsort to determine on it’s own which of the options to use. Most often syscsort will try to reduce cpu at the expense of Elapsed time. For small sorts this will be fine. For large sorts Elap should be coded as the overall elapsed time will be reduced. Since, sysnsort offloads most processing to the ziip processor cpu is not the biggest concern.

VSCORET is another parm this is often misused. This parm tells syncsort how much core to try an to retrieve. This can cause abends when not enough core is available. Never code VSCORET=MAX as this will most likely cause the sort or other processes to abend.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Thu Jun 05, 2014 7:49 pm    Post subject: Reply to: How to Choose between INREC and OUTREC
Reply with quote

Quote:
This tells syncsort to determine on it’s own which of the options to use.


if You are talking about SYNCSORT why did You post to the DFSORT section of the forum ???
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7308

PostPosted: Thu Jun 05, 2014 8:34 pm    Post subject: Reply to: How to Choose between INREC and OUTREC
Reply with quote

If you are going to quote chunks of a SyncSort manual at least give attribution, and don't post it in the DFSORT forum.

Note how it is best not to use OUTREC on OUTFIL at all, instead to use BUILD on OUTFIL (they are equivalent) and avoid the confusion.
Back to top
View user's profile Send private message
subdalal

New User


Joined: 27 Sep 2010
Posts: 21
Location: Boudh

PostPosted: Fri Jun 06, 2014 4:10 pm    Post subject:
Reply with quote

Sorry Guys!! Enricho and Bill !! Could not locate the Synsort Forum.
Wil take care in Future.

And thanks for moving the same to Syncsort.


Thanks
Subhasis
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts outrec field outside range Danielle.Filteau SYNCSORT 10 Sat Mar 04, 2017 2:37 am
No new posts SORT- outrec ram_vizag DFSORT/ICETOOL 10 Tue Sep 27, 2016 12:50 am
No new posts OUTREC FILELDS FAILS WITH ICE126A 2 ... balaji81_k DFSORT/ICETOOL 8 Sat Jul 02, 2016 1:22 am
No new posts OUTREC RDW NOT INCLUDED krsenthil85 SYNCSORT 10 Fri May 06, 2016 3:22 am
No new posts What does this INREC do? Lino Pontes DFSORT/ICETOOL 5 Fri Apr 08, 2016 12:17 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us