When trying to unload the table using imagecopy we are getting the following message in sysprint
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = UNLOADC1
DSNU050I DSNUGUTC - UNLOAD TABLESPACE SVC014.SVCV16D
DSNU650I # DSNUUGMS - FROMCOPY SPND.IMAGECP.SVC014.SVCV16D.G9648V00 PUNCHDDN SYSPUNCH UNLDDN SYSREC
DSNU1211I DSNUULCB - INPUT DATA SET IS NOT AN IMAGE COPY
DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
I have tried to use all versions imagecopies but all in vain.
The job which is making the imagecopies is having the following message
BMC30571I RETRYING DB2 COMMAND OR STATEMENT: STOP. WAITING 3 SECONds
The bmc catalog is not able to detect the imagecopies.what could be the possible reasons for that?.is the copy corrupted?
Please assist in that .
Please do tell me what are the other info i need to give u,to solve the problem.
Regards,
Rahul
imagecopy problem
Previous topic • Next topic • 3 posts
• Page 1 of 1
imagecopy problem
by mukerjr » Fri Dec 05, 2008 2:08 pm
- mukerjr
- Posts: 6
- Joined: Thu Nov 27, 2008 1:16 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: imagecopy problem
by dick scherrer » Fri Dec 05, 2008 2:30 pm
Hello,
It may help if you post the jcl and control statements for this run. Use copy/paste and the "Code" tag for readability and to preserve alignment.
You might want to compare this job to another that currently works and see where they are different.
It may help if you post the jcl and control statements for this run. Use copy/paste and the "Code" tag for readability and to preserve alignment.
If i understood the requirement, you want to create an image copy, not use one as input.DSNU1211I DSNUULCB - INPUT DATA SET IS NOT AN IMAGE COPY
You might want to compare this job to another that currently works and see where they are different.
Hope this helps,
d.sch.
d.sch.
-
dick scherrer - Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
- Has thanked: 3 times
- Been thanked: 93 times
Re: imagecopy problem
by mukerjr » Fri Dec 05, 2008 3:46 pm
IMAGECOPY PROBLEM
the job which is making the imagecopy is shown below.I have expanded this and -- steps shows you what the parms are doing.also i am posting the unload jcl as well.
JOB TRIGERRING IMAGECOPY
UNLOAD JCL
the job which is making the imagecopy is shown below.I have expanded this and -- steps shows you what the parms are doing.also i am posting the unload jcl as well.
JOB TRIGERRING IMAGECOPY
//YCI106P JOB (YCI1,P),P,MSGCLASS=P,CLASS=7,REGION=0M
#SCC,COND=(0,NE,*-SDBCOPYP)
#SCC,COND=(1-3,EQ,SDBCOPYP)
#SCC,COND=(4,LT,SDBCOPYP)
//*
//PROCLIB JCLLIB ORDER=(APPL.PFIX.PROCLIB,
// APPL.PROD.PROCLIB)
//*
//SETEM INCLUDE MEMBER=PRODY (set statements for database)
//*
//INCJLIB INCLUDE MEMBER=JLIBAPP
//*
//*
//*------------------------------------------------------------------*
//* DAILY IMAGE COPY OF SVC014 (CPIA VEHICLE) DATABASE. *
//*------------------------------------------------------------------*
//STEP01 EXEC SDBCOPYP,FPFX=S&ENV.ND,DB2LOAD=&DBENV, (YCIY1061)
--STEP01 EXEC SDBCOPYP,FPFX=SPND,DB2LOAD=PROD,
// DB2SYS=&DB2,UID='YCI106IM',UTPROC='NEW/RESET',
-- DB2SYS=DB2P,UID='YCI106IM',UTPROC='NEW/RESET',
// COND=(0,NE)
//SYSIN DD DSN=&SPNPFX..DB2.&DBENV..PARMLIB(YCI106C1),DISP=SHR
--SYSIN DD DSN=SPN.DB2.PROD.PARMLIB(YCI106C1),DISP=SHR
//SDBCOPYP PROC SOUT='*',
// FPFX=SDND,
// DB2LOAD=TEST,
// DB2SYS=DB2D,
// UID=,
// UTPROC=,
// MSGLVL='MSGLEVEL(1)',
// DBNAME='DB',
// TSNAME='TS',
// SYSCOPY='DUMMY,'
//SDBCOPYP EXEC PGM=ACPMAIN,
// REGION=0M,
// PARM='&DB2SYS,&UID,&UTPROC,&MSGLVL'
-- PARM='DB2P,YCI106IM,NEW/RESET,MSGLEVEL(1)'
//STEPLIB DD DISP=SHR,DSN=SYS3.BMCDB2.PROD.LOAD
// DD DISP=SHR,DSN=DB2.&DB2LOAD..SDSNLOAD
-- DD DISP=SHR,DSN=DB2.PROD.SDSNLOAD
//SYSPRINT DD SYSOUT=&SOUT
--SYSPRINT DD SYSOUT=*
//SYSCOPY DD &SYSCOPY.DISP=(,CATLG),UNIT=CART,
//SYSCOPY DD &SYSCOPY.DISP=(,CATLG),UNIT=CART,
--SYSCOPY DD DUMMY,DISP=(,CATLG),UNIT=CART,
// DSN=&FPFX..IMAGECP.&DBNAME..&TSNAME
-- DSN=SPND.IMAGECP.DB.TS
$/SYSIN DD DSN=&SPNPFX..DB2.&DBENV..PARMLIB(YCI106C1),DISP=SHR
--SYSIN DD DSN=SPN.DB2.PROD.PARMLIB(YCI106C1),DISP=SHR
----+----1----+----2----+----3----+----4----+----5----+----6----+----7
OUTPUT LPCOPY UNIT CART STACK YES
CATLG YES
MODELDCB NMC.DSCB
VOLCNT 99
DSNAME SPND.IMAGECP.&DB.&TS(+2)
OUTPUT RPCOPY UNIT CARTE STACK YES
CATLG YES
MODELDCB NMC.DSCB
VOLCNT 99
DSNAME SPND.DR1.IMAGECP.&DB.&TS(+2)
--- END OF STEP ---
--- END OF PROC ---
--- END OF JOB ---
#SCC,COND=(0,NE,*-SDBCOPYP)
#SCC,COND=(1-3,EQ,SDBCOPYP)
#SCC,COND=(4,LT,SDBCOPYP)
//*
//PROCLIB JCLLIB ORDER=(APPL.PFIX.PROCLIB,
// APPL.PROD.PROCLIB)
//*
//SETEM INCLUDE MEMBER=PRODY (set statements for database)
//*
//INCJLIB INCLUDE MEMBER=JLIBAPP
//*
//*
//*------------------------------------------------------------------*
//* DAILY IMAGE COPY OF SVC014 (CPIA VEHICLE) DATABASE. *
//*------------------------------------------------------------------*
//STEP01 EXEC SDBCOPYP,FPFX=S&ENV.ND,DB2LOAD=&DBENV, (YCIY1061)
--STEP01 EXEC SDBCOPYP,FPFX=SPND,DB2LOAD=PROD,
// DB2SYS=&DB2,UID='YCI106IM',UTPROC='NEW/RESET',
-- DB2SYS=DB2P,UID='YCI106IM',UTPROC='NEW/RESET',
// COND=(0,NE)
//SYSIN DD DSN=&SPNPFX..DB2.&DBENV..PARMLIB(YCI106C1),DISP=SHR
--SYSIN DD DSN=SPN.DB2.PROD.PARMLIB(YCI106C1),DISP=SHR
//SDBCOPYP PROC SOUT='*',
// FPFX=SDND,
// DB2LOAD=TEST,
// DB2SYS=DB2D,
// UID=,
// UTPROC=,
// MSGLVL='MSGLEVEL(1)',
// DBNAME='DB',
// TSNAME='TS',
// SYSCOPY='DUMMY,'
//SDBCOPYP EXEC PGM=ACPMAIN,
// REGION=0M,
// PARM='&DB2SYS,&UID,&UTPROC,&MSGLVL'
-- PARM='DB2P,YCI106IM,NEW/RESET,MSGLEVEL(1)'
//STEPLIB DD DISP=SHR,DSN=SYS3.BMCDB2.PROD.LOAD
// DD DISP=SHR,DSN=DB2.&DB2LOAD..SDSNLOAD
-- DD DISP=SHR,DSN=DB2.PROD.SDSNLOAD
//SYSPRINT DD SYSOUT=&SOUT
--SYSPRINT DD SYSOUT=*
//SYSCOPY DD &SYSCOPY.DISP=(,CATLG),UNIT=CART,
//SYSCOPY DD &SYSCOPY.DISP=(,CATLG),UNIT=CART,
--SYSCOPY DD DUMMY,DISP=(,CATLG),UNIT=CART,
// DSN=&FPFX..IMAGECP.&DBNAME..&TSNAME
-- DSN=SPND.IMAGECP.DB.TS
$/SYSIN DD DSN=&SPNPFX..DB2.&DBENV..PARMLIB(YCI106C1),DISP=SHR
--SYSIN DD DSN=SPN.DB2.PROD.PARMLIB(YCI106C1),DISP=SHR
----+----1----+----2----+----3----+----4----+----5----+----6----+----7
OUTPUT LPCOPY UNIT CART STACK YES
CATLG YES
MODELDCB NMC.DSCB
VOLCNT 99
DSNAME SPND.IMAGECP.&DB.&TS(+2)
OUTPUT RPCOPY UNIT CARTE STACK YES
CATLG YES
MODELDCB NMC.DSCB
VOLCNT 99
DSNAME SPND.DR1.IMAGECP.&DB.&TS(+2)
--- END OF STEP ---
--- END OF PROC ---
--- END OF JOB ---
UNLOAD JCL
//UNLOADC JOB (BMS9,B000000,1926),'UNLOAD',NOTIFY=BED066U,REGION=0M,
// MSGCLASS=X,CLASS=T,TIME=1440,
//*
/*ROUTE XEQ NFDG
//UTIL EXEC DSNUPROC,SYSTEM=DB2P,UID='UNLOADIC',UTPROC=''
//STEPLIB DD DSN=DB2.PROD.SDSNLOAD,DISP=SHR
//*
//*
//DSNUPROC.SYSREC DD DSN=BSA808U.SVC014.SVCV16D.UNLOAD1,
// DISP=(NEW,CATLG,DELETE),UNIT=TAPE
//DSNUPROC.PUNCH DD DSN=BSA808U.SVC014.SVCV16D.CNTL,
// DISP=(NEW,CATLG,DELETE),UNIT=SYSDA,SPACE=(TRK,(1,1))
//DSNUPROC.SYSPRINT DD SYSOUT=*
//DSNUPROC.SYSIN DD *
UNLOAD TABLESPACE SVC014.SVCV16D
FROMCOPY SPND.IMAGECP.SVC014.SVCV16D.G9659V00
PUNCHDDN PUNCH UNLDDN SYSREC
/*
// MSGCLASS=X,CLASS=T,TIME=1440,
//*
/*ROUTE XEQ NFDG
//UTIL EXEC DSNUPROC,SYSTEM=DB2P,UID='UNLOADIC',UTPROC=''
//STEPLIB DD DSN=DB2.PROD.SDSNLOAD,DISP=SHR
//*
//*
//DSNUPROC.SYSREC DD DSN=BSA808U.SVC014.SVCV16D.UNLOAD1,
// DISP=(NEW,CATLG,DELETE),UNIT=TAPE
//DSNUPROC.PUNCH DD DSN=BSA808U.SVC014.SVCV16D.CNTL,
// DISP=(NEW,CATLG,DELETE),UNIT=SYSDA,SPACE=(TRK,(1,1))
//DSNUPROC.SYSPRINT DD SYSOUT=*
//DSNUPROC.SYSIN DD *
UNLOAD TABLESPACE SVC014.SVCV16D
FROMCOPY SPND.IMAGECP.SVC014.SVCV16D.G9659V00
PUNCHDDN PUNCH UNLDDN SYSREC
/*
- mukerjr
- Posts: 6
- Joined: Thu Nov 27, 2008 1:16 pm
- Has thanked: 0 time
- Been thanked: 0 time
Previous topic • Next topic • 3 posts
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- unload using incremental imagecopy problem
by mukerjr » Fri Dec 05, 2008 4:47 pm - 1 Replies
- 2332 Views
- Last post by dick scherrer
Wed Dec 10, 2008 4:14 am
- unload using incremental imagecopy problem
-
- recover from imagecopy
by makkena » Wed Mar 23, 2011 1:07 pm - 4 Replies
- 2014 Views
- Last post by GuyC
Wed Mar 23, 2011 3:08 pm
- recover from imagecopy
-
- DB2 CONTENTION PROBLEM (-911)
by chetan_007 » Thu Feb 12, 2009 2:49 pm - 1 Replies
- 3352 Views
- Last post by dick scherrer
Fri Feb 13, 2009 1:04 am
- DB2 CONTENTION PROBLEM (-911)
-
- db2 load problem
by blue_tina » Wed Feb 03, 2010 7:41 pm - 5 Replies
- 8581 Views
- Last post by chaat
Mon Feb 08, 2010 7:36 am
- db2 load problem
-
- problem using dclgen
by swapna namburu » Wed Sep 08, 2010 2:44 pm - 1 Replies
- 1946 Views
- Last post by dick scherrer
Thu Sep 09, 2010 2:41 am
- problem using dclgen