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

Example 2B: Using RECOVER INDEX


In the second job in this example, the index is recovered from image copies and log.

Note that this job uses MSGLEVEL(2), which produces all of the output produced by the default of MSGLEVEL(1) and the AFRPLAN.

JCL for a simple RECOVER TABLESPACE and RECOVER INDEX

//AFREX02B JOB (PAFR),'EXAMPLE 2B',
//         CLASS=Q,
//         MSGCLASS=X,NOTIFY=&SYSUID
/*ROUTE XEQ BMCPLX1
/*JOBPARM SYSAFF=DB2A
//*
//RECOVER EXEC PGM=AFRMAIN,REGION=0M,
//             PARM='DGE,EX02B,NEW/RESTART,MSGLEVEL(2)'
//STEPLIB  DD DISP=SHR,DSN=product.libraries
//         DD DISP=SHR,DSN=DB2.DSNEXIT
//         DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSIN     DD *
 OPTIONS EARLYRECALL INDEXLOG YES
 RECOVER TABLESPACE BMCDBSMP.BMCTS011
 RECOVER INDEX (RMD.BMCIX011)
/*
//

The remaining figures show the following output files produced by this JCL:

  • AFRSUMRY
  • AFRSTMT
  • AFRPRINT
  • AFRPR001
  • AFRPR002
  • AFROSUM
  • AFRPLAN

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


AFRSUMRY for a simple RECOVER INDEX

BMC40018I BMC AMI Recover for Db2 V12.1.00
 BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2020
 BMC96173I BMC AMI Recover TECHNOLOGY IS PROTECTED BY U.S. PATENTS 7,133,884 7,769,718 AND 8,161,001
 BMC40474I CONTACT BMC SUPPORT AT 1-800-537-1813 OR EMAIL TO SUPPORT@BMC.COM

 BMC40001I UTILITY EXECUTION STARTING 08/17/2012 13:39:16

 BMC40018I BMC AMI Recover for Db2 V12.1.00
 BMC40876I MAINT:  NO BMC AMI Recover PTFS APPLIED

 BMC96010I SOLUTION COMMON CODE V11.1.01
 BMC40876I MAINT:  NO SOLUTION COMMON CODE PTFS APPLIED

 BMC96010I BMCSORT ENGINE V2.3.01
 BMC40876I MAINT:  BPJ0195  BPJ0198  BPJ0209  BPJ0250  BPJ0263  BPJ0269  BPJ0279
 BMC40876I MAINT:  BPJ0288  BPJ0308  BPJ0343  BPJ0357  BPJ0361  BPJ0374  BPJ0390
 BMC40876I MAINT:  BPJ0404  BPJ0473  BPJ0503  BPJ0521

 BMC40002I UTILITY ID = EX02B. DB2 SUBSYSTEM ID = DXW .
 BMC40094I ATTEMPTING TO CONNECT TO DB2 SUBSYSTEM DXW , USING PLAN AFRB111T
 BMC40342I A GROUP ATTACH WAS PERFORMED WITH DXW
 BMC40024I SUCCESSFUL CONNECT TO W4   (RELEASE 910 OF DB2) USING PLAN AFRB111T
 BMC40067I DB2 W4   IS MEMBER DXW4 IN DATA SHARING GROUP DSNDXW

 BMC40475I INPUT STATEMENTS PRINTED IN AFRSTMT

 BMC40336I ANALYZE FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:02, UTILITY ELAPSED TIME = 00:00:03
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40336I PLANNING FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:01, UTILITY ELAPSED TIME = 00:00:05
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40336I PLAN EXECUTION FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:13, UTILITY ELAPSED TIME = 00:00:19
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:01

 BMC40476I EXECUTION SUMMARY
 BMC40477I      TABLE SPACES / PHASES (PARTITIONS) RECOVERED   :  1 (0)
 BMC40478I      INDEX SPACES / PHASES (PARTITIONS) RECOVERED   :  1 (0)
 BMC40479I      LOG RECORDS APPLIED                   :  12498

 BMC40005I UTILITY EXECUTION COMPLETE 08/17/2012 13:39:36, RETURN CODE = 0


AFRSTMT for a simple RECOVER INDEX

BMC40018I BMC AMI Recover for Db2 V12.1.00
 BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2020
 BMC96173I BMC AMI Recover TECHNOLOGY IS PROTECTED BY U.S. PATENTS 7,133,884 7,769,718 AND 8,161,001
 BMC40474I CONTACT BMC SUPPORT AT 1-800-537-1813 OR EMAIL TO SUPPORT@BMC.COM

 BMC40931I PARM LIST:   DB2 SSID = DXW
 BMC40932I                UTILID = EX02B
 BMC40009I UTILITY NEW/RESTART REQUESTED - SYNCPOINT RESTART WILL OCCUR IF UTILID IS IN BMCUTIL
 BMC40933I               RESTART = NEW/RESTART
 BMC40934I              MSGLEVEL = 2
 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 = AFRB111T       (MAIN PLAN)
 BMC40408I         BINDQUALIFIER = BMCAFR         (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)
 BMC96235I                   AUX = NO             (INCLUDE XML/LOB/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)
 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 = 10  (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 = CRT8NS
 BMC40967I         TAPE DEVICE09 = CRT9NS
 BMC40967I         TAPE DEVICE10 = DANBARR
 BMC40967I         TAPE DEVICE11 = EXT3592
 BMC40967I         TAPE DEVICE12 = IBMATL
 BMC40967I         TAPE DEVICE13 = IBMVTS
 BMC40967I         TAPE DEVICE14 = PHXATL
 BMC40967I         TAPE DEVICE15 = SA3590
 BMC40967I         TAPE DEVICE16 = TAPEABL
 BMC40967I         TAPE DEVICE17 = 3590B
 BMC40967I         TAPE DEVICE18 = 3590E
 BMC40967I         TAPE DEVICE19 = 3480
 BMC40967I         TAPE DEVICE20 = 3400-9
 BMC40967I         TAPE DEVICE21 = SYS3480R
 BMC40967I         TAPE DEVICE22 = SYS348XR

 BMC40018I BMC AMI Recover for Db2 V12.1.00
 BMC40876I MAINT:  NO BMC AMI Recover PTFS APPLIED

 BMC96010I SOLUTION COMMON CODE V11.1.01
 BMC40876I MAINT:  NO SOLUTION COMMON CODE PTFS APPLIED

 BMC96010I BMCSORT ENGINE V2.3.01
 BMC40876I MAINT:  BPJ0195  BPJ0198  BPJ0209  BPJ0250  BPJ0263  BPJ0269  BPJ0279
 BMC40876I MAINT:  BPJ0288  BPJ0308  BPJ0343  BPJ0357  BPJ0361  BPJ0374  BPJ0390
 BMC40876I MAINT:  BPJ0404  BPJ0473  BPJ0503  BPJ0521

 BMC40335I PACKAGE CHECKING AND BINDING STARTING 08/17/2012 13:39:17
 BMC40336I PACKAGE CHECKING AND BINDING FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40020I EBCDIC CCSID = 37
 BMC96014I DB2 VERSION = 910  SITE TYPE = LOCAL  MODE = NFM
 BMC40954I AVAILABLE MEMORY BELOW THE LINE = 10068K, TOTAL AVAILABLE MEMORY (AT LEAST) = 1373600K
 BMC40037I UTILID EX02B WAS NOT FOUND IN THE BMCUTIL TABLE - UTILITY WILL RUN AS IF 'NEW' WERE SPECIFIED

 BMC40611I INPUT STATEMENTS:
 BMC40101I   OPTION EARLYRECALL INDEXLOG YES
 BMC40101I   RECOVER TABLESPACE BMCDBSMP.BMCTS011
 BMC40101I   RECOVER INDEX (RMD.BMCIX011)
 BMC40101I
 BMC40959I INDEXLOG YES STRATEGY REQUESTED
 BMC96020I USE OF REAL-TIME STATISTICS ENABLED FOR REBUILD SORT ESTIMATION
 BMC96004I ZIIP ENABLED (0) USING SUBSYSTEM ACP1
 BMC40937I z/OS RELEASE = 1.13.00,  PID = HBB7780,  SMS RELEASE = 1.13.0
 BMC40157I AVAILABLE REGION BELOW 16M = 10056K, AVAILABLE REGION ABOVE 16M = 1362352K, NUMBER OF CPUS = 5
 BMC40020I BYT:0, 0, 0; BLK:0, 0, 0; TOT:860944, 5115972, 5115972;iter: 1; RC:4

 BMC40335I ANALYZE STARTING 08/17/2012 13:39:17

 BMC40335I CATALOG LOOKUP STARTING 08/17/2012 13:39:17
 BMC40336I PROC RO STMT FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40336I SCAN SYSTB FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40336I SCAN SYSIX FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40336I COL LOOKUP FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40336I SCAN SYSKY FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40336I SCAN SYSFL FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40336I TS LOOKUP FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40633I USING STANDARD DB2 SECURITY

 BMC40336I DB LOOKUP FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40336I TB LOOKUP FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40336I IP LOOKUP FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40336I SG LOOKUP FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40705I VOLUMES IN STOGROUP SYSDEFLT WILL BE USED IN THE FOLLOWING ORDER:
 BMC40707I       (<sms volume>,<sms volume>,<sms volume>,<sms volume>,<sms volume>,<sms volume>,<sms volume>,<sms volume>
 BMC40707I       <sms volume>,<sms volume>,<sms volume>,<sms volume>,<sms volume>,<sms volume>,<sms volume>,<sms volume>
 BMC40707I       <sms volume>,<sms volume>,<sms volume>,<sms volume>,<sms volume>)
 BMC40336I SCAN SYSVOL FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40336I CHK DS FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40336I HDR PG RD FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40336I SYSCOPY LOOKUP FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40336I CATALOG LOOKUP FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00


 BMC40335I SYNCHRONIZATION STARTING 08/17/2012 13:39:17
 BMC40025I OUTPUT FROM COMMAND '-STO DB(BMCDBSMP) SPACE(BMCTS011) AT (COMMIT)' FOLLOWS:
 BMC40020I DSN9022I  *DXW4 DSNTDDIS 'STOP DATABASE' NORMAL COMPLETION
 BMC40025I OUTPUT FROM COMMAND '-STO DB(BMCDBSMP) SPACE(BMCIX011) AT(COMMIT)' FOLLOWS:
 BMC40020I DSN9022I  *DXW4 DSNTDDIS 'STOP DATABASE' NORMAL COMPLETION
 BMC40336I SYNCHRONIZATION FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:02, UTILITY ELAPSED TIME = 00:00:03
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC96306I MAXLSORT REDUCED FROM 50 TO 22 DUE TO MEMORY CONSTRAINTS
 BMC40336I DDSCAN FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:03
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00


 BMC40335I PLANNING STARTING 08/17/2012 13:39:20
 BMC40459I BSDS DSNDXW.DXW4.BSDS01 SELECTED
 BMC40459I BSDS DSNDXW.DXW3.BSDS01 SELECTED
 BMC40066I TIME TO READ SYSLGRNX WAS 00:00:00
 BMC40459I BSDS DSNDXW.DXW4.BSDS01 SELECTED
 BMC40459I BSDS DSNDXW.DXW3.BSDS01 SELECTED
 BMC40459I BSDS DSNDXW.DXW1.BSDS01 SELECTED
 BMC40459I BSDS DSNDXW.DXW2.BSDS01 SELECTED

 BMC40512I LOG FILE RESOURCES:
 BMC40302I    DSN = DSNDXW.DXW1.LOGCOPY1.DS02.DATA
 BMC40302I    DSN = DSNDXW.DXW3.LOGCOPY1.DS02.DATA
 BMC40302I    DSN = DSNDXW.DXW4.LOGCOPY1.DS01.DATA
 BMC40302I    DSN = DSNDXW.DXW2.LOGCOPY1.DS04.DATA

 BMC40566I    USING LOG DSNDXW.DXW1.LOGCOPY1.DS02.DATA FOR PROCESSING
 BMC40555I       FROMRBA  = X'000000000221FB0DF000'  TORBA  = X'000000000222060A6FFF'
 BMC40566I    USING LOG DSNDXW.DXW3.LOGCOPY1.DS02.DATA FOR PROCESSING
 BMC40555I       FROMRBA  = X'00000000018750C8C000'  TORBA  = X'0000000001875BC53FFF'
 BMC40566I    USING LOG DSNDXW.DXW4.LOGCOPY1.DS01.DATA FOR PROCESSING
 BMC40555I       FROMRBA  = X'00000000015B8AF7D000'  TORBA  = X'00000000015B95F44FFF'
 BMC40566I    USING LOG DSNDXW.DXW2.LOGCOPY1.DS04.DATA FOR PROCESSING
 BMC40555I       FROMRBA  = X'0000000001C85AD13000'  TORBA  = X'0000000001C91C2D2FFF'
 BMC40189I THE 0 TAPE AND 4 DISK LOG FILES WILL BE READ IN 2 LOG READING STEPS BECAUSE MAXDRIVES = 0 AND MAXLOGS = 3

 BMC40335I PLAN EXECUTION STARTING 08/17/2012 13:39:22
 BMC40025I OUTPUT FROM COMMAND '-STA DB(BMCDBSMP) SPACE(BMCTS011)  ACCESS(RW)' FOLLOWS:
 BMC40020I DSN9022I  *DXW4 DSNTDDIS 'START DATABASE' NORMAL COMPLETION
 BMC40025I OUTPUT FROM COMMAND '-STA DB(BMCDBSMP) SPACE(BMCIX011)  ACCESS(RW)' FOLLOWS:
 BMC40020I DSN9022I  *DXW4 DSNTDDIS 'START DATABASE' NORMAL COMPLETION


AFRPRINT for a simple RECOVER INDEX

BMC40018I BMC AMI Recover for Db2 V12.1.00
 BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2020
 BMC96173I BMC AMI Recover TECHNOLOGY IS PROTECTED BY U.S. PATENTS 7,133,884 7,769,718 AND 8,161,001
 BMC40474I CONTACT BMC SUPPORT AT 1-800-537-1813 OR EMAIL TO SUPPORT@BMC.COM

 BMC96401I LOG INPUT PHASE MESSAGES ARE IN FILE AFRPR001
 BMC96400I MERGE PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR001
 BMC40303I    INDEX = RMD.BMCIX011
 BMC96400I MERGE PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR002
 BMC40301I    TABLESPACE = BMCDBSMP.BMCTS011


AFRPR001 for a simple RECOVER INDEX

BMC40018I BMC AMI Recover for Db2 V12.1.00
 BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2020
 BMC96173I BMC AMI Recover TECHNOLOGY IS PROTECTED BY U.S. PATENTS 7,133,884 7,769,718 AND 8,161,001
 BMC40474I CONTACT BMC SUPPORT AT 1-800-537-1813 OR EMAIL TO SUPPORT@BMC.COM



 BMC40016I LOG INPUT PHASE STARTING 08/17/2012 13:39:22
 BMC40954I AVAILABLE MEMORY BELOW THE LINE = 10044K, TOTAL AVAILABLE MEMORY (AT LEAST) = 1370428K
 BMC40441I BMCSORT PRODUCT LOCATED AND WILL BE USED
 BMC40020I ORG-BEL:0, 0, 0; EXT:0, 0, 0; TOT:858704, 5113732, 5113732;ITER: 1; RC:4
 BMC40020I SYSEVENT STGTEST STORAGE AVAILABLE = 5113732
 BMC40020I OPT-SOPT:SBEL:524288; ABOV:523763712; HYPR:184411136; REAS:0; MMEM:0;  NUMS:2; SEAD:2BE77978; RSV1:0;
 BMC40020I OPT-SENT:AVGR:1000; FSZ:       322; SBEL:262144; ABOV:1835008; HYPR:0;  DATA:0; KEYL:17; RSRV:0; FLG1:80; FLG2:40
 BMC40020I SORT FILE SIZE = 989184, SORT MEMORY = 154079
 BMC40954I AVAILABLE MEMORY BELOW THE LINE = 10044K, TOTAL AVAILABLE MEMORY (AT LEAST) = 1370276K
 BMC40441I BMCSORT PRODUCT LOCATED AND WILL BE USED
 BMC40020I ORG-BEL:0, 0, 0; EXT:0, 0, 0; TOT:857488, 5112516, 5112516;ITER: 1; RC:4
 BMC40020I SYSEVENT STGTEST STORAGE AVAILABLE = 5112516
 BMC40020I OPT-SOPT:SBEL:262144; ABOV:261881856; HYPR:223872000; REAS:0; MMEM:0;  NUMS:1; SEAD:2BE77908; RSV1:0;
 BMC40020I OPT-SENT:AVGR:1000; FSZ:   1236000; SBEL:262144; ABOV:262144000; HYPR:54656;  DATA:0; KEYL:17; RSRV:0; FLG1:80; FLG2:C0
 BMC40020I SORT FILE SIZE = 3796992000, SORT MEMORY = 9546089
 BMC40725I PROCESSING LOG RANGE:
 BMC40302I          DSN = DSNDXW.DXW4.LOGCOPY1.DS01.DATA
 BMC40555I          FROMRBA  = X'00000000015B8AF7D000'  TORBA  = X'00000000015B95F44FFF'
 BMC40724I          DATA SHARING MEMBERID IS 3
 BMC40725I PROCESSING LOG RANGE:
 BMC40302I          DSN = DSNDXW.DXW3.LOGCOPY1.DS02.DATA
 BMC40555I          FROMRBA  = X'00000000018750C8C000'  TORBA  = X'0000000001875BC53FFF'
 BMC40724I          DATA SHARING MEMBERID IS 2
 BMC40725I PROCESSING LOG RANGE:
 BMC40302I          DSN = DSNDXW.DXW1.LOGCOPY1.DS02.DATA
 BMC40555I          FROMRBA  = X'000000000221FB0DF000'  TORBA  = X'000000000222060A6FFF'
 BMC40724I          DATA SHARING MEMBERID IS 1
 BMC40193I 3 LOG DATASET BUFFERS OF 348160 BYTES EACH WERE ALLOCATED
 BMC40302I          DSN = DSNDXW.DXW3.LOGCOPY1.DS02.DATA
 BMC40193I 3 LOG DATASET BUFFERS OF 348160 BYTES EACH WERE ALLOCATED
 BMC40302I          DSN = DSNDXW.DXW1.LOGCOPY1.DS02.DATA
 BMC40193I 3 LOG DATASET BUFFERS OF 348160 BYTES EACH WERE ALLOCATED
 BMC40302I          DSN = DSNDXW.DXW4.LOGCOPY1.DS01.DATA
 BMC40352I DDNAME SYS00012 (DSN DSNDXW.DXW1.LOGCOPY1.DS02.DATA) WAS SUCCESSFULLY UNALLOCATED
 BMC40352I DDNAME SYS00011 (DSN DSNDXW.DXW4.LOGCOPY1.DS01.DATA) WAS SUCCESSFULLY UNALLOCATED
 BMC40352I DDNAME SYS00010 (DSN DSNDXW.DXW3.LOGCOPY1.DS02.DATA) WAS SUCCESSFULLY UNALLOCATED


 BMC40117I **********     PERFORMANCE STATISTICS FROM LOG READ STEP     **********

 BMC40120I      3 FILES READ     1985 I/O WAITS        I/O WAIT TIME = 00:00:05
 BMC40175I                       2 WAITS FOR THREAD     WAIT TIME = 00:00:00
 BMC40124I                       0 SORT WAITS      SORT WAIT TIME = 00:00:00
 BMC40124I                       1 SORT WAITS      SORT WAIT TIME = 00:00:00
 BMC40172I                       12498 LOG RECORDS AND 819866 BYTES OF LOG DATA PROCESSED

 BMC40302I          DSN = DSNDXW.DXW4.LOGCOPY1.DS01.DATA
 BMC40173I                       TIME SPENT IN DATASET ALLOCATION = 00:00:00
 BMC40174I                       1455 I/O WAITS    I/O WAIT TIME = 00:00:04
 BMC40172I                       0 LOG RECORDS AND 0 BYTES OF LOG DATA PROCESSED

 BMC40302I          DSN = DSNDXW.DXW3.LOGCOPY1.DS02.DATA
 BMC40173I                       TIME SPENT IN DATASET ALLOCATION = 00:00:00
 BMC40174I                       530 I/O WAITS    I/O WAIT TIME = 00:00:00
 BMC40172I                       12498 LOG RECORDS AND 819866 BYTES OF LOG DATA PROCESSED

 BMC40302I          DSN = DSNDXW.DXW1.LOGCOPY1.DS02.DATA
 BMC40173I                       TIME SPENT IN DATASET ALLOCATION = 00:00:00
 BMC40174I                       0 I/O WAITS    I/O WAIT TIME = 00:00:00
 BMC40172I                       0 LOG RECORDS AND 0 BYTES OF LOG DATA PROCESSED

 BMC40725I PROCESSING LOG RANGE:
 BMC40302I          DSN = DSNDXW.DXW2.LOGCOPY1.DS04.DATA
 BMC40555I          FROMRBA  = X'0000000001C85AD13000'  TORBA  = X'0000000001C91C2D2FFF'
 BMC40724I          DATA SHARING MEMBERID IS 4
 BMC40193I 3 LOG DATASET BUFFERS OF 348160 BYTES EACH WERE ALLOCATED
 BMC40302I          DSN = DSNDXW.DXW2.LOGCOPY1.DS04.DATA
 BMC40352I DDNAME SYS00017 (DSN DSNDXW.DXW2.LOGCOPY1.DS04.DATA) WAS SUCCESSFULLY UNALLOCATED


 BMC40117I **********     PERFORMANCE STATISTICS FROM LOG READ STEP     **********

 BMC40120I      1 FILES READ     6255 I/O WAITS        I/O WAIT TIME = 00:00:05
 BMC40175I                       390 WAITS FOR THREAD     WAIT TIME = 00:00:00
 BMC40124I                       0 SORT WAITS      SORT WAIT TIME = 00:00:00
 BMC40124I                       0 SORT WAITS      SORT WAIT TIME = 00:00:00
 BMC40172I                       0 LOG RECORDS AND 0 BYTES OF LOG DATA PROCESSED

 BMC40302I          DSN = DSNDXW.DXW2.LOGCOPY1.DS04.DATA
 BMC40173I                       TIME SPENT IN DATASET ALLOCATION = 00:00:00
 BMC40174I                       6255 I/O WAITS    I/O WAIT TIME = 00:00:05
 BMC40172I                       0 LOG RECORDS AND 0 BYTES OF LOG DATA PROCESSED

 BMC40012I LOG INPUT PHASE COMPLETE. ELAPSED TIME = 00:00:13, TIME SINCE UTILITY START = 00:00:18
 BMC40868I LOG INPUT PHASE COMPLETE. ACCUMULATED TCB TIME = 00:00:01

 BMC40484I MESSAGES FROM PHASE SUBTASK:

 BMC40350I DATA SET DSNDXW.DXW3.LOGCOPY1.DS02.DATA WAS SUCCESSFULLY ALLOCATED TO DDNAME SYS00010 ELAPSED = 00:00:00
 BMC40350I DATA SET DSNDXW.DXW4.LOGCOPY1.DS01.DATA WAS SUCCESSFULLY ALLOCATED TO DDNAME SYS00011 ELAPSED = 00:00:00
 BMC40350I DATA SET DSNDXW.DXW1.LOGCOPY1.DS02.DATA WAS SUCCESSFULLY ALLOCATED TO DDNAME SYS00012 ELAPSED = 00:00:00
 BMC40350I DATA SET DSNDXW.DXW2.LOGCOPY1.DS04.DATA WAS SUCCESSFULLY ALLOCATED TO DDNAME SYS00017 ELAPSED = 00:00:00

 BMC40485I END OF PHASE SUBTASK MESSAGES



 BMC40016I MERGE PHASE STARTING 08/17/2012 13:39:35
 BMC40303I    INDEX = RMD.BMCIX011

 BMC40484I MESSAGES FROM PHASE SUBTASK:

 BMC40417I 1 VSAM DATA SETS NOW ALLOCATED
 BMC40060I PENDING FLAG RBDP SET FOR
 BMC40345I    SPACE = BMCDBSMP.BMCIX011
 BMC40356I AN IDCAMS 'DELETE CLUSTER' OPERATION WAS SUCCESSFUL ON DATASET DSNDXW.DSNDBC.BMCDBSMP.BMCIX011.I0001.A001
 BMC40356I AN IDCAMS 'DEFINE CLUSTER' OPERATION WAS SUCCESSFUL ON DATASET DSNDXW.DSNDBC.BMCDBSMP.BMCIX011.I0001.A001
 BMC40350I DATA SET DSNDXW.DSNDBD.BMCDBSMP.BMCIX011.I0001.A001 WAS SUCCESSFULLY ALLOCATED TO DDNAME SYS00016 ELAPSED = 00:00:00

 BMC40485I END OF PHASE SUBTASK MESSAGES

 BMC40350I DATA SET RDAPXR.BMCDBSMP.BMCIX011.F.T133832 WAS SUCCESSFULLY ALLOCATED TO DDNAME SYS00018 ELAPSED = 00:00:00
 BMC96304I THIS PHASE WILL RUN IN EXECUTION SUBTASK 1
 BMC40593I START MERGE COMPLETE, ELAPSED TIME = 00:00:00
 BMC40102I MERGE INDEXSPACE STEP STARTING
 BMC40795I FULL COPY DATASET IS RDAPXR.BMCDBSMP.BMCIX011.F.T133832
 BMC40799I MERGE STARTING FOR DATA SET DSNDXW.DSNDBD.BMCDBSMP.BMCIX011.I0001.A001
 BMC40593I INITIALIZATION COMPLETE, ELAPSED TIME = 00:00:00
 BMC40088I WAIT TIME FOR SORT OUTPUT PHASE = 00:00:00
 BMC40593I SPIN COMPLETE, ELAPSED TIME = 00:00:00
 BMC40902I TOTAL WAITS = 3, TOTAL WAIT TIME = 00:00:00
 BMC40981I FULL IC RDAPXR.BMCDBSMP.BMCIX011.F.T133832 READ WAITS = 1, WAIT TIME = 00:00:00
 BMC40979I LOG INPUT WAITS = 1, WAIT TIME = 00:00:00
 BMC40905I SPACE WRITE WAITS = 1, WAIT TIME = 00:00:00
 BMC40985I NUMBER OF PAGES READ FROM FULL COPY FOR THIS OBJECT = 20, USED = 20
 BMC40790I NUMBER OF PAGES READ FROM FULL COPY TOTAL = 20, USED = 20
 BMC40792I LOG RECORDS THIS PAGESET:     FROM SORT = 0 (   0 BYTES), SELECTED = 0
 BMC96081I                               APPLIED = 0
 BMC40989I LOG RECORDS TOTAL:            FROM SORT = 0 (   0 BYTES), SELECTED = 0
 BMC96081I                               APPLIED = 0
 BMC40798I NUMBER OF PAGES OUTPUT IS = 20
 BMC40900I MERGE INDEXSPACE STEP COMPLETE
 BMC40593I MERGE PROCESS COMPLETE, ELAPSED TIME = 00:00:00
 BMC40352I DDNAME SYS00016 (DSN DSNDXW.DSNDBD.BMCDBSMP.BMCIX011.I0001.A001) WAS SUCCESSFULLY UNALLOCATED
 BMC40352I DDNAME SYS00018 (DSN RDAPXR.BMCDBSMP.BMCIX011.F.T133832) WAS SUCCESSFULLY UNALLOCATED
 BMC40060I PENDING FLAG RBDP RESET FOR
 BMC40345I    SPACE = BMCDBSMP.BMCIX011
 BMC40091I 08/17/2012 13:39:35 SUBPHASE CHECKPOINT TAKEN FOR MERGE    PHASE
 BMC40012I MERGE PHASE COMPLETE. ELAPSED TIME = 00:00:00, TIME SINCE UTILITY START = 00:00:18
 BMC40868I MERGE PHASE COMPLETE. ACCUMULATED TCB TIME = 00:00:01
1 SYNCSORT FOR Z/OS  2.3.1.0NI   U.S. PATENTS: 4210961, 5117495   (C) 2007 SYNCSORT INC.   DATE=2012/230   TIME=13.39.22
                   BMCSORT ENGINE - IF PROBLEMS, CONTACT BMC SUPPORT AT 1-800-537-1813   z/OS   1.13.0
  $BMCPRM$ : BMSG,EQUALS
  PARMLIST :
  SORT FIELDS=(30,20,BI,A),DYNALLOC,FILSZ=E322
  RECORD TYPE=V,LENGTH=(8192,8192,8192,32,1000)
  OPTION SORTDD=L001,MSGDDN=LOGOU001,AVGRLEN=1000
  WER161B  ALTERNATE PARM USED
  WER164B  2,096K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
  WER164B     44K BYTES RESERVE REQUESTED, 2M BYTES USED
  WER410B  1,792K BYTES OF VIRTUAL STORAGE AVAILABLE ABOVE THE 16MEG LINE,
  WER410B     0 BYTES RESERVE REQUESTED, 1,792K BYTES USED
  WER036B  G=179,B=27984,SEGLEN=5032,BIAS=50
  WER162B  0 PREALLOCATED SORTWORK TRACKS, 960 DYNAMICALLY ALLOCATED,
  WER162B     0 ACQUIRED IN SECONDARY EXTENTS, 0 RELEASED, TOTAL OF 21 TRACKS USED
  WER045C  END SORT PHASE
  WER055I  INSERT      12498, DELETE      12498
  WER416B  L001WK01 : EXCP'S=9,UNIT=3390,DEV=2778,CHP=DFEF,VOL=WRK015
  WER416B  L001WK02 : EXCP'S=3,UNIT=3390,DEV=2782,CHP=DFEF,VOL=WRK024
  WER416B  TOTAL OF 12 EXCP'S ISSUED FOR SORTWORKS
  WER416B  TOTAL OF 12 EXCP'S ISSUED FOR SORTING
  WER246I  FILESIZE 819,866 BYTES
  WER054I  RCD IN          0, OUT          0
  WER072I  EQUALS, ELAP IN EFFECT
  WER169I  RELEASE 2.3 BATCH 0486 TPF LEVEL 0.0
  WER052I  END SYNCSORT - AFREX02B,RECOVER,,DIAG=C800,4290,E03E,6CEC,81C2,6DAA,2260,6662
1 SYNCSORT FOR Z/OS  2.3.1.0NI   U.S. PATENTS: 4210961, 5117495   (C) 2007 SYNCSORT INC.   DATE=2012/230   TIME=13.39.22
                   BMCSORT ENGINE - IF PROBLEMS, CONTACT BMC SUPPORT AT 1-800-537-1813   z/OS   1.13.0
  $BMCPRM$ : BMSG,EQUALS
  PARMLIST :
  SORT FIELDS=(30,20,BI,A),DYNALLOC,FILSZ=E1236000
  RECORD TYPE=V,LENGTH=(8192,8192,8192,32,1000)
  OPTION SORTDD=L002,MSGDDN=LOGOU002,AVGRLEN=1000
  WER161B  ALTERNATE PARM USED
  WER164B  9,628K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
  WER164B     44K BYTES RESERVE REQUESTED, 9,580K BYTES USED
  WER410B  9,324K BYTES OF VIRTUAL STORAGE AVAILABLE ABOVE THE 16MEG LINE,
  WER410B     0 BYTES RESERVE REQUESTED, 9,324K BYTES USED
  WER036B  G=1111,SEGLEN=3888
  WER177I  TURNAROUND SORT PERFORMED
  WER045C  END SORT PHASE
  WER055I  INSERT          0, DELETE          0
  WER416B  TOTAL OF 0 EXCP'S ISSUED FOR SORTING
  WER246I  FILESIZE 0 BYTES
  WER054I  RCD IN          0, OUT          0
  WER072I  EQUALS, ELAP IN EFFECT
  WER169I  RELEASE 2.3 BATCH 0486 TPF LEVEL 0.0
  WER052I  END SYNCSORT - AFREX02B,RECOVER,,DIAG=8A00,C00C,A23E,E0FF,C3C2,6D82,2260,CE62


AFRPR002 for a simple RECOVER INDEX

 BMC40018I BMC AMI Recover for Db2 V12.1.00
 BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2020
 BMC96173I BMC AMI Recover TECHNOLOGY IS PROTECTED BY U.S. PATENTS 7,133,884 7,769,718 AND 8,161,001
 BMC40474I CONTACT BMC SUPPORT AT 1-800-537-1813 OR EMAIL TO SUPPORT@BMC.COM



 BMC40016I MERGE PHASE STARTING 08/17/2012 13:39:35
 BMC40301I    TABLESPACE = BMCDBSMP.BMCTS011

 BMC40484I MESSAGES FROM PHASE SUBTASK:

 BMC40060I PENDING FLAG RECP SET FOR
 BMC40345I    SPACE = BMCDBSMP.BMCTS011
 BMC40356I AN IDCAMS 'DELETE CLUSTER' OPERATION WAS SUCCESSFUL ON DATASET DSNDXW.DSNDBC.BMCDBSMP.BMCTS011.I0001.A001
 BMC40356I AN IDCAMS 'DEFINE CLUSTER' OPERATION WAS SUCCESSFUL ON DATASET DSNDXW.DSNDBC.BMCDBSMP.BMCTS011.I0001.A001
 BMC40350I DATA SET DSNDXW.DSNDBD.BMCDBSMP.BMCTS011.I0001.A001 WAS SUCCESSFULLY ALLOCATED TO DDNAME SYS00014 ELAPSED = 00:00:00
 BMC40417I 2 VSAM DATA SETS NOW ALLOCATED

 BMC40485I END OF PHASE SUBTASK MESSAGES

 BMC40350I DATA SET RDAPXR.BMCDBSMP.BMCTS011.F.T133831 WAS SUCCESSFULLY ALLOCATED TO DDNAME SYS00019 ELAPSED = 00:00:00
 BMC96304I THIS PHASE WILL RUN IN EXECUTION SUBTASK 1
 BMC40593I START MERGE COMPLETE, ELAPSED TIME = 00:00:00
 BMC40102I MERGE TABLESPACE STEP STARTING
 BMC40795I FULL COPY DATASET IS RDAPXR.BMCDBSMP.BMCTS011.F.T133831
 BMC40799I MERGE STARTING FOR DATA SET DSNDXW.DSNDBD.BMCDBSMP.BMCTS011.I0001.A001
 BMC40593I INITIALIZATION COMPLETE, ELAPSED TIME = 00:00:00
 BMC40088I WAIT TIME FOR SORT OUTPUT PHASE = 00:00:00
 BMC40593I SPIN COMPLETE, ELAPSED TIME = 00:00:00
 BMC40401I EXTENT ALLOCATED FOR TABLE SPACE BMCDBSMP.BMCTS011
 BMC40302I          DSN = DSNDXW.DSNDBD.BMCDBSMP.BMCTS011.I0001.A001
 BMC40401I EXTENT ALLOCATED FOR TABLE SPACE BMCDBSMP.BMCTS011
 BMC40302I          DSN = DSNDXW.DSNDBD.BMCDBSMP.BMCTS011.I0001.A001
 BMC40401I EXTENT ALLOCATED FOR TABLE SPACE BMCDBSMP.BMCTS011
 BMC40302I          DSN = DSNDXW.DSNDBD.BMCDBSMP.BMCTS011.I0001.A001
 BMC40902I TOTAL WAITS = 9, TOTAL WAIT TIME = 00:00:00
 BMC40981I FULL IC RDAPXR.BMCDBSMP.BMCTS011.F.T133831 READ WAITS = 1, WAIT TIME = 00:00:00
 BMC40979I LOG INPUT WAITS = 1, WAIT TIME = 00:00:00
 BMC40905I SPACE WRITE WAITS = 7, WAIT TIME = 00:00:00
 BMC40985I NUMBER OF PAGES READ FROM FULL COPY FOR THIS OBJECT = 2503, USED = 2503
 BMC40790I NUMBER OF PAGES READ FROM FULL COPY TOTAL = 2503, USED = 2503
 BMC40792I LOG RECORDS THIS PAGESET:     FROM SORT = 12498 ( 819K BYTES), SELECTED = 12498
 BMC96081I                               APPLIED = 12498
 BMC40989I LOG RECORDS TOTAL:            FROM SORT = 12498 ( 819K BYTES), SELECTED = 12498
 BMC96081I                               APPLIED = 12498
 BMC40798I NUMBER OF PAGES OUTPUT IS = 2503
 BMC40900I MERGE TABLESPACE STEP COMPLETE
 BMC40593I MERGE PROCESS COMPLETE, ELAPSED TIME = 00:00:00
 BMC40352I DDNAME SYS00014 (DSN DSNDXW.DSNDBD.BMCDBSMP.BMCTS011.I0001.A001) WAS SUCCESSFULLY UNALLOCATED
 BMC40352I DDNAME SYS00019 (DSN RDAPXR.BMCDBSMP.BMCTS011.F.T133831) WAS SUCCESSFULLY UNALLOCATED
 BMC40060I PENDING FLAG RECP RESET FOR
 BMC40345I    SPACE = BMCDBSMP.BMCTS011
 BMC40091I 08/17/2012 13:39:35 SUBPHASE CHECKPOINT TAKEN FOR MERGE    PHASE
 BMC40012I MERGE PHASE COMPLETE. ELAPSED TIME = 00:00:00, TIME SINCE UTILITY START = 00:00:19
 BMC40868I MERGE PHASE COMPLETE. ACCUMULATED TCB TIME = 00:00:01


AFROSUM for a simple RECOVER INDEX

BMC40018I BMC AMI Recover for Db2 V12.1.00
 BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2020
 BMC96173I BMC AMI Recover TECHNOLOGY IS PROTECTED BY U.S. PATENTS 7,133,884 7,769,718 AND 8,161,001
 BMC40474I CONTACT BMC SUPPORT AT 1-800-537-1813 OR EMAIL TO SUPPORT@BMC.COM


 BMC40709I OBJECT SUMMARY:
 BMC40301I    TABLESPACE = BMCDBSMP.BMCTS011
 BMC40711I       DBID = X'0267'  PSID = X'000E'
 BMC40712I       ORIGINAL STATUS = RW
 BMC40716I          STOGROUP = SYSDEFLT PRIQTY = 1200 SECQTY = 400
 BMC40710I          PAGE SIZE = 4K  SEGSIZE = 4
 BMC40723I          ENCODING SCHEME = EBCDIC


 BMC40820I       TABLESPACE RECOVERY
 BMC40827I       LOG RESOURCE RANGE:
 BMC40585I          FROM LOGPOINT = X'00CA08AC036260000000'  TO LOGPOINT = X'00CA08AC3005F5000000'
 BMC40727I       DISCRETE LOG RANGE(S):
 BMC40559I          FROMLRSN = X'00CA08AC0434E1000000'  TOLRSN = X'00CA08AC04924C000000'   MEMBER = DXW3     ID = 2
 BMC40555I          FROMRBA  = X'00000000018753BAB1F0'  TORBA  = X'00000000018753C9CAF9'

 BMC40840I       INPUT COPY / SYSCOPY DATA:
 BMC40640I          2012-08-17 13.38.31.4241 RBA/LRSN X'00CA08AC036260000000' FULL IMAGE COPY
 BMC40302I             DSN = RDAPXR.BMCDBSMP.BMCTS011.F.T133831
 BMC40641I                SHRLEVEL = REFERENCE  SITETYPE = LP  DSNUM = 0
 BMC40640I          2012-08-17 13.38.31.5971 RBA/LRSN X'00CA08AC03BB46000000' QUIESCE UTILITY POINT - WRITE(YES)
 BMC40640I          2012-08-17 13.38.32.4810 RBA/LRSN X'00CA08AC04930E000000' QUIESCE UTILITY POINT - WRITE(YES)


 BMC40709I OBJECT SUMMARY:
 BMC40346I    INDEXSPACE = BMCDBSMP.BMCIX011
 BMC40711I       DBID = X'0267'  PSID = X'0011'
 BMC40712I       ORIGINAL STATUS = RW
 BMC40303I       INDEX = RMD.BMCIX011
 BMC96160I          PAGE SIZE = 4K
 BMC40716I          STOGROUP = SYSDEFLT PRIQTY = 60 SECQTY = 40
 BMC40830I       ON TABLE RMD.BMCTB011 (OBID X'000F') IN TABLESPACE BMCDBSMP.BMCTS011
 BMC40836I          TABLE CARDINALITY = -1
 BMC40832I       NON-CLUSTERING INDEX
 BMC40833I       UNIQUE INDEX
 BMC40844I       TYPE 2


 BMC40843I       INDEX RECOVERY
 BMC40827I       LOG RESOURCE RANGE:
 BMC40585I          FROM LOGPOINT = X'00CA08AC03CEDC000000'  TO LOGPOINT = X'00CA08AC3005F5000000'
 BMC40727I       DISCRETE LOG RANGE(S):
 BMC40559I          FROMLRSN = X'00CA08AC03CEDC000000'  TOLRSN = X'00CA08AC3005F5000000'   MEMBER = DXW1     ID = 1
 BMC40555I          FROMRBA  = X'00000000000000000000'  TORBA  = X'FFFFFFFFFFFFFFFFFFFF'
 BMC40559I          FROMLRSN = X'00CA08AC03CEDC000000'  TOLRSN = X'00CA08AC3005F5000000'   MEMBER = DXW3     ID = 2
 BMC40555I          FROMRBA  = X'00000000000000000000'  TORBA  = X'FFFFFFFFFFFFFFFFFFFF'
 BMC40559I          FROMLRSN = X'00CA08AC03CEDC000000'  TOLRSN = X'00CA08AC3005F5000000'   MEMBER = DXW4     ID = 3
 BMC40555I          FROMRBA  = X'00000000000000000000'  TORBA  = X'FFFFFFFFFFFFFFFFFFFF'
 BMC40559I          FROMLRSN = X'00CA08AC03CEDC000000'  TOLRSN = X'00CA08AC3005F5000000'   MEMBER = DXW2     ID = 4
 BMC40555I          FROMRBA  = X'00000000000000000000'  TORBA  = X'FFFFFFFFFFFFFFFFFFFF'

 BMC40840I       INPUT COPY / SYSCOPY DATA:
 BMC40640I          2012-08-17 13.38.31.8216 RBA/LRSN X'00CA08AC03CEDC000000' FULL IMAGE COPY
 BMC40302I             DSN = RDAPXR.BMCDBSMP.BMCIX011.F.T133832
 BMC40641I                SHRLEVEL = REFERENCE  SITETYPE = LP  DSNUM = 0
 BMC40640I          2012-08-17 13.38.32.4810 RBA/LRSN X'00CA08AC04930E000000' QUIESCE UTILITY POINT - WRITE(YES)


AFRPLAN for a simple RECOVER INDEX

BMC40018I BMC AMI Recover for Db2 V12.1.00
 BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2020
 BMC96173I BMC AMI Recover TECHNOLOGY IS PROTECTED BY U.S. PATENTS 7,133,884 7,769,718 AND 8,161,001
 BMC40474I CONTACT BMC SUPPORT AT 1-800-537-1813 OR EMAIL TO SUPPORT@BMC.COM



 BMC40700I EXECUTION 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 = 322
 BMC40738I       ALLOCATE 2 POINTER BUFFERS (53092 BYTES EACH)
 BMC40738I       INITIALIZE LOG RECORD SORT 2
 BMC40814I          ESTIMATED RECORD SIZE = 1000
 BMC40813I          ESTIMATED NUMBER OF RECORDS = 1236000
 BMC40738I       ALLOCATE 2 POINTER BUFFERS (53092 BYTES EACH)
 BMC40702I    STEP:  READ LOG PAGES
 BMC40736I     STEP INITIALIZATION:
 BMC40738I       ALLOCATE INPUT LOG FILE
 BMC40302I          DSN = DSNDXW.DXW4.LOGCOPY1.DS01.DATA
 BMC40738I       ALLOCATE INPUT LOG FILE
 BMC40302I          DSN = DSNDXW.DXW3.LOGCOPY1.DS02.DATA
 BMC40738I       ALLOCATE INPUT LOG FILE
 BMC40302I          DSN = DSNDXW.DXW1.LOGCOPY1.DS02.DATA
 BMC40741I     STEP PROCESSING:
 BMC40738I       FILE OPTIMIZATION
 BMC40738I       OPEN LOG DATASET
 BMC40302I          DSN = DSNDXW.DXW4.LOGCOPY1.DS01.DATA
 BMC40738I       ALLOCATE LOG DATASET BUFFER(S)
 BMC40738I       PREPARE LOG FOR PROCESSING
 BMC40302I          DSN = DSNDXW.DXW4.LOGCOPY1.DS01.DATA
 BMC40704I       45000 PAGES FROM PAGE NUMBER 0
 BMC40738I       FILE OPTIMIZATION
 BMC40738I       OPEN LOG DATASET
 BMC40302I          DSN = DSNDXW.DXW3.LOGCOPY1.DS02.DATA
 BMC40738I       ALLOCATE LOG DATASET BUFFER(S)
 BMC40738I       PREPARE LOG FOR PROCESSING
 BMC40302I          DSN = DSNDXW.DXW3.LOGCOPY1.DS02.DATA
 BMC40704I       45000 PAGES FROM PAGE NUMBER 0
 BMC40738I       FILE OPTIMIZATION
 BMC40738I       OPEN LOG DATASET
 BMC40302I          DSN = DSNDXW.DXW1.LOGCOPY1.DS02.DATA
 BMC40738I       ALLOCATE LOG DATASET BUFFER(S)
 BMC40738I       PREPARE LOG FOR PROCESSING
 BMC40302I          DSN = DSNDXW.DXW1.LOGCOPY1.DS02.DATA
 BMC40704I       45000 PAGES FROM PAGE NUMBER 0
 BMC40738I       CLOSE LOG DATASET
 BMC40302I          DSN = DSNDXW.DXW4.LOGCOPY1.DS01.DATA
 BMC40738I       DEALLOCATE INPUT LOG FILE
 BMC40302I          DSN = DSNDXW.DXW4.LOGCOPY1.DS01.DATA
 BMC40738I       FREE 3 LOG DATASET BUFFER(S)
 BMC40738I       CLOSE LOG DATASET
 BMC40302I          DSN = DSNDXW.DXW3.LOGCOPY1.DS02.DATA
 BMC40738I       DEALLOCATE INPUT LOG FILE
 BMC40302I          DSN = DSNDXW.DXW3.LOGCOPY1.DS02.DATA
 BMC40738I       FREE 3 LOG DATASET BUFFER(S)
 BMC40738I       CLOSE LOG DATASET
 BMC40302I          DSN = DSNDXW.DXW1.LOGCOPY1.DS02.DATA
 BMC40738I       DEALLOCATE INPUT LOG FILE
 BMC40302I          DSN = DSNDXW.DXW1.LOGCOPY1.DS02.DATA
 BMC40738I       FREE 3 LOG DATASET BUFFER(S)
 BMC40737I     STEP TERMINATION:
 BMC40702I    STEP:  READ LOG PAGES
 BMC40736I     STEP INITIALIZATION:
 BMC40738I       ALLOCATE INPUT LOG FILE
 BMC40302I          DSN = DSNDXW.DXW2.LOGCOPY1.DS04.DATA
 BMC40741I     STEP PROCESSING:
 BMC40738I       FILE OPTIMIZATION
 BMC40738I       OPEN LOG DATASET
 BMC40302I          DSN = DSNDXW.DXW2.LOGCOPY1.DS04.DATA
 BMC40738I       ALLOCATE LOG DATASET BUFFER(S)
 BMC40738I       PREPARE LOG FOR PROCESSING
 BMC40302I          DSN = DSNDXW.DXW2.LOGCOPY1.DS04.DATA
 BMC40704I       792000 PAGES FROM PAGE NUMBER 0
 BMC40738I       CLOSE LOG DATASET
 BMC40302I          DSN = DSNDXW.DXW2.LOGCOPY1.DS04.DATA
 BMC40738I       DEALLOCATE INPUT LOG FILE
 BMC40302I          DSN = DSNDXW.DXW2.LOGCOPY1.DS04.DATA
 BMC40738I       FREE 3 LOG DATASET BUFFER(S)
 BMC40737I     STEP TERMINATION:
 BMC40735I   PHASE TERMINATION:
 BMC40738I       END LOG RECORD SORT INPUT 1
 BMC40738I       FREE POINTER BUFFER
 BMC40738I       END LOG RECORD SORT INPUT 2
 BMC40738I       FREE POINTER BUFFER

 BMC40701I PHASE:  MERGE
 BMC40721I   PHASE INITIALIZATION:
 BMC40301I    TABLESPACE = BMCDBSMP.BMCTS011
 BMC40738I       ALLOCATE 3 LOG RECORD BUFFER(S) (81920 BYTES EACH)
 BMC40738I       ALLOCATE INPUT IMAGE COPY FILE
 BMC40302I          DSN = RDAPXR.BMCDBSMP.BMCTS011.F.T133831
 BMC40738I       FILE OPTIMIZATION
 BMC40738I       ALLOCATE 2 INPUT FILE BUFFER(S)
 BMC40738I       OPEN IMAGE COPY FILE
 BMC40302I          DSN = RDAPXR.BMCDBSMP.BMCTS011.F.T133831
 BMC40738I       ALLOCATE PAGE CHECK BUFFER (4096 BYTES)
 BMC40738I       ALLOCATE SPACEMAP BUFFER (4096 BYTES)
 BMC40738I       ALLOCATE PASTE BUFFER (4096 BYTES)
 BMC40738I       SET RECOVERY PENDING (RECP) FLAG
 BMC40738I       CREATE SPACE
 BMC40345I          SPACE = BMCDBSMP.BMCTS011
 BMC40738I       ALLOCATE SPACE (READ/WRITE)
 BMC40345I          SPACE = BMCDBSMP.BMCTS011
 BMC40738I       CONNECT TO SPACE
 BMC40738I       ALLOCATE PAGE CHECK BUFFER (4096 BYTES)
 BMC40738I       FILE OPTIMIZATION
 BMC40738I       ALLOCATE 2 SPACE OUTPUT BUFFER(S)
 BMC40738I       ALLOCATE SPACEMAP BUFFER (4096 BYTES)
 BMC40738I       ALLOCATE PASTE BUFFER (4096 BYTES)
 BMC40702I    STEP:  MERGE SPACE
 BMC40738I       MERGE SPACE
 BMC40301I          TABLESPACE = BMCDBSMP.BMCTS011
 BMC40735I   PHASE TERMINATION:
 BMC40738I       DISCONNECT FROM SPACE
 BMC40738I       DEALLOCATE SPACE
 BMC40345I          SPACE = BMCDBSMP.BMCTS011
 BMC40738I       FREE PAGE CHECK BUFFER
 BMC40738I       FREE SPACEMAP BUFFER
 BMC40738I       FREE PASTE BUFFER
 BMC40738I       FREE 2 OUTPUT SPACE BUFFER(S)
 BMC40738I       FREE PAGE CHECK BUFFER
 BMC40738I       FREE PASTE BUFFER
 BMC40738I       FREE SPACEMAP BUFFER
 BMC40738I       CLOSE IMAGE COPY FILE
 BMC40302I          DSN = RDAPXR.BMCDBSMP.BMCTS011.F.T133831
 BMC40738I       FREE 2 INPUT FILE BUFFER(S)
 BMC40738I       DEALLOCATE INPUT IMAGE COPY FILE
 BMC40302I          DSN = RDAPXR.BMCDBSMP.BMCTS011.F.T133831
 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

 BMC40701I PHASE:  MERGE
 BMC40721I   PHASE INITIALIZATION:
 BMC40303I    INDEX = RMD.BMCIX011
 BMC40738I       ALLOCATE 3 LOG RECORD BUFFER(S) (81920 BYTES EACH)
 BMC40738I       ALLOCATE INPUT IMAGE COPY FILE
 BMC40302I          DSN = RDAPXR.BMCDBSMP.BMCIX011.F.T133832
 BMC40738I       FILE OPTIMIZATION
 BMC40738I       ALLOCATE 2 INPUT FILE BUFFER(S)
 BMC40738I       OPEN IMAGE COPY FILE
 BMC40302I          DSN = RDAPXR.BMCDBSMP.BMCIX011.F.T133832
 BMC40738I       ALLOCATE PAGE CHECK BUFFER (4096 BYTES)
 BMC40738I       ALLOCATE SPACEMAP BUFFER (4096 BYTES)
 BMC40738I       ALLOCATE PASTE BUFFER (4096 BYTES)
 BMC40738I       SET REBUILD PENDING (RBDP) FLAG
 BMC40738I       CREATE SPACE
 BMC40345I          SPACE = BMCDBSMP.BMCIX011
 BMC40738I       ALLOCATE SPACE (READ/WRITE)
 BMC40345I          SPACE = BMCDBSMP.BMCIX011
 BMC40738I       CONNECT TO SPACE
 BMC40738I       ALLOCATE PAGE CHECK BUFFER (4096 BYTES)
 BMC40738I       FILE OPTIMIZATION
 BMC40738I       ALLOCATE 2 SPACE OUTPUT BUFFER(S)
 BMC40738I       ALLOCATE SPACEMAP BUFFER (4096 BYTES)
 BMC40738I       ALLOCATE PASTE BUFFER (4096 BYTES)
 BMC40702I    STEP:  MERGE SPACE
 BMC40738I       MERGE SPACE
 BMC40303I          INDEX = RMD.BMCIX011
 BMC40735I   PHASE TERMINATION:
 BMC40738I       DISCONNECT FROM SPACE
 BMC40738I       DEALLOCATE SPACE
 BMC40345I          SPACE = BMCDBSMP.BMCIX011
 BMC40738I       FREE PAGE CHECK BUFFER
 BMC40738I       FREE SPACEMAP BUFFER
 BMC40738I       FREE PASTE BUFFER
 BMC40738I       FREE 2 OUTPUT SPACE BUFFER(S)
 BMC40738I       FREE PAGE CHECK BUFFER
 BMC40738I       FREE PASTE BUFFER
 BMC40738I       FREE SPACEMAP BUFFER
 BMC40738I       CLOSE IMAGE COPY FILE
 BMC40302I          DSN = RDAPXR.BMCDBSMP.BMCIX011.F.T133832
 BMC40738I       FREE 2 INPUT FILE BUFFER(S)
 BMC40738I       DEALLOCATE INPUT IMAGE COPY FILE
 BMC40302I          DSN = RDAPXR.BMCDBSMP.BMCIX011.F.T133832
 BMC40738I       RESET REBUILD PENDING (RBDP) FLAG
 BMC40738I       END LOG RECORD SORT
 BMC40738I       FREE 3 LOG RECORD BUFFER(S)
 BMC40738I       REGISTER RECOVER TO CURRENT IN BMCXCOPY
 BMC40738I       RECORD RESTART INFORMATION


 

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