Example 15: Using MAXKSORT for parallel index rebuilds
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
Comments
Log in or register to comment.