Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Copy for Db2 13.1.

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*