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 2A: Using REBUILD INDEX

In the first job in this example, the index is rebuilt from the rows in this recovered image.

Note the use of the NOWORKDDN option to send the extracted index keys directly to the sort routine. Also, note the use of MSGLEVEL(0), which produces less output than the default of MSGLEVEL(1).

JCL for a simple RECOVER TABLESPACE and REBUILD INDEX

//AFREX02A JOB (5225),'EXAMPLE 2A', 
//         CLASS=Q, 
//         MSGCLASS=X,NOTIFY=&SYSUID 
/*ROUTE XEQ BMCPLX1 
/*JOBPARM SYSAFF=DB2A 
//* 
//RECOVER EXEC PGM=AFRMAIN,REGION=0M, 
//             PARM='DGE,EX02AMSG0,NEW,MSGLEVEL(0)' 
//STEPLIB  DD DISP=SHR,DSN=product.libraries
//         DD DISP=SHR,DSN=DB2.DSNEXIT
//         DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSIN     DD * 
 OPTIONS EARLYRECALL INDEXLOG NO 
 RECOVER TABLESPACE BMCDBSMP.BMCTS011 
 REBUILD INDEX (RMD.BMCIX011) NOWORKDDN
/* 
//

The remaining three figures show the output produced by this JCL, which includes the following files:

  • AFRSUMRY

  • AFRSTMT

  • AFRPR001

For a description of each of these files, see the table in BMC AMI Recover data sets and BMC AMI Recover DD statements.

AFRSUMRY for a simple REBUILD INDEX

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/2012 12:59:30

 BMC40018I BMC AMI Recover for Db2 V12.1.00
 BMC40876I MAINT:  NO BMC AMI Recover PTFS APPLIED

 BMC96010I SOLUTION COMMON CODE V11.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 = EX02AMSG0. 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:03, UTILITY ELAPSED TIME = 00:00:04
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

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

 BMC40476I EXECUTION SUMMARY
 BMC40477I      TABLE SPACES / PHASES (PARTITIONS) RECOVERED   :  1 (0)
 BMC40479I      LOG RECORDS APPLIED                   :  22496
 BMC40480I      INDEXES REBUILT                       :  1

 BMC40005I UTILITY EXECUTION COMPLETE 08/17/2012 12:59:41, RETURN CODE = 0

 AFRSTMT for a simple REBUILD INDEX

BMC40018I BMC AMI Recover for Db2 V11.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 = EX02AMSG0
 BMC40008I UTILITY REPLACEMENT ('NEW') REQUESTED
 BMC40933I               RESTART = NEW
 BMC40934I              MSGLEVEL = 0
 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)
 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 V11.1.00
 BMC40876I MAINT:  NO BMC AMI RECOVER PLUS PTFS APPLIED

 BMC96010I SOLUTION COMMON CODE V11.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

 BMC40611I INPUT STATEMENTS:
 BMC40101I   OPTION EARLYRECALL INDEXLOG NO
 BMC40101I   RECOVER TABLESPACE BMCDBSMP.BMCTS011
 BMC40101I   REBUILD INDEX (RMD.BMCIX011) NOWORKDDN
 BMC40101I
 BMC40960I INDEXLOG STRATEGY DISABLED
 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/2012 12:59:31

 BMC40335I CATALOG LOOKUP STARTING 08/17/2012 12:59:31
 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:01
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00


 BMC40335I SYNCHRONIZATION STARTING 08/17/2012 12:59:32
 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 17 DUE TO MEMORY CONSTRAINTS

 BMC40335I PLANNING STARTING 08/17/2012 12:59:34

 BMC40512I LOG FILE RESOURCES:
 BMC40302I    DSN = DSNDXW.DXW4.LOGCOPY1.DS01.DATA

 BMC40566I    USING LOG DSNDXW.DXW4.LOGCOPY1.DS01.DATA FOR PROCESSING
 BMC40555I       FROMRBA  = X'00000000015B9138D000'  TORBA  = X'00000000015B914A5E0C'
 BMC40555I       FROMRBA  = X'00000000015B914CD000'  TORBA  = X'00000000015B915A53E5'

 BMC40335I PLAN EXECUTION STARTING 08/17/2012 12:59:36

 AFRP001 for a simple REBUILD INDEX

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

 BMC40483I LOG INPUT COMPLETE.
 BMC40483I MERGE COMPLETE.
 BMC40301I          TABLESPACE = BMCDBSMP.BMCTS011
 BMC40483I BUILD COMPLETE.
 BMC40303I          INDEX = RMD.BMCIX011
1 SYNCSORT FOR Z/OS  2.3.1.0NI   U.S. PATENTS: 4210961, 5117495   (C) 2007 SYNCSORT INC.   DATE=2012/230   TIME=12.59.36
                   BMCSORT ENGINE - IF PROBLEMS, CONTACT BMC SUPPORT AT 1-800-537-1813   z/OS   1.13.0
  $BMCPRM$ : BMSG,EQUALS
  PARMLIST :
  SORT FIELDS=(30,20,BI,A),DYNALLOC,FILSZ=E664
  RECORD TYPE=V,LENGTH=(8192,8192,8192,32,1000)
  OPTION SORTDD=L001,MSGDDN=LOGOU001,AVGRLEN=1000
  WER161B  ALTERNATE PARM USED
  WER164B  2,260K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
  WER164B     44K BYTES RESERVE REQUESTED, 2,212K BYTES USED
  WER410B  1,956K BYTES OF VIRTUAL STORAGE AVAILABLE ABOVE THE 16MEG LINE,
  WER410B     0 BYTES RESERVE REQUESTED, 1,956K BYTES USED
  WER036B  G=150,B=13672,SEGLEN=4200,BIAS=34
  WER162B  0 PREALLOCATED SORTWORK TRACKS, 960 DYNAMICALLY ALLOCATED,
  WER162B     0 ACQUIRED IN SECONDARY EXTENTS, 0 RELEASED, TOTAL OF 40 TRACKS USED
  WER045C  END SORT PHASE
  WER055I  INSERT      22496, DELETE      22496
  WER416B  L001WK01 : EXCP'S=7,UNIT=3390,DEV=40AB,CHP=89DFEF,VOL=WRK029
  WER416B  L001WK02 : EXCP'S=6,UNIT=3390,DEV=5949,CHP=FD8E,VOL=WRK069
  WER416B  TOTAL OF 13 EXCP'S ISSUED FOR SORTWORKS
  WER416B  TOTAL OF 13 EXCP'S ISSUED FOR SORTING
  WER246I  FILESIZE 1,609,708 BYTES
  WER054I  RCD IN          0, OUT          0
  WER072I  EQUALS, ELAP IN EFFECT
  WER169I  RELEASE 2.3 BATCH 0486 TPF LEVEL 0.0
  WER052I  END SYNCSORT - AFREX02A,RECOVER,,DIAG=E000,EADE,C83C,20C4,A9C2,4DC2,0260,0C60
Was this page helpful? Yes No Submitting... Thank you

Comments