Enyinnaya
asked on
Why am I getting this DB2 error? "DSNU034I DSNUBCKB - DATA SET TYPE INVALID FOR DDNAME SYSTEMPL"
Hello all,
I am running a job to copy DB2 tablespaces on the mainframe and it is failing on the template dataset definition for the COPY request. Can someone help descibe what I am missing and how to fix this. The error and JCL is shown below:
Error:
DSNU050I DSNUGUTC - COPY LIST OG1LIST COPYDDN(SYSTEMPL) PARALLEL(4) SHRLEVEL REFERENCE
DSNU427I DSNUBBID - OBJECTS WILL BE PROCESSED IN PARALLEL,
NUMBER OF OBJECTS = 4
DSNU034I DSNUBCKB - DATA SET TYPE INVALID FOR DDNAME SYSTEMPL
DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
JCL:
//OG1TESTF JOB 05274,'ONGARD,BN-53',NOTIF Y=&SYSUID, JOB02435
// CLASS=H,MSGCLASS=X,REGION= 0M
//*
//SETVAR SET SSNODE=DBO1,DBOI=P1,DBOO=D 2,TRK=OG1, LOADIR=TES T,
// NODELIB=OGADM3,PDBNAME='OG 1DD%1',PNA ME='OG1SC% '
// SET VAL1='WHERE DBNAME LIKE ',
// VAL2='OG1DDEV1',
// LISTDEF='D1OG1LD'
//*
//JOBLIB DD DISP=SHR,DSN=SYS2.DB2.&LOA DIR..SDSNE XIT
// DD DISP=SHR,DSN=SYS2.DB2.&LOA DIR..SDSNL OAD
// DD DISP=SHR,DSN=SYS2.DB2.&LOA DIR..RUNLI B.LOAD
//MYLIBS1 JCLLIB ORDER=OG1.&NODELIB..PROCLI B
//*
//************************ ********** ********** ********
//* DELETE PREVIOUS WORK FILES FOR DATABASE & TRACK *
//************************ ********** ********** ********
//*
//UTL100U EXEC PGM=IEFBR14 00058100
//DD01 DD DSN=OG1.F&SSNODE..&TRK..RU NDYNAM, 00058200
// DISP=(MOD,DELETE,DELETE), 00058300
// UNIT=SYSDA,SPACE=(TRK,(1,1 ),RLSE),
// DCB=(RECFM=FB,LRECL=80,BLK SIZE=0)
//* DD DSN=OG1.F&SSNODE..&TRK..OS CR.OG1LIST .TSPACEO, 00058400
//* DISP=(MOD,DELETE,DELETE), 00058500
//* UNIT=SYSDA,SPACE=(TRK,(1,1 ),RLSE),
//* DCB=(RECFM=FB,LRECL=80,BLK SIZE=2400)
//* DD DSN=OG1.F&SSNODE..&TRK..TB SPACE.DATA , 00058400
//* DISP=(MOD,DELETE,DELETE), 00058500
//* UNIT=SYSDA,SPACE=(TRK,(1,1 ),RLSE),
//* DCB=(RECFM=FB,LRECL=80,BLK SIZE=2400)
//* DD DSN=OG1.F&SSNODE..&TRK..TR ACK.DATA1, 00058400
//* DISP=(MOD,DELETE,DELETE), 00058500
//* UNIT=SYSDA,SPACE=(TRK,(1,1 ),RLSE),
//* DCB=(RECFM=FB,LRECL=80,BLK SIZE=2400)
//*
//************************ ********** ********** ********** *****
//* QUIESCE LISTDEF, COPY TABLESPACE LISTDEF TABLESPACES *
//* NOTE: (1) ONGARD MAY DECIDE TO ADD RECOVERYDDN HERE *
//* THIS WILL NECESSARILY REDUCE THE NEED TO *
//* MAINTAIN OFFSITE RECOVERY DB2 RECOVERY JOBS. *
//************************ ********** ********** ********** *****
//UTL1025U EXEC DBO1PROC,UID='OG1DDEV1.QUI ESC1',
// UTPROC='',SYSTEM='DBO1',CO ND=(4,LT)
//LISTDD DD DISP=SHR,DSN=OG1.&NODELIB. .PARMLIB(& LISTDEF)
//SYSTEMPL DD * 00330000
TEMPLATE TEMPLDD 00340000
DSN OG3.F&SSNNODE..&DB..&TS..P &PART..D&D ATE, 00350000
DISP=(MOD,CATLG,CATLG),UNI T=SYSDA, 00380000
SPACE=(TRK,(1,1),RLSE),AVG REC=M, 00390000
DATACLAS=LINEAR,DCB=(ADP1. GDGMODEL) 00400000
//SYSIN DD *
// DD DISP=SHR,DSN=OG1.&NODELIB. .PARMLIB(O G1COPY)
PARMLIB Control statement:
OPTIONS LISTDEFDD(LISTDD) TEMPLATEDD(SYSTEMPL)
QUIESCE LIST OG1LIST
COPY LIST OG1LIST COPYDDN(SYSTEMPL) PARALLEL(4) SHRLEVEL REFERENCE
Any help to show what I am missing and how to fix it will be highly appreciated.
Thanks
I am running a job to copy DB2 tablespaces on the mainframe and it is failing on the template dataset definition for the COPY request. Can someone help descibe what I am missing and how to fix this. The error and JCL is shown below:
Error:
DSNU050I DSNUGUTC - COPY LIST OG1LIST COPYDDN(SYSTEMPL) PARALLEL(4) SHRLEVEL REFERENCE
DSNU427I DSNUBBID - OBJECTS WILL BE PROCESSED IN PARALLEL,
NUMBER OF OBJECTS = 4
DSNU034I DSNUBCKB - DATA SET TYPE INVALID FOR DDNAME SYSTEMPL
DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
JCL:
//OG1TESTF JOB 05274,'ONGARD,BN-53',NOTIF
// CLASS=H,MSGCLASS=X,REGION=
//*
//SETVAR SET SSNODE=DBO1,DBOI=P1,DBOO=D
// NODELIB=OGADM3,PDBNAME='OG
// SET VAL1='WHERE DBNAME LIKE ',
// VAL2='OG1DDEV1',
// LISTDEF='D1OG1LD'
//*
//JOBLIB DD DISP=SHR,DSN=SYS2.DB2.&LOA
// DD DISP=SHR,DSN=SYS2.DB2.&LOA
// DD DISP=SHR,DSN=SYS2.DB2.&LOA
//MYLIBS1 JCLLIB ORDER=OG1.&NODELIB..PROCLI
//*
//************************
//* DELETE PREVIOUS WORK FILES FOR DATABASE & TRACK *
//************************
//*
//UTL100U EXEC PGM=IEFBR14 00058100
//DD01 DD DSN=OG1.F&SSNODE..&TRK..RU
// DISP=(MOD,DELETE,DELETE), 00058300
// UNIT=SYSDA,SPACE=(TRK,(1,1
// DCB=(RECFM=FB,LRECL=80,BLK
//* DD DSN=OG1.F&SSNODE..&TRK..OS
//* DISP=(MOD,DELETE,DELETE), 00058500
//* UNIT=SYSDA,SPACE=(TRK,(1,1
//* DCB=(RECFM=FB,LRECL=80,BLK
//* DD DSN=OG1.F&SSNODE..&TRK..TB
//* DISP=(MOD,DELETE,DELETE), 00058500
//* UNIT=SYSDA,SPACE=(TRK,(1,1
//* DCB=(RECFM=FB,LRECL=80,BLK
//* DD DSN=OG1.F&SSNODE..&TRK..TR
//* DISP=(MOD,DELETE,DELETE), 00058500
//* UNIT=SYSDA,SPACE=(TRK,(1,1
//* DCB=(RECFM=FB,LRECL=80,BLK
//*
//************************
//* QUIESCE LISTDEF, COPY TABLESPACE LISTDEF TABLESPACES *
//* NOTE: (1) ONGARD MAY DECIDE TO ADD RECOVERYDDN HERE *
//* THIS WILL NECESSARILY REDUCE THE NEED TO *
//* MAINTAIN OFFSITE RECOVERY DB2 RECOVERY JOBS. *
//************************
//UTL1025U EXEC DBO1PROC,UID='OG1DDEV1.QUI
// UTPROC='',SYSTEM='DBO1',CO
//LISTDD DD DISP=SHR,DSN=OG1.&NODELIB.
//SYSTEMPL DD * 00330000
TEMPLATE TEMPLDD 00340000
DSN OG3.F&SSNNODE..&DB..&TS..P
DISP=(MOD,CATLG,CATLG),UNI
SPACE=(TRK,(1,1),RLSE),AVG
DATACLAS=LINEAR,DCB=(ADP1.
//SYSIN DD *
// DD DISP=SHR,DSN=OG1.&NODELIB.
PARMLIB Control statement:
OPTIONS LISTDEFDD(LISTDD) TEMPLATEDD(SYSTEMPL)
QUIESCE LIST OG1LIST
COPY LIST OG1LIST COPYDDN(SYSTEMPL) PARALLEL(4) SHRLEVEL REFERENCE
Any help to show what I am missing and how to fix it will be highly appreciated.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Unless something has change, DISP is ignored for "DD *".
ASKER
Hello momi_sabag and giltjr,
Thank you guys for your continued interest on this thread. I made some changes keeping in mind the suggestions that I got from your posts. While there is definite progress, I am having some errors whith the TEMPLATE dataset name. Please see the cleanup JCL and the error that I am having now...with the template variables:
"D&DATE or &DT and "T&TIME or &TI".
Do you guys see anything I am missing with regards to the dataset name?
ERROR MSG:
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = OG1DDEV1.QUIESC1
DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I DSNUGUTC - OPTIONS LISTDEFDD(LISTDD) TEMPLATEDD(SYSTEMPL)
DSNU1035I DSNUILDR - OPTIONS STATEMENT PROCESSED SUCCESSFULLY
DSNU050I DSNUGUTC - COPY LIST OG1LIST COPYDDN(TEMPLDD) PARALLEL(4) SHRLEVEL REFERENCE
DSNU1044I DSNUGTIS - PROCESSING LISTDD AS EBCDIC
DSNU427I DSNUBBID - OBJECTS WILL BE PROCESSED IN PARALLEL,
NUMBER OF OBJECTS = 4
DSNU1044I DSNUGTIS - PROCESSING SYSTEMPL AS EBCDIC
DSNU1032I DSNUGTDS - INVALID QUALIFIER T&HOUR IN TEMPLATE TEMPLDD
DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
JCL:
//OG1TESTF JOB 05274,'ONGARD,BN-53',NOTIF Y=&SYSUID,
// CLASS=H,MSGCLASS=X,REGION= 0M
//*
//SETVAR SET SSNODE=DBO1,DBOI=P1,DBOO=D 2,TRK=OG1, LOADIR=TES T,
// NODELIB=OGADM3,PDBNAME='OG 1DDEV1',PN AME='OG1SC %'
// SET VAL1='WHERE DBNAME LIKE ',
// VAL2='OG1DDEV1',
// LISTDEF='D1OG1LD',
// OGCOPY='OG1COPY'
//*
//JOBLIB DD DISP=SHR,DSN=SYS2.DB2.&LOA DIR..SDSNE XIT
// DD DISP=SHR,DSN=SYS2.DB2.&LOA DIR..SDSNL OAD
// DD DISP=SHR,DSN=SYS2.DB2.&LOA DIR..RUNLI B.LOAD
//MYLIBS1 JCLLIB ORDER=OG1.&NODELIB..PROCLI B
//*
//************************ ********** ********** ********
//* DELETE PREVIOUS WORK FILES FOR DATABASE & TRACK *
//************************ ********** ********** ********
//*
//UTL100U EXEC PGM=IEFBR14
//DD01 DD DSN=OG1.F&SSNODE..&TRK..RU NDYNAM,
// DISP=(MOD,DELETE,DELETE),
// UNIT=SYSDA,SPACE=(TRK,(1,1 ),RLSE),
// DCB=(RECFM=FB,LRECL=80,BLK SIZE=0)
//************************ ********** ********** ********** *****
//* QUIESCE LISTDEF, COPY TABLESPACE LISTDEF TABLESPACES *
//* NOTE: (1) ONGARD MAY DECIDE TO ADD RECOVERYDDN HERE *
//* THIS WILL NECESSARILY REDUCE THE NEED TO *
//* MAINTAIN OFFSITE RECOVERY DB2 RECOVERY JOBS. *
//************************ ********** ********** ********** *****
//UTL1025U EXEC DBO1PROC,UID='OG1DDEV1.QUI ESC1',
// UTPROC='',SYSTEM='DBO1',CO ND=(4,LT)
//LISTDD DD DISP=SHR,DSN=OG1.&NODELIB. .PARMLIB(& LISTDEF)
LISTDEF OG1LIST INCLUDE TABLESPACE OG1DDEV1.*
//SYSTEMPL DD *
TEMPLATE TEMPLDD
DSN('OG3.F&SSID..OSCD.&DB. .&TS..D&DT ..T&TI')
DISP(NEW,CATLG,DELETE)
GDGLIMIT(3)
UNIT SYSDA
//SYSIN DD *
// DD DISP=SHR,DSN=OG1.&NODELIB. .PARMLIB(& OGCOPY)
OPTIONS LISTDEFDD(LISTDD) TEMPLATEDD(SYSTEMPL)
COPY LIST OG1LIST COPYDDN(TEMPLDD) PARALLEL(4) SHRLEVEL REFERENCE
Thanks
Thank you guys for your continued interest on this thread. I made some changes keeping in mind the suggestions that I got from your posts. While there is definite progress, I am having some errors whith the TEMPLATE dataset name. Please see the cleanup JCL and the error that I am having now...with the template variables:
"D&DATE or &DT and "T&TIME or &TI".
Do you guys see anything I am missing with regards to the dataset name?
ERROR MSG:
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = OG1DDEV1.QUIESC1
DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I DSNUGUTC - OPTIONS LISTDEFDD(LISTDD) TEMPLATEDD(SYSTEMPL)
DSNU1035I DSNUILDR - OPTIONS STATEMENT PROCESSED SUCCESSFULLY
DSNU050I DSNUGUTC - COPY LIST OG1LIST COPYDDN(TEMPLDD) PARALLEL(4) SHRLEVEL REFERENCE
DSNU1044I DSNUGTIS - PROCESSING LISTDD AS EBCDIC
DSNU427I DSNUBBID - OBJECTS WILL BE PROCESSED IN PARALLEL,
NUMBER OF OBJECTS = 4
DSNU1044I DSNUGTIS - PROCESSING SYSTEMPL AS EBCDIC
DSNU1032I DSNUGTDS - INVALID QUALIFIER T&HOUR IN TEMPLATE TEMPLDD
DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
JCL:
//OG1TESTF JOB 05274,'ONGARD,BN-53',NOTIF
// CLASS=H,MSGCLASS=X,REGION=
//*
//SETVAR SET SSNODE=DBO1,DBOI=P1,DBOO=D
// NODELIB=OGADM3,PDBNAME='OG
// SET VAL1='WHERE DBNAME LIKE ',
// VAL2='OG1DDEV1',
// LISTDEF='D1OG1LD',
// OGCOPY='OG1COPY'
//*
//JOBLIB DD DISP=SHR,DSN=SYS2.DB2.&LOA
// DD DISP=SHR,DSN=SYS2.DB2.&LOA
// DD DISP=SHR,DSN=SYS2.DB2.&LOA
//MYLIBS1 JCLLIB ORDER=OG1.&NODELIB..PROCLI
//*
//************************
//* DELETE PREVIOUS WORK FILES FOR DATABASE & TRACK *
//************************
//*
//UTL100U EXEC PGM=IEFBR14
//DD01 DD DSN=OG1.F&SSNODE..&TRK..RU
// DISP=(MOD,DELETE,DELETE),
// UNIT=SYSDA,SPACE=(TRK,(1,1
// DCB=(RECFM=FB,LRECL=80,BLK
//************************
//* QUIESCE LISTDEF, COPY TABLESPACE LISTDEF TABLESPACES *
//* NOTE: (1) ONGARD MAY DECIDE TO ADD RECOVERYDDN HERE *
//* THIS WILL NECESSARILY REDUCE THE NEED TO *
//* MAINTAIN OFFSITE RECOVERY DB2 RECOVERY JOBS. *
//************************
//UTL1025U EXEC DBO1PROC,UID='OG1DDEV1.QUI
// UTPROC='',SYSTEM='DBO1',CO
//LISTDD DD DISP=SHR,DSN=OG1.&NODELIB.
LISTDEF OG1LIST INCLUDE TABLESPACE OG1DDEV1.*
//SYSTEMPL DD *
TEMPLATE TEMPLDD
DSN('OG3.F&SSID..OSCD.&DB.
DISP(NEW,CATLG,DELETE)
GDGLIMIT(3)
UNIT SYSDA
//SYSIN DD *
// DD DISP=SHR,DSN=OG1.&NODELIB.
OPTIONS LISTDEFDD(LISTDD) TEMPLATEDD(SYSTEMPL)
COPY LIST OG1LIST COPYDDN(TEMPLDD) PARALLEL(4) SHRLEVEL REFERENCE
Thanks
Do you have some other input to this? The error you are getting is:
DSNU1032I DSNUGTDS - INVALID QUALIFIER T&HOUR IN TEMPLATE TEMPLDD
Because &HOUR is not a valid variable. However I don't see where you have specified T&HOUR anyplace.
DSNU1032I DSNUGTDS - INVALID QUALIFIER T&HOUR IN TEMPLATE TEMPLDD
Because &HOUR is not a valid variable. However I don't see where you have specified T&HOUR anyplace.
Oh wait, just found &HOUR is supposed to be valid, but I still don't see where you have it specified.
I did noticed that you have specified GDGLIMIT(3), but you don't have a GDG name specified for the template.
You would need to add (+1) to the end of the name and then make sure that with all of the other variables and the GooVoo number that the file name does not exceed 44 characters.
I did noticed that you have specified GDGLIMIT(3), but you don't have a GDG name specified for the template.
You would need to add (+1) to the end of the name and then make sure that with all of the other variables and the GooVoo number that the file name does not exceed 44 characters.
ASKER
giltjr,
I am not really using &HOUR, I am using TIME or &TT as shown above. I have been able to solve my problem and yes, I will add the (+1).
For all your help, I thank you very much.
I am not really using &HOUR, I am using TIME or &TT as shown above. I have been able to solve my problem and yes, I will add the (+1).
For all your help, I thank you very much.
ASKER
Thanks