File Comparison using ICETOOL



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

Re: File Comparison using ICETOOL

Postby BillyBoyo » Fri Aug 31, 2012 3:51 pm

The message, and workfile usage, tells you it was doing a SORT, as part of the SELECT. Consult the manual and turn it off.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Re: File Comparison using ICETOOL

 

Re: File Comparison using ICETOOL

Postby thermalchu » Fri Aug 31, 2012 4:23 pm

How to turn it off?

//DFSPARM DD *
OPTION DYNALLOC=(SYSDA,200),FILSZ=E7000000
DSNTYPE=LARGE,MAINSIZE=MAX
/*
//TOOLIN DD *
SELECT FROM(SORTIN) TO(OUTPUT) ON(1,3500,CH) NODUPS
/*

This is the error message I'm getting:
SORT CAPACITY EXCEEDED - RECORD COUNT 6653419
RECORDS SORTED - PROCESSED: 6653419, EXPECTED: 7596926
DFSORT FAILED TO DYNAMICALLY ALLOCATE THE REQUIRED WORK DATA SET SPACE
FWK=(153,966195) SWK=(2,10104) TWK=(45,161013) RWK=(6,40722) TOTAL=(206,1178034) BLK=55272
ATTEMPTED TO ALLOCATE 66564MB OF DISK WORK SPACE ON 200 WORK DATA SETS WERE USED
SUCCESSFULLY ALLOCATED 62095MB OF DISK WORK SPACE ON 206 WORK DATA SETS
200 WORK DATA SETS WERE INSUFFICIENT TO COMPLETE THIS SORT SO 6 ADDITIONAL WERE
DE-K61787 D5-K58148 C4-K58148 C4-K58148 E8-K70685
END OF DFSORT
thermalchu
 
Posts: 38
Joined: Thu Aug 30, 2012 3:47 pm
Has thanked: 0 time
Been thanked: 0 time

Re: File Comparison using ICETOOL

Postby BillyBoyo » Fri Aug 31, 2012 5:02 pm

Firstly, while developing your solution, use test data.

If you are going to use ICETOOL functions, read that chapter in the manual, look at the examples, wonder what it is that the CNTL files can do for you.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: File Comparison using ICETOOL

Postby skolusu » Fri Aug 31, 2012 8:43 pm

thermalchu,

I am not sure as to why you are wasting time on something that cannot be done. Write a COBOL program to compare. You cannot use select on the first 4000 bytes and eliminate the dups as the other 3000 bytes may be different. So your approach itself is wrong.
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: File Comparison using ICETOOL

Postby dick scherrer » Fri Aug 31, 2012 9:01 pm

Hello,

At the top of the COBOL part of the forum is working sample code that will "match" the file by the "key".

How you compare the matched records is up to you. How to process any unmatched is also your code. The sample code will handle the key compare (both files must ne in key sequence).
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: File Comparison using ICETOOL

Postby thermalchu » Sat Sep 01, 2012 8:55 am

There is no other way I can modify this JCL? Like 3 steps in one job: (1-3000,3000-6000,6000-7000 bytes)

I went to COBOL part of the forum. It says:
You do not have the required permissions to view the files attached to this post.
thermalchu
 
Posts: 38
Joined: Thu Aug 30, 2012 3:47 pm
Has thanked: 0 time
Been thanked: 0 time

Re: File Comparison using ICETOOL

Postby dick scherrer » Sat Sep 01, 2012 9:09 am

Hello,

There is no other way I can modify this JCL?
IIRC, you have been told NO several times. Suggest you let this go and use the programming solution. . .

This will sound tedious, but if you post each step you took to get to the "Sticky" and how you tried to download the attachment, we may see the problem. As far as i know there is no restricton on downloading attachments.

When downloading, do Not try to "open in new window" - this accesses the attachment, but it is basically unusable. When downloading the attachment right-click and save it to your hard drive. Then upload it to your mainframe.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: File Comparison using ICETOOL

Postby thermalchu » Fri Sep 07, 2012 2:24 pm

Thank you so much :)
thermalchu
 
Posts: 38
Joined: Thu Aug 30, 2012 3:47 pm
Has thanked: 0 time
Been thanked: 0 time

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post