Example 1: Previewing the recovery plan
This example illustrates the use of the ANALYZE ONLY option with RECOVER TABLESPACE to obtain a preview of the recovery plan.
When you use the ANALYZE ONLY option, BMC AMI Recover determines the data sets required for recovery and produces a recovery plan. This example also uses the SYSPICK DD statement to list all of the tape and cartridge volumes that will be dynamically allocated during recovery. The JCL for this example is in the following figure:
JCL using ANALYZE ONLY
//AFREX01 JOB (PAFR),'EXAMPLE 1',
// CLASS=Q,
// MSGCLASS=X,NOTIFY=&SYSUID
/*ROUTE XEQ BMCPLX1
/*JOBPARM SYSAFF=DB2A
//*
//RECOVER EXEC PGM=AFRMAIN,REGION=0M,
// PARM='DGE,EXAMPLE01,NEW/RESTART'
//STEPLIB DD DISP=SHR,DSN=product.libraries
// DD DISP=SHR,DSN=DB2.DSNEXIT
// DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSIN DD *
RECOVER TABLESPACE BMCDBSMP.BMCTS001
LOGSORT ANALYZE ONLY
/*
//SYSPICK DD SYSOUT=*
//
// CLASS=Q,
// MSGCLASS=X,NOTIFY=&SYSUID
/*ROUTE XEQ BMCPLX1
/*JOBPARM SYSAFF=DB2A
//*
//RECOVER EXEC PGM=AFRMAIN,REGION=0M,
// PARM='DGE,EXAMPLE01,NEW/RESTART'
//STEPLIB DD DISP=SHR,DSN=product.libraries
// DD DISP=SHR,DSN=DB2.DSNEXIT
// DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSIN DD *
RECOVER TABLESPACE BMCDBSMP.BMCTS001
LOGSORT ANALYZE ONLY
/*
//SYSPICK DD SYSOUT=*
//
The remaining figures show the following output files from this BMC AMI Recover job:
- AFRSUMRY
- AFRSTMT
- AFROSUM
- AFRPLAN
- SYSPICK
See the table in, BMC-AMI-Recover-data-sets-and-BMC-AMI-Recover-DD-statements, for a description of each of these files.
AFRSUMRY using ANALYZE ONLY
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/2016 12:58:08
BMC40018I BMC AMI Recover for Db2 V12.1.00
BMC40876I MAINT: NO BMC AMI Recover PTFS APPLIED
BMC96010I SOLUTION COMMON CODE V12.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 = EXAMPLE01. 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:00, 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:03, UTILITY ELAPSED TIME = 00:00:07
BMC40288I CPU TIME = 00:00:00, UTILITY CPU TIME = 00:00:00
BMC40005I UTILITY EXECUTION COMPLETE 08/17/2016 12:58:15, RETURN CODE = 0
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/2016 12:58:08
BMC40018I BMC AMI Recover for Db2 V12.1.00
BMC40876I MAINT: NO BMC AMI Recover PTFS APPLIED
BMC96010I SOLUTION COMMON CODE V12.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 = EXAMPLE01. 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:00, 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:03, UTILITY ELAPSED TIME = 00:00:07
BMC40288I CPU TIME = 00:00:00, UTILITY CPU TIME = 00:00:00
BMC40005I UTILITY EXECUTION COMPLETE 08/17/2016 12:58:15, RETURN CODE = 0
AFRSTMT using ANALYZE ONLY
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 = EXAMPLE01
BMC40009I UTILITY NEW/RESTART REQUESTED - SYNCPOINT RESTART WILL OCCUR IF UTILID IS IN BMCUTIL
BMC40933I RESTART = NEW/RESTART
BMC40930I PARM NOT CODED - MSGLEVEL(1)
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 AUXILIARY 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)
BMC96426IMATCHING = AUTO (ENFORCE SCHEMA MATCHING IN IMPORT AND MIGRATE)
BMC96035I ----- DEFAULT OPTIONS: SORT
BMC40928I SMCORE = ( 0K, 0K) (SORT CORE VALUES)
BMC40893I RESINV = ( 0K) (MEMORY BELOW 16MB EXCLUDED FROM USE BY SORT)
BMC40962I SORTDEVT = SORT DEFAULT (DEVICE TYPE FOR LOG AND INDEX SORTS)
BMC40963I SORTNUM = SORT DEFAULT (WORK DATASETS FOR LOG AND INDEX SORTS)
BMC96230I KSORTSHARE = YES (KEY SORTS SHARED BY ALL TASKS)
BMC40942I MAXKSORT = 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 = DLM3480
BMC40967I TAPE DEVICE11 = DLM3490
BMC40967I TAPE DEVICE12 = DLM3590
BMC40967I TAPE DEVICE13 = D3480
BMC40967I TAPE DEVICE14 = EXT3592
BMC40967I TAPE DEVICE15 = IBMATL
BMC40967I TAPE DEVICE16 = IBMVTS
BMC40967I TAPE DEVICE17 = PHXATL
BMC40967I TAPE DEVICE18 = PHX3592
BMC40967I TAPE DEVICE19 = SA3590
BMC40967I TAPE DEVICE20 = TAPEABL
BMC40967I TAPE DEVICE21 = 3590B
BMC40967I TAPE DEVICE22 = 3590E
BMC40967I TAPE DEVICE23 = 3480
BMC40967I TAPE DEVICE24 = 3400-9
BMC40967I TAPE DEVICE25 = SYS3480R
BMC40967I TAPE DEVICE25 = SYS348XR
BMC40018I BMC AMI Recover for Db2 V12.1.00
BMC40876I MAINT: NO BMC AMI Recover PTFS APPLIED
BMC96010I SOLUTION COMMON CODE V12.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
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) = 1373604K
BMC40037I UTILID EXAMPLE01 WAS NOT FOUND IN THE BMCUTIL TABLE - UTILITY WILL RUN AS IF 'NEW' WERE SPECIFIED
BMC40611I INPUT STATEMENTS:
BMC40101I RECOVER TABLESPACE BMCDBSMP.BMCTS001
BMC40101I LOGSORT ANALYZE ONLY
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 = 1362352K, NUMBER OF CPUS = 5
BMC40335I ANALYZE STARTING 08/17/2016 12:58:11
BMC40335I CATALOG LOOKUP STARTING 08/17/2016 12:58:11
BMC40633I USING STANDARD DB2 SECURITY
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 CATALOG LOOKUP 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 SYNCHRONIZATION STARTING 08/17/2016 12:58:11
BMC40336I SYNCHRONIZATION 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
BMC96306I MAXLSORT REDUCED FROM 50 TO 22 DUE TO MEMORY CONSTRAINTS
BMC40335I PLANNING STARTING 08/17/2016 12:58:11
BMC40066I TIME TO READ SYSLGRNX WAS 00:00: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 = EXAMPLE01
BMC40009I UTILITY NEW/RESTART REQUESTED - SYNCPOINT RESTART WILL OCCUR IF UTILID IS IN BMCUTIL
BMC40933I RESTART = NEW/RESTART
BMC40930I PARM NOT CODED - MSGLEVEL(1)
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 AUXILIARY 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)
BMC96426IMATCHING = AUTO (ENFORCE SCHEMA MATCHING IN IMPORT AND MIGRATE)
BMC96035I ----- DEFAULT OPTIONS: SORT
BMC40928I SMCORE = ( 0K, 0K) (SORT CORE VALUES)
BMC40893I RESINV = ( 0K) (MEMORY BELOW 16MB EXCLUDED FROM USE BY SORT)
BMC40962I SORTDEVT = SORT DEFAULT (DEVICE TYPE FOR LOG AND INDEX SORTS)
BMC40963I SORTNUM = SORT DEFAULT (WORK DATASETS FOR LOG AND INDEX SORTS)
BMC96230I KSORTSHARE = YES (KEY SORTS SHARED BY ALL TASKS)
BMC40942I MAXKSORT = 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 = DLM3480
BMC40967I TAPE DEVICE11 = DLM3490
BMC40967I TAPE DEVICE12 = DLM3590
BMC40967I TAPE DEVICE13 = D3480
BMC40967I TAPE DEVICE14 = EXT3592
BMC40967I TAPE DEVICE15 = IBMATL
BMC40967I TAPE DEVICE16 = IBMVTS
BMC40967I TAPE DEVICE17 = PHXATL
BMC40967I TAPE DEVICE18 = PHX3592
BMC40967I TAPE DEVICE19 = SA3590
BMC40967I TAPE DEVICE20 = TAPEABL
BMC40967I TAPE DEVICE21 = 3590B
BMC40967I TAPE DEVICE22 = 3590E
BMC40967I TAPE DEVICE23 = 3480
BMC40967I TAPE DEVICE24 = 3400-9
BMC40967I TAPE DEVICE25 = SYS3480R
BMC40967I TAPE DEVICE25 = SYS348XR
BMC40018I BMC AMI Recover for Db2 V12.1.00
BMC40876I MAINT: NO BMC AMI Recover PTFS APPLIED
BMC96010I SOLUTION COMMON CODE V12.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
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) = 1373604K
BMC40037I UTILID EXAMPLE01 WAS NOT FOUND IN THE BMCUTIL TABLE - UTILITY WILL RUN AS IF 'NEW' WERE SPECIFIED
BMC40611I INPUT STATEMENTS:
BMC40101I RECOVER TABLESPACE BMCDBSMP.BMCTS001
BMC40101I LOGSORT ANALYZE ONLY
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 = 1362352K, NUMBER OF CPUS = 5
BMC40335I ANALYZE STARTING 08/17/2016 12:58:11
BMC40335I CATALOG LOOKUP STARTING 08/17/2016 12:58:11
BMC40633I USING STANDARD DB2 SECURITY
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 CATALOG LOOKUP 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 SYNCHRONIZATION STARTING 08/17/2016 12:58:11
BMC40336I SYNCHRONIZATION 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
BMC96306I MAXLSORT REDUCED FROM 50 TO 22 DUE TO MEMORY CONSTRAINTS
BMC40335I PLANNING STARTING 08/17/2016 12:58:11
BMC40066I TIME TO READ SYSLGRNX WAS 00:00:00
AFROSUM using ANALYZE ONLY
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.BMCTS001
BMC40711I DBID = X'0267' PSID = X'0002'
BMC40712I ORIGINAL STATUS = RW
BMC40716I STOGROUP = SYSDEFLT PRIQTY = 800 SECQTY = 400
BMC40710I PAGE SIZE = 4K SEGSIZE = 4
BMC40723I ENCODING SCHEME = EBCDIC
BMC40820I TABLESPACE RECOVERY
BMC40827I LOG RESOURCE RANGE:
BMC40585I FROM LOGPOINT = X'00CA088B59E63E000000' TO LOGPOINT = X'00CA08A2FF9049000000'
BMC40840I INPUT COPY / SYSCOPY DATA:
BMC40640I 2012-08-17 11.12.24.2272 RBA/LRSN X'00CA088B59E63E000000' FULL IMAGE COPY
BMC40302I DSN = RDAPXR.BMCDBSMP.BMCTS001.F.T111223
BMC40641I SHRLEVEL = REFERENCE SITETYPE = LP DSNUM = 0
BMC40640I 2012-08-17 11.12.26.9237 RBA/LRSN X'00CA088B5D166C000000' QUIESCE UTILITY POINT - WRITE(YES)
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.BMCTS001
BMC40711I DBID = X'0267' PSID = X'0002'
BMC40712I ORIGINAL STATUS = RW
BMC40716I STOGROUP = SYSDEFLT PRIQTY = 800 SECQTY = 400
BMC40710I PAGE SIZE = 4K SEGSIZE = 4
BMC40723I ENCODING SCHEME = EBCDIC
BMC40820I TABLESPACE RECOVERY
BMC40827I LOG RESOURCE RANGE:
BMC40585I FROM LOGPOINT = X'00CA088B59E63E000000' TO LOGPOINT = X'00CA08A2FF9049000000'
BMC40840I INPUT COPY / SYSCOPY DATA:
BMC40640I 2012-08-17 11.12.24.2272 RBA/LRSN X'00CA088B59E63E000000' FULL IMAGE COPY
BMC40302I DSN = RDAPXR.BMCDBSMP.BMCTS001.F.T111223
BMC40641I SHRLEVEL = REFERENCE SITETYPE = LP DSNUM = 0
BMC40640I 2012-08-17 11.12.26.9237 RBA/LRSN X'00CA088B5D166C000000' QUIESCE UTILITY POINT - WRITE(YES)
AFRPLAN using ANALYZE ONLY
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
BMC40755I ANALYSIS PLAN SUMMARY:
BMC40701I PHASE: MERGE
BMC40721I PHASE INITIALIZATION:
BMC40301I TABLESPACE = BMCDBSMP.BMCTS001
BMC40738I ALLOCATE INPUT IMAGE COPY FILE
BMC40302I DSN = RDAPXR.BMCDBSMP.BMCTS001.F.T111223
BMC40738I FILE OPTIMIZATION
BMC40738I ALLOCATE 2 INPUT FILE BUFFER(S)
BMC40738I OPEN IMAGE COPY FILE
BMC40302I DSN = RDAPXR.BMCDBSMP.BMCTS001.F.T111223
BMC40738I SET RECOVERY PENDING (RECP) FLAG
BMC40738I CREATE SPACE
BMC40345I SPACE = BMCDBSMP.BMCTS001
BMC40738I ALLOCATE SPACE (READ/WRITE)
BMC40345I SPACE = BMCDBSMP.BMCTS001
BMC40738I CONNECT TO SPACE
BMC40738I FILE OPTIMIZATION
BMC40738I ALLOCATE 2 SPACE OUTPUT BUFFER(S)
BMC40702I STEP: MERGE SPACE
BMC40738I MERGE SPACE
BMC40301I TABLESPACE = BMCDBSMP.BMCTS001
BMC40735I PHASE TERMINATION:
BMC40738I DISCONNECT FROM SPACE
BMC40738I DEALLOCATE SPACE
BMC40345I SPACE = BMCDBSMP.BMCTS001
BMC40738I FREE 2 OUTPUT SPACE BUFFER(S)
BMC40738I CLOSE IMAGE COPY FILE
BMC40302I DSN = RDAPXR.BMCDBSMP.BMCTS001.F.T111223
BMC40738I FREE 2 INPUT FILE BUFFER(S)
BMC40738I DEALLOCATE INPUT IMAGE COPY FILE
BMC40302I DSN = RDAPXR.BMCDBSMP.BMCTS001.F.T111223
BMC40738I RESET RECOVERY PENDING (RECP) FLAG
BMC40738I REGISTER RECOVER TO CURRENT IN SYSCOPY
BMC40738I RECORD RESTART INFORMATION
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
BMC40755I ANALYSIS PLAN SUMMARY:
BMC40701I PHASE: MERGE
BMC40721I PHASE INITIALIZATION:
BMC40301I TABLESPACE = BMCDBSMP.BMCTS001
BMC40738I ALLOCATE INPUT IMAGE COPY FILE
BMC40302I DSN = RDAPXR.BMCDBSMP.BMCTS001.F.T111223
BMC40738I FILE OPTIMIZATION
BMC40738I ALLOCATE 2 INPUT FILE BUFFER(S)
BMC40738I OPEN IMAGE COPY FILE
BMC40302I DSN = RDAPXR.BMCDBSMP.BMCTS001.F.T111223
BMC40738I SET RECOVERY PENDING (RECP) FLAG
BMC40738I CREATE SPACE
BMC40345I SPACE = BMCDBSMP.BMCTS001
BMC40738I ALLOCATE SPACE (READ/WRITE)
BMC40345I SPACE = BMCDBSMP.BMCTS001
BMC40738I CONNECT TO SPACE
BMC40738I FILE OPTIMIZATION
BMC40738I ALLOCATE 2 SPACE OUTPUT BUFFER(S)
BMC40702I STEP: MERGE SPACE
BMC40738I MERGE SPACE
BMC40301I TABLESPACE = BMCDBSMP.BMCTS001
BMC40735I PHASE TERMINATION:
BMC40738I DISCONNECT FROM SPACE
BMC40738I DEALLOCATE SPACE
BMC40345I SPACE = BMCDBSMP.BMCTS001
BMC40738I FREE 2 OUTPUT SPACE BUFFER(S)
BMC40738I CLOSE IMAGE COPY FILE
BMC40302I DSN = RDAPXR.BMCDBSMP.BMCTS001.F.T111223
BMC40738I FREE 2 INPUT FILE BUFFER(S)
BMC40738I DEALLOCATE INPUT IMAGE COPY FILE
BMC40302I DSN = RDAPXR.BMCDBSMP.BMCTS001.F.T111223
BMC40738I RESET RECOVERY PENDING (RECP) FLAG
BMC40738I REGISTER RECOVER TO CURRENT IN SYSCOPY
BMC40738I RECORD RESTART INFORMATION
SYSPICK using ANALYZE ONLY
1DATE 08/17/2016 BMC AMI Recover for Db2 PAGE 001 of 001
TIME 12:58:15 VOLUME PICK LIST
BY VOLUME SERIAL NUMBER
- VOLSER DEV TYPE DATASET NAME SEQ
-NO VOLUMES FOUND
TIME 12:58:15 VOLUME PICK LIST
BY VOLUME SERIAL NUMBER
- VOLSER DEV TYPE DATASET NAME SEQ
-NO VOLUMES FOUND
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*