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 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=* 
//

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

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)
 BMC96426I				MATCHING = 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)

 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

 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
Was this page helpful? Yes No Submitting... Thank you

Comments