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
 

 

Efficient sorting

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
chandracdac

New User


Joined: 15 Jun 2007
Posts: 88
Location: bangalore

PostPosted: Sat Oct 22, 2016 3:23 am    Post subject: Efficient sorting
Reply with quote

What is the best way to SORT tape files. i don't want to use IEBGENR. Also i want to OMIT few records while copying from my tape file also i want to take part of my record(like INREC fields)

One more question is do we have advantage of having LRECL for SORTIN. where tape is the file in my SORTIN

Thanks,
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7234

PostPosted: Sat Oct 22, 2016 4:13 am    Post subject: Reply to: Efficient sorting
Reply with quote

Where did you get the idea IEBGENER could SORT?

You use your installed SORT product, either DFSORT or SyncSORT or possibly CA-SORT, but no so much of that around.

Even if you don't really want to SORT, (you also mention copy) then SORT with a COPY operation is going to be more flexible and faster than IEBGENER.

What on Earth do you mean by "the advantage of having LRECL"?
Back to top
View user's profile Send private message
chandracdac

New User


Joined: 15 Jun 2007
Posts: 88
Location: bangalore

PostPosted: Mon Oct 24, 2016 10:54 pm    Post subject: Reply to: Efficient sorting
Reply with quote

sorry for the confusion created. i meant i don't want to use IEBGENR for copying.
Back to top
View user's profile Send private message
chandracdac

New User


Joined: 15 Jun 2007
Posts: 88
Location: bangalore

PostPosted: Mon Oct 24, 2016 10:58 pm    Post subject: Reply to: Efficient sorting
Reply with quote

Bill for your question

What on Earth do you mean by "the advantage of having LRECL"?

suppose if my sortin file is of variable block with record length of 5000 and i am not worried about last 2000 characters from the record, in that case is there any advantage if i specify LRECL=3000 for my SORTIN . Hope it is clear now.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7234

PostPosted: Mon Oct 24, 2016 11:08 pm    Post subject: Reply to: Efficient sorting
Reply with quote

No, there would be no benefit for specifying LRECL=3000 for your SORTIN. This would not truncate the records, just distribute data around (fixed-length records) or, well, forget it for variable-length records as well.

What you should do is use INREC to only have in your records the bytes you need to use during the processing or in the output.

Code:
  INREC BUILD=(1,3000)


For fixed-length records.

For variable-length records, if you are sure there is data up to 3000 bytes:

Code:
  INREC BUILD=(1,4,5,3000)


If your data could be shorter than 3000 bytes, you can hardly shorten the records to 3000 bytes of data anyway.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Mon Oct 24, 2016 11:55 pm    Post subject:
Reply with quote

Quote:
What is the best way to SORT tape files.
First understand how DFSORT works and then we all worry about optimization. If you don't "Quote" properly then your meant could mean totally different to us.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Stripping and Sorting of VB file G SRINIVASA RAO SYNCSORT 5 Wed Sep 14, 2016 1:34 pm
No new posts DFSORT sorting only specific records akodakka DFSORT/ICETOOL 4 Thu Aug 04, 2016 11:24 am
No new posts Which is more efficient? pshongal DB2 6 Wed Mar 16, 2016 2:55 pm
No new posts VB file sorting V S Amarendra Reddy DFSORT/ICETOOL 2 Fri Feb 26, 2016 8:29 pm
No new posts File sorting and summing up values at... kenshin DFSORT/ICETOOL 3 Wed Sep 23, 2015 2:14 am


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