Hi Guys,

Thanks for your commitment but it's not what I need.

It seems that you think that my problem is the target tape but it's not. My target tape is kept in the drive all the time,

The problem is that DB2 keeps kicking and mounting the original tape (FULLIMAGE COPY TAPE) everytime it tries COPYTOCOPY a new tablespace from the original to the backup tape.

All I want is that the original tape that is a FULLIMAGE COPY of multiple tablespaces keeps in the drive for all the duration of the job.

I'm sending you a version with only 3 tablespaces that we're running for tests.

//ASEGCP99 JOB (),CLASS=S,MSGCLASS=S,

// MSGLEVEL=(1,1),NOTIFY=&SYSUID,TIME=1440


//ASEGCP99 EXEC PGM=DSNUTILB,PARM='DB2R,ASEGCP99',REGION=0M

//*

//SYSCA001 DD UNIT=3590,

// DSN=DB2X.ICXXXXXX.DBASEXXX.TSXXXXX1,

// LABEL=(001,SL),

// VOL=(,RETAIN),

// DISP=(NEW,KEEP)

//SYSCA002 DD UNIT=3590,

// DSN=DB2R.ICXXXXXX.DBASEXXX.TSXXXXX2,

// LABEL=(002,SL),

// VOL=(,RETAIN,REF=*.SYSCA001),

// DISP=(NEW,KEEP)

//SYSCA003 DD UNIT=3590,

// DSN=DB2R.ICXXXXXX.DBASEXXX.TSXXXXX3,

// LABEL=(003,SL),

// VOL=(,RETAIN,REF=*.SYSCA002),

// DISP=(NEW,KEEP)

//SYSPRINT DD SYSOUT=*

//SYSUDUMP DD SYSOUT=*

//SYSIN DD *

COPYTOCOPY TABLESPACE DBASEXX1.TSXXXXX1 FROMLASTFULLCOPY

COPYDDN(,SYSCA001)

TABLESPACE DBASEXX1.TSXXXXX2 FROMLASTFULLCOPY

COPYDDN(,SYSCA002)

TABLESPACE DBASEXX1.TSXXXXX3 FROMLASTFULLCOPY

COPYDDN(,SYSCA003)


Thanks in advance ,

Pedro Gonçalves.

DB2 & UDB email list listserv db2-l LazyDBA home page