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
 

 

DFSORT or DB2 or SAS for merging flat files??

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

Global Moderator


Joined: 28 Aug 2007
Posts: 1491
Location: Chennai

PostPosted: Thu Feb 19, 2009 3:49 pm    Post subject: DFSORT or DB2 or SAS for merging flat files??
Reply with quote

Hi,

The tricks on the "SMART DFSORT TRICKS" document were really helpful. Thanks for putting all of them together. icon_biggrin.gif
I have a question regarding the Merging done using the splicing technique.

I have a requirement to merge two really big files. The merge condition is based on 2 key fields.
The two input files have roughly 5 fields and record length of 300 to 400.

For merging we have three options in our shop.
1) Using DB2 tables and then merging together using queries. And then write them to an external file.
2) Reading them into SAS databases and then merging using DATA step and then writing to external file.
3) Using DFsort merging technique.

Could you please tell me which technique is better so that the CPU usage is less.
Also could you please tell me which technique is optimum for ultilising less temp work space.

Also if it is not confidential.... icon_cool.gif "who wrote "SMART DFSORT TRICKS e-book???"
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu Feb 19, 2009 10:05 pm    Post subject:
Reply with quote

Quote:
The tricks on the "SMART DFSORT TRICKS" document were really helpful. Thanks for putting all of them together


You're welcome. I'm glad you find it helpful.

Quote:
who wrote "SMART DFSORT TRICKS e-book???"


I wrote that paper as well as the other papers (Ask Professor Sort, Beyond Sorting, etc) on the DFSORT website. Kolusu and others contributed some of the "Smart DFSORT Tricks".

Quote:
Could you please tell me which technique is better so that the CPU usage is less.
Also could you please tell me which technique is optimum for ultilising less temp work space.


The only way to find out for sure is to try all three techniques using your specific requirements and data, and compare the results. Anything else is just speculation.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1491
Location: Chennai

PostPosted: Fri Feb 20, 2009 1:51 pm    Post subject:
Reply with quote

Thanks Frank, icon_biggrin.gif

Actually I did not know the technique to measure the CPU usage in the three techniques as I have only basic knowledge on DB2 and SAS.
I will try them out with and see wat happens.

Have not heard about Ask Professor Sort, Beyond Sorting. They sound interesting..will try them out..
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 Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts Dynamic split of files under groups sril.krishy DFSORT/ICETOOL 4 Mon Apr 17, 2017 1:09 pm
No new posts DFSORT - Overriding default option TU... Steve Ironmonger DFSORT/ICETOOL 3 Tue Apr 04, 2017 3:54 pm
No new posts Compare two files and subtract values ameetmund DFSORT/ICETOOL 7 Fri Mar 31, 2017 3:35 pm


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