Why this DB2 error? DSNU034I DSNUBCKB - DATASET TYPE INVALID

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
okonita1
Member
Posts: 12
Joined: Thu Jan 03, 2013 12:18 pm

Why this DB2 error? DSNU034I DSNUBCKB - DATASET TYPE INVALID

Post by okonita1 » Mon Jan 07, 2013 12:16 pm

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',NOTIFY=&SYSUID, JOB02435
// CLASS=H,MSGCLASS=X,REGION=0M
//*
//SETVAR SET SSNODE=DBO1,DBOI=P1,DBOO=D2,TRK=OG1,LOADIR=TEST,
// NODELIB=OGADM3,PDBNAME='OG1DD%1',PNAME='OG1SC%'
// SET VAL1='WHERE DBNAME LIKE ',
// VAL2='OG1DDEV1',
// LISTDEF='D1OG1LD'
//*
//JOBLIB DD DISP=SHR,DSN=SYS2.DB2.&LOADIR..SDSNEXIT
// DD DISP=SHR,DSN=SYS2.DB2.&LOADIR..SDSNLOAD
// DD DISP=SHR,DSN=SYS2.DB2.&LOADIR..RUNLIB.LOAD
//MYLIBS1 JCLLIB ORDER=OG1.&NODELIB..PROCLIB
//*
//****************************************************
//* DELETE PREVIOUS WORK FILES FOR DATABASE & TRACK *
//****************************************************
//*
//UTL100U EXEC PGM=IEFBR14 00058100
//DD01 DD DSN=OG1.F&SSNODE..&TRK..RUNDYNAM, 00058200
// DISP=(MOD,DELETE,DELETE), 00058300
// UNIT=SYSDA,SPACE=(TRK,(1,1),RLSE),
// DCB=(RECFM=FB,LRECL=80,BLKSIZE=0)
//* DD DSN=OG1.F&SSNODE..&TRK..OSCR.OG1LIST.TSPACEO, 00058400
//* DISP=(MOD,DELETE,DELETE), 00058500
//* UNIT=SYSDA,SPACE=(TRK,(1,1),RLSE),
//* DCB=(RECFM=FB,LRECL=80,BLKSIZE=2400)
//* DD DSN=OG1.F&SSNODE..&TRK..TBSPACE.DATA, 00058400
//* DISP=(MOD,DELETE,DELETE), 00058500
//* UNIT=SYSDA,SPACE=(TRK,(1,1),RLSE),
//* DCB=(RECFM=FB,LRECL=80,BLKSIZE=2400)
//* DD DSN=OG1.F&SSNODE..&TRK..TRACK.DATA1, 00058400
//* DISP=(MOD,DELETE,DELETE), 00058500
//* UNIT=SYSDA,SPACE=(TRK,(1,1),RLSE),
//* DCB=(RECFM=FB,LRECL=80,BLKSIZE=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.QUIESC1',
// UTPROC='',SYSTEM='DBO1',COND=(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&DATE, 00350000
DISP=(MOD,CATLG,CATLG),UNIT=SYSDA, 00380000
SPACE=(TRK,(1,1),RLSE),AVGREC=M, 00390000
DATACLAS=LINEAR,DCB=(ADP1.GDGMODEL) 00400000
//SYSIN DD *
// DD DISP=SHR,DSN=OG1.&NODELIB..PARMLIB(OG1COPY)

PARMLIB Control statement:

OPTIONS LISTDEFDD(LISTDD) TEMPLATED(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
okonita1

MrSpock
Active Member
Posts: 273
Joined: Wed Jun 27, 2007 5:37 pm

Post by MrSpock » Mon Jan 07, 2013 7:24 pm

//SYSTEMPL DD * 00330000

Do you have NUMBERS ON?

okonita1
Member
Posts: 12
Joined: Thu Jan 03, 2013 12:18 pm

Post by okonita1 » Mon Jan 07, 2013 8:16 pm

No, that is just JCL line numbers from column 73 through 80 I believe.
okonita1

okonita1
Member
Posts: 12
Joined: Thu Jan 03, 2013 12:18 pm

Post by okonita1 » Mon Jan 07, 2013 8:18 pm

This is really a DB2 question I mistakenly posted it in this JCL forum. I wonder if I should repost it in the DB2 forum...
okonita1

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Mon Jan 07, 2013 10:37 pm

Possibly the &values in the DSN statement in the SYSTEMPL DD cannot be resolved.
Have a good one

NicC
Active Member
Posts: 650
Joined: Sun Jul 24, 2011 5:27 pm
Location: Down on the pig farm

Post by NicC » Mon Jan 07, 2013 11:39 pm

And possibly it would be easier to resolve if you used the code tags. If you do not know what they are then using the preview button will produce the full editor which has the relevant button.
Regards
Nic

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others