match data across four files and write matching data



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Re: match data across four files and write matching data

Postby savitha_y » Fri Jun 05, 2009 11:17 am

Hi Frank, Thanks a lot

It is working as expected... Thanks once again. I have a doubt about CPU. Will it consume more CPU if we have 1 lakh records on each input file as we are using two temp files in a single icetool step. Please advice..
savitha_y
 
Posts: 18
Joined: Mon May 11, 2009 3:05 pm
Has thanked: 0 time
Been thanked: 0 time

Re: match data across four files and write matching data

Postby Frank Yaeger » Fri Jun 05, 2009 8:52 pm

Consume more CPU time compared to what?

1 lakh is only 100000 records which is a rather small file as far as DFSORT is concerned. The CPU time consumed is related to the number of passes over the data, but the job won't consume much CPU time for that small a file.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: match data across four files and write matching data

Postby savitha_y » Mon Jun 08, 2009 5:02 pm

Hi Frank,

Thanks a lot. It is working as expected. Thanks once again.
I need small clarification regarding CPU usage. Will this icetool step consume more CPU if each of the four input files has approximately 1 lakh records as we are using two temparory datasets in single icetool step.

Thank you.
savitha_y
 
Posts: 18
Joined: Mon May 11, 2009 3:05 pm
Has thanked: 0 time
Been thanked: 0 time

Re: match data across four files and write matching data

Postby savitha_y » Mon Jun 08, 2009 5:04 pm

Hi Frank,

Sorry for posting same question again. Please ignore it.
savitha_y
 
Posts: 18
Joined: Mon May 11, 2009 3:05 pm
Has thanked: 0 time
Been thanked: 0 time

Re: match data across four files and write matching data

Postby gokulNmf » Wed Jun 24, 2009 5:15 pm

Hi,
Is there any utility avaiable for doing this without creating any kind of intermediate datasets?
Cheers,
Gokul
User avatar
gokulNmf
 
Posts: 118
Joined: Sat Mar 28, 2009 6:41 pm
Location: India
Has thanked: 2 times
Been thanked: 0 time

Re: match data across four files and write matching data

Postby skolusu » Wed Jun 24, 2009 9:04 pm

gokulNmf wrote:Hi,
Is there any utility avaiable for doing this without creating any kind of intermediate datasets?

gokulNmf,

If all 4 files are of the same LRECL and you have a unique indicator in all of the four files that identifies at to which file the record belongs to , then DFSORT with WHEN=GROUP will get you the desired results without using any intermediate files.
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: match data across four files and write matching data

Postby gokulNmf » Thu Jun 25, 2009 8:42 am

Thanks skolusu :) !
Cheers,
Gokul
User avatar
gokulNmf
 
Posts: 118
Joined: Sat Mar 28, 2009 6:41 pm
Location: India
Has thanked: 2 times
Been thanked: 0 time

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post