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 Recovery Manager for Db2 13.1.

Using BMC AMI Recovery Manager object sets for backup and recovery backup and recovery setup

BMC AMI Recovery Manager

 creates object sets and stores them in the BMC Common Db2 repository on each Db2 subsystem. An object set is a collection of Db2 table spaces, indexes, or both, as determined by the object set definitions.

Important

BMC AMI Recovery Manager does not support delimited object set names. Delimited names are those enclosed by double quotation marks and can contain special characters (for example, 'creator'.'name').

When accessing an object set, BMC AMI Recovery Manager returns objects based on the object set definition:

  • If the definitions are explicit (no wildcards), BMC AMI Recovery Manager returns only the explicitly specified objects.
  • If the definition contains wildcards, BMC AMI Recovery Manager returns all objects matching the wildcard pattern or patterns. For example, if a definition is DB40.*, BMC AMI Recovery Manager returns all table spaces in the database DB40. Also, if you subsequently add table space to that database, BMC AMI Recovery Manager dynamically recognizes the new table space.

For information about OBJECTSET, see OBJECTSET.

Programs for managing object sets

With BMC AMI Recovery Manager, you can use the ARMBGRP, ARMBGPS, and ARMBSET programs to create and manage object sets:

  • ARMBGRP is a batch interface for creating and managing object sets. You can use a variety of definitions to create the object sets, such as by:

    • Table space
    • Table
    • Index
    • Index space
    • Plan
    • Package
    • Stogroup
    • User-specified SQL
    • Object status

    You can use a mixture of definitions to create your preferred collection of Db2 objects. For more information, see ARMBGRP—Object set creation and maintenance.

  • ARMBGPS creates a collection of object sets (up to 99) as specified by MAXOBJECTSETS nn syntax. These object sets contain only table spaces. ARMBGPS automatically distributes the objects into multiple size-balanced object sets, keeping related object types (such as LOB, XML, temporal, and archive enabled) together in the same object set. BMC AMI Recovery Manager can then treat these object sets as independent units for backup and recovery. Because these object sets are balanced by size, the backup and recovery jobs that use them should run for approximately the same length of time

    Important

    You should use the same object sets for recovery that you use for backup. If using tape, attempting to recover with different object sets in multiple jobs can cause contention between jobs that need the same tape. To maintain parallelism, you can use multiple recover jobs per object set. However, each job will need to read the Db2 log. So, optimally, you should use only one or two concurrent jobs per LPAR for data sharing, and a maximum of four for non-data sharing. Contention might occur on the log (even if it is on disk) if too many jobs are running in parallel and attempt to read the log simultaneously. This situation can degrade performance.

    For more information, see ARMBGPS—Subsystem object set split.

  • ARMBSET is an object set utility. You can use ARMBSET to perform the following actions for objects in a specified object set:
  • CHECK
  • REPAIR
  • QUIESCE
  • RUNSTATS
  • START
  • STOP

For more information about ARMBSET, see ARMBSET— OBJECTSET processing.

JCL examples for backing up and recovering object sets

The following JCL examples show how to back up and recover with object sets using the BMC AMI Recovery Manager for Db2, BMC AMI Copy for Db2 , and BMC AMI Recover for Db2 products.

You create this JCL only once; you do not need to regenerate it each time. However, the JCL requires that the copies be created by object set when tape is involved to avoid contention for volumes across the recovery jobs.

BMC AMI Recovery Manager SAMPLIB member ARMBSET contains the following jobs:



JOB00011—CREATE INITIAL OBJECTSET/CREATE BALANCED OBJECTSETS

//JOB00011 JOB PACP,NAME,CLASS=A,MSGCLASS=X,
//             NOTIFY=RDAWXP,REGION=0M
//*
//*********************************************************************
//* CREATE INITIAL OBJECTSET
//*********************************************************************
//CREATEG1  EXEC PGM=ARMBGRP,
//             PARM='DIZ,ARMOPTS=ARM$OPTS'
//STEPLIB        DD DISP=SHR,DSN=RMD.INST1110.BMCLINK
//                        DD DISP=SHR,DSN=SYS3.DIZ.DSNEXIT
//                        DD DISP=SHR,DSN=CSGI.DB2V10M.DSNLOAD
//ARMMSGS    DD DISP=SHR,DSN=RMD.INST1110.BMCCNTL(ARMMSGS)
//ARMERROR  DD SYSOUT=*                                                 
//ARMPRINT    DD SYSOUT=*                                                 
//ARMIN           DD *
CREATE OBJECTSET RDAWXP.BIGOBJECTSET                                            
 DESCRIPTION 'ALL OBJECTS'                                             
 REPLACE YES                                                            
 INCLUDE TABLESPACE RDAWXP*.*                                               
   INCLUDEIX NO
