Example 9: Copying table spaces and indexes using INDEXES YES
//ACPEX09 JOB (PACP),'EXAMPLE 9',CLASS=Q,MSGCLASS=X,NOTIFY=&SYSUID
//**********************************************************************
//* Make a SHRLEVEL CHANGE copy of all table spaces in databases
//* ACPEXDB*, and copy any associated index spaces if they are
//* larger than 72,000 KB (100 cyl on a 3390 device).
//*
//* This job will create a local-site primary (LP) copy on DASD,
//* and a recovery-site primary (RP) copy that is stacked on tape.
//*
//* This example demonstrates the following features of COPY PLUS:
//*
//* - Restart parm NEW/RESTART to allow the job to be restarted by
//* re-submitting the job without changes.
//* - IXDSNUM ALL to copy multi-data-set indexes to a single
//* image copy data set.
//* - IXSIZE 72000K to cause COPY PLUS to bypass copying indexes that
//* are less than 72,000 KB, or about 100 cyl on a 3390 device.
//* - Dynamic allocation with the OUTPUT command. Note that
//* MAXPRIM on the OUTPUT statement for LOCALP will limit the
//* primary and secondary extent size to 200 cylinders.
//* - Dynamic GDG base creation with the ACPGDG DD statement. In this
//* example, if the GDG base does not exist, one will be created
//* with a limit of 3.
//* - INDEXES YES to copy the indexes associated with the spaces in
//* the table space list.
//* - RESETMOD NO to avoid the overhead of clearing the modified-page
//* indicators in each spacemap.
//*
//**********************************************************************
//BMCCOPY EXEC PGM=ACPMAIN,REGION=0M,
// PARM='DGA,ACPEX09,NEW/RESTART,MSGLEVEL(1)'
//STEPLIB DD DISP=SHR,DSN=product.libraries
// DD DISP=SHR,DSN=DB2.DSNEXIT
// DD DISP=SHR,DSN=DB2.DSNLOAD
//ACPGDG DD *
DEFINE GDG (NAME(&BASE) LIMIT(3) SCR)
//ACPERROR DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
OPTIONS IXDSNUM ALL
IXSIZE 72000K
OUTPUT LOCALP UNIT SYSDA
MAXPRIM 200 CYL
DSNAME ACP.LP.&DB.&TS.F&LPART(+1)
OUTPUT REMOTP UNIT CARTVTS STACK YES
DSNAME ACP.RP.&DB.&TS.D&DATE.T&TIME
COPY TABLESPACE ACPEXDB*.*
INDEXES YES
COPYDDN(LOCALP)
RECOVERYDDN(REMOTP)
SHRLEVEL CHANGE
RESETMOD NO
/*
//**********************************************************************
//* Make a SHRLEVEL CHANGE copy of all table spaces in databases
//* ACPEXDB*, and copy any associated index spaces if they are
//* larger than 72,000 KB (100 cyl on a 3390 device).
//*
//* This job will create a local-site primary (LP) copy on DASD,
//* and a recovery-site primary (RP) copy that is stacked on tape.
//*
//* This example demonstrates the following features of COPY PLUS:
//*
//* - Restart parm NEW/RESTART to allow the job to be restarted by
//* re-submitting the job without changes.
//* - IXDSNUM ALL to copy multi-data-set indexes to a single
//* image copy data set.
//* - IXSIZE 72000K to cause COPY PLUS to bypass copying indexes that
//* are less than 72,000 KB, or about 100 cyl on a 3390 device.
//* - Dynamic allocation with the OUTPUT command. Note that
//* MAXPRIM on the OUTPUT statement for LOCALP will limit the
//* primary and secondary extent size to 200 cylinders.
//* - Dynamic GDG base creation with the ACPGDG DD statement. In this
//* example, if the GDG base does not exist, one will be created
//* with a limit of 3.
//* - INDEXES YES to copy the indexes associated with the spaces in
//* the table space list.
//* - RESETMOD NO to avoid the overhead of clearing the modified-page
//* indicators in each spacemap.
//*
//**********************************************************************
//BMCCOPY EXEC PGM=ACPMAIN,REGION=0M,
// PARM='DGA,ACPEX09,NEW/RESTART,MSGLEVEL(1)'
//STEPLIB DD DISP=SHR,DSN=product.libraries
// DD DISP=SHR,DSN=DB2.DSNEXIT
// DD DISP=SHR,DSN=DB2.DSNLOAD
//ACPGDG DD *
DEFINE GDG (NAME(&BASE) LIMIT(3) SCR)
//ACPERROR DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
OPTIONS IXDSNUM ALL
IXSIZE 72000K
OUTPUT LOCALP UNIT SYSDA
MAXPRIM 200 CYL
DSNAME ACP.LP.&DB.&TS.F&LPART(+1)
OUTPUT REMOTP UNIT CARTVTS STACK YES
DSNAME ACP.RP.&DB.&TS.D&DATE.T&TIME
COPY TABLESPACE ACPEXDB*.*
INDEXES YES
COPYDDN(LOCALP)
RECOVERYDDN(REMOTP)
SHRLEVEL CHANGE
RESETMOD NO
/*
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*