Example 10: Overriding installation options
This example demonstrates the use of the OPTIONS statement to override installation options at execution time.
Not all installation options can be overridden. See OPTIONS command for a description of the OPTIONS statement.
Important
Some OPTIONS keywords are different from their corresponding installation option names. For example, the OPTIONS keyword is MAXDRIVES, but the installation option is MAXDRIVE. Be sure to use the keywords as they are shown in the OPTIONS syntax diagram in OPTIONS syntax.
Example 10A: Overriding several installation options
In the first part of Example 10A, the SORTDEVT and SORTNUM options are overridden to SYSDA and 03.
In addition, the resources eligible for use in this recovery are limited to the archive log 1 and active log 1, and the remote primary and local primary image copies. Note that, in the example output, only an active log was read because it had not yet been archived and was therefore the only source of log records for the recovery.
JCL for overriding installation options
//AFREX12A JOB (PAFR),'EXAMPLE 10A',
// class="Q",NOTIFY=&SYSUID,
// MSGCLASS=X
//*
//RECOVER EXEC PGM=AFRMAIN,REGION=0M,
// PARM='DGE,EXAMPLE10A,NEW'
//STEPLIB DD DISP=SHR,DSN=product.libraries
// DD DISP=SHR,DSN=DB2.DSNEXIT
// DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSIN DD *
OPTIONS
SORTDEVT SYSDA SORTNUM 03
RESOURCE SELECTION
LOGS (ARC1, ACT1)
COPIES (RP, LP)
RECOVER TABLESPACE BMCDBSMP.BMCTS012
/*
//
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. BMC AMI 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, BMC AMI Recover data sets and BMC AMI Recover DD statements.
AFRSTMT for overriding the IXRECP installation option
BMC40018I BMC AMI Recover for Db2 V12.1.00 (RECOVER AFRSTMT)
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 = 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 BMC AMI Recover for Db2 V12.1.00
BMC40876I MAINT: NO BMC AMI Recover 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 BMC AMI Recover for Db2 V12.1.00 (RECOVER AFRPLAN)
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: 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 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
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
Comments
Log in or register to comment.