Example 9: Copying table spaces and indexes using INDEXES YES


This job example copies table spaces and indexes using the INDEXES YES option.

//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
/*


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*