Example 2A: Using REBUILD INDEX

In the first job in this example, the index is rebuilt from the rows in this recovered image.

Note the use of the NOWORKDDN option to send the extracted index keys directly to the sort routine. Also, note the use of MSGLEVEL(0), which produces less output than the default of MSGLEVEL(1).

JCL for a simple RECOVER TABLESPACE and REBUILD INDEX

//AFREX02B JOB (5225),'EXAMPLE 2A',
//         CLASS=Q,
//         MSGCLASS=X,NOTIFY=&SYSUID
/*ROUTE XEQ BMCPLX1
/*JOBPARM SYSAFF=DB2B
//*
//RECOVER EXEC PGM=AFRMAIN,REGION=0M,
//             PARM='DEJM,EXAMPLE2B,NEW/RESTART,MSGLEVEL(2)'
//STEPLIB DD DSN=RMD.TEST1311.BMCPSWD.AFR,DISP=SHR PASSWORD
//        DD DSN=AFR.TEST1311.UDBLINK,DISP=SHR     OPTIONS MODULES
//        DD DSN=SCC.TEST1310.LOAD,DISP=SHR        SCC MODULES-XBM V620
//        DD DSN=RMD.TEST1311.BMCLINK,DISP=SHR     ROLLUP
//        DD DISP=SHR,DSN=CSGI.DB2V12M.DSNLOAD
//        DD DISP=SHR,DSN=CSG.DEJM.DSNEXIT
//SYSIN     DD *
  OPTION EARLYRECALL INDEXLOG YES
  RECOVER TABLESPACE BMCDBSMP.BMCTS011
  RECOVER INDEX (RMD.BMCIX011)
/*

//AFREX02A JOB (5225),'EXAMPLE 2A',
//         CLASS=Q,
//         MSGCLASS=X,NOTIFY=&SYSUID
/*ROUTE XEQ BMCPLX1
/*JOBPARM SYSAFF=DB2B
//*
//RECOVER EXEC PGM=AFRMAIN,REGION=0M,
//             PARM='DEJM,EXAMPLE2A,NEW,MSGLEVEL(0)'
//STEPLIB DD DSN=RMD.TEST1311.BMCPSWD.AFR,DISP=SHR PASSWORD
//        DD DSN=AFR.TEST1311.UDBLINK,DISP=SHR     OPTIONS MODULES
//        DD DSN=SCC.TEST1310.LOAD,DISP=SHR        SCC MODULES-XBM V620
//        DD DSN=RMD.TEST1311.BMCLINK,DISP=SHR     ROLLUP
//        DD DISP=SHR,DSN=CSGI.DB2V12M.DSNLOAD
//        DD DISP=SHR,DSN=CSG.DEJM.DSNEXIT
//SYSIN     DD *
  OPTION EARLYRECALL INDEXLOG NO
  RECOVER TABLESPACE BMCDBSMP.BMCTS011
  REBUILD INDEX (RMD.BMCIX011) NOWORKDDN
/*

The remaining three figures show the output produced by this JCL, which includes the following files:

AFRSUMRY
AFRSTMT
AFRPR001

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

AFRSUMRY for a simple REBUILD INDEX

BMC40018I BMC AMI Recover for Db2 V13.1.00    (RECOVER AFRSUMRY)
BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2022
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/04/2022 15:26:22


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 = EXAMPLE2A. 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
BMC40336I PLAN EXECUTION FINISHED.
BMC40287I      ELAPSED TIME = 00:00:01, UTILITY ELAPSED TIME = 00:00:01
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

BMC40476I EXECUTION SUMMARY
BMC40477I      TABLE SPACES (PARTITIONS) RECOVERED   : 1 (1)
BMC40479I      LOG RECORDS APPLIED / PROCESSED       : 697 / 698
BMC40480I      INDEXES (PARTITIONS) REBUILT          : 1 (0)

BMC40005I UTILITY EXECUTION COMPLETE 03/04/2022 15:26:24, RETURN CODE = 4

AFRSTMT for a simple REBUILD INDEX

BMC40018I BMC AMI Recover for Db2 V13.1.00    (RECOVER AFRSTMT)
BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2022
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 = EXAMPLE2A
BMC40008I UTILITY REPLACEMENT ('NEW') REQUESTED
BMC40933I               RESTART = NEW
BMC40934I              MSGLEVEL = 0
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

BMC40611I INPUT STATEMENTS:
BMC40101I   OPTION EARLYRECALL INDEXLOG NO
BMC40101I   RECOVER TABLESPACE BMCDBSMP.BMCTS011
BMC40101I   REBUILD INDEX (RMD.BMCIX011) NOWORKDDN
BMC40101I
BMC40960I INDEXLOG STRATEGY DISABLED

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/04/2022 15:26:22

BMC40335I CATALOG LOOKUP STARTING 03/04/2022 15:26:22
BMC40633I USING STANDARD DB2 SECURITY

BMC40705I VOLUMES IN STOGROUP SYSDEFLT WILL BE USED IN THE FOLLOWING ORDER:
BMC40707I       (<SMS VOLUME>,<SMS VOLUME>,<SMS VOLUME>)
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/04/2022 15:26:22
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 11 DUE TO MEMORY CONSTRAINTS
BMC96004I ZIIP ENABLED (0) USING SUBSYSTEM XBMB

BMC40335I PLANNING STARTING 03/04/2022 15:26:22

BMC40512I LOG FILE RESOURCES:
BMC40302I    DSN = DEJMCAT.LOGCOPY1.DS01.DATA

BMC40566I    USING LOG DEJMCAT.LOGCOPY1.DS01.DATA FOR PROCESSING
BMC40555I       FROMRBA = X'0000000024D40C54E000' TORBA = X'0000000024D40C59889A'

BMC40335I PLAN EXECUTION STARTING 03/04/2022 15:26:22

AFRP001 for a simple REBUILD INDEX

BMC40018I BMC AMI Recover for Db2 V13.1.00    (RECOVER AFRPR001)
BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2022
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

BMC40483I LOG INPUT COMPLETE.
BMC40483I MERGE COMPLETE.
BMC40301I          TABLESPACE = BMCDBSMP.BMCTS011
BMC40269I             PARTITION = 1
BMC40483I BUILD COMPLETE.
BMC40303I          INDEX = RMD.BMCIX011

Example 2A: Using REBUILD INDEX

On this page