SQL Object Consistency Analyzer and Upgrade Rebind Utilities › SQL Object Consistency Analyzer › Running the SQL Object Consistency Analyzer › Sample JCL

Sample JCL

Following are JCL examples showing the limiting of analysis to a specific entity-type (and a certain AUTHID) and showing the analysis of all constraints, views, and plans. For more information about the target libraries, see Listing Libraries for CA Datacom Products.

Note: These JCL examples contain lowercase letters indicating entries you must replace with code that meets your installation and site standards.

 //jobname  JOB (acctinfo),'submitter name',CLASS=A,MSGCLASS=X,REGION=2048K
 //SQLEXEC1 EXEC PGM=DBSOCPR,COND=(0,NE),REGION=1024K,
 //       PARM='PLAN=authid.*'
 //STEPLIB  DD DSN=cai.db90.svclib,DISP=SHR        CA Datacom SVC library
 //         DD DSN=cai.db90.loadlib,DISP=SHR       CA Datacom load library
 //         DD DSN=cai.db100.cuslib,DISP=SHR       CA Datacom custom library
 //         DD DSN=cai.db100.CAILIB,DISP=SHR       CA Datacom target library
 //         DD DSN=cai.ca90s.wu40.CAILIB,DISP=SHR  VPE target library
 //SYSUDUMP DD   SYSOUT=*
 //SYSPRINT DD  SYSOUT=*
 /*
 //jobname  JOB (acctinfo),'submitter name',CLASS=A,MSGCLASS=X,REGION=2048K
 //SQLEXEC1 EXEC PGM=DBSOCPR,COND=(0,NE),REGION=1024K,
          PARM='*.*'
 //STEPLIB  DD DSN=cai.db90.svclib,DISP=SHR        CA Datacom SVC library
 //         DD DSN=cai.db90.loadlib,DISP=SHR       CA Datacom load library
 //         DD DSN=cai.db100.cuslib,DISP=SHR       CA Datacom custom library
 //         DD DSN=cai.db100.CAILIB,DISP=SHR       CA Datacom target library
 //         DD DSN=cai.ca90s.wu40.CAILIB,DISP=SHR  VPE target library
 //SYSUDUMP DD   SYSOUT=*
 //SYSPRINT DD  SYSOUT=*
 /*

Ensure that your new version's library is concatenated behind your previous version's library.

 * $$ JOB JNM=SQLENT,CLASS=n,USER='CAINS'
 * $$ LST CLASS=a,DEST=(*,vmuidnn)
 // JOB SQLENT   ANALYSIS BY ENTITY-TYPE
 // ASSGN SYS025,DISK,VOL=volser,SHR
 // DLBL db90,'db90.customer.library'
 // EXTENT SYS025,volser
 // DLBL db100,'db100.customer.library'
 // EXTENT SYS025,volser
 // DLBL vpe,'cai.ca90s.wu40.library
 // EXTENT SYS025,volser
 // LIBDEF *,SEARCH=(db90.db90,db100.db100,vpe.vpe,ca90s.ca90s)
 /*
 /&
 * $$ EOJ
 * $$ JOB JNM=SQLALL,CLASS=n,USER='CAINS'
 * $$ LST CLASS=a,DEST=(*,vmuidnn)
 // JOB SQLALL   ANALYSIS OF ALL CONSTRAINTS, VIEWS, AND PLANS
 // ASSGN SYS025,DISK,VOL=volser,SHR
 // DLBL db90,'db90.customer.library'
 // EXTENT SYS025,volser
 // DLBL db100,'db100.customer.library'
 // EXTENT SYS025,volser
 // DLBL vpe,'cai.ca90s.wu40.library'
 // EXTENT SYS025,volser
 // LIBDEF *,SEARCH=(db90.db90,db100.db100,vpe.vpe,ca90s.ca90s)
 // EXEC DBSOCPR,SIZE=1024K,PARM='*.*'
 /*
 /&
 * $$ EOJ