SYNCTOOL to resolve DB2 Query



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

SYNCTOOL to resolve DB2 Query

Postby aquiroga » Wed Jan 04, 2017 8:02 pm

Hello
I'm using SYNCTOOL to run a SELECT from a DB2 table and to register duplicated records in a file, with no success. What am I missing if SORTDBIN is included in JCL ?
SYNCTOOL calls SYNCSORT in our installation.

Here is the jcl:
//PASO20 EXEC PGM=SYNCTOOL,REGION=0M                              
//$ORTPARM DD *                                                
DB2=DB2M                                                          
//SORTDBIN DD DISP=SHR,DSN=hlq.CNTL(SORTDBIN)                <---- Here is the select
//SORTDBOU DD DSN=hlq.SYSREC00,DISP=(,CATLG,KEEP),  
//            SPACE=(CYL,(5,5),RLSE),UNIT=3390,                  
//            DCB=(LRECL=571,RECFM=FB,DSORG=PS,BLKSIZE=27979)  
//DD1      DD DSN=hlq.DD1,DISP=(,CATLG,KEEP),    
//            SPACE=(CYL,(5,5),RLSE),UNIT=3390,DCB=*.SORTDBOU  
//DD2      DD DSN=hlq.DUP,DISP=(,CATLG,KEEP),    
....                                                                          ---> other system outputs DD's like sysout
//TOOLMSG  DD SYSOUT=*                                      
//DFSMSG   DD SYSOUT=*                                      
//TOOLIN   DD *                                              
   COPY FROM(SORTDBOU) TO(DD1) USING(CTL1)                  
   SELECT FROM(SORTDBOU) TO(DD2) ALLDUPS ON(20,19,CH)        
//CTL1CNTL DD *                    
   SORT FIELDS=(571,1,CH,A),EQUALS  
   OUTREC BUILD=(1,571)


SYNCTOOL OUTUPUT MESSAGE:
SYNCSORT LICENSED FOR CPU SERIAL NUMBER xxxxx, MODEL 2964 507             LICEN
$ORTPARM : DB2=DB2M                                                            
   SORT FIELDS=(571,1,CH,A),EQUALS                                            
   OUTREC BUILD=(1,571)                                                        
PARMLIST :                                                                    
OPTION RESINV=0,ARESINV=0,MSGDDN=DFSMSG,SORTIN=SORTDBOU,SORTOUT=DD1,SORTDD=CTL1
SORT FIELDS=COPY                                                              
WER813I  INSTALLATION OPTIONS IN MFXPRMD1 WILL BE USED                        
WER428I  CALLER-PROVIDED IDENTIFIER IS "0001"                                  
WER161B  ALTERNATE PARM USED                                                  
WER276B  SYSDIAG= 1268629, 1697870, 1697870, 1389460                          
WER426G  AVAILABLE STORAGE RESOURCES:  666,860K EXCESS CENTRAL, 666,860K EXPANDED
WER164B  13,840K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,            
WER164B     0 BYTES RESERVE REQUESTED, 2,024K BYTES USED                      
WER146B  20K BYTES OF EMERGENCY SPACE ALLOCATED                                
WER468A  DB2 QUERY SUPPORT ERROR: SORTDBIN CANNOT BE FOUND                
WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000                                  
WER449I  SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE


Thanks in advance,
Amelia Quiroga

Edited to include code tags. Also removed 'bolding' (it makes no difference on my machine)
aquiroga
 
Posts: 2
Joined: Wed Jan 04, 2017 6:47 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SYNCTOOL to resolve DB2 Query

Postby enrico-sorichetti » Wed Jan 04, 2017 8:46 pm

Help people who spend their time helping You

use the CODE tags to make jcl/code/data snippets more readable


//PASO20 EXEC PGM=SYNCTOOL,REGION=0M
//$ORTPARM DD *
DB2=DB2M
//SORTDBIN DD DISP=SHR,DSN=hlq.CNTL(SORTDBIN) <---- Here is the select
//SORTDBOU DD DSN=hlq.SYSREC00,DISP=(,CATLG,KEEP),
// SPACE=(CYL,(5,5),RLSE),UNIT=3390,
// DCB=(LRECL=571,RECFM=FB,DSORG=PS,BLKSIZE=27979)
//DD1 DD DSN=hlq.DD1,DISP=(,CATLG,KEEP),
// SPACE=(CYL,(5,5),RLSE),UNIT=3390,DCB=*.SORTDBOU
//DD2 DD DSN=hlq.DUP,DISP=(,CATLG,KEEP),
.... ---> other system outputs DD's like sysout
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//TOOLIN DD *
COPY FROM(SORTDBOU) TO(DD1) USING(CTL1)
SELECT FROM(SORTDBOU) TO(DD2) ALLDUPS ON(20,19,CH)
//CTL1CNTL DD *
SORT FIELDS=(571,1,CH,A),EQUALS
OUTREC BUILD=(1,571)

SYNCTOOL OUTUPUT MESSAGE:
SYNCSORT LICENSED FOR CPU SERIAL NUMBER xxxxx, MODEL 2964 507 LICEN
$ORTPARM : DB2=DB2M
SORT FIELDS=(571,1,CH,A),EQUALS
OUTREC BUILD=(1,571)
PARMLIST :
OPTION RESINV=0,ARESINV=0,MSGDDN=DFSMSG,SORTIN=SORTDBOU,SORTOUT=DD1,SORTDD=CTL1
SORT FIELDS=COPY
WER813I INSTALLATION OPTIONS IN MFXPRMD1 WILL BE USED
WER428I CALLER-PROVIDED IDENTIFIER IS "0001"
WER161B ALTERNATE PARM USED
WER276B SYSDIAG= 1268629, 1697870, 1697870, 1389460
WER426G AVAILABLE STORAGE RESOURCES: 666,860K EXCESS CENTRAL, 666,860K EXPANDED
WER164B 13,840K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 0 BYTES RESERVE REQUESTED, 2,024K BYTES USED
WER146B 20K BYTES OF EMERGENCY SPACE ALLOCATED
WER468A DB2 QUERY SUPPORT ERROR: SORTDBIN CANNOT BE FOUND
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: SYNCTOOL to resolve DB2 Query

Postby Robert Sample » Wed Jan 04, 2017 8:51 pm

Syncsort is telling you SORTDBIN is not found. Have you looked at the job output to see what the system says about the //SORTDBIN DD statement you coded? Looking at JESYSMSG should tell you a lot about why Syncsort does not think there's a SORTDBIN DD statement.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: SYNCTOOL to resolve DB2 Query

Postby aquiroga » Thu Jan 05, 2017 3:39 am

Hi
I made it work by deleting the USING clause from COPY statement.
Thanks for the effort.
Amelia.
aquiroga
 
Posts: 2
Joined: Wed Jan 04, 2017 6:47 pm
Has thanked: 0 time
Been thanked: 0 time


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post