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 15: Using MAXKSORT for parallel index rebuilds

Example 15 illustrates the use of the MAXKSORT option to invoke parallel index sorts and rebuilds to rebuild a partitioned index and multiple nonpartitioned indexes.

JCL using the MAXKSORT option for parallel index rebuilds

//AFREX16  JOB (PAFR),'EXAMPLE 15', 
//         CLASS=Q,NOTIFY=&SYSUID, 
//         MSGCLASS=X,TIME=(0,5) 
/*ROUTE XEQ BMCPLX1 
/*JOBPARM SYSAFF=DB2A 
//* 
//RECOVER EXEC PGM=AFRMAIN,REGION=0M, 
//             PARM='DEBA,EXAMPLE15,NEW/RESTART,MSGLEVEL(0)'
//STEPLIB  DD DISP=SHR,DSN=product.libraries
//          DD DISP=SHR,DSN=DB2.DSNEXIT
//          DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSIN     DD * 
 OPTIONS MAXKSORT 12 
 BMC40101I   REBUILD INDEX (ALL) TABLESPACE RMDSUPDB.TS67P32K
/* 
//

Displayed below, the figures, AFRERR for parallel index rebuilds with MAXKSORT,  AFRSTMT for parallel index rebuilds with MAXKSORT, and AFRPRINT for parallel index rebuilds with MAXKSORT show the following output, which is produced by running this JCL:

  • AFRERR

  • AFRSUMRY

  • AFRSTMT

  • AFRPRINT

  • AFRPR001 (AFRPR002 through AFRPR009 are produced but not shown.)

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


AFRSUMRY for parallel index rebuilds with MAXKSORT

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/21/2014 18:05:05

 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

 BMC40002I UTILITY ID = EXAMPLE16. DB2 SUBSYSTEM ID = DEDL.
 BMC40094I ATTEMPTING TO CONNECT TO DB2 SUBSYSTEM DEDL, USING PLAN AFRB111T
 BMC40024I SUCCESSFUL CONNECT TO DEDL (RELEASE 910 OF DB2) USING PLAN AFRB111T

 BMC40475I INPUT STATEMENTS PRINTED IN AFRSTMT

 BMC40336I ANALYZE 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 PLANNING 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 PLAN EXECUTION FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:04, UTILITY ELAPSED TIME = 00:00:08
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40476I EXECUTION SUMMARY
 BMC40480I      INDEXES REBUILT                       :  4

 BMC40005I UTILITY EXECUTION COMPLETE 08/21/2014 18:05:14, RETURN CODE = 4


AFRERR for parallel index rebuilds with MAXKSORT

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

 BMC40775W THERE ARE NO KEY VALUES FOR PART 2 OF INDEX RDAPXR.IX67P32
 BMC40775W THERE ARE NO KEY VALUES FOR PART 3 OF INDEX RDAPXR.IX67P32
 BMC40775W THERE ARE NO KEY VALUES FOR PART 4 OF INDEX RDAPXR.IX67P32
 BMC40775W THERE ARE NO KEY VALUES FOR PART 5 OF INDEX RDAPXR.IX67P32
 BMC40775W THERE ARE NO KEY VALUES FOR PART 6 OF INDEX RDAPXR.IX67P32


AFRSTMT for parallel index rebuilds with MAXKSORT

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 = DEDL
 BMC40932I                UTILID = EXAMPLE16
 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 = EXT3592
 BMC40967I         TAPE DEVICE11 = IBMATL
 BMC40967I         TAPE DEVICE12 = IBMVTS
 BMC40967I         TAPE DEVICE13 = PHXATL
 BMC40967I         TAPE DEVICE14 = SA3590
 BMC40967I         TAPE DEVICE15 = TAPEABL
 BMC40967I         TAPE DEVICE16 = 3590B
 BMC40967I         TAPE DEVICE17 = 3590E
 BMC40967I         TAPE DEVICE18 = 3480
 BMC40967I         TAPE DEVICE19 = 3400-9
 BMC40967I         TAPE DEVICE20 = SYS3480R
 BMC40967I         TAPE DEVICE21 = 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 18:05:06
 BMC40336I PACKAGE CHECKING AND BINDING FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:00
 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 = 9044K, TOTAL AVAILABLE MEMORY (AT LEAST) = 1414552K
 BMC40037I UTILID EXAMPLE16 WAS NOT FOUND IN THE BMCUTIL TABLE - UTILITY WILL RUN AS IF 'NEW' WERE SPECIFIED

 BMC40611I INPUT STATEMENTS:
 BMC40101I   OPTION MAXKSORT 12
 BMC40101I   REBUILD INDEX (ALL) TABLESPACE RMDSUPDB.TS67P32K
 BMC40101I
 BMC40957I MAXKSORT VALUE OVERRIDDEN, NEW VALUE = 12
 BMC96004I ZIIP ENABLED (0) USING SUBSYSTEM XBMA
 BMC40937I z/OS RELEASE = 1.13.00,  PID = HBB7780,  SMS RELEASE = 1.13.0
 BMC40157I AVAILABLE REGION BELOW 16M = 9032K, AVAILABLE REGION ABOVE 16M = 1404328K, NUMBER OF CPUS = 5
 BMC40020I BYT:0, 0, 0; BLK:0, 0, 0; TOT:1656364, 10037136, 10037136;iter: 1; RC:4

 BMC40335I ANALYZE STARTING 08/21/2014 18:05:06

 BMC40335I CATALOG LOOKUP STARTING 08/21/2014 18:05:06
 BMC40336I PROC IX STMT FINISHED.
 BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:00
 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:00
 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:00
 BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00

 BMC40336I COL 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 SCAN SYSKY 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 SYSFL 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

 BMC40068I THE KEYS FOR INDEX RDAPXR.IX67P324 WILL GO DIRECTLY TO THE SORT BECAUSE THERE IS NO SYSUT1 DD STATEMENT IN THE JCL
 BMC40068I THE KEYS FOR INDEX RDAPXR.IX67P323 WILL GO DIRECTLY TO THE SORT BECAUSE THERE IS NO SYSUT1 DD STATEMENT IN THE JCL
 BMC40068I THE KEYS FOR INDEX RDAPXR.IX67P322 WILL GO DIRECTLY TO THE SORT BECAUSE THERE IS NO SYSUT1 DD STATEMENT IN THE JCL
 BMC40068I THE KEYS FOR INDEX RDAPXR.IX67P32 WILL GO DIRECTLY TO THE SORT BECAUSE THERE IS NO SYSUT1 DD STATEMENT IN THE JCL
 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 IP 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>)
 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 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 18:05:07
 BMC40025I OUTPUT FROM COMMAND '-STO DB(RMDSUPDB) SPACE(TS67P32K) AT (COMMIT)' FOLLOWS:
 BMC40020I DSN9022I  *DEDL DSNTDDIS 'STOP DATABASE' NORMAL COMPLETION
 BMC40025I OUTPUT FROM COMMAND '-STO DB(RMDSUPDB) SPACE(IX67P324) AT(COMMIT)' FOLLOWS:
 BMC40020I DSN9022I  *DEDL DSNTDDIS 'STOP DATABASE' NORMAL COMPLETION
 BMC40025I OUTPUT FROM COMMAND '-STO DB(RMDSUPDB) SPACE(IX67P323) AT(COMMIT)' FOLLOWS:
 BMC40020I DSN9022I  *DEDL DSNTDDIS 'STOP DATABASE' NORMAL COMPLETION
 BMC40025I OUTPUT FROM COMMAND '-STO DB(RMDSUPDB) SPACE(IX67P322) AT(COMMIT)' FOLLOWS:
 BMC40020I DSN9022I  *DEDL DSNTDDIS 'STOP DATABASE' NORMAL COMPLETION
 BMC40025I OUTPUT FROM COMMAND '-STO DB(RMDSUPDB) SPACE(IX67P32) AT(COMMIT)' FOLLOWS:
 BMC40020I DSN9022I  *DEDL DSNTDDIS 'STOP DATABASE' NORMAL COMPLETION
 BMC40025I OUTPUT FROM COMMAND '-STA DB(RMDSUPDB) SPACE(TS67P32K) ACCESS(RO)' FOLLOWS:
 BMC40020I DSN9022I  *DEDL DSNTDDIS 'START DATABASE' NORMAL COMPLETION
 BMC40336I SYNCHRONIZATION 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 DDSCAN 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 PLANNING STARTING 08/21/2014 18:05:07

 BMC40335I PLAN EXECUTION STARTING 08/21/2014 18:05:10
 BMC40025I OUTPUT FROM COMMAND '-STA DB(RMDSUPDB) SPACE(TS67P32K)  ACCESS(RW)' FOLLOWS:
 BMC40020I DSN9022I  *DEDL DSNTDDIS 'START DATABASE' NORMAL COMPLETION
 BMC40025I OUTPUT FROM COMMAND '-STA DB(RMDSUPDB) SPACE(IX67P324)  ACCESS(RW)' FOLLOWS:
 BMC40020I DSN9022I  *DEDL DSNTDDIS 'START DATABASE' NORMAL COMPLETION
 BMC40025I OUTPUT FROM COMMAND '-STA DB(RMDSUPDB) SPACE(IX67P323)  ACCESS(RW)' FOLLOWS:
 BMC40020I DSN9022I  *DEDL DSNTDDIS 'START DATABASE' NORMAL COMPLETION
 BMC40025I OUTPUT FROM COMMAND '-STA DB(RMDSUPDB) SPACE(IX67P322)  ACCESS(RW)' FOLLOWS:
 BMC40020I DSN9022I  *DEDL DSNTDDIS 'START DATABASE' NORMAL COMPLETION
 BMC40025I OUTPUT FROM COMMAND '-STA DB(RMDSUPDB) SPACE(IX67P32)  ACCESS(RW)' FOLLOWS:
 BMC40020I DSN9022I  *DEDL DSNTDDIS 'START DATABASE' NORMAL COMPLETION


AFRPRINT for parallel index rebuilds with MAXKSORT

BMC40018I RECOVER PLUS FOR DB2 V11.2.00   (RECOVER  AFRPRINT)
 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 UNLOAD PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR001
 BMC40301I    TABLESPACE = RMDSUPDB.TS67P32K
 BMC40305I         DSNUM = 1
 BMC96400I UNLOAD PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR002
 BMC40301I    TABLESPACE = RMDSUPDB.TS67P32K
 BMC40305I         DSNUM = 2
 BMC96400I UNLOAD PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR003
 BMC40301I    TABLESPACE = RMDSUPDB.TS67P32K
 BMC40305I         DSNUM = 3
 BMC96400I UNLOAD PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR004
 BMC40301I    TABLESPACE = RMDSUPDB.TS67P32K
 BMC40305I         DSNUM = 4
 BMC96400I UNLOAD PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR005
 BMC40301I    TABLESPACE = RMDSUPDB.TS67P32K
 BMC40305I         DSNUM = 5
 BMC96400I UNLOAD PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR002
 BMC40301I    TABLESPACE = RMDSUPDB.TS67P32K
 BMC40305I         DSNUM = 6
 BMC96400I BUILD PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR001
 BMC40303I    INDEX = RDAPXR.IX67P32
 BMC40305I       DSNUM = 1
 BMC96400I BUILD PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR002
 BMC40303I    INDEX = RDAPXR.IX67P32
 BMC40305I       DSNUM = 2
 BMC96400I BUILD PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR003
 BMC40303I    INDEX = RDAPXR.IX67P32
 BMC40305I       DSNUM = 3
 BMC96400I BUILD PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR004
 BMC40303I    INDEX = RDAPXR.IX67P32
 BMC40305I       DSNUM = 4
 BMC96400I BUILD PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR005
 BMC40303I    INDEX = RDAPXR.IX67P32
 BMC40305I       DSNUM = 5
 BMC96400I BUILD PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR006
 BMC40303I    INDEX = RDAPXR.IX67P32
 BMC40305I       DSNUM = 6
 BMC96400I BUILD PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR007
 BMC40303I    INDEX = RDAPXR.IX67P322
 BMC96400I BUILD PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR008
 BMC40303I    INDEX = RDAPXR.IX67P324
 BMC96400I BUILD PHASE MESSAGES FOR THE FOLLOWING OBJECT ARE IN FILE AFRPR009
 BMC40303I    INDEX = RDAPXR.IX67P323

In addition to AFRPR001 in the following figure, this job also produces AFRPR002 through AFRPR009.

AFRPR001 for parallel index rebuilds with MAXKSORT

BMC40018I RECOVER PLUS FOR DB2 V11.2.00   (RECOVER  AFRPR001)
 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 UNLOAD PHASE STARTING 08/21/2014 18:05:10
 BMC40301I    TABLESPACE = RMDSUPDB.TS67P32K
 BMC40305I         DSNUM = 1
 BMC40306I    COLLECTING KEYS FOR:
 BMC40303I         INDEX = RDAPXR.IX67P32
 BMC40305I            DSNUM = 1
 BMC40303I         INDEX = RDAPXR.IX67P324
 BMC40303I         INDEX = RDAPXR.IX67P322
 BMC40303I         INDEX = RDAPXR.IX67P323
 BMC96304I THIS PHASE WILL RUN IN EXECUTION SUBTASK 1
 BMC40593I START UNLOAD COMPLETE, ELAPSED TIME = 00:00:00
 BMC40102I UNLOAD KEYS STEP STARTING
 BMC40350I DATA SET DEDLCAT.DSNDBD.RMDSUPDB.TS67P32K.I0001.A001 WAS SUCCESSFULLY ALLOCATED TO DDNAME SYS00008 ELAPSED = 00:00:00
 BMC40593I INITIALIZATION COMPLETE, ELAPSED TIME = 00:00:00
 BMC96303I KEY SORT FOR INDEX GROUP 1 WILL USE THREAD 1
 BMC40954I AVAILABLE MEMORY BELOW THE LINE = 8772K, TOTAL AVAILABLE MEMORY (AT LEAST) = 1402096K
 BMC40441I BMCSORT PRODUCT LOCATED AND WILL BE USED
 BMC40020I ORG-BEL:0, 0, 0; EXT:0, 0, 0; TOT:1643692, 9993468, 9993468;ITER: 1; RC:4
 BMC40020I SYSEVENT STGTEST STORAGE AVAILABLE = 9993468
 BMC40020I OPT-SOPT:SBEL:3145728; ABOV:1432600576; HYPR:0; REAS:0; MMEM:0;  NUMS:12; SEAD:299DC148; RSV1:0;
 BMC40020I OPT-SENT:AVGR:126; FSZ:    322335; SBEL:262144; ABOV:763617280; HYPR:0;  DATA:59; KEYL:126; RSRV:0; FLG1:0; FLG2:60
 BMC40020I SORT FILE SIZE = 40614210, SORT MEMORY = 987290
 BMC96303I KEY SORT FOR INDEX GROUP 2 WILL USE THREAD 2
 BMC40954I AVAILABLE MEMORY BELOW THE LINE = 8692K, TOTAL AVAILABLE MEMORY (AT LEAST) = 1399576K
 BMC40441I BMCSORT PRODUCT LOCATED AND WILL BE USED
 BMC40020I ORG-BEL:0, 0, 0; EXT:0, 0, 0; TOT:1640852, 9990628, 9990628;ITER: 1; RC:4
 BMC40020I SYSEVENT STGTEST STORAGE AVAILABLE = 9990628
 BMC40020I OPT-SOPT:SBEL:2883584; ABOV:1428544512; HYPR:0; REAS:0; MMEM:0;  NUMS:11; SEAD:2969E288; RSV1:0;
 BMC40020I OPT-SENT:AVGR:36; FSZ:    967005; SBEL:262144; ABOV:1415360512; HYPR:0;  DATA:30; KEYL:36; RSRV:0; FLG1:0; FLG2:60
 BMC40020I SORT FILE SIZE = 34812180, SORT MEMORY = 914053
 BMC40906I NUMBER OF PAGES EXAMINED = 11112, ROWS EXAMINED = 300000, KEYS EXTRACTED = 1200000
 BMC40907I INDIRECT REFERENCES: FORWARD = 0, BACKWARD = 0
 BMC40901I TOTAL WAITS = 92
 BMC40916I TABLESPACE READ WAITS = 53, KEY OUT WAITS = 39
 BMC40917I TOTAL TIME FOR WAITS = 00:00:01
 BMC40918I TABLESPACE READ WAIT TIME = 00:00:01,  KEY OUT WAIT TIME = 00:00:00
 BMC40952I NUMBER OF PAGES READ FROM INPUT SPACE = 11115
 BMC40900I UNLOAD KEYS STEP COMPLETE
 BMC40352I DDNAME SYS00008 (DSN DEDLCAT.DSNDBD.RMDSUPDB.TS67P32K.I0001.A001) WAS SUCCESSFULLY UNALLOCATED
 BMC40593I UNLOAD KEY PROCESS COMPLETE, ELAPSED TIME = 00:00:02
 BMC40012I UNLOAD PHASE COMPLETE. ELAPSED TIME = 00:00:02, TIME SINCE UTILITY START = 00:00:06
 BMC40868I UNLOAD PHASE COMPLETE. ACCUMULATED TCB TIME = 00:00:00


 BMC40016I BUILD PHASE STARTING 08/21/2014 18:05:12
 BMC40303I    INDEX = RDAPXR.IX67P32
 BMC40305I       DSNUM = 1

 BMC40484I MESSAGES FROM PHASE SUBTASK:

 BMC40060I PENDING FLAG RBDP SET FOR
 BMC40346I    INDEXSPACE = RMDSUPDB.IX67P32
 BMC40305I    DSNUM = 1
 BMC40356I AN IDCAMS 'DELETE CLUSTER' OPERATION WAS SUCCESSFUL ON DATASET DEDLCAT.DSNDBC.RMDSUPDB.IX67P32.I0001.A001
 BMC40356I AN IDCAMS 'DEFINE CLUSTER' OPERATION WAS SUCCESSFUL ON DATASET DEDLCAT.DSNDBC.RMDSUPDB.IX67P32.I0001.A001
 BMC40350I DATA SET DEDLCAT.DSNDBD.RMDSUPDB.IX67P32.I0001.A001 WAS SUCCESSFULLY ALLOCATED TO DDNAME SYS00015 ELAPSED = 00:00:00

 BMC40485I END OF PHASE SUBTASK MESSAGES

 BMC96304I THIS PHASE WILL RUN IN EXECUTION SUBTASK 1
 BMC40102I BUILD INDEX STEP STARTING
 BMC40593I START BUILD COMPLETE, ELAPSED TIME = 00:00:00
 BMC40366I BUFFER CREATED FOR PAGE SIZE 4K, REFRESH=1
 BMC40367I RANDOM BUFFER: NUMBER OF PAGES = 1000, MINIMUM CLEAN = 100, NUMBER TO WRITE PER I/O = 100
 BMC40368I RANDOM BUFFER: MAXIMUM OUTSTANDING WRITES = 5, MAXIMUM OUTSTANDING READS = 50, HASH HEADS = 1021
 BMC40369I SEQUENTIAL BUFFER: NUMBER OF CYLINDERS = 5, IDLE CYLINDERS = 1, CI'S PER CYLINDER = 180
 BMC40593I INITIALIZATION COMPLETE, ELAPSED TIME = 00:00:00
 BMC40088I WAIT TIME FOR SORT OUTPUT PHASE = 00:00:00
 BMC40593I PRIMED SKEY BUFFERS COMPLETE, ELAPSED TIME = 00:00:00
 BMC40403I EXTENT ALLOCATED FOR INDEX SPACE RDAPXR.IX67P32
 BMC40305I             DSNUM = 1
 BMC40302I          DSN = DEDLCAT.DSNDBD.RMDSUPDB.IX67P32.I0001.A001
 BMC40403I EXTENT ALLOCATED FOR INDEX SPACE RDAPXR.IX67P32
 BMC40305I             DSNUM = 1
 BMC40302I          DSN = DEDLCAT.DSNDBD.RMDSUPDB.IX67P32.I0001.A001
 BMC40593I READING AND INSERTING ALL KEYS COMPLETE, ELAPSED TIME = 00:00:00
 BMC40403I EXTENT ALLOCATED FOR INDEX SPACE RDAPXR.IX67P32
 BMC40305I             DSNUM = 1
 BMC40302I          DSN = DEDLCAT.DSNDBD.RMDSUPDB.IX67P32.I0001.A001
 BMC40370I BUFFER MANAGER TERMINATION, GET PAGE COUNT = 4734, RANDOM SEARCH COUNT = 3153
 BMC40372I    TOTAL WAITS IN BUFFER MANAGER = 5
 BMC40373I    RANDOM WRITE WAITS = 1, RANDOM READ WAITS = 2, RANDOM SYNC WAITS = 0
 BMC40374I    CYLINDER WAITS = 2, SEQUENTIAL SYNC WAITS = 0
 BMC40371I    CYLINDERS WRITTEN = 9

 BMC40375I    RANDOM READS = 2, HITS = 0
 BMC40376I    PREFETCH COUNT = 0, HITS CAUSED BY PREFETCH = 0, HITS ON PREFETCH = 0
 BMC40377I    RANDOM WRITES = 4 IN 1 GROUPS
 BMC40378I    TOTAL WAIT TIME = 00:00:00, RANDOM WRITE TIME = 00:00:00, RANDOM READ TIME = 00:00:00
 BMC40379I    CYLINDER WAIT TIME = 00:00:00
 BMC40770I BUILD STATISTICS: # INPUT RECORDS = 300000 # KEY VALUES = 300000
 BMC40771I             # WAITS FOR SORT = 10
 BMC40772I             # GETPAGE CALLS = 4734  # PAGES WRITTEN = 1581  # LEAF PAGES = 1571
 BMC40919I TOTAL TIME FOR WAITS = 00:00:00, WAIT TIME FOR BUFFER MANAGER = 00:00:00
 BMC40920I WAIT TIME FOR SORT = 00:00:00
 BMC40352I DDNAME SYS00015 (DSN DEDLCAT.DSNDBD.RMDSUPDB.IX67P32.I0001.A001) WAS SUCCESSFULLY UNALLOCATED
 BMC40593I TERMINATION COMPLETE, ELAPSED TIME = 00:00:00
 BMC40900I BUILD INDEX STEP COMPLETE
 BMC40091I 08/21/2014 18:05:14 SUBPHASE CHECKPOINT TAKEN FOR BUILD    PHASE
 BMC40060I PENDING FLAG RBDP RESET FOR
 BMC40346I    INDEXSPACE = RMDSUPDB.IX67P32
 BMC40305I    DSNUM = 1
 BMC40012I BUILD PHASE COMPLETE. ELAPSED TIME = 00:00:01, TIME SINCE UTILITY START = 00:00:08
 BMC40868I BUILD PHASE COMPLETE. ACCUMULATED TCB TIME = 00:00:00


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

Comments