COPY with INLCUDE - size of temp storage for large file?



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

COPY with INLCUDE - size of temp storage for large file?

Postby rmd3003 » Mon Nov 28, 2011 10:39 pm

Hi there. Let's say I have very large file (thousands of cylinders on DASD) and I need to eliminate some records. Two questions:
1. Which will give me better performance INCLUDE or OMIT? Or it doesn't matter?
2. Second question is if I use option COPY/INLCUDE without actual re-sorting do I have to allocate extra SORTWKxx datasets?
For example:

//STEP1     EXEC PGM=SYNCSORT
//SORTIN    DD DSN=TEST.FILE.IN,DISP=SHR       
//SORTOUT   DD DSN=TEST.FILE.OUT,                 
//             DISP=(NEW,CATLG,DELETE),                       
//             UNIT=SYSDA,SPACE=(CYL,(3000,1000),RLSE),           
//             DCB=(RECFM=FB,LRECL=1000,BLKSIZE=0,DSORG=PS)     
//SORTWK01  DD UNIT=WORK,SPACE=(CYL,(100,100),RLSE)             
//SORTWK02  DD UNIT=WORK,SPACE=(CYL,(100,100),RLSE)             
//SORTWK03  DD UNIT=WORK,SPACE=(CYL,(100,100),RLSE)             
//SORTWK04  DD UNIT=WORK,SPACE=(CYL,(100,100),RLSE)             
//SORTWK05  DD UNIT=WORK,SPACE=(CYL,(100,100),RLSE)
//SORTMSG   DD SYSOUT=*                                       
//SYSOUT    DD SYSOUT=*                                       
//SYSUDUMP  DD SYSOUT=*                                       
//SYSIN     DD *                 
    OPTION COPY                   
    OMIT COND=(1,4,ZD,GT,5555)   
/*                               


Thank you.
rmd3003
 
Posts: 6
Joined: Wed Nov 23, 2011 1:27 am
Has thanked: 0 time
Been thanked: 0 time

Re: COPY with INLCUDE - size of temp storage for large file?

 

Re: COPY with INLCUDE - size of temp storage for large file?

Postby BillyBoyo » Wed Nov 30, 2011 6:28 am

I can't imagine that OMIT and INCLUDE would perform differently. Use the one which is easiest to understand for your requriments.

With OPTION COPY you need zero work datasets, it will just read the input, look at the include/omit, write to output if necessary, repeat until end-of-file. No work dataset activity.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post