Example 9: Recovering to a non Db2 data set

Recovering to data sets not used by Db2 is useful for testing or for setting up recovered spaces to switch to while READ ONLY access continues to the real data sets.

Although INDEP INTABLESPACE is not explicitly specified with REBUILD INDEX in the SYSIN statement in the recovery JCL in the following figure, BMC AMI Recover assumes it and defaults to the RECOVER TABLESPACE non Db2 data set for index data input.

Related topics

Examples-of-BMC-AMI-Recover-jobs

INDEP-OUTSPACE

INDEP-INTABLESPACE

INDEPENDENT-OUTSPACE

JCL for simple table space and index recovery to non Db2 data sets

//AFREX10 JOB (PAFR),'EXAMPLE 9',
//         class="Q",NOTIFY=&SYSUID,
//         MSGCLASS=X
//*
//RECOVER EXEC PGM=AFRMAIN,REGION=0M,
//             PARM='DEJM,EXAMPLE9,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 *
 RECOVER TABLESPACE BMCDBSMP.BMCTS012 INDEP OUTSPACE
 REBUILD INDEX (RMD.BMCIX010) INDEP OUTSPACE NOWORKDDN
/*
//

Directing recovery output

When you use the BMC AMI Recover redirection feature to direct the output of a table space or index recovery to a data set other than the one normally used by Db2 or to extract index information from such a data set, you must construct your RECOVER statements according to the following rules:

  • When you specify redirection of the recovery output in a RECOVER TABLESPACE statement, you append the keyword INDEPENDENT (which you can abbreviate to INDEP) followed by OUTSPACE and (optionally) the model data set name (dataSetName) to the statement as follows:

       RECOVER TABLESPACE tableSpaceSpecification
           INDEP OUTSPACE optional dataSetName model
           other recovery options

    Important

    BMC AMI Recover requires consistent use of the INDEP OUTSPACE option across all commands; if you use INDEP OUTSPACE with one command, you must use it with all other commands that support it. If you use INDEP OUTSPACE but subsequently omit it from another command that supports it, BMC AMI Recover issues an error message.

  • When you specify redirection of the recovery output in a REBUILD INDEX or RECOVER BUILDINDEX statement, you insert INDEP OUTSPACE before the table space specification, as follows:

       REBUILD INDEX ... INDEP OUTSPACE optional dataSetName model
           optional tableSpaceSpecification
           other recovery options
       RECOVER BUILDINDEX ... INDEP OUTSPACE
           optional dataSetName model
           optional tableSpaceSpecification
           other recovery options

  • When you rebuild indexes from data that resides in an independent data set, you must also redirect the input for the index rebuild as follows:

       REBUILD INDEX ... INDEP OUTSPACE optional dataSetName model
           optional tableSpaceSpecification
           INDEP INTABLESPACE optional dataSetName model
           other recovery options

    In addition, if the SYSIN statement in which the REBUILD INDEX appears also includes a RECOVER TABLESPACE statement that specifies redirection, any data set name model specified with INDEP INTABLESPACE must agree with the RECOVER TABLESPACE data set name model. If you do not specify INDEP INTABLESPACE explicitly, BMC AMI Recover assumes it and defaults to the RECOVER TABLESPACE data set name model for index data input.

    BMC AMI Recover does not allow:

    • The recovery of indexes into Db2 data sets when the corresponding table space recovery is to a non Db2 (independent) data set
    • The recovery of indexes into Db2 data sets when the source data for the table space is a non Db2 data set

    That is, if you specify INDEP INTABLESPACE in a REBUILD INDEX statement, you must also specify INDEP OUTSPACE. Similarly, if an index rebuild implies an INDEP INTABLESPACE (because it is in the same SYSIN statement as a RECOVER TABLESPACE with an INDEP OUTSPACE clause for the related table space), the REBUILD INDEX must also have an INDEP OUTSPACE clause.

  • If you are extracting index keys (using a RECOVER UNLOADKEYS statement) from data that has already been redirected to an independent data set, you insert INDEP INTABLESPACE after the table space specification as follows:

       RECOVER UNLOADKEYS ... optional table space
           specification
           INDEP INTABLESPACE optional dataSetName model
           other recovery options

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

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

AFRSUMRY for recovering to a non Db2 data set

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 = EXAMPLE10B. DB2 SUBSYSTEM ID = DEJM.
 BMC40094I ATTEMPTING TO CONNECT TO DB2 SUBSYSTEM DEJM, USING PLAN AFRB131T
 BMC40024I SUCCESSFUL CONNECT TO DEJM (RELEASE 1310 OF DB2) USING PLAN AFRB131T

 BMC40475I INPUT STATEMENTS PRINTED IN AFRSTMT

 BMC40336I ANALYZE 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 PLANNING FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:03, 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:00, UTILITY ELAPSED TIME = 00:00:05
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40476I EXECUTION SUMMARY
 BMC40477I      TABLE SPACES / PHASES (PARTITIONS) RECOVERED   :  1 (0)
 BMC40480I      INDEXES REBUILT                       :  1

 BMC40005I UTILITY EXECUTION COMPLETE 03/20/2022 09:51:35, RETURN CODE = 4

AFRPRINT for recovering to a non Db2 data set

 BMC96400I MERGE PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR001
 BMC40301I    TABLESPACE = BMCDBSMP.BMCTS010
 BMC96400I BUILD PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR001
 BMC40303I    INDEX = RMD.BMCIX010

AFRPR001 for recovering to a non Db2 data set

BMC40018I BMC AMI Recover for Db2 V13.1.00    (RECOVER  AFRPR001)                                                            
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  

 BMC40016I MERGE PHASE STARTING 03/20/2022 09:51:35
 BMC40301I    TABLESPACE = BMCDBSMP.BMCTS010
 BMC40793I    EXTRACTING KEYS FOR:
 BMC40303I         INDEX = RMD.BMCIX010
 BMC40350I DATA SET RDAPXR.BMCDBSMP.BMCTS010.F.T095108 WAS SUCCESSFULLY ALLOCATED TO DDNAME SYS00004 ELAPSED = 00:00:00
 BMC40350I DATA SET DEJMCAT.BMCDBD.BMCDBSMP.BMCTS010.I0001.A001 WAS SUCCESSFULLY ALLOCATED TO DDNAME SYS00006 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.BMCTS010.F.T095108
 BMC40799I MERGE STARTING FOR DATA SET DEJMCAT.BMCDBD.BMCDBSMP.BMCTS010.I0001.A001
 BMC40593I INITIALIZATION COMPLETE, ELAPSED TIME = 00:00:00
 BMC40593I SPIN COMPLETE, ELAPSED TIME = 00:00:00
 BMC40906I NUMBER OF PAGES EXAMINED = 0, ROWS EXAMINED = 0, KEYS EXTRACTED = 0
 BMC40907I INDIRECT REFERENCES: FORWARD = 0, BACKWARD = 0
 BMC40902I TOTAL WAITS = 1, TOTAL WAIT TIME = 00:00:00
 BMC40981I FULL IC RDAPXR.BMCDBSMP.BMCTS010.F.T095108 READ WAITS = 0, WAIT TIME = 00:00:00
 BMC40905I SPACE WRITE WAITS = 1, WAIT TIME = 00:00:00
 BMC40980I KEY OUTPUT WAITS = 0, WAIT TIME = 00:00:00
 BMC40985I NUMBER OF PAGES READ FROM FULL COPY FOR THIS OBJECT = 2, USED = 2
 BMC40790I NUMBER OF PAGES READ FROM FULL COPY TOTAL = 2, USED = 2
 BMC40798I NUMBER OF PAGES OUTPUT IS = 2
 BMC40900I MERGE TABLESPACE STEP COMPLETE
 BMC40593I MERGE PROCESS COMPLETE, ELAPSED TIME = 00:00:00
 BMC40352I DDNAME SYS00006 (DSN DEJMCAT.BMCDBD.BMCDBSMP.BMCTS010.I0001.A001) WAS SUCCESSFULLY UNALLOCATED
 BMC40352I DDNAME SYS00004 (DSN RDAPXR.BMCDBSMP.BMCTS010.F.T095108) WAS SUCCESSFULLY UNALLOCATED
 BMC40091I 03/20/2022 09:51:35 SUBPHASE CHECKPOINT TAKEN FOR MERGE    PHASE
 BMC40012I MERGE PHASE COMPLETE. ELAPSED TIME = 00:00:00, TIME SINCE UTILITY START = 00:00:05
 BMC40868I MERGE PHASE COMPLETE. ACCUMULATED TCB TIME = 00:00:00


 BMC40016I BUILD PHASE STARTING 03/20/2022 09:51:35
 BMC40303I    INDEX = RMD.BMCIX010

 BMC40484I MESSAGES FROM PHASE SUBTASK:

 BMC40350I DATA SET DEJMCAT.BMCDBD.BMCDBSMP.BMCIX010.I0001.A001 WAS SUCCESSFULLY ALLOCATED TO DDNAME SYS00005 ELAPSED = 00:00:00
 BMC40417I 1 VSAM DATA SETS NOW ALLOCATED

 BMC40485I END OF PHASE SUBTASK MESSAGES

 BMC96304I THIS PHASE WILL RUN IN EXECUTION SUBTASK 1
 BMC40102I BUILD INDEX STEP STARTING
 BMC40593I START BUILD COMPLETE, ELAPSED TIME = 00:00:00
 BMC40366I BUFFER CREATED FOR PAGE SIZE 4K, REFRESH=1
 BMC40367I RANDOM BUFFER: NUMBER OF PAGES = 1000, MINIMUM CLEAN = 100, NUMBER TO WRITE PER I/O = 100
 BMC40368I RANDOM BUFFER: MAXIMUM OUTSTANDING WRITES = 5, MAXIMUM OUTSTANDING READS = 50, HASH HEADS = 1111
 BMC40369I SEQUENTIAL BUFFER: NUMBER OF CYLINDERS = 5, IDLE CYLINDERS = 1, CI'S PER CYLINDER = 180
 BMC40593I INITIALIZATION COMPLETE, ELAPSED TIME = 00:00:00
 BMC40593I GOT FIRST KEY BUFFER COMPLETE, ELAPSED TIME = 00:00:00
 BMC40593I READING AND INSERTING ALL KEYS COMPLETE, ELAPSED TIME = 00:00:00
 BMC40775W THERE ARE NO KEY VALUES FOR INDEX RMD.BMCIX010
 BMC40370I BUFFER MANAGER TERMINATION, GET PAGE COUNT = 7, RANDOM SEARCH COUNT = 2
 BMC40372I    TOTAL WAITS IN BUFFER MANAGER = 1
 BMC40373I    RANDOM WRITE WAITS = 0, RANDOM READ WAITS = 0, RANDOM SYNC WAITS = 0
 BMC40374I    CYLINDER WAITS = 1, SEQUENTIAL SYNC WAITS = 0
 BMC40371I    CYLINDERS WRITTEN = 1

 BMC40375I    RANDOM READS = 0, HITS = 0
 BMC40376I    PREFETCH COUNT = 0, HITS CAUSED BY PREFETCH = 0, HITS ON PREFETCH = 0
 BMC40377I    RANDOM WRITES = 0 IN 0 GROUPS
 BMC40378I    TOTAL WAIT TIME = 00:00:00, RANDOM WRITE TIME = 00:00:00, RANDOM READ TIME = 00:00:00
 BMC40379I    CYLINDER WAIT TIME = 00:00:00
 BMC40770I BUILD STATISTICS: # INPUT RECORDS = 0 # KEY VALUES = 0
 BMC40771I             # WAITS FOR SORT = 0
 BMC40772I             # GETPAGE CALLS = 7  # PAGES WRITTEN = 5  # LEAF PAGES = 1
 BMC40919I TOTAL TIME FOR WAITS = 00:00:00, WAIT TIME FOR BUFFER MANAGER = 00:00:00
 BMC40920I WAIT TIME FOR SORT = 00:00:00
 BMC40352I DDNAME SYS00005 (DSN DEJMCAT.BMCDBD.BMCDBSMP.BMCIX010.I0001.A001) WAS SUCCESSFULLY UNALLOCATED
 BMC40593I TERMINATION COMPLETE, ELAPSED TIME = 00:00:00
 BMC40900I BUILD INDEX STEP COMPLETE
 BMC40775W THERE ARE NO KEY VALUES FOR INDEX RMD.BMCIX010
 BMC40091I 03/20/2022 09:51:35 SUBPHASE CHECKPOINT TAKEN FOR BUILD    PHASE
 BMC40012I BUILD PHASE COMPLETE. ELAPSED TIME = 00:00:00, TIME SINCE UTILITY START = 00:00:05
 BMC40868I BUILD PHASE COMPLETE. ACCUMULATED TCB TIME = 00:00:00

AFRSTMT for recovering to a non Db2 data set

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 = EXAMPLE10B
 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 = AFRB131T       (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/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)
 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 = EXT3592
 BMC40967I         TAPE DEVICE11 = IBMATL
 BMC40967I         TAPE DEVICE12 = IBMVTS
 BMC40967I         TAPE DEVICE13 = PHXATL
 BMC40967I         TAPE DEVICE14 = SA3590
 BMC40967I         TAPE DEVICE15 = TAPEABL
 BMC40967I         TAPE DEVICE16 = 3590B
 BMC40967I         TAPE DEVICE17 = 3590E
 BMC40967I         TAPE DEVICE18 = 3480
 BMC40967I         TAPE DEVICE19 = 3400-9
 BMC40967I         TAPE DEVICE20 = SYS3480R
 BMC40967I         TAPE DEVICE21 = 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

 BMC40335I PACKAGE CHECKING AND BINDING STARTING 03/20/2022 09:51:31
 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 = 1310  SITE TYPE = LOCAL  MODE = NFM
 BMC40954I AVAILABLE MEMORY BELOW THE LINE = 9044K, TOTAL AVAILABLE MEMORY (AT LEAST) = 1414560K
 BMC40028I UTILID EXAMPLE10B ORIGINALLY TERMINATED BEFORE COMPLETING ANALYZE PHASE.  RESTART WILL BE TREATED AS A NEW RUN

 BMC40611I INPUT STATEMENTS:
 BMC40101I   RECOVER TABLESPACE BMCDBSMP.BMCTS010 INDEP OUTSPACE
 BMC40101I   REBUILD INDEX (RMD.BMCIX010) INDEP OUTSPACE NOWORKDDN
 BMC40101I
 BMC96004I ZIIP ENABLED (0) USING SUBSYSTEM XBMA
 BMC40937I z/OS RELEASE = 2.4.00, PID = HBB77C0, SMS RELEASE = 2.4.0  
 BMC40157I AVAILABLE REGION BELOW 16M = 9032K, AVAILABLE REGION ABOVE 16M = 1404336K, NUMBER OF CPUS = 5
 BMC40020I BYT:0, 0, 0; BLK:0, 0, 0; TOT:3214464, 9766832, 9766832;iter: 1; RC:4

 BMC40335I ANALYZE STARTING 03/20/2022 09:51:31

 BMC40335I CATALOG LOOKUP STARTING 03/20/2022 09:51:31
 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 PROC IX 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>)
 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 03/20/2022 09:51:31
 BMC40336I SYNCHRONIZATION 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

 BMC96306I MAXLSORT REDUCED FROM 50 TO 15 DUE TO MEMORY CONSTRAINTS
 BMC40336I DDSCAN 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 PLANNING STARTING 03/20/2022 09:51:31
 BMC40459I BSDS DEJMCAT.BSDS01 SELECTED
 BMC40066I TIME TO READ SYSLGRNX WAS 00:00:00
 BMC40459I BSDS DEJMCAT.BSDS01 SELECTED

 BMC40335I PLAN EXECUTION STARTING 03/20/2022 09:51:35

AFROSUM for recovering to a non Db2 data set

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.BMCTS010
 BMC40711I       DBID = X'0613'  PSID = X'0002'
 BMC40712I       ORIGINAL STATUS = RW
 BMC40716I          STOGROUP = SYSDEFLT PRIQTY = 250 SECQTY = 250
 BMC40710I          PAGE SIZE = 4K  SEGSIZE = 4
 BMC40723I          ENCODING SCHEME = EBCDIC


 BMC40820I       TABLESPACE RECOVERY
 BMC40823I       COLLECTING INDEX KEYS
 BMC40826I       INDEPENDENT OUTSPACE = DEJMCAT.BMCDBD.BMCDBSMP.BMCTS010.I0001.A001
 BMC40827I       LOG RESOURCE RANGE:
 BMC40585I          FROM LOGPOINT = X'000000000FACB6D3EF65'  TO LOGPOINT = X'000000000FACB9B85F66'

 BMC40840I       INPUT COPY / SYSCOPY DATA:
 BMC40640I          2022-08-20 09.51.08.4568 RBA/LRSN X'000000000FACB6D3EF65' FULL IMAGE COPY
 BMC40302I             DSN = RDAPXR.BMCDBSMP.BMCTS010.F.T095108
 BMC40641I                SHRLEVEL = REFERENCE  SITETYPE = LP  DSNUM = 0
 BMC40640I          2022-08-20 09.51.08.7338 RBA/LRSN X'000000000FACB6DF36F6' QUIESCE UTILITY POINT - WRITE(YES)


 BMC40709I OBJECT SUMMARY:
 BMC40346I    INDEXSPACE = BMCDBSMP.BMCIX010
 BMC40711I       DBID = X'0613'  PSID = X'0005'
 BMC40712I       ORIGINAL STATUS = RW
 BMC40303I       INDEX = RMD.BMCIX010
 BMC96160I          PAGE SIZE = 4K
 BMC40716I          STOGROUP = SYSDEFLT PRIQTY = 3 SECQTY = 3
 BMC40835I          PCTFREE = 10  FREEPAGE = 0  KEY LENGTH = 4
 BMC40830I       ON TABLE RMD.BMCTB010 (OBID X'0003') IN TABLESPACE BMCDBSMP.BMCTS010
 BMC40836I          TABLE CARDINALITY = -1
 BMC40832I       NON-CLUSTERING INDEX
 BMC40833I       UNIQUE INDEX
 BMC40844I       TYPE 2

 BMC40865I       INDEX REBUILD  - GROUP 1
 BMC40826I       INDEPENDENT OUTSPACE = DEJMCAT.BMCDBD.BMCDBSMP.BMCIX010.I0001.A001

AFRPLAN for recovering to a non Db2 data set

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  


BMC40700I EXECUTION PLAN SUMMARY:


 BMC40701I PHASE:  MERGE
 BMC40721I   PHASE INITIALIZATION:
 BMC40301I    TABLESPACE = BMCDBSMP.BMCTS010
 BMC40738I       ALLOCATE INPUT IMAGE COPY FILE
 BMC40302I          DSN = RDAPXR.BMCDBSMP.BMCTS010.F.T095108
 BMC40738I       FILE OPTIMIZATION
 BMC40738I       ALLOCATE 2 INPUT FILE BUFFER(S)
 BMC40738I       OPEN IMAGE COPY FILE
 BMC40302I          DSN = RDAPXR.BMCDBSMP.BMCTS010.F.T095108
 BMC40738I       ALLOCATE PAGE CHECK BUFFER (4096 BYTES)
 BMC40738I       ALLOCATE SPACEMAP BUFFER (4096 BYTES)
 BMC40738I       ALLOCATE PASTE BUFFER (4096 BYTES)
 BMC40738I       CREATE SPACE
 BMC40345I          SPACE = BMCDBSMP.BMCTS010
 BMC40738I       ALLOCATE SPACE (READ/WRITE)
 BMC40345I          SPACE = BMCDBSMP.BMCTS010
 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.BMCTS010
 BMC40735I   PHASE TERMINATION:
 BMC40738I       DISCONNECT FROM SPACE
 BMC40738I       DEALLOCATE SPACE
 BMC40345I          SPACE = BMCDBSMP.BMCTS010
 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.BMCTS010.F.T095108
 BMC40738I       FREE 2 INPUT FILE BUFFER(S)
 BMC40738I       DEALLOCATE INPUT IMAGE COPY FILE
 BMC40302I          DSN = RDAPXR.BMCDBSMP.BMCTS010.F.T095108
 BMC40738I       RECORD RESTART INFORMATION

 BMC40701I PHASE:  UNLOAD
 BMC40721I   PHASE INITIALIZATION:
 BMC40301I    TABLESPACE = BMCDBSMP.BMCTS010
 BMC40306I    COLLECTING KEYS FOR:
 BMC40303I         INDEX = RMD.BMCIX010
 BMC40738I       ALLOCATE (2) KEY BUFFER(S) (270336 BYTES EACH) FOR INDEX GROUP 1
 BMC40738I       INITIALIZE KEY SORT INPUT PHASE FOR INDEX GROUP 1
 BMC40813I          ESTIMATED NUMBER OF RECORDS = 8
 BMC40738I       ALLOCATE SPACE (READ ONLY)
 BMC40345I          SPACE = BMCDBSMP.BMCTS010
 BMC40738I       CONNECT TO SPACE
 BMC40738I       FILE OPTIMIZATION
 BMC40738I       ALLOCATE 2 SPACE INPUT BUFFER(S)
 BMC40738I       ALLOCATE SPACEMAP BUFFER (4096 BYTES)
 BMC40738I       ALLOCATE PASTE BUFFER (4096 BYTES)
 BMC40738I       ALLOCATE PAGE CHECK BUFFER (4096 BYTES)
 BMC40702I    STEP:  UNLOAD KEYS
 BMC40738I       UNLOAD KEYS
 BMC40735I   PHASE TERMINATION:
 BMC40738I       END KEY SORT INPUT FOR INDEX GROUP 1
 BMC40738I       FREE 2 KEY BUFFER(S) FOR INDEX GROUP 1
 BMC40738I       DISCONNECT FROM SPACE
 BMC40738I       DEALLOCATE SPACE
 BMC40345I          SPACE = BMCDBSMP.BMCTS010
 BMC40738I       FREE SPACEMAP BUFFER
 BMC40738I       FREE PASTE BUFFER
 BMC40738I       FREE PAGE CHECK BUFFER
 BMC40738I       FREE 2 INPUT SPACE BUFFER(S)

 BMC40701I PHASE:  BUILD
 BMC40721I   PHASE INITIALIZATION:
 BMC40303I    INDEX = RMD.BMCIX010
 BMC40738I       ALLOCATE 2 SORT OUTPUT BUFFERS (270336 BYTES EACH) FOR INDEX GROUP 1
 BMC40738I       ALLOCATE SPACE (READ/WRITE)
 BMC40345I          SPACE = BMCDBSMP.BMCIX010
 BMC40738I       CONNECT TO SPACE
 BMC40702I    STEP:  BUILD INDEX
 BMC40738I       BUILD INDEX
 BMC40735I   PHASE TERMINATION:
 BMC40738I       END SORT
 BMC40738I       FREE 2 SORT OUTPUT BUFFER(S) FOR INDEX GROUP 1
 BMC40738I       DISCONNECT FROM SPACE
 BMC40738I       DEALLOCATE SPACE
 BMC40345I          SPACE = BMCDBSMP.BMCIX010
 BMC40738I       RECORD RESTART INFORMATION

AFRERR for recovering to a non Db2 data set

 BMC40775W THERE ARE NO KEY VALUES FOR INDEX RMD.BMCIX010



 

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