Example 1: Previewing the recovery plan

This example illustrates the use of the ANALYZE ONLY option with RECOVER TABLESPACE to obtain a preview of the recovery plan.

When you use the ANALYZE ONLY option, BMC AMI Recover determines the data sets required for recovery and produces a recovery plan. This example also uses the SYSPICK DD statement to list all of the tape and cartridge volumes that will be dynamically allocated during recovery. The JCL for this example is in the following figure:

Related topic

Examples-of-BMC-AMI-Recover-jobs

JCL using ANALYZE ONLY

//AFREX01 JOB (PAFR),'EXAMPLE 1',
//        CLASS=Q,
//        MSGCLASS=X,NOTIFY=&SYSUID
/*ROUTE XEQ BMCPLX1
/*JOBPARM SYSAFF=DB2A
//*
//RECOVER EXEC PGM=AFRMAIN,REGION=0M,
//             PARM='DEJM,EXAMPLE01,NEW/RESTART'
//STEPLIB DD DISP=SHR,DSN=product.libraries
//         DD DISP=SHR,DSN=DB2.DSNEXIT
//         DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSIN     DD *
RECOVER TABLESPACE BMCDBSMP.BMCTS011
   LOGSORT ANALYZE ONLY
/*
//SYSPICK   DD SYSOUT=*
//

The remaining figures show the following output files from this BMC AMI Recover job:

AFRSUMRY
AFRSTMT
AFROSUM
AFRPLAN
SYSPICK

See the table in, BMC-AMI-Recover-data-sets-and-BMC-AMI-Recover-DD-statements, for a description of each of these files.

AFRSUMRY using ANALYZE ONLY

BMC40018I BMC AMI Recover for Db2 V13.1.00    (RECOVER AFRSUMRY)
BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2023
BMC96173I BMC AMI Recover TECHNOLOGY IS PROTECTED BY U.S. PATENTS 7,133,884 7,769,718 7,933,927 8,161,001 8,671,076 8,818,949
          8,843,449 9,152,659 9,753,811 10,366,074 AND 10,565,070
BMC40474I CONTACT BMC SUPPORT AT 1-800-537-1813 OR EMAIL TO SUPPORT@BMC.COM

BMC40001I UTILITY EXECUTION STARTING 03/07/2022 19:15:58


BMC96010I BMC AMI Recover for Db2 V13.1.00 BASE
BMC40876I MAINT: NO BMC AMI Recover for Db2 PTFS APPLIED

BMC96010I SOLUTION COMMON CODE V13.1.00 BASE
BMC40876I MAINT: BPJ1541 BPJ1713 BPJ2211

BMC96010I BMCSORT ENGINE V2.4.01
BMC40876I MAINT: NO BMCSORT ENGINE PTFS APPLIED

BMC40002I UTILITY ID = EXAMPLE01. DB2 SUBSYSTEM ID = DEJM.
BMC40094I ATTEMPTING TO CONNECT TO DB2 SUBSYSTEM DEJM, USING PLAN AFR1311T
BMC40024I SUCCESSFUL CONNECT TO DEJM (RELEASE 1210 OF DB2) USING PLAN AFR1311T

BMC40475I INPUT STATEMENTS PRINTED IN AFRSTMT

BMC40336I ANALYZE FINISHED.
BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:00
BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00
BMC96414I      ZIIP TIME    = 00:00:00, UTILITY ZIIP TIME    = 00:00:00
BMC96415I      ZIIP ON CP   = 00:00:00, UTILITY ZIIP ON CP   = 00:00:00
BMC40336I PLANNING FINISHED.
BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:00
BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00
BMC96414I      ZIIP TIME    = 00:00:00, UTILITY ZIIP TIME    = 00:00:00
BMC96415I      ZIIP ON CP   = 00:00:00, UTILITY ZIIP ON CP   = 00:00:00

BMC40005I UTILITY EXECUTION COMPLETE 03/07/2022 19:15:59, RETURN CODE = 0

AFRSTMT using ANALYZE ONLY

BMC40018I BMC AMI Recover for Db2 V13.1.00    (RECOVER AFRSTMT)
BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2023
BMC96173I BMC AMI Recover TECHNOLOGY IS PROTECTED BY U.S. PATENTS 7,133,884 7,769,718 7,933,927 8,161,001 8,671,076 8,818,949
          8,843,449 9,152,659 9,753,811 10,366,074 AND 10,565,070
BMC40474I CONTACT BMC SUPPORT AT 1-800-537-1813 OR EMAIL TO SUPPORT@BMC.COM

BMC40931I PARM LIST:   DB2 SSID = DEJM
BMC40932I                UTILID = EXAMPLE01
BMC40009I UTILITY NEW/RESTART REQUESTED - SYNCPOINT RESTART WILL OCCUR IF UTILID IS IN BMCUTIL
BMC40933I               RESTART = NEW/RESTART
BMC40930I        PARM NOT CODED - MSGLEVEL(1)
BMC40930I        PARM NOT CODED - CHECKPT
BMC40930I        PARM NOT CODED - RDB2STAT
BMC40930I        PARM NOT CODED - AFROPTS
BMC40930I        PARM NOT CODED - ACAOPTS
BMC96035I ----- DEFAULT OPTIONS:
BMC40924I              PLANRECV = AFR1311T       (MAIN PLAN)
BMC40408I         BINDQUALIFIER = BMCAFRA        (QUALIFIER USED FOR DYNAMIC BIND)
BMC40241I            PUBLICPLAN = YES            (GRANT PLAN TO PUBLIC)
BMC96003I                  ZIIP = ENABLED        (ZIIP PROCESSOR ENABLEMENT)
BMC40547I              INDEXLOG = NO             (DEFAULT USE OF INDEXLOG STRATEGY)
BMC40941I                IXRECP = NO             (SET INDEX RECOVER PENDING)
BMC96233I               BACKOUT = AUTO           (DEFAULT POINT-IN-TIME RECOVERY STRATEGY)
BMC40944I              OPNDB2ID = YES            (ACQUIRE RACF AUTHORITY OF DB2)
BMC40927I              RDB2STAT = YES            (RESET DB2 OBJECT STATUS)
BMC40946I                AMSCAT = NO             (USE 'CATALOG' IN IDCAMS INPUT)
BMC40938I                WKUNIT = SYSALLDA       (WORK UNIT NAME)
BMC40878I                  WTOR = YES            (ISSUE WTOR IF SPACE REMAINS IN STOPP STATUS)
BMC96034I           USEHDROBIDS = YES            (USE HEADER PAGE IDS FOR OBIDXLAT)
BMC96246I                 RICHK = NO             (CHECK RI OBJECTS)
BMC96277I                DEFINE = NO             (INSTANTIATE DEFINE NO OBJECTS)
BMC96235I                   AUX = NO             (INCLUDE XML/LOB/ALL/HISTORY/ARCHIVE OBJECTS)
BMC40926I               CHECKPT = PHASE          (CHECKPOINTING)
BMC40945I              CHECKINT = 0              (CHECKPOINT INTERVAL MINUTES)
BMC40537I               ERRCONT = 10             (DEFAULT MAX SEVERE ERRORS)
BMC40956I                RCLTSK = 10             (MAXIMUM RECALL TASKS)
BMC40925I                TBUFFS = 1000           (BUFFER MANAGER PAGES)
BMC96245I               HISTORY = YES            (UPDATE BMCHIST TABLE)
BMC96426I              MATCHING = AUTO           (ENFORCE SCHEMA MATCHING IN IMPORT AND MIGRATE)
BMC96035I ----- DEFAULT OPTIONS: SORT
BMC40928I                SMCORE = (    0K,   0K) (SORT CORE VALUES)
BMC40893I                RESINV = (    0K)       (MEMORY BELOW 16MB EXCLUDED FROM USE BY SORT)
BMC40962I              SORTDEVT = SORT DEFAULT   (DEVICE TYPE FOR LOG AND INDEX SORTS)
BMC40963I               SORTNUM = SORT DEFAULT   (WORK DATASETS FOR LOG AND INDEX SORTS)
BMC96230I            KSORTSHARE = YES            (KEY SORTS SHARED BY ALL TASKS)
BMC40942I              MAXKSORT = 12 (DEFAULT) (MAX CONCURRENT INDEX KEY SORTS)
BMC96192I              MAXLSORT = 50             (MAX CONCURRENT LOG SORTS)
BMC40891I              MAXDRIVE = 0              (DEFAULT MAX TAPE DRIVES)
BMC40892I               MAXLOGS = 3              (DEFAULT MAX CONCURRENT LOG FILES)
BMC96035I ----- DEFAULT OPTIONS: OUTPUT COPIES
BMC40964I               OUTCOPY = ASCODED        (OUTCOPY CREATION DIRECTIVE)
BMC96221I              AUTOSIZE = YES            (AUTO SIZE OUTPUT COPIES AND OUTPUT ACCUM FILES)
BMC96033I                 EATTR = NONE           (EXTENDED ATTRIBUTES FOR DYNAMIC ALLOCATION OF OUTPUT COPIES)
BMC96035I ----- DEFAULT OPTIONS: ESTIMATION
BMC96251I            DISKIORATE = 100            (DISK READ RATE IN MB/SEC)
BMC96252I               CPUMIPS = 200            (CPU PROCESSING SPEED IN MIPS)
BMC96035I ----- DEFAULT RESOURCE SELECTION SEQUENCE FOR LOCAL SITE
BMC96113I                COPIES = (FC,LP,LB)     (DEFAULT SEQUENCE FOR IMAGE COPIES)
BMC96114I                ACCUMS = (LP,LB)        (DEFAULT SEQUENCE FOR CA FILES)
BMC96112I                  LOGS = (ACT1,ACT2     (DEFAULT SEQUENCE FOR LOG FILES)
BMC96112I                          ARC1,ARC2)
BMC96035I ----- DEFAULT RESOURCE SELECTION SEQUENCE FOR REMOTE SITE
BMC96113I                COPIES = (RP,RB,FC)     (DEFAULT SEQUENCE FOR IMAGE COPIES)
BMC96114I                ACCUMS = (RP,RB)        (DEFAULT SEQUENCE FOR CA FILES)
BMC96112I                  LOGS = (ACT1,ACT2     (DEFAULT SEQUENCE FOR LOG FILES)
BMC96112I                          ARC1,ARC2)
BMC96035I ----- TAPE DEVICES
BMC40967I         TAPE DEVICE01 = 3590-1
BMC40967I         TAPE DEVICE02 = 3490
BMC40967I         TAPE DEVICE03 = 3480X
BMC40967I         TAPE DEVICE04 = ATLVTS
BMC40967I         TAPE DEVICE05 = ATL3592
BMC40967I         TAPE DEVICE06 = CART
BMC40967I         TAPE DEVICE07 = CARTVTS
BMC40967I         TAPE DEVICE08 = DLM3480
BMC40967I         TAPE DEVICE09 = DLM3490
BMC40967I         TAPE DEVICE10 = DLM3590
BMC40967I         TAPE DEVICE11 = D3480
BMC40967I         TAPE DEVICE12 = IBMATL
BMC40967I         TAPE DEVICE13 = IBMVTS
BMC40967I         TAPE DEVICE14 = PHXATL
BMC40967I         TAPE DEVICE15 = 3480
BMC40967I         TAPE DEVICE16 = 3400-9
BMC40967I         TAPE DEVICE17 = SYS3480R
BMC40967I         TAPE DEVICE18 = SYS348XR

BMC96010I BMC AMI Recover for Db2 V13.1.00 BASE
BMC40876I MAINT: NO BMC AMI Recover for Db2 PTFS APPLIED

BMC96010I SOLUTION COMMON CODE V13.1.00 BASE
BMC40876I MAINT: BPJ1541 BPJ1713 BPJ2211

BMC96010I BMCSORT ENGINE V2.4.01
BMC40876I MAINT: NO BMCSORT ENGINE PTFS APPLIED
BMC40020I EBCDIC CCSID = 37
BMC96014I DB2 SITE TYPE = LOCAL
BMC40020I DB2 CURRENT FUNCTION LEVEL IS V12R1M509
BMC40020I DB2 HIGHEST ACTIVATED FUNCTION LEVEL IS V12R1M509
BMC40020I DB2 CATALOG LEVEL IS V12R1M509
BMC40020I DB2 CODE LEVEL IS V12R1M510
BMC40954I AVAILABLE MEMORY BELOW THE LINE = 8700K, TOTAL AVAILABLE MEMORY (AT LEAST) = 1035544K
BMC40037I UTILID EXAMPLE01 WAS NOT FOUND IN THE BMCUTIL TABLE - UTILITY WILL RUN AS IF 'NEW' WERE SPECIFIED

BMC40611I INPUT STATEMENTS:
BMC40101I   RECOVER TABLESPACE BMCDBSMP.BMCTS011
BMC40101I       LOGSORT ANALYZE ONLY
BMC40101I

BMC96292I BACKOUT NO WILL BE USED FOR RECOVER TO CURRENT

BMC96020I USE OF REAL-TIME STATISTICS ENABLED FOR REBUILD SORT ESTIMATION
BMC40937I z/OS RELEASE = 2.4.00, PID = HBB77C0, SMS RELEASE = 2.4.0
BMC40157I AVAILABLE REGION BELOW 16M = 8700K, AVAILABLE REGION ABOVE 16M = 1026816K, NUMBER OF CPUS = 7

BMC40335I ANALYZE STARTING 03/07/2022 19:15:59

BMC40335I CATALOG LOOKUP STARTING 03/07/2022 19:15:59
BMC40633I USING STANDARD DB2 SECURITY

BMC40705I VOLUMES IN STOGROUP RMDSGSMS WILL BE USED IN THE FOLLOWING ORDER:
BMC40707I       (<SMS VOLUME>)
BMC40336I CATALOG LOOKUP FINISHED.
BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:00
BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

BMC40335I SYNCHRONIZATION STARTING 03/07/2022 19:15:59
BMC40336I SYNCHRONIZATION FINISHED.
BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:00
BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00
BMC96306I MAXLSORT REDUCED FROM 50 TO 17 DUE TO MEMORY CONSTRAINTS
BMC96004I ZIIP ENABLED (0) USING SUBSYSTEM XBMB

BMC40335I PLANNING STARTING 03/07/2022 19:15:59
BMC40066I TIME TO READ SYSLGRNX WAS 00:00:00

BMC40512I LOG FILE RESOURCES:
BMC40302I    DSN = DEJMCAT.ARCHLOG1.A0104414

BMC40566I    USING LOG DEJMCAT.ARCHLOG1.A0104414 FOR PROCESSING
BMC40555I       FROMRBA = X'00000000251A14BF5000' TORBA = X'00000000251A14C264D2'

AFROSUM using ANALYZE ONLY

BMC40018I BMC AMI Recover for Db2 V13.1.00    (RECOVER AFROSUM)
BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2023
BMC96173I BMC AMI Recover TECHNOLOGY IS PROTECTED BY U.S. PATENTS 7,133,884 7,769,718 7,933,927 8,161,001 8,671,076 8,818,949
          8,843,449 9,152,659 9,753,811 10,366,074 AND 10,565,070
BMC40474I CONTACT BMC SUPPORT AT 1-800-537-1813 OR EMAIL TO SUPPORT@BMC.COM


BMC40709I OBJECT SUMMARY:
BMC40301I    TABLESPACE = BMCDBSMP.BMCTS011
BMC40713I         PARTITION = 1 OF 1
BMC40711I       DBID = X'8997' PSID = X'0002'
BMC40712I       ORIGINAL STATUS = RW
BMC40716I          STOGROUP = RMDSGSMS PRIQTY = -1 SECQTY = -1
BMC96154I          PARTITIONED BY GROWTH
BMC40734I          PAGE SIZE = 4K SEGSIZE = 64 DSSIZE = 4G
BMC40723I          ENCODING SCHEME = EBCDIC


BMC40820I       TABLESPACE RECOVERY
BMC40827I       LOG RESOURCE RANGE:
BMC40585I          FROM LOGPOINT = X'00000000251A14B72AC1' TO LOGPOINT = X'00000000251A5300E16F'
BMC40727I       DISCRETE LOG RANGE(S):
BMC40555I          FROMRBA = X'00000000251A14BF56AC' TORBA = X'00000000251A14C1C4D2'

BMC40840I       INPUT COPY / SYSCOPY DATA:
BMC40640I          2022-03-07 19.12.02.1205 RBA/LRSN X'00000000251A14B72AC1' FULL IMAGE COPY
BMC40302I             DSN = RDAJBM.BMCDBSMP.BMCTS011.P000.FACGFGGP
BMC40641I                SHRLEVEL = CHANGE SITETYPE = LP DSNUM = 0
BMC40640I          2022-03-07 19.12.03.7943 RBA/LRSN X'00000000251A14BEB44C' QUIESCE UTILITY POINT - WRITE(YES)
BMC40640I          2022-03-07 19.12.14.2080 RBA/LRSN X'00000000251A14C27B45' QUIESCE UTILITY POINT - WRITE(YES)

AFRPLAN using ANALYZE ONLY

BMC40018I BMC AMI Recover for Db2 V13.1.00    (RECOVER AFRPLAN)
BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2023
BMC96173I BMC AMI Recover TECHNOLOGY IS PROTECTED BY U.S. PATENTS 7,133,884 7,769,718 7,933,927 8,161,001 8,671,076 8,818,949
          8,843,449 9,152,659 9,753,811 10,366,074 AND 10,565,070
BMC40474I CONTACT BMC SUPPORT AT 1-800-537-1813 OR EMAIL TO SUPPORT@BMC.COM



BMC40755I ANALYSIS PLAN SUMMARY:


BMC40701I PHASE: LOG INPUT
BMC40721I   PHASE INITIALIZATION:
BMC40738I       INITIALIZE LOG RECORD SORT 1
BMC40814I          ESTIMATED RECORD SIZE = 1000
BMC40813I          ESTIMATED NUMBER OF RECORDS = 205
BMC40738I       ALLOCATE 2 POINTER BUFFERS (73584 BYTES EACH)
BMC40702I    STEP: READ LOG PAGES
BMC40736I     STEP INITIALIZATION:
BMC40738I       ALLOCATE INPUT LOG FILE
BMC40302I          DSN = DEJMCAT.ARCHLOG1.A0104414
BMC40741I     STEP PROCESSING:
BMC40738I       FILE OPTIMIZATION
BMC40738I       OPEN LOG DATASET
BMC40302I          DSN = DEJMCAT.ARCHLOG1.A0104414
BMC40738I       ALLOCATE LOG DATASET BUFFER(S)
BMC40738I       PREPARE LOG FOR PROCESSING
BMC40302I          DSN = DEJMCAT.ARCHLOG1.A0104414
BMC40704I       50 PAGES FROM PAGE NUMBER 56802
BMC40738I       CLOSE LOG DATASET
BMC40302I          DSN = DEJMCAT.ARCHLOG1.A0104414
BMC40738I       DEALLOCATE INPUT LOG FILE
BMC40302I          DSN = DEJMCAT.ARCHLOG1.A0104414
BMC40738I       FREE 3 LOG DATASET BUFFER(S)
BMC40737I     STEP TERMINATION:
BMC40735I   PHASE TERMINATION:
BMC40738I       END LOG RECORD SORT INPUT 1
BMC40738I       FREE POINTER BUFFER

BMC40701I PHASE: MERGE
BMC40721I   PHASE INITIALIZATION:
BMC40301I    TABLESPACE = BMCDBSMP.BMCTS011
BMC40305I         DSNUM = 1
BMC40738I       ALLOCATE 3 LOG RECORD BUFFER(S) (81920 BYTES EACH)
BMC40738I       ALLOCATE INPUT IMAGE COPY FILE
BMC40302I          DSN = RDAJBM.BMCDBSMP.BMCTS011.P000.FACGFGGP
BMC40738I       FILE OPTIMIZATION
BMC40738I       ALLOCATE 2 INPUT FILE BUFFER(S)
BMC40738I       OPEN IMAGE COPY FILE
BMC40302I          DSN = RDAJBM.BMCDBSMP.BMCTS011.P000.FACGFGGP
BMC40738I       SET RECOVERY PENDING (RECP) FLAG
BMC40738I       CREATE SPACE
BMC40345I          SPACE = BMCDBSMP.BMCTS011
BMC40305I             DSNUM = 1
BMC40738I       ALLOCATE SPACE (READ/WRITE)
BMC40345I          SPACE = BMCDBSMP.BMCTS011
BMC40305I             DSNUM = 1
BMC40738I       CONNECT TO SPACE
BMC40738I       FILE OPTIMIZATION
BMC40738I       ALLOCATE 2 SPACE OUTPUT BUFFER(S)
BMC40702I    STEP: MERGE SPACE
BMC40738I       MERGE SPACE
BMC40301I          TABLESPACE = BMCDBSMP.BMCTS011
BMC40305I               DSNUM = 1
BMC40735I   PHASE TERMINATION:
BMC40738I       DISCONNECT FROM SPACE
BMC40738I       DEALLOCATE SPACE
BMC40345I          SPACE = BMCDBSMP.BMCTS011
BMC40305I             DSNUM = 1
BMC40738I       FREE 2 OUTPUT SPACE BUFFER(S)
BMC40738I       CLOSE IMAGE COPY FILE
BMC40302I          DSN = RDAJBM.BMCDBSMP.BMCTS011.P000.FACGFGGP
BMC40738I       FREE 2 INPUT FILE BUFFER(S)
BMC40738I       DEALLOCATE INPUT IMAGE COPY FILE
BMC40302I          DSN = RDAJBM.BMCDBSMP.BMCTS011.P000.FACGFGGP
BMC40738I       RESET RECOVERY PENDING (RECP) FLAG
BMC40738I       END LOG RECORD SORT
BMC40738I       FREE 3 LOG RECORD BUFFER(S)
BMC40738I       REGISTER RECOVER TO CURRENT IN SYSCOPY
BMC40738I       RECORD RESTART INFORMATION

SYSPICK using ANALYZE ONLY

DATE 03/07/2022      BMC AMI Recover for Db2           PAGE 001 of 001
TIME 19:15:59           VOLUME PICK LIST
                        BY VOLUME SERIAL NUMBER
VOLSER   DEV TYPE   DATASET NAME                                   SEQ
730626   CART       DEJMCAT.ARCHLOG1.A0104414                      0002
DATE 03/07/2022      BMC AMI Recover for Db2           PAGE 001 of 001
TIME 19:15:59           VOLUME PICK LIST
                           BY ORDER OF USAGE
VOLSER   DEV TYPE   DATASET NAME                                   SEQ
730626   CART       DEJMCAT.ARCHLOG1.A0104414                      0002

Example 1: Previewing the recovery plan

On this page