;                                                                       
//*
//*********************************************************************
//* CREATE BALANCED OBJECTSETS
//*********************************************************************
//SPLITGP EXEC PGM=ARMBGPS,
//             PARM='DIZ,ARMOPTS=ARM$OPTS',
//             REGION=4M
//STEPLIB       DD DISP=SHR,DSN=RMD.INST1110.BMCLINK
//                       DD DISP=SHR,DSN=SYS3.DIZ.DSNEXIT
//                       DD DISP=SHR,DSN=CSGI.DB2V10M.DSNLOAD
//ARMMSGS   DD DISP=SHR,DSN=RMD.INST1110.BMCCNTL(ARMMSGS)
//ARMPRINT  DD SYSOUT=*
//ARMERROR DD SYSOUT=*
//ARMIN          DD *
 SET CURRENT SQLID = RDAWXP;
     BUILD OBJECTSETS RDAWXP.MYGRP
        MAXOBJECTSETS 4
     INCLUDE_OBJECTSET
         RDAWXP.BIGOBJECTSET
     ;
/*
//

JOB00021—COPY EACH OBJECTSET

//JOB00021 JOB PACP,NAME,CLASS=A,MSGCLASS=X,
//             NOTIFY=RDAWXP,REGION=0M
//*
//*********************************************************************
//* COPY OBJECTSET
//* -----------------------------------------------------------------
//* NOTES:
//*
//* - Indexes larger than IXSIZE will be copied.
//* - Table spaces larger than OUTSIZE will be copied to BIGDDN
//* - If a copy fails for any reason, and you wish to re-run the job
//*   from the beginning, change the restart parm from NEW/RESTART to
//*   NEW, and Copy+ will automatically TERM the old utilid.
//*
//*********************************************************************
//*
//*********************************************************************
//* COPY EACH RECOVERY OBJECTSET
//*********************************************************************
//BMCCOPY1 EXEC PGM=ACPMAIN,REGION=0M,
//         PARM='DIZ,,NEW/RESTART,MSGLEVEL(1)'
//STEPLIB  DD DSN=RMD.INST1110.BMCLINK,DISP=SHR
//                  DD DSN=SYS3.DIZ.DSNEXIT,DISP=SHR
//                  DD DSN=CSGI.DB2V10M.DSNLOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//ACPERROR DD SYSOUT=*
//SYSIN    DD *
  OPTIONS
     MAXTASKS 8
     OUTSIZE 1500 M
     IXSIZE  1500 M
     XBMID XBMDB2

  -- BIG COPIES ON THEIR OWN TAPE
  OUTPUT BIGTAPE UNIT CARTVTS STACK NO
       DSNAME RDAWXP2.&DB.&TS.P&LPART.&UNIQ

  -- SMALLER COPIES ON STACKED TAPE
  OUTPUT TAPE    UNIT CARTVTS STACK YES
       DSNAME RDAWXP2.&DB.&TS.P&LPART.&UNIQ

  -- CABINET COPIES
  OUTPUT CABINET UNIT CARTVTS STACK CABINET
       DSNAME RDAWXP2.MYGRP01.CAB.&UNIQ

  -- SNAP COPIES (REQUIRES DSNUM DATASET)
  OUTPUT SNAP UNIT SYSDA
       STORCLAS DEVSMS
       DSNAME RDAWXP2.&DB.&TS.D&DSNUM.&UNIQ
       DSSNAP AUTO

  COPY TABLESPACE OBJECTSET RDAWXP.MYGRP00
       TABLESPACE OBJECTSET RDAWXP.MYGRP01
       EXCLUDE RDAWXP02.MDSNP01, RDAWXP02.MDSNP02
       INDEXES YES
       COPYDDN(TAPE)
       BIGDDN(BIGTAPE)
     SHRLEVEL CHANGE
     OBJECTSET NO
/*
//

JOB00022—COPY EACH OBJECTSET

//JOB00022 JOB PACP,NAME,CLASS=A,MSGCLASS=X,
//             NOTIFY=RDAWXP,REGION=0M
//*
//*********************************************************************
//* COPY OBJECTSET
//* -----------------------------------------------------------------
//* NOTES:
//*
//* - Indexes larger than IXSIZE will be copied.
//* - Table spaces larger than OUTSIZE will be copied to BIGDDN
//* - If a copy fails for any reason, and you wish to re-run the job
//*   from the beginning, change the restart parm from NEW/RESTART to
//*   NEW, and Copy+ will automatically TERM the old utilid.
//*
//*********************************************************************
//*
//*********************************************************************
//* COPY EACH RECOVERY OBJECTSET
//*********************************************************************
//BMCCOPY1 EXEC PGM=ACPMAIN,REGION=0M,
//         PARM='DIZ,,NEW/RESTART,MSGLEVEL(1)'
//STEPLIB  DD DSN=RMD.INST1110.BMCLINK,DISP=SHR
//                  DD DSN=SYS3.DIZ.DSNEXIT,DISP=SHR
//                  DD DSN=CSGI.DB2V10M.DSNLOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//ACPERROR DD SYSOUT=*
//SYSIN    DD *
  OPTIONS
     MAXTASKS 8
     OUTSIZE 1500 M
     IXSIZE  1500 M
     XBMID XBMDB2

  -- BIG COPIES ON THEIR OWN TAPE
  OUTPUT BIGTAPE UNIT CARTVTS STACK NO
       DSNAME RDAWXP2.&DB.&TS.P&LPART.&UNIQ

  -- SMALLER COPIES ON STACKED TAPE
  OUTPUT TAPE    UNIT CARTVTS STACK YES
       DSNAME RDAWXP2.&DB.&TS.P&LPART.&UNIQ

  -- CABINET COPIES
  OUTPUT CABINET UNIT CARTVTS STACK CABINET
       DSNAME RDAWXP2.MYGRP01.CAB.&UNIQ

  -- SNAP COPIES (REQUIRES DSNUM DATASET)
  OUTPUT SNAP UNIT SYSDA
       STORCLAS DEVSMS
       DSNAME RDAWXP2.&DB.&TS.D&DSNUM.&UNIQ
       DSSNAP AUTO

  COPY TABLESPACE OBJECTSET RDAWXP.MYGRP02
       EXCLUDE RDAWXP02.MDSNP01, RDAWXP02.MDSNP02
       INDEXES YES
       COPYDDN(TAPE)
       BIGDDN(BIGTAPE)
     SHRLEVEL CHANGE
     OBJECTSET NO
/*
//

JOB00023—COPY EACH OBJECTSET

//JOB0023 JOB PACP,NAME,CLASS=A,MSGCLASS=X,
//             NOTIFY=RDAWXP,REGION=0M
//*
//*********************************************************************
//* COPY OBJECTSET
//* -----------------------------------------------------------------
//* NOTES:
//*
//* - Indexes larger than IXSIZE will be copied.
//* - Table spaces larger than OUTSIZE will be copied to BIGDDN
//* - If a copy fails for any reason, and you wish to re-run the job
//*   from the beginning, change the restart parm from NEW/RESTART to
//*   NEW, and Copy+ will automatically TERM the old utilid.
//*
//*********************************************************************
//*
//*********************************************************************
//* COPY EACH RECOVERY OBJECTSET
//*********************************************************************
//BMCCOPY1 EXEC PGM=ACPMAIN,REGION=0M,
//         PARM='DIZ,,NEW/RESTART,MSGLEVEL(1)'
//STEPLIB  DD DSN=RMD.INST1110.BMCLINK,DISP=SHR
//                  DD DSN=SYS3.DIZ.DSNEXIT,DISP=SHR
//                  DD DSN=CSGI.DB2V10M.DSNLOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//ACPERROR DD SYSOUT=*
//SYSIN    DD *
  OPTIONS
     MAXTASKS 8
     OUTSIZE 1500 M
     IXSIZE  1500 M
     XBMID XBMDB2

  -- BIG COPIES ON THEIR OWN TAPE
  OUTPUT BIGTAPE UNIT CARTVTS STACK NO
       DSNAME RDAWXP2.&DB.&TS.P&LPART.&UNIQ

  -- SMALLER COPIES ON STACKED TAPE
  OUTPUT TAPE    UNIT CARTVTS STACK YES
       DSNAME RDAWXP2.&DB.&TS.P&LPART.&UNIQ

  -- CABINET COPIES
  OUTPUT CABINET UNIT CARTVTS STACK CABINET
       DSNAME RDAWXP2.MYGRP01.CAB.&UNIQ

  -- SNAP COPIES (REQUIRES DSNUM DATASET)
  OUTPUT SNAP UNIT SYSDA
       STORCLAS DEVSMS
       DSNAME RDAWXP2.&DB.&TS.D&DSNUM.&UNIQ
       DSSNAP AUTO

  COPY TABLESPACE OBJECTSET RDAWXP.MYGRP03
       EXCLUDE RDAWXP02.MDSNP01, RDAWXP02.MDSNP02
       INDEXES YES
       COPYDDN(TAPE)
       BIGDDN(BIGTAPE)
     SHRLEVEL CHANGE
     OBJECTSET NO
/*
//

JOB00024—COPY EACH OBJECTSET

//JOB0024 JOB PACP,NAME,CLASS=A,MSGCLASS=X,
//             NOTIFY=RDAWXP,REGION=0M
//*
//*********************************************************************
//* COPY OBJECTSET
//* -----------------------------------------------------------------
//* NOTES:
//*
//* - Indexes larger than IXSIZE will be copied.
//* - Table spaces larger than OUTSIZE will be copied to BIGDDN
//* - If a copy fails for any reason, and you wish to re-run the job
//*   from the beginning, change the restart parm from NEW/RESTART to
//*   NEW, and Copy+ will automatically TERM the old utilid.
//*
//*********************************************************************
//*
//*********************************************************************
//* COPY EACH RECOVERY OBJECTSET
//*********************************************************************
//BMCCOPY1 EXEC PGM=ACPMAIN,REGION=0M,
//         PARM='DIZ,,NEW/RESTART,MSGLEVEL(1)'
//STEPLIB  DD DSN=RMD.INST1110.BMCLINK,DISP=SHR
//                  DD DSN=SYS3.DIZ.DSNEXIT,DISP=SHR
//                  DD DSN=CSGI.DB2V10M.DSNLOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//ACPERROR DD SYSOUT=*
//SYSIN    DD *
  OPTIONS
     MAXTASKS 8
     OUTSIZE 1500 M
     IXSIZE  1500 M
     XBMID XBMDB2

  -- BIG COPIES ON THEIR OWN TAPE
  OUTPUT BIGTAPE UNIT CARTVTS STACK NO
       DSNAME RDAWXP2.&DB.&TS.P&LPART.&UNIQ

  -- SMALLER COPIES ON STACKED TAPE
  OUTPUT TAPE    UNIT CARTVTS STACK YES
       DSNAME RDAWXP2.&DB.&TS.P&LPART.&UNIQ

  -- CABINET COPIES
  OUTPUT CABINET UNIT CARTVTS STACK CABINET
       DSNAME RDAWXP2.MYGRP01.CAB.&UNIQ

  -- SNAP COPIES (REQUIRES DSNUM DATASET)
  OUTPUT SNAP UNIT SYSDA
       STORCLAS DEVSMS
       DSNAME RDAWXP2.&DB.&TS.D&DSNUM.&UNIQ
       DSSNAP AUTO

  COPY TABLESPACE OBJECTSET RDAWXP.MYGRP04
       EXCLUDE RDAWXP02.MDSNP01, RDAWXP02.MDSNP02
       INDEXES YES
       COPYDDN(TAPE)
       BIGDDN(BIGTAPE)
     SHRLEVEL CHANGE
     OBJECTSET NO
/*
//

JOB00031—RECOVER EACH OBJECTSET

//JOB00031 JOB PACP,NAME,CLASS=A,MSGCLASS=X,
//             NOTIFY=RDAWXP,REGION=0M
//*
//*********************************************************************
//* RECOVER OBJECTSET
//* -----------------------------------------------------------------
//* INSTRUCTIONS:
//*
//* 1. Set the RECOVERYPOINT timestamp in each job,
//*    or remove the RECOVERYPOINT syntax for recovery to current.
//* 2. For best results, submit the jobs on separate LPARs.
//*
//* For recovery at a DR site:
//*    - Set BACKOUT NO
//*    - Set REDEFINE NOSCRATCH to eliminate mount messages for
//*      primary site volumes that do not exist at the recovery site.
//*
//* -----------------------------------------------------------------
//* ADDITIONAL NOTES:
//*
//* - RESOURCE SELECTION is used to spread log reads across the
//*   active and archive logs.
//* - With BACKOUT AUTO, BACKOUT is automatically set to NO when you
//*   are recovering to current,
//* - With INDEXLOG AUTO, if an image copy of an index is available,
//*   an index will be recovered from the copy. If no copy is available
//*   the index will be rebuilt.
//*
//*********************************************************************
//ARM0001 EXEC PGM=AFRMAIN,
// PARM=(DIZ,,
// 'NEW/RESTART','MSGLEVEL(1)',,'RDB2STAT(YES)',
// AFROPTS(AFR$OPTS))
//STEPLIB   DD DISP=SHR,DSN=RMD.INST1110.BMCLINK
//                   DD DISP=SHR,DSN=SYS3.DIZ.DSNEXIT
//                   DD DISP=SHR,DSN=CSGI.DB2V10M.DSNLOAD
//SYSUDUMP  DD SYSOUT=*
//SYSPICK   DD SYSOUT=*
//SYSOUT    DD SYSOUT=*
//SYSERR    DD SYSOUT=*
//SYSIN     DD *
 OPTIONS
    INDEXLOG AUTO
    BACKOUT AUTO
    ON ERROR CONTINUE 10
    RECOVERYPOINT
       TIMESTAMP 2014-07-17-11.00.00.000000
       URIDDDN(URID0)
    RESOURCE SELECTION
       LOGS(ACT1,ACT2,ARC1,ARC2)
 OUTPUT URID0 UNIT SYSDA
    DSNAME &UID.D&DATE.T&TIME.URIDS.&UNIQ
 RECOVER TABLESPACE OBJECTSET RDAWXP.MYGRP00   -- DELTA OBJECTSET (NEW OBJ)
    INDEXES YES
    EXCLUDE (RDAWXP02.MDSNP01, RDAWXP02.MDSNP02)
    REDEFINE NO
 RECOVER TABLESPACE OBJECTSET RDAWXP.MYGRP01
    INDEXES YES
    EXCLUDE (RDAWXP02.MDSNP01, RDAWXP02.MDSNP02)
    REDEFINE NO
/*
//

JOB00032—RECOVER EACH OBJECTSET

//JOB00032 JOB PACP,NAME,CLASS=A,MSGCLASS=X,
//             NOTIFY=RDAWXP,REGION=0M
//*
//*********************************************************************
//* RECOVER OBJECTSET
//* -----------------------------------------------------------------
//* INSTRUCTIONS:
//*
//* 1. Set the RECOVERYPOINT timestamp in each job,
//*    or remove the RECOVERYPOINT syntax for recovery to current.
//* 2. For best results, submit the jobs on separate LPARs.
//*
//* For recovery at a DR site:
//*    - Set BACKOUT NO
//*    - Set REDEFINE NOSCRATCH to eliminate mount messages for
//*      primary site volumes that do not exist at the recovery site.
//*
//* -----------------------------------------------------------------
//* ADDITIONAL NOTES:
//*
//* - RESOURCE SELECTION is used to spread log reads across the
//*   active and archive logs.
//* - With BACKOUT AUTO, BACKOUT is automatically set to NO when you
//*   are recovering to current,
//* - With INDEXLOG AUTO, if an image copy of an index is available,
//*   an index will be recovered from the copy. If no copy is available
//*   the index will be rebuilt.
//*
//*********************************************************************
//*
//*********************************************************************
//* RECOVER OBJECTSET
//*********************************************************************
//ARM0001 EXEC PGM=AFRMAIN,
// PARM=(DIZ,,
// 'NEW/RESTART','MSGLEVEL(1)',,'RDB2STAT(YES)',
// AFROPTS(AFR$OPTS))
//STEPLIB   DD DISP=SHR,DSN=RMD.INST1110.BMCLINK
//                   DD DISP=SHR,DSN=SYS3.DIZ.DSNEXIT
//                   DD DISP=SHR,DSN=CSGI.DB2V10M.DSNLOAD
//SYSUDUMP  DD SYSOUT=*
//SYSPICK   DD SYSOUT=*
//SYSOUT    DD SYSOUT=*
//SYSERR    DD SYSOUT=*
//SYSIN     DD *
 OPTIONS
    INDEXLOG AUTO
    BACKOUT AUTO
    ON ERROR CONTINUE 10
    RECOVERYPOINT
       TIMESTAMP 2014-07-17-11.00.00.000000
       URIDDDN(URID0)
    RESOURCE SELECTION
       LOGS(ACT2,ARC1,ARC2,ACT1)
 OUTPUT URID0 UNIT SYSDA
    DSNAME &UID.D&DATE.T&TIME.URIDS.&UNIQ
 RECOVER TABLESPACE OBJECTSET RDAWXP.MYGRP02
    INDEXES YES
    EXCLUDE (RDAWXP02.MDSNP01, RDAWXP02.MDSNP02)
    REDEFINE NO
/*
//

JOB00033—RECOVER EACH OBJECTSET

//JOB00033 JOB PACP,NAME,CLASS=A,MSGCLASS=X,
//             NOTIFY=RDAWXP,REGION=0M
//*
//*********************************************************************
//* RECOVER OBJECTSET
//* -----------------------------------------------------------------
//* INSTRUCTIONS:
//*
//* 1. Set the RECOVERYPOINT timestamp in each job,
//*    or remove the RECOVERYPOINT syntax for recovery to current.
//* 2. For best results, submit the jobs on separate LPARs.
//*
//* For recovery at a DR site:
//*    - Set BACKOUT NO
//*    - Set REDEFINE NOSCRATCH to eliminate mount messages for
//*      primary site volumes that do not exist at the recovery site.
//*
//* -----------------------------------------------------------------
//* ADDITIONAL NOTES:
//*
//* - RESOURCE SELECTION is used to spread log reads across the
//*   active and archive logs.
//* - With BACKOUT AUTO, BACKOUT is automatically set to NO when you
//*   are recovering to current,
//* - With INDEXLOG AUTO, if an image copy of an index is available,
//*   an index will be recovered from the copy. If no copy is available
//*   the index will be rebuilt.
//*
//*********************************************************************
//*
//*********************************************************************
//* RECOVER OBJECTSET
//*********************************************************************
//ARM0001 EXEC PGM=AFRMAIN,
// PARM=(DIZ,,
// 'NEW/RESTART','MSGLEVEL(1)',,'RDB2STAT(YES)',
// AFROPTS(AFR$OPTS))
//STEPLIB   DD DISP=SHR,DSN=RMD.INST1110.BMCLINK
//                   DD DISP=SHR,DSN=SYS3.DIZ.DSNEXIT
//                   DD DISP=SHR,DSN=CSGI.DB2V10M.DSNLOAD
//SYSUDUMP  DD SYSOUT=*
//SYSPICK   DD SYSOUT=*
//SYSOUT    DD SYSOUT=*
//SYSERR    DD SYSOUT=*
//SYSIN     DD *
 OPTIONS
    INDEXLOG AUTO
    BACKOUT AUTO
    ON ERROR CONTINUE 10
    RECOVERYPOINT
       TIMESTAMP 2014-07-17-11.00.00.000000
       URIDDDN(URID0)
    RESOURCE SELECTION
       LOGS(ARC1,ARC2,ACT1,ACT2)
 OUTPUT URID0 UNIT SYSDA
    DSNAME &UID.D&DATE.T&TIME.URIDS.&UNIQ
 RECOVER TABLESPACE OBJECTSET RDAWXP.MYGRP03
    INDEXES YES
    EXCLUDE (RDAWXP02.MDSNP01, RDAWXP02.MDSNP02)
    REDEFINE NO
/*
//

JOB00034—RECOVER EACH OBJECTSET

//JOB0034 JOB PACP,NAME,CLASS=A,MSGCLASS=X,
//             NOTIFY=RDAWXP,REGION=0M
//*
//*********************************************************************
//* RECOVER OBJECTSET
//* -----------------------------------------------------------------
//* INSTRUCTIONS:
//*
//* 1. Set the RECOVERYPOINT timestamp in each job,
//*    or remove the RECOVERYPOINT syntax for recovery to current.
//* 2. For best results, submit the jobs on separate LPARs.
//*
//* For recovery at a DR site:
//*    - Set BACKOUT NO
//*    - Set REDEFINE NOSCRATCH to eliminate mount messages for
//*      primary site volumes that do not exist at the recovery site.
//*
//* -----------------------------------------------------------------
//* ADDITIONAL NOTES:
//*
//* - RESOURCE SELECTION is used to spread log reads across the
//*   active and archive logs.
//* - With BACKOUT AUTO, BACKOUT is automatically set to NO when you
//*   are recovering to current,
//* - With INDEXLOG AUTO, if an image copy of an index is available,
//*   an index will be recovered from the copy. If no copy is available
//*   the index will be rebuilt.
//*
//*********************************************************************
//*
//*********************************************************************
//* RECOVER OBJECTSET
//*********************************************************************
//ARM0001 EXEC PGM=AFRMAIN,
// PARM=(DIZ,,
// 'NEW/RESTART','MSGLEVEL(1)',,'RDB2STAT(YES)',
// AFROPTS(AFR$OPTS))
//STEPLIB   DD DISP=SHR,DSN=RMD.INST1110.BMCLINK
//                   DD DISP=SHR,DSN=SYS3.DIZ.DSNEXIT
//                   DD DISP=SHR,DSN=CSGI.DB2V10M.DSNLOAD
//SYSUDUMP  DD SYSOUT=*
//SYSPICK   DD SYSOUT=*
//SYSOUT    DD SYSOUT=*
//SYSERR    DD SYSOUT=*
//SYSIN     DD *
 OPTIONS
    INDEXLOG AUTO
    BACKOUT AUTO
    ON ERROR CONTINUE 10
    RECOVERYPOINT
       TIMESTAMP 2014-07-17-11.00.00.000000
       URIDDDN(URID0)
    RESOURCE SELECTION
       LOGS(ARC2,ACT1,ACT2,ARC1)
 OUTPUT URID0 UNIT SYSDA
    DSNAME &UID.D&DATE.T&TIME.URIDS.&UNIQ
 RECOVER TABLESPACE OBJECTSET RDAWXP.MYGRP04
    INDEXES YES
    EXCLUDE (RDAWXP02.MDSNP01, RDAWXP02.MDSNP02)
    REDEFINE NO
/*
//

JOB00041—CREATE AN OBJECTSET THAT INCLUDES TS & IX/ARMBSET TO START SPACES

//JOB00041 JOB PACP,NAME,CLASS=A,MSGCLASS=X,
//             NOTIFY=RDAWXP,REGION=0M
//*
//*********************************************************************
//* CREATE AN OBJECTSET THAT INCLUDES OUR TS & IX
//*********************************************************************
//CREATEGP  EXEC PGM=ARMBGRP,
//             PARM='DIZ,ARMOPTS=ARM$OPTS'
//STEPLIB   DD DISP=SHR,DSN=RMD.INST1110.BMCLINK
//                   DD DISP=SHR,DSN=SYS3.DIZ.DSNEXIT
//                   DD DISP=SHR,DSN=CSGI.DB2V10M.DSNLOAD
//ARMMSGS   DD DISP=SHR,DSN=RMD.INST1110.BMCCNTL(ARMMSGS)
//*RMTRACE  DD SYSOUT=*                                                
//ARMERROR  DD SYSOUT=*                                               
//ARMPRINT  DD SYSOUT=*                                                 
//ARMIN     DD *
-- CREATE AN OBJECTSET THAT INCLUDES INDEXES (FOR CONVENIENCE)
CREATE OBJECTSET RDAWXP.BIGOBJECTSET                                           
 DESCRIPTION 'ALL OBJECTS'                                              
 REPLACE YES                                                            
 INCLUDE TABLESPACE RDAWXP*.*                              
   INCLUDEIX YES
;                                                                       
//*
//*********************************************************************
//* RECOVERY MANAGER ARMBSET TO START SPACES IF NECESSARY
//*********************************************************************
//ARM00001  EXEC PGM=ARMBSET,
//             PARM='DIZ,ARMOPTS=ARM$OPTS'
//STEPLIB   DD DISP=SHR,DSN=RMD.INST1110.BMCLINK
//                   DD DISP=SHR,DSN=SYS3.DIZ.DSNEXIT
//                   DD DISP=SHR,DSN=CSGI.DB2V10M.DSNLOAD
//ARMMSGS   DD DISP=SHR,DSN=RMD.INST1110.BMCCNTL(ARMMSGS)
//ARMPRINT  DD SYSOUT=*
//ARMERROR  DD SYSOUT=*
//*RMTRACE  DD SYSOUT=*
//ARMIN     DD *
   SET CURRENT SQLID = RDAWXP
   ;
   START RW
     OBJECTSET RDAWXP.BIGOBJECTSET
   ;
//*------------------------------------------------------------
//* ARMBSET READS OBJECTSETS (OBJECTSET) FROM THE BMC COMMON DB2
//* REPOSITORY AND PROCESSES ALL OBJECTS IN THE OBJECTSET
//* ACCORDING THE COMMAND.
//*------------------------------------------------------------
//*
//*  >>-SET CURRENT SQLID = <sqlid>------------------------------->>
//*
//*                        |--UNSET--|---<options>----<objset def>---->>
//*                        |--NONE---|
//*                        |--CHECK--|
//*                        |--REPAIR-|
//*  >>-CHECK_PEND_ACTION--|
//*                        |--LEVELID|------------<objset def>------|
//*                                  |                              |->>
//*                                  |------------<objpatt def>-----|
//*
//*  >>-QUIESCE-----------------------------------<objset def>---->>
//*
//*  >>-RUNSTATS----------------------------------<objset def>---->>
//*
//*  >>-RESET_GRECP_LPL------------------------------------------->>
//*
//*  >>-START--------|---RW----------|------------<objset def>---->>
//*                  |---RO----------|
//*                  |---UT----------|
//*                  |---FORCE-------|
//*
//*  >>-STOP--------------------------------------<objset def>---->>
//*
//*  >>-WAIT---------|  1 to 86400   |  ( number of seconds )
//*
//*  <options>
//*
//*  >>-RECOVERTYPE--|---TOCURRENT---|-------->>
//*                  |---TOCOPY------|
//*                  |---TOQUIESCE---|
//*                  |---TOCOMMONPT--|
//*                  |---TOLOGPOINT--|
//*                  |---TOTIMESTAMP-|
//*                  |---TOLOGMARK---|
//*
//*  >>-BACKOUT------|---YES---------|-------->>
//*                  |---NO----------|
//*                  |---AUTO--------|
//*
//*  >>-INDEX -------|---REBUILD ----|-------->>
//*                  |---RECOVER-----|
//*
//*  >>-CLONE--------------------------------->>
//*
//*  >>-REPAIRTS-----|---YES---------|-------->>
//*                  |---NO----------|
//*
//*  >>-WRITE--------|---YES---------|-------->>
//*                  |---NO----------|
//*
//*  >>-REPORT-------|---YES---------|-------->>
//*                  |---NO----------|
//*
//*  >>-UPDATE-------|---ALL---------|-------->>
//*                  |---ACCESSPATH--|
//*                  |---SPACE-------|
//*                  |---NONE--------|
//*
//*  >>-SHRLEVEL-----|---REFERENCE---|-------->>
//*                  |---CHANGE------|
//*
//*  <objset def>
//*
//*  >>-OBJECTSET----ObjectSetName------------>>
//*
//*  <objpatt def>
//*
//*  >>-OBJECT_PATTERN----dbname.tsname------->>
//*       ... wildcards allowed
//*


Related topic

Creating-and-working-with-object-sets



 

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