understand how ICETOOL



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

understand how ICETOOL

Postby lestmen » Sat Mar 29, 2008 4:49 pm

Good Morning
i have 1 one with 600.000.000 of records and i have to write two files on bases to two different condition.
all is ok, i wrote using ICETOLL.
But i see the LOG and i Note that ICETOOL, use however the input file two times. i beleived that ICETOOL use the input-file one time to write two different output records.

my question is
1. is there a way to use the input-file one time to write two different output-file ?
2. if no way, which is the difference using two different step (eg. with PGM SORT) wiht ICETOLL

thank you in advance and sorry to English Mistake
Sergio
lestmen
 
Posts: 10
Joined: Sun Mar 23, 2008 8:38 pm
Has thanked: 0 time
Been thanked: 0 time

Re: understad how ICETOOL

Postby dick scherrer » Sat Mar 29, 2008 7:38 pm

Hello Sergio and welcome to the forums,

Some processes require multiple passes of the data and some can be accomplished in a single pass.

Please post your jcl and control statements. A bit of sample data of each format may help as well.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: understad how ICETOOL

Postby Frank Yaeger » Sat Mar 29, 2008 9:16 pm

Sergio,

You can use multiple OUTFIL statements with DFSORT or ICETOOL to write two files based on two different conditions. Here are examples with DFSORT and with ICETOOL. The exact job you would use depends on exactly what you want to do.

DFSORT job

//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=... input file
//OUT1 DD DSN=...  output file1
//OUT2 DD DSN=...  output file2
//SYSIN    DD *
  OPTION COPY
  OUTFIL FNAMES=OUT1,INCLUDE=(8,1,CH,EQ,C'3')
  OUTFIL FNAMES=OUT2,INCLUDE=(8,1,CH,EQ,C'4')
/*


DFSORT/ICETOOL job

//S2    EXEC  PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG  DD SYSOUT=*
//IN DD DSN=... input file
//OUT1 DD DSN=...  output file1
//OUT2 DD DSN=...  output file2
//TOOLIN DD *
COPY FROM(IN) USING(CTL1)
/*
//CTL1CNTL DD *
  OUTFIL FNAMES=OUT1,INCLUDE=(8,1,CH,EQ,C'3')
  OUTFIL FNAMES=OUT2,INCLUDE=(8,1,CH,EQ,C'4')
/*


If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

http://www.ibm.com/servers/storage/supp ... tmpub.html
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: understad how ICETOOL

Postby lestmen » Sat Mar 29, 2008 11:17 pm

this is the sleketon jcl that i use

//S2    EXEC  PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG  DD SYSOUT=*
//IN DD DSN=... input file
//OUT1 DD DSN=...  output file1
//OUT2 DD DSN=...  output file2
//TOOLIN DD *
COPY (IN) TO (OUT1)  USING(CTL1)
COPY (IN) TO (OUT2) USING(CTL2)
/*
//CTL1CNTL DD *
   OPTION COPY
   INCLUDE=(8,1,CH,EQ,C'3')
 //CTL2CNTL DD *
   OPTION COPY
   INCLUDE=(8,1,CH,EQ,C'3')
/*
lestmen
 
Posts: 10
Joined: Sun Mar 23, 2008 8:38 pm
Has thanked: 0 time
Been thanked: 0 time

Re: understad how ICETOOL

Postby dick scherrer » Sun Mar 30, 2008 12:57 am

Hello,

By comparing your process to what Frank posted, do you see why yours requires 2 passes of the data?

I suggest you change your syntax to be like Frank's (using OUTFIL instead of 2 separate copy commands).

You may have a typo in what you posted as you mention '3' in both copies.

After making that change, let us know if you get the result you want.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: understad how ICETOOL

Postby lestmen » Sun Mar 30, 2008 1:49 am

like performance is it better use the first or second JCL,
to performance i say (eg allocation memory, usage cpy and soon on)
lestmen
 
Posts: 10
Joined: Sun Mar 23, 2008 8:38 pm
Has thanked: 0 time
Been thanked: 0 time

Re: understad how ICETOOL

Postby dick scherrer » Sun Mar 30, 2008 2:30 am

Hello,

The jcl you created requires 2 complete passes of the input data to create the required output.

Either of the solutions Frank posted should require only one pass of the input data.

I suspect that the performance of Frank's solutions will be very similar and that both of them will require less resources than the jcl you have been using.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: understad how ICETOOL

Postby Frank Yaeger » Mon Mar 31, 2008 1:24 am

is there a way to use the input-file one time to write two different output-file ?


Sergio,

You asked this question and I gave you a way to what you asked for. I don't understand why you would then come back and post the two-pass method you used that doesn't do what you asked for.

I would think it would be obvious that using one pass over the data is better then using two passes over the data which is why you asked for a one pass solution in the first place.

The DFSORT job and ICETOOL job I posted do the same thing and perform the same.

By the way, when you use ICETOOL's COPY operator, you don't need OPTION COPY in CTLxCNTL.
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: understad how ICETOOL

Postby bakshi_man » Fri May 16, 2008 7:13 pm

hi There

i've tried the iceman example at my shop , it works really well!!!!

Thanks
bakshi_man
 
Posts: 1
Joined: Fri May 16, 2008 5:00 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post