Need jcl to take unmatched records count to store in dataset



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

Re: Need jcl to take unmatched records count to store in dat

Postby BillyBoyo » Thu Apr 05, 2012 3:56 pm

  SORT FIELDS=(1,10,CH,A)
  OUTREC OVERLAY=(51:SEQNUM,8,ZD,RESTART=(1,10))


I'm not going to do JCL for you, but here's the sort deck. Run for each of your files to new, extended by 8 byte, files. Put those new files into the JOINKEYS processing.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Need jcl to take unmatched records count to store in dat

Postby deva_048 » Fri Apr 06, 2012 8:11 am

Am not getting the output still. Please reply. In above badrinath posted code getting rc=0 and not displaying output in spool
deva_048
 
Posts: 72
Joined: Thu Feb 02, 2012 9:28 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Need jcl to take unmatched records count to store in dat

Postby BillyBoyo » Fri Apr 06, 2012 12:16 pm

You have to show us what you have done, JCL, sort cards and output messages.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Need jcl to take unmatched records count to store in dat

Postby deva_048 » Fri Apr 06, 2012 2:24 pm

I dint change anything Watever badrinath posted the jcl same jcl i tried to submit getting rc = 0 not getting output in spool. In that code wat else need to do anything need to change or i have to test in icetool.
deva_048
 
Posts: 72
Joined: Thu Feb 02, 2012 9:28 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Need jcl to take unmatched records count to store in dat

Postby BillyBoyo » Fri Apr 06, 2012 2:57 pm

-3nadh's code, as he said, is for a later release of Syncsort.

To get it to work, follow what I have suggested to pre-process your files and then put them into that step. What it is doing, to both files, is adding the sequence number which would otherwise have been in the "cntl" files in the JOINKEYS, because your version of Syncsort doesn't support cntl files in JOINKEYS.

Again this topic is extending, have you wondered why?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Need jcl to take unmatched records count to store in dat

Postby deva_048 » Fri Apr 06, 2012 4:50 pm

ok thanks got it.
deva_048
 
Posts: 72
Joined: Thu Feb 02, 2012 9:28 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Need jcl to take unmatched records count to store in dat

Postby Alissa Margulies » Fri Apr 06, 2012 7:59 pm

JNF1CNTL and JNF2CNTL are supported in Syncsort MFX for z/OS 1.4. In order for them to be honored in SyncSort for z/OS 1.3.2, an additional support fix is required. Please contact Syncsort Mainframe Product Services for the maintenance.

Regards,
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times

Re: Need jcl to take unmatched records count to store in dat

Postby deva_048 » Mon Apr 09, 2012 10:13 am

Am getting the output in spool but not in dataset getting incompatible lrecl

 WER276B  SYSDIAG= 2632446, 3990715, 3990715, 1455675                   
 WER164B  12,892K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,   
 WER164B     32K BYTES RESERVE REQUESTED, 968K BYTES USED               
 WER146B  20K BYTES OF EMERGENCY SPACE ALLOCATED                       
 WER481I  JOINKEYS REFORMAT RECORD LENGTH=  300, TYPE = F               
 WER110I  SORTOUT  : RECFM=FB   ; LRECL=   300; BLKSIZE= 30000         
 WER247A  SORTOUT  HAS INCOMPATIBLE LRECL                               
 WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000                         


Below are the control cards used:
SYSIN :                                             
  JOINKEYS FILE=F1,FIELDS=(1,230,A,240,8,A),SORTED 
  JOINKEYS FILE=F2,FIELDS=(1,230,A,240,8,A),SORTED 
  JOIN UNPAIRED,F1,ONLY                             
  SORT FIELDS=COPY                                 
  OUTFIL BUILD=(1,230,50X)                         
deva_048
 
Posts: 72
Joined: Thu Feb 02, 2012 9:28 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Need jcl to take unmatched records count to store in dat

Postby deva_048 » Mon Apr 09, 2012 10:28 am

Found it thanks for your support without your help i can't do this task within specified time. Thanks a lot:)
deva_048
 
Posts: 72
Joined: Thu Feb 02, 2012 9:28 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Need jcl to take unmatched records count to store in dat

Postby BillyBoyo » Mon Apr 09, 2012 5:13 pm

Just a last thing. Unless the output is going to tape, then 30000 is a very bad blocksize to use. For a 3390, you will be leaving 20,000+ bytes per track empty. Or, to put it another way, you data is going to require a much greater space allocation than is necessary, because more than 40% of the space allocated is unusable to you.

Your storage management people would, hopefully, pick this up at some point. However, why not put a better blocksize before they come after you without something heavy?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Previous

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post