Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Example 10B: Overriding the IXRECP installation option

The following JCL shows the use of the OPTIONS statement to override the IXRECP installation option.

IXRECP YES is used to set RECP or RBDP for the indexes associated with the recovered table space to force index recoveries before the data can be accessed. NGT Recover also issues a warning message for each index that has not been recovered with the table space.

JCL for overriding the IXRECP installation option

//AFREX12B JOB (PAFR),'EXAMPLE 10B', 
//        CLASS=Q,NOTIFY=&SYSUID, 
//        MSGCLASS=X 
//* 
//RECOVER EXEC PGM=AFRMAIN,REGION=0M, 
//             PARM='DGE,EXAMPLE10B,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 IXRECP YES 
 RECOVER TABLESPACE BMCDBSMP.BMCTS012 
   TOCOPY LASTCOPY 
/* 
//

The remaining figures show the following output, which is produced by running this JCL:

  • AFRSTMT

  • AFRPRINT

  • AFRPR001

  • AFRPLAN

For a description of each of these files, see the table in, DD statements common to all NGT Recover executions.


AFRSTMT for overriding the IXRECP installation option

BMC40018I RECOVER PLUS FOR DB2 V11.2.00   (RECOVER  AFRSTMT)
 BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2015
 BMC96173I RECOVER PLUS 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 = EXAMPLE12B
 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/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 = 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 RECOVER PLUS FOR DB2 V11.2.00
 BMC40876I MAINT:  NO RECOVER PLUS PTFS APPLIED

 BMC96010I SOLUTION COMMON CODE V11.2.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/21/2014 17:15:06
 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) = 1373592K
 BMC40037I UTILID EXAMPLE12B WAS NOT FOUND IN THE BMCUTIL TABLE - UTILITY WILL RUN AS IF 'NEW' WERE SPECIFIED

 BMC40611I INPUT STATEMENTS:
 BMC40101I   OPTION IXRECP YES
 BMC40101I   RECOVER TABLESPACE BMCDBSMP.BMCTS012
 BMC40101I       TOCOPY LASTCOPY
 BMC40101I
 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 = 1362344K, NUMBER OF CPUS = 5
 BMC40020I BYT:0, 0, 0; BLK:0, 0, 0; TOT:902724, 5854652, 5854652;iter: 1; RC:4

 BMC40335I ANALYZE STARTING 08/21/2014 17:15:07

 BMC40335I CATALOG LOOKUP STARTING 08/21/2014 17:15:07
 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 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 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/21/2014 17:15:07
 BMC40025I OUTPUT FROM COMMAND '-STO DB(BMCDBSMP) SPACE(BMCTS012) 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:04
 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:04
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00


 BMC40335I PLANNING STARTING 08/21/2014 17:15:10

 BMC40335I PLAN EXECUTION STARTING 08/21/2014 17:15:13
 BMC40025I OUTPUT FROM COMMAND '-STA DB(BMCDBSMP) SPACE(BMCTS012)  ACCESS(RW)' FOLLOWS:
 BMC40020I DSN9022I  *DXW4 DSNTDDIS 'START DATABASE' NORMAL COMPLETION


AFRPLAN for overriding the IXRECP installation option

BMC40018I RECOVER PLUS FOR DB2 V11.2.00   (RECOVER  AFRPLAN)
 BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2015
 BMC96173I RECOVER PLUS 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:  MERGE
 BMC40721I   PHASE INITIALIZATION:
 BMC40301I    TABLESPACE = BMCDBSMP.BMCTS012
 BMC40738I       ALLOCATE INPUT IMAGE COPY FILE
 BMC40302I          DSN = RDAPXR.BMCDBSMP.BMCTS012.F.T135427.LP
 BMC40738I       FILE OPTIMIZATION
 BMC40738I       ALLOCATE 2 INPUT FILE BUFFER(S)
 BMC40738I       OPEN IMAGE COPY FILE
 BMC40302I          DSN = RDAPXR.BMCDBSMP.BMCTS012.F.T135427.LP
 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.BMCTS012
 BMC40738I       ALLOCATE SPACE (READ/WRITE)
 BMC40345I          SPACE = BMCDBSMP.BMCTS012
 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.BMCTS012
 BMC40735I   PHASE TERMINATION:
 BMC40738I       DISCONNECT FROM SPACE
 BMC40738I       DEALLOCATE SPACE
 BMC40345I          SPACE = BMCDBSMP.BMCTS012
 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.BMCTS012.F.T135427.LP
 BMC40738I       FREE 2 INPUT FILE BUFFER(S)
 BMC40738I       DEALLOCATE INPUT IMAGE COPY FILE
 BMC40302I          DSN = RDAPXR.BMCDBSMP.BMCTS012.F.T135427.LP
 BMC40738I       RESET RECOVERY PENDING (RECP) FLAG
 BMC40738I       REGISTER PARTIAL RECOVERY IN SYSCOPY
 BMC40738I       SET INDEX(S) STATUS TO REBUILD PENDING IF NEEDED
 BMC40738I       RECORD RESTART INFORMATION


AFRPRINT and AFRPR001 for overriding the IXRECP installation option

BMC40018I RECOVER PLUS FOR DB2 V11.2.00 
 BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2015
 BMC96173I RECOVER PLUS 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

 BMC96400I MERGE PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR001
 BMC40301I    TABLESPACE = BMCDBSMP.BMCTS012
 BMC40018I RECOVER PLUS FOR DB2 V11.2.00 
 BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2015
 BMC96173I RECOVER PLUS 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/21/2014 17:15:13
 BMC40301I    TABLESPACE = BMCDBSMP.BMCTS012
 BMC40350I DATA SET RDAPXR.BMCDBSMP.BMCTS012.F.T135427.LP WAS SUCCESSFULLY ALLOCATED TO DDNAME SYS00002 ELAPSED = 00:00:00
 BMC40060I PENDING FLAG RECP SET FOR
 BMC40345I    SPACE = BMCDBSMP.BMCTS012
 BMC40356I AN IDCAMS 'DELETE CLUSTER' OPERATION WAS SUCCESSFUL ON DATASET DSNDXW.DSNDBC.BMCDBSMP.BMCTS012.I0001.A001
 BMC40356I AN IDCAMS 'DEFINE CLUSTER' OPERATION WAS SUCCESSFUL ON DATASET DSNDXW.DSNDBC.BMCDBSMP.BMCTS012.I0001.A001
 BMC40350I DATA SET DSNDXW.DSNDBD.BMCDBSMP.BMCTS012.I0001.A001 WAS SUCCESSFULLY ALLOCATED TO DDNAME SYS00004 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.BMCTS012.F.T135427.LP
 BMC40799I MERGE STARTING FOR DATA SET DSNDXW.DSNDBD.BMCDBSMP.BMCTS012.I0001.A001
 BMC40593I INITIALIZATION COMPLETE, ELAPSED TIME = 00:00:00
 BMC40593I SPIN COMPLETE, ELAPSED TIME = 00:00:00
 BMC40401I EXTENT ALLOCATED FOR TABLE SPACE BMCDBSMP.BMCTS012
 BMC40302I          DSN = DSNDXW.DSNDBD.BMCDBSMP.BMCTS012.I0001.A001
 BMC40401I EXTENT ALLOCATED FOR TABLE SPACE BMCDBSMP.BMCTS012
 BMC40302I          DSN = DSNDXW.DSNDBD.BMCDBSMP.BMCTS012.I0001.A001
 BMC40401I EXTENT ALLOCATED FOR TABLE SPACE BMCDBSMP.BMCTS012
 BMC40302I          DSN = DSNDXW.DSNDBD.BMCDBSMP.BMCTS012.I0001.A001
 BMC40401I EXTENT ALLOCATED FOR TABLE SPACE BMCDBSMP.BMCTS012
 BMC40302I          DSN = DSNDXW.DSNDBD.BMCDBSMP.BMCTS012.I0001.A001
 BMC40401I EXTENT ALLOCATED FOR TABLE SPACE BMCDBSMP.BMCTS012
 BMC40302I          DSN = DSNDXW.DSNDBD.BMCDBSMP.BMCTS012.I0001.A001
 BMC40401I EXTENT ALLOCATED FOR TABLE SPACE BMCDBSMP.BMCTS012
 BMC40302I          DSN = DSNDXW.DSNDBD.BMCDBSMP.BMCTS012.I0001.A001
 BMC40902I TOTAL WAITS = 26, TOTAL WAIT TIME = 00:00:00
 BMC40981I FULL IC RDAPXR.BMCDBSMP.BMCTS012.F.T135427.LP READ WAITS = 4, WAIT TIME = 00:00:00
 BMC40905I SPACE WRITE WAITS = 22, WAIT TIME = 00:00:00
 BMC40985I NUMBER OF PAGES READ FROM FULL COPY FOR THIS OBJECT = 5003, USED = 5003
 BMC40790I NUMBER OF PAGES READ FROM FULL COPY TOTAL = 5003, USED = 5003
 BMC40798I NUMBER OF PAGES OUTPUT IS = 5003
 BMC40900I MERGE TABLESPACE STEP COMPLETE
 BMC40593I MERGE PROCESS COMPLETE, ELAPSED TIME = 00:00:00
 BMC40352I DDNAME SYS00004 (DSN DSNDXW.DSNDBD.BMCDBSMP.BMCTS012.I0001.A001) WAS SUCCESSFULLY UNALLOCATED
 BMC40352I DDNAME SYS00002 (DSN RDAPXR.BMCDBSMP.BMCTS012.F.T135427.LP) WAS SUCCESSFULLY UNALLOCATED
 BMC40060I PENDING FLAG RECP RESET FOR
 BMC40345I    SPACE = BMCDBSMP.BMCTS012
 BMC40060I PENDING FLAG RBDP SET FOR
 BMC40303I          INDEX = RMD.BMCIX012
 BMC40898W INDEX LEFT IN RBDP BECAUSE TABLESPACE WAS RECOVERED TO POINT-IN-TIME AND INDEX WAS NOT
 BMC40091I 08/21/2014 17:15:15 SUBPHASE CHECKPOINT TAKEN FOR MERGE    PHASE
 BMC40012I MERGE PHASE COMPLETE. ELAPSED TIME = 00:00:01, TIME SINCE UTILITY START = 00:00:09
 BMC40868I MERGE PHASE COMPLETE. ACCUMULATED TCB TIME = 00:00:00

Was this page helpful? Yes No Submitting... Thank you

Comments