Example 13: Materializing pending definition changes
The following table describes the key command options for this job:
Command options used in JCL | Description |
|---|---|
REORG TABLESPACE | Specifies that the table space named in the statement is to be reorganized |
ORDER YES | Sorts the data rows |
COPY YES | Creates a Db2 image copy of the table space Because the INLINECP installation option is YES, REORG PLUS creates an inline image copy. |
ANALYZE SAMPLE | Gathers information about the objects that you are reorganizing and provides estimated sizes for SYSREC, SYSUT1, SORTWK, and copy data sets SAMPLE tells REORG PLUS to read the minimum number of pages needed to determine a reasonable estimate for the cardinality. |
DSNPAT | Specifies a pattern of variables and text that REORG PLUS uses to create data set names for dynamic data set allocation, overriding the default pattern |
The following figure shows the JCL for Example 13:
// JOBCARD
//**********************ARUEX013***************************************
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//* PARTITIONED TABLESPACE THAT USES TABLE-BASED PARTITIONING. *
//* DATA-PARTITIONED SECONDARY INDEX (DPSI) AND NON-PARTITIONED *
//* SECONDARY (NPSI) INDEXES DEFINED. *
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//* PARTITIONED TABLE SPACE (UTS) *
//* WITH PENDING DDL - ALTER BUFFERPOOL ISSUED PRIOR TO REORG *
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//*====================================================================
//* Replace "DB2SYS" by your DB2 subsystem name. *
//* Use your DB2 product install libraries for STEPLIBS : *
//* PRODUCT.LIBRARIES *
//* DB2.DSNEXIT *
//* DB2.DSNLOAD *
//*====================================================================
//EXAMPL13 EXEC PGM=ARUUMAIN,
// PARM='DB2SYS,ARUEX13,NEW/RESTART,,MSGLEVEL(1)'
//* SSID,UTILID,RSTART,NOTIFY,MSGLEVEL
//STEPLIB DD DISP=SHR,DSN=PRODUCT.LIBRARIES
// DD DISP=SHR,DSN=DB2.DSNEXIT
// DD DISP=SHR,DSN=DB2.DSNLOAD
//*
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//DDLOUT DD SYSOUT=*
//ASUSRPRT DD SYSOUT=*
//*
//SYSIN DD *
REORG TABLESPACE EXMPLE13.EXMPLE13
XBMID XV2B SHRLEVEL CHANGE
COPY YES
ORDER YES
ANALYZE SAMPLE
REBALANCE
FASTSWITCH YES
DDTYPE UNLOAD
UNIT (WORK)
DSNPAT 'ARU.EXAMPL13.DEMO.&DB.&TSIX.&DDNAME'
DDTYPE WORK
UNIT (WORK)
DSNPAT 'ARU.EXAMPL13.DEMO.&DB.&TSIX.&DDNAME'
DDTYPE LOCPFCPY
UNIT (WORK)
DSNPAT 'ARU.EXAMPL13.DEMO.&DB.&TSIX.&DDNAME'
/*
//**********************ARUEX013***************************************
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//* PARTITIONED TABLESPACE THAT USES TABLE-BASED PARTITIONING. *
//* DATA-PARTITIONED SECONDARY INDEX (DPSI) AND NON-PARTITIONED *
//* SECONDARY (NPSI) INDEXES DEFINED. *
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//* PARTITIONED TABLE SPACE (UTS) *
//* WITH PENDING DDL - ALTER BUFFERPOOL ISSUED PRIOR TO REORG *
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//*====================================================================
//* Replace "DB2SYS" by your DB2 subsystem name. *
//* Use your DB2 product install libraries for STEPLIBS : *
//* PRODUCT.LIBRARIES *
//* DB2.DSNEXIT *
//* DB2.DSNLOAD *
//*====================================================================
//EXAMPL13 EXEC PGM=ARUUMAIN,
// PARM='DB2SYS,ARUEX13,NEW/RESTART,,MSGLEVEL(1)'
//* SSID,UTILID,RSTART,NOTIFY,MSGLEVEL
//STEPLIB DD DISP=SHR,DSN=PRODUCT.LIBRARIES
// DD DISP=SHR,DSN=DB2.DSNEXIT
// DD DISP=SHR,DSN=DB2.DSNLOAD
//*
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//DDLOUT DD SYSOUT=*
//ASUSRPRT DD SYSOUT=*
//*
//SYSIN DD *
REORG TABLESPACE EXMPLE13.EXMPLE13
XBMID XV2B SHRLEVEL CHANGE
COPY YES
ORDER YES
ANALYZE SAMPLE
REBALANCE
FASTSWITCH YES
DDTYPE UNLOAD
UNIT (WORK)
DSNPAT 'ARU.EXAMPL13.DEMO.&DB.&TSIX.&DDNAME'
DDTYPE WORK
UNIT (WORK)
DSNPAT 'ARU.EXAMPL13.DEMO.&DB.&TSIX.&DDNAME'
DDTYPE LOCPFCPY
UNIT (WORK)
DSNPAT 'ARU.EXAMPL13.DEMO.&DB.&TSIX.&DDNAME'
/*
SYSPRINT for example 13
The following figure shows the SYSPRINT for Example 13.
1 ***** B M C R E O R G P L U S F O R D B 2 V13R1.00 *****
(C) COPYRIGHT 1988 - 2022 BMC SOFTWARE, INC.
REORG PLUS TECHNOLOGY IS PROTECTED BY ONE OR MORE OF THE FOLLOWING U.S. PATENTS: 5,222,235 AND 7,809,762
-BMC50001I UTILITY EXECUTION STARTING 1/29/2022 3:53:29 ...
BMC50002I UTILITY ID = 'EXAMPL13'. DB2 SUBSYSTEM ID = 'DEMO'. OPTION MODULE = 'ARU$OPTS'.
BMC50471I z/OS 2.4.0,PID=HBB77C0,DFSMS FOR Z/OS=2.4.0,DB2=13.1.501
BMC50471I REGION=0M,BELOW 16M=8840K,ABOVE 16M=1031048K,IEFUSI=NO,CPUs=7,GPs=5,zIIPs=2
BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040300M,MEMLIMIT SET BY:REGION=0
BMC50471I SMFID=DB2B,JOBID=J0709660,JOB=EXAMPL13,STEP=BMCREORG,CPU=8561-615 (z15)/1.71
0
BMC50471I REORG PLUS FOR DB2--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I SOLUTION COMMON CODE--V13.01.00 BASE
BMC50471I MAINT: BPJ1541 BPJ1713 BPJ2211
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922 BPJ0996 BPJ1164 BPJ1309 BPJ1386 BPJ1497 BPJ1594 BPJ1724 BPJ1809
BMC50471I BPJ1833 BPJ1891 BPJ1905 BPJ2109 BPJ2232 BPJ2297
BMC50471I BMC STATS API--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.02.01
BMC50471I MAINT: BPE0443 BPE0445 BPE0447 BPE0449 BPE0450 BPE0451 BPE0452 BPE0455 BPE0456 BPE0457 BPE0460 BPE0463
BMC50471I BPE0467 BPE0468 BPE0469 BPE0473 BPE0474 BPE0475 BPE0479 BPE0480 BPE0482 BPE0487 BPE0488 BPE0489
BMC50471I BPE0493 BPE0497 BPE0498 BPE0501 BPE0503 BPE0507 BPE0512 BPE0513 BPE0517 BPE0518 BPE0519 BPE0523
BMC50471I BPE0524 BPE0527 BPE0528 BPE0530 BPE0531 BPE0534 BPE0535 BPE0540 BPE0541 BPE0542 BPE0545 BPE0549
BMC50471I BPE0551 BPE0552 BPE0555 BPE0557
0
BMC50471I ANALMAX=1000% ICTYPE=AUTO SDUMP=YES
BMC50471I ARC=NO IDCACHE=10000 SHORTMEMORY=CONTINUE
BMC50471I ARCHDDN=SYSARC INDREFLM=10 SIXSNAP=NO
BMC50471I ARCHFORMAT=BMC INLINECP=YES SMAX=0
BMC50471I AVAILPAGEPCT=100 INVALIDATECACHE=YES SMCORE=(0K,0K)
BMC50471I BILDMAX=300% KEEPDICTIONARY=NO SORTDEVT=(,SYSALLDA)
BMC50471I BMCHIST=YES LEAFDSLM=200 SORTNUM=32
BMC50471I CBUFFS=30 LOCKROW=YES SPILDCLS=NONE
BMC50471I CONDEXEC=NO LOGFINAL=NONE SPILDSNP=&UID
BMC50471I COPYDDN=(BMCCPY,BMCCPZ) LOGMEM=0 SPILSCLS=NONE
BMC50471I COPYLVL=PART LOGSPIL=(20000,10000) SPILUNIT=WORK
BMC50471I COPYMAX=1000% LOGTHRSH=0 SQLDELAY=3
BMC50471I COPYSUBSET=NO LONGLOG=CONTINUE SQLRETRY=100
BMC50471I CPYRFAIL=TERM LONGNAMETRUNC=MIDDLE SSREPORT=REPORT_SWITCH
BMC50471I DATACAP=NO MAPTEXIT=(NONE,REXX) STAGEDSN=BMC
BMC50471I DDLDDN=DDLIN MAXNEWPARTS=2 STOP@CMT=YES
BMC50471I DEADLINE=NONE MAXRO=300 STOPDELAY=1
BMC50471I DELAY=1200 MAXSORTMEMORY=0 STOPRETRY=300
BMC50471I DELFILES=YES MAXTAPE=3 TAPEDISP=DELETE
BMC50471I DESCCDE=(3,7) MGEXTENT=CONTINUE TASKMAX=1000%
BMC50471I DRAINTYP=ALL MINSORTMEMORY=0 TERMEXIT=(NONE,REXX)
BMC50471I DRNDELAY=1 MSGLEVEL=1 TIMEOUT=TERM
BMC50471I DRNRETRY=255 OFFPOSLM=10 TOTALPAGEPCT=0
BMC50471I DRNWAIT=NONE OPNDB2ID=YES TSSAMPLEPCT=100
BMC50471I DSNUEXIT=(NONE,ASM) ORIGDISP=DELETE UBUFFS=20
BMC50471I DSNUTILB=YES PREFORMAT=NO UNLDDN=SYSREC
BMC50471I DSPLOCKS=DRNFAIL RCVICDDN=(BMCIRY,BMCIRZ) UNLDMAX=300%
BMC50471I DSRSEXIT=(NONE,REXX) RCVYDDN=(BMCRCY,BMCRCZ) UNLOAD=RELOAD
BMC50471I EXCLDUMP=(X37,X22,X06) REDEFINE=YES UXSTATE=SUP
BMC50471I FASTSWITCH=NO RENMMAX=30 WBUFFS=(20,10)
BMC50471I FILECHK=WARN RIDCWTO=NO WORKDDN=SYSUT1
BMC50471I FORCE_AT=(START,3) RIDMDSSZ=2097152 WORKUNIT=SYSALLDA
BMC50471I FORCE_RPT=NO RIDMMAXD=1 WRLOG=NO
BMC50471I FORCE=NONE RMAPMEM=0 XBMID=
BMC50471I FSFALLBACK=NO RORGMAX=300% ZIIP=ENABLED
BMC50471I FSTHRESHOLD=0 ROUTCDE=(11,1)
BMC50471I ICDDN=(BMCICY,BMCICZ) SCPYMAX=8
0
BMC50471I PLAN=ARU1310T
0
BMC50470I DDTYPE = UNLOAD WORK SORTWORK
BMC50470I ACTIVE = YES YES NO
BMC50470I IFALLOC = USE USE USE
BMC50470I ALLOC = N/A N/A ANY
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) N/A
BMC50470I VOLCNT = (25,25) (25,25) N/A
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) N/A
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) N/A
BMC50470I EXPDT = N/A N/A N/A
BMC50470I RETPD = N/A N/A N/A
BMC50470I GDGLIMIT = N/A N/A N/A
BMC50470I GDGEMPTY = N/A N/A N/A
BMC50470I GDGSCRAT = N/A N/A N/A
0
BMC50470I DDTYPE = ARCHIVE LOCPFCPY LOCPICPY
BMC50470I ACTIVE = NO YES YES
BMC50470I IFALLOC = USE USE USE
BMC50470I ALLOC = N/A N/A N/A
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (5,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = LOCBFCPY LOCBICPY REMPFCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I ALLOC = N/A N/A N/A
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = REMPICPY REMBFCPY REMBICPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I ALLOC = N/A N/A
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = SYSPUNCH
BMC50470I ACTIVE = YES
BMC50470I IFALLOC = USE
BMC50470I ALLOC = N/A
BMC50470I SMS = NO
BMC50470I SMSUNIT = NO
BMC50470I SIZEPCT = (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0)
BMC50470I VOLCNT = (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK))
BMC50470I DATACLAS = (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE)
BMC50470I THRESHLD = 0
BMC50470I MAXEXTSZ = ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 0
BMC50470I GDGEMPTY = NO
BMC50470I GDGSCRAT = NO
0
BMC50470I DDTYPE = LOCPLCPY LOCBLCPY
BMC50470I ACTIVE = NO NO
BMC50470I IFALLOC = USE USE
BMC50470I ALLOC = N/A N/A
BMC50470I SMS = NO NO
BMC50470I SMSUNIT = NO NO
BMC50470I SIZEPCT = (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5
BMC50470I GDGEMPTY = NO NO
BMC50470I GDGSCRAT = NO NO
0
BMC50470I DDTYPE = REMPLCPY REMBLCPY
BMC50470I ACTIVE = NO NO
BMC50470I IFALLOC = USE USE
BMC50470I ALLOC = N/A N/A
BMC50470I SMS = NO NO
BMC50470I SMSUNIT = NO NO
BMC50470I SIZEPCT = (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5
BMC50470I GDGEMPTY = NO NO
BMC50470I GDGSCRAT = NO NO
0
0
0
0
BMC50483I UNLOAD DSNPAT=&UID..BMC.&TSIX.&DDNAME
BMC50483I WORK DSNPAT=&UID..BMC.&TSIX.&DDNAME
BMC50483I SORTWORK DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I ARCHIVE DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I SYSPUNCH DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50483I LOCPFCPY DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
BMC50483I LOCPICPY DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
BMC50483I LOCBFCPY DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
BMC50483I LOCBICPY DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
BMC50483I LOCPLCPY DSNPAT=&UID.&DDNAME.&TSIX..T&TIME
BMC50483I LOCBLCPY DSNPAT=&UID.&DDNAME.&TSIX..T&TIME
0
BMC50483I REMPFCPY DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
BMC50483I REMPICPY DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
BMC50483I REMBFCPY DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
BMC50483I REMPLCPY DSNPAT=&UID.&DDNAME.&TSIX..T&TIME
BMC50483I REMBLCPY DSNPAT=&UID.&DDNAME.&TSIX..T&TIME
BMC50471I DB2 DSNHDECP MODULE SETTINGS:
BMC50471I VERSION = 1310
BMC50471I SUBSYSTEM DEFAULT = DEMO
BMC50471I CHARACTER SET = ALPHANUM
BMC50471I DATE FORMAT = USA
BMC50471I TIME FORMAT = USA
BMC50471I LOCAL DATE LENGTH = 0
BMC50471I LOCAL TIME LENGTH = 0
BMC50471I DECIMAL POINT = PERIOD
BMC50471I DECIMAL ARITHMETIC = 15
BMC50471I DELIMITER = DEFAULT
BMC50471I SQL DELIMITER = DEFAULT
BMC50471I ENCODING SCHEME = EBCDIC
BMC50471I APPL. ENCODING SCHEME = EBCDIC
BMC50471I MIXED = NO
BMC50471I EBCDIC CCSID = (37,65534,65534)
BMC50471I ASCII CCSID = (819,65534,65534)
BMC50471I UNICODE CCSID = (367,1208,1200)
BMC50471I IMPLICIT TIME ZONE = CURRENT (-06:00)
BMC50658I DB2 CURRENT FUNCTION LEVEL IS V13R1M501
BMC50659I DB2 CATALOG LEVEL IS V13R1M501
BMC50660I DB2 HIGHEST ACTIVATED FUNCTION LEVEL IS V13R1M501
BMC50661I DB2 CODE LEVEL IS V13R1M501
BMC50471I BMC_BMCUTIL ='BMCUTIL.CMN_BMCUTIL'
BMC50471I BMC_BMCSYNC ='BMCUTIL.CMN_BMCSYNC'
BMC50471I BMC_BMCHIST ='BMCUTIL.CMN_BMCHIST'
BMC50471I BMC_BMCDICT ='BMCUTIL.CMN_BMCDICT'
BMC50471I BMC_BMCXCOPY ='BMCUTIL.CMN_BMCXCOPY'
BMC50471I BMC_BMCSMARTSWITCH='BMCUTIL.CMN_BMCSWITCH'
BMC50471I DASD MANAGER PLUS TABLES:
BMC50471I ...'ATS131.RS_COLDIST_VW'
BMC50471I ...'ATS131.RS_COLDISTSTAT_VW'
BMC50471I ...'ATS131.RS_COLSTATS_VW'
BMC50471I ...'ATS131.RS_COLUMNS_VW'
BMC50471I ...'ATS131.RS_INDEXES_VW'
BMC50471I ...'ATS131.RS_INDEXPART_VW'
BMC50471I ...'ATS131.RS_IXPART_DIST_VW'
BMC50471I ...'ATS131.RS_KEYTGTDIST_VW'
BMC50471I ...'ATS131.RS_STOGROUP_VW'
BMC50471I ...'ATS131.RS_TABLEPART_VW'
BMC50471I ...'ATS131.RS_TABLES_VW'
BMC50471I ...'ATS131.RS_TABLESPACE_VW'
BMC50471I ...'ATS131.RS_TSPART_DIST_VW'
0
BMC50102I REORG TABLESPACE EXMPLE13.EXMPLE13
BMC50102I XBMID XV2B SHRLEVEL CHANGE
BMC50102I COPY YES
BMC50102I ORDER YES
BMC50102I ANALYZE SAMPLE
BMC50102I REBALANCE
BMC50102I FASTSWITCH YES
BMC50102I DDTYPE UNLOAD
BMC50102I UNIT (WORK)
BMC50102I DSNPAT 'ARU.EXMPL13A.DEMO.&DB.&TSIX.&DDNAME'
BMC50102I DDTYPE WORK
BMC50102I UNIT (WORK)
BMC50102I DSNPAT 'ARU.EXMPL13A.DEMO.&DB.&TSIX.&DDNAME'
BMC50102I DDTYPE LOCPFCPY
BMC50102I UNIT (WORK)
BMC50102I DSNPAT 'ARU.EXMPL13A.DEMO.&DB.&TSIX.&DDNAME'
BMC50102I
BMC50109I 'FASTSWITCH=YES' OPTION SPECIFIED. OPTION 'STAGEDSN=BMC' IGNORED
BMC50138I 'UPDATEDB2STATS NO' CHANGED TO 'UPDATEDB2STATS YES' DUE TO PENDING ALTER(S)
BMC50138I 'CPYRFAIL TERM' CHANGED TO 'CPYRFAIL COPYPEND' DUE TO PENDING ALTER(S)
BMC50004I UTILINIT PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC54000I SMARTSWITCH NOT SUPPORTED - NO BMC AMI UTILITIES VERSION FOUND
BMC54003I SMARTSWITCH RULE: FORCE_NO_SWITCH COMMENT: SMARTSWITCH NOT ACTIVATED, NO ROWS ON POLICY TABLE
BMC50199I REORG PLUS PROCESSING CONTINUES
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XV2B
BMC50244I PROCESSING PAGESET DBID(1955) PSID(2) PART(1) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00000000 FOR DBID(1955) PSID(2)
BMC50245I REGISTERING SYSTEM PAGE - 00000022 FOR DBID(1955) PSID(2)
BMC50244I PROCESSING PAGESET DBID(1955) PSID(2) PART(2) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00100000 FOR DBID(1955) PSID(2)
BMC50245I REGISTERING SYSTEM PAGE - 00100022 FOR DBID(1955) PSID(2)
BMC51301I 3: SAMPLING STATISTICS: PART=1,TP=8743,SP=117,SR=7916,AVGR=52,SD=66,SE=0,AVGF=6765,SD=65,SE=202,EP=11
BMC51301I 3: SAMPLING STATISTICS: PART=1,TP=8743,SP=232,SR=15763,AVGR=52,SD=66,SE=0,AVGF=6794,SD=65,SE=141,EP=21
BMC50244I PROCESSING PAGESET DBID(1955) PSID(2) PART(3) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00200000 FOR DBID(1955) PSID(2)
BMC50245I REGISTERING SYSTEM PAGE - 00200022 FOR DBID(1955) PSID(2)
BMC51301I 2: SAMPLING STATISTICS: PART=2,TP=4823,SP=109,SR=7527,AVGR=52,SD=66,SE=0,AVGF=6905,SD=65,SE=188,EP=8
BMC51301I 3: SAMPLING STATISTICS: PART=1,TP=8743,SP=346,SR=23597,AVGR=52,SD=66,SE=0,AVGF=6819,SD=65,SE=113,EP=30
BMC51301I 2: SAMPLING STATISTICS: PART=2,TP=4823,SP=217,SR=15135,AVGR=52,SD=66,SE=0,AVGF=6974,SD=65,SE=125,EP=14
BMC51301I 1: SAMPLING STATISTICS: PART=3,TP=1834,SP=99,SR=6983,AVGR=52,SD=66,SE=0,AVGF=7053,SD=65,SE=183,EP=6
BMC51301I 2: SAMPLING STATISTICS: PART=2,TP=4823,SP=324,SR=22232,AVGR=52,SD=66,SE=0,AVGF=6861,SD=65,SE=113,EP=26
BMC51301I 1: SAMPLING STATISTICS: PART=3,TP=1834,SP=201,SR=13997,AVGR=52,SD=66,SE=0,AVGF=6963,SD=65,SE=141,EP=15
BMC51301I 1: SAMPLING STATISTICS: PART=3,TP=1834,SP=297,SR=20648,AVGR=52,SD=66,SE=0,AVGF=6952,SD=65,SE=117,EP=23
BMC51265I ESTIMATED CARDINALITY OF SPACE = 1054040 AVG SORTWK ROW LENGTH = 52 AVG UNLOAD ROW LENGTH = 52
BMC50484I ESTIMATED CARDINALITY OF PART 0001 = 351346 AVG SORTWK ROW LENGTH = 52 AVG UNLOAD ROW LENGTH = 52
BMC50484I ESTIMATED CARDINALITY OF PART 0002 = 351346 AVG SORTWK ROW LENGTH = 52 AVG UNLOAD ROW LENGTH = 52
BMC50484I ESTIMATED CARDINALITY OF PART 0003 = 351348 AVG SORTWK ROW LENGTH = 52 AVG UNLOAD ROW LENGTH = 52
BMC51264I UNLOAD WILL READ 15392 DATA PAGES FROM SPACE 'EXMPLE13.EXMPLE13'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XV2B
BMC50004I ANALYZE PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XV2B
BMC50425I &JOBNAME = EXAMPL13 &STEPNAME = BMCREORG &DB = EXMPLE13 &TSIX = EXMPLE13 &RTYPE = TS
BMC50425I &UID = BMCPMN &DATE = 012922 &TIME = 035329 &SSID = DEMO &UTIL = EXAMPL13
BMC50425I &UTILPFX = EXAMPL13 &UTILSFX = &DATE8 = 01292022 &GRPNM = DEMO &VCAT = DEMOCAT
BMC50425I &TIME4 = 0353 &DATEJ = 2021363 &JDATE = 21363
BMC50702I LOG PROCESSING STARTED AT 1/29/2022 03:53:30
BMC50773I 101: LOG SCAN TASK STARTED AT 1/29/2022 03:53:30
BMC50706I MONITOR TRACE CLASS(1) STARTED, TRACE NUMBER = 06
BMC50877I POINT OF CONSISTENCY ESTABLISHED AT RBA/LRSN = 0000000002B5AB49F7DD
BMC50445I REORG PLUS DYNAMIC FILE ALLOCATION REPORT
BMC50446I UNIT OR KBYTES KBYTES ALOC ALOC
BMC50447I DDNAME DSNAME DATACLAS MGMTCLAS STORCLAS PRI SEC PRI SEC
BMC50448I BMCCPY01 ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.BMCCPY01*WORK 20534 2053 428 43 TRK
BMC50448I BMCCPY02 ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.BMCCPY02*WORK 20534 2053 428 43 TRK
BMC50448I BMCCPY03 ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.BMCCPY03*WORK 20534 2053 428 43 TRK
BMC50448I SYSUT101 ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT101*WORK 24707 2471 458 46 TRK
BMC50448I SYSUT102 ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT102*WORK 24707 2471 458 46 TRK
BMC50448I SYSUT103 ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT103*WORK 21619 2162 401 41 TRK
BMC50448I SYSUT104 ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT104*WORK 17501 1751 325 33 TRK
BMC50448I SYSUT105 ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT105*WORK 11324 1133 210 21 TRK
BMC50394I UNABLE TO LOCATE SORT WORK DATASETS, DDNAME = 'SORTWKNN'
BMC50474I BELOW 16M = 8076K, ABOVE 16M = 1015000K, CPUS = 5
BMC50479I TOTAL PAGES: 11132659, ALLOWED: 0; AVAILABLE PAGES: 3014227, ALLOWED: 3014227
BMC50719I 1 LOG APPLY TASKS, 6 INDEX APPLY TASKS, AVAILABLE MEMORY: 896056K
BMC50887I RIDMAP: RIDMAPMEM CHANGED TO 2097152K
BMC51302I MAX TASKS = 1, MAX PARTITIONS PER TASK = 3, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 3
BMC50864I LOGMEM OF 0K SPECIFIED, CHANGED TO 28160K
BMC50773I 109: LOG RECORD SORT TASK STARTED AT 1/29/2022 03:53:32
BMC50773I 110: LOG RECORD SPILL TASK STARTED AT 12/29/2022 03:53:32
BMC50773I 111: INLINE IMAGE COPY APPEND TASK STARTED AT 1/29/2022 03:53:32
BMC50847I 111: BUFFER ALLOCATIONS: CHANGED PAGE BUFFERS = 0, I/O BUFFERS = 800,LARGEST BLOCK SIZE = 8192
BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 2136K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50477I 1: PARTITION = 1, ROWS/KEYS = 616704, I/O WAITS = 1 ,DDNAME = SYS00039
BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE EXMPLE13.EXMPLE13 PARTITION 1
BMC51271I UNLOAD STATISTICS: 616704 ROWS/KEYS UNLOADED FROM PARTITION 1
BMC51281I UNLOAD STATISTICS: X'0000000002B5AB3BF0BA' IS THE HIGHEST LOGRBA FOR PARTITION 1
BMC50477I 1: PARTITION = 2, ROWS/KEYS = 337920, I/O WAITS = 1 ,DDNAME = SYS00040
BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE EXMPLE13.EXMPLE13 PARTITION 2
BMC51271I UNLOAD STATISTICS: 337920 ROWS/KEYS UNLOADED FROM PARTITION 2
BMC51281I UNLOAD STATISTICS: X'0000000002B5AB3C061C' IS THE HIGHEST LOGRBA FOR PARTITION 2
BMC50477I 1: PARTITION = 3, ROWS/KEYS = 126720, I/O WAITS = 2 ,DDNAME = SYS00041
BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE EXMPLE13.EXMPLE13 PARTITION 3
BMC51271I UNLOAD STATISTICS: 126720 ROWS/KEYS UNLOADED FROM PARTITION 3
BMC51281I UNLOAD STATISTICS: X'0000000002B5AB3C2000' IS THE HIGHEST LOGRBA FOR PARTITION 3
BMC51272I UNLOAD STATISTICS: 1081344 ROWS UNLOADED FROM SPACE 'EXMPLE13.EXMPLE13', 0 ROWS DISCARDED, 0 ROWS UPDATED
BMC51282I UNLOAD STATISTICS: X'0000000002B5AB3C2000' IS THE HIGHEST LOGRBA FOR SPACE 'EXMPLE13.EXMPLE13'
BMC50481I 1: SORT COMPLETE. ELAPSED TIME = 00:00:02
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A001'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A001'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A001'
BMC50482I 1: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A001'
BMC50477I 1: PARTITION = 1, ROWS/KEYS = 360448, I/O WAITS = 9 ,DDNAME = SYS00042
BMC51274I RELOAD STATISTICS: 360448 ROWS/KEYS LOADED INTO PARTITION 1
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A002'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A002'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A002'
BMC50482I 1: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A002'
BMC50477I 1: PARTITION = 2, ROWS/KEYS = 360448, I/O WAITS = 8 ,DDNAME = SYS00043
BMC51274I RELOAD STATISTICS: 360448 ROWS/KEYS LOADED INTO PARTITION 2
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A003'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A003'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A003'
BMC50482I 1: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A003'
BMC50477I 1: PARTITION = 3, ROWS/KEYS = 360448, I/O WAITS = 9 ,DDNAME = SYS00044
BMC51274I RELOAD STATISTICS: 360448 ROWS/KEYS LOADED INTO PARTITION 3
BMC50773I 102: LOG APPLY TASK STARTED AT 1/29/2022 03:53:36
BMC50481I 1: REORG TASK COMPLETE. ELAPSED TIME = 00:00:03
BMC50277I XBM STATISTICS: DSN='DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.I0001.A001 ', READS 8743, HITS 0, WRITES 0, CACHE 0
BMC50277I XBM STATISTICS: DSN='DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.I0001.A002 ', READS 4823, HITS 0, WRITES 0, CACHE 0
BMC50277I XBM STATISTICS: DSN='DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.I0001.A003 ', READS 1834, HITS 0, WRITES 0, CACHE 0
BMC50476I DDNAME = SYSUT104, I/OS = 59, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSUT101, I/OS = 82, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSUT102, I/OS = 82, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSUT103, I/OS = 72, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSUT105, I/OS = 38, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC51275I RELOAD STATISTICS: 1081344 ROWS LOADED INTO SPACE 'EXMPLE13.EXMPLE13'
BMC50474I BELOW 16M = 7960K, ABOVE 16M = 980444K, CPUS = 5
BMC50479I TOTAL PAGES: 11126428, ALLOWED: 0; AVAILABLE PAGES: 3010377, ALLOWED: 3010377
BMC51303I MAX TASKS = 5, INDEXES PER TASK = 1, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 5
BMC50486I 4: BMCSORT STARTED, 256K BELOW 16M, 1356K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 3: BMCSORT STARTED, 256K BELOW 16M, 1416K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 5: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 2: BMCSORT STARTED, 256K BELOW 16M, 1416K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50476I DDNAME = SYSUT104, I/OS = 54, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50481I 1: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50476I DDNAME = SYSUT103, I/OS = 67, I/O WAITS = 5, RDB LOCK WAITS = 0
BMC50481I 4: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50476I DDNAME = SYSUT102, I/OS = 77, I/O WAITS = 4, RDB LOCK WAITS = 0
BMC50481I 3: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50476I DDNAME = SYSUT105, I/OS = 35, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50481I 5: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50476I DDNAME = SYSUT101, I/OS = 77, I/O WAITS = 4, RDB LOCK WAITS = 0
BMC50481I 2: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013A.J0001.A001'
BMC50477I 1: PARTITION = 1, ROWS/KEYS = 360448, I/O WAITS = 5 ,DDNAME = SYS00050
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:01 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013A.J0001.A002'
BMC50477I 1: PARTITION = 2, ROWS/KEYS = 360448, I/O WAITS = 5 ,DDNAME = SYS00055
BMC50773I 103: INDEX APPLY TASK STARTED AT 1/29/2022 03:53:39
BMC50482I 2: BUILD COMPLETE. ELAPSED TIME = 00:00:01 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013C.J0001.A001'
BMC50477I 2: PARTITION = 1, ROWS/KEYS = 360448, I/O WAITS = 5 ,DDNAME = SYS00053
BMC50482I 5: BUILD COMPLETE. ELAPSED TIME = 00:00:01 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013E.J0001.A001'
BMC50477I 5: PARTITION = 0, ROWS/KEYS = 1081344, I/O WAITS = 5 ,DDNAME = SYS00054
BMC50773I 106: INDEX APPLY TASK STARTED AT 1/29/2022 03:53:40
BMC51276I BUILD STATISTICS: 1081344 KEYS LOADED INTO INDEX 'ARU.ARX013E'
BMC50482I 4: BUILD COMPLETE. ELAPSED TIME = 00:00:01 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013D.J0001.A001'
BMC50477I 4: PARTITION = 0, ROWS/KEYS = 1081344, I/O WAITS = 6 ,DDNAME = SYS00051
BMC50773I 107: INDEX APPLY TASK STARTED AT 1/29/2022 03:53:40
BMC51276I BUILD STATISTICS: 1081344 KEYS LOADED INTO INDEX 'ARU.ARX013D'
BMC50482I 3: BUILD COMPLETE. ELAPSED TIME = 00:00:01 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013B.J0001.A001'
BMC50477I 3: PARTITION = 0, ROWS/KEYS = 1081344, I/O WAITS = 8 ,DDNAME = SYS00052
BMC50773I 108: INDEX APPLY TASK STARTED AT 1/29/2022 03:53:40
BMC51276I BUILD STATISTICS: 1081344 KEYS LOADED INTO INDEX 'ARU.ARX013B'
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013A.J0001.A003'
BMC50477I 1: PARTITION = 3, ROWS/KEYS = 360448, I/O WAITS = 5 ,DDNAME = SYS00057
BMC50773I 104: INDEX APPLY TASK STARTED AT 1/29/2022 03:53:40
BMC51276I BUILD STATISTICS: 1081344 KEYS LOADED INTO INDEX 'ARU.ARX013A'
BMC50482I 2: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013C.J0001.A002'
BMC50477I 2: PARTITION = 2, ROWS/KEYS = 360448, I/O WAITS = 5 ,DDNAME = SYS00056
BMC50482I 2: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013C.J0001.A003'
BMC50477I 2: PARTITION = 3, ROWS/KEYS = 360448, I/O WAITS = 5 ,DDNAME = SYS00058
BMC50773I 105: INDEX APPLY TASK STARTED AT 1/29/2022 03:53:41
BMC50829I LOGAPPLY PHASE STARTING AT 1/29/2022 03:53:41
BMC51276I BUILD STATISTICS: 1081344 KEYS LOADED INTO INDEX 'ARU.ARX013C'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT101', DSNAME = 'ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT101'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT105', DSNAME = 'ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT105'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT102', DSNAME = 'ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT102'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT103', DSNAME = 'ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT103'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT104', DSNAME = 'ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT104'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XV2B
BMC50004I REORG PHASE COMPLETE. ELAPSED TIME = 00:00:10
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XV2B
BMC50877I POINT OF CONSISTENCY ESTABLISHED AT RBA/LRSN = 0000000002B5AB5465B2
BMC50778I LOG RECORD QUEUE SIZE AT OR BELOW THRESHOLD
BMC50004I LOGAPPLY PHASE COMPLETE. ELAPSED TIME = 00:00:06
BMC50830I LOGFINAL PHASE STARTING AT 1/29/2022 03:53:47
BMC50709I MONITOR TRACE CLASS(1) TRACE NUMBER = 06 STOPPED
BMC50786I 101: LOG SCAN TASK ENDED AT 1/29/2022 03:53:47, ELAPSED TIME = 00:00:17
BMC50720I 102: 0 NEW LOG APPLY BUFFERS, 0 REUSED, 163488 INITIAL MAXIMUM, 0 WAITS, BUFFER SIZE=606
BMC50741I 102: LOGAPPLY STATISTICS
BMC50742I 102: PROCESSED TRANSACTIONS
BMC50744I 102: INSERTS: 0 INSERTS(COMPENSATION): 0
BMC50745I 102: UPDATES: 0 UPDATES(COMPENSATION): 0
BMC50746I 102: DELETES: 0 DELETES(COMPENSATION): 0
BMC50743I 102: CONSOLIDATED TRANSACTIONS
BMC50744I 102: INSERTS: 0 INSERTS(COMPENSATION): 0
BMC50745I 102: UPDATES: 0 UPDATES(COMPENSATION): 0
BMC50746I 102: DELETES: 0 DELETES(COMPENSATION): 0
BMC50747I 102: PAGES UPDATED COUNTERS FOR EXMPLE13.EXMPLE13
BMC50748I 102: PART TOTAL PAGES DATA PAGES SPACE MAPS HEADER PAGES
BMC50749I 102: 1 1 0 0 1
BMC50749I 102: 2 1 0 0 1
BMC50749I 102: 3 1 0 0 1
BMC50716I 102: Buffer Manager Statistics
BMC50717I 102: DATASET=DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.J0001.A001
BMC50717I 102: DATASET=DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.J0001.A002
BMC50717I 102: DATASET=DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.J0001.A003
BMC50718I 102: Page Requests 33 | Page Hits 3
BMC50718I 102: Page Reads 30 | Page Writes 1
BMC50718I 102: Write I/O Requests 3 | New Pages 0
BMC50716I 102: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50786I 102: LOG APPLY TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:15
BMC50794I 106: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013E
BMC50791I 106: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 106: RID INSERTS : 0 RID DELETES (PS): 0
BMC50794I 104: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013C DSNUM 1
BMC50794I 107: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013D
BMC50791I 107: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 107: RID INSERTS : 0 RID DELETES (PS): 0
BMC50794I 108: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013B
BMC50794I 105: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013C DSNUM 2
BMC50791I 105: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 105: RID INSERTS : 0 RID DELETES (PS): 0
BMC50791I 108: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 108: RID INSERTS : 0 RID DELETES (PS): 0
BMC50791I 108: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 108: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 108: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50794I 103: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013A DSNUM 1
BMC50791I 103: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 103: RID INSERTS : 0 RID DELETES (PS): 0
BMC50791I 107: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 107: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 107: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50791I 106: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 105: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 106: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 105: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 106: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50791I 103: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 105: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50791I 103: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 103: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50716I 108: Buffer Manager Statistics
BMC50717I 108: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013B.J0001.A001
BMC50718I 108: Page Requests 6 | Page Hits 1
BMC50718I 108: Page Reads 5 | Page Writes 1
BMC50718I 108: Write I/O Requests 1 | New Pages 0
BMC50716I 108: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50794I 105: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013C DSNUM 3
BMC50791I 105: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 105: RID INSERTS : 0 RID DELETES (PS): 0
BMC50791I 105: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 105: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 105: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50716I 107: Buffer Manager Statistics
BMC50786I 109: LOG RECORD SORT TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:19
BMC50717I 107: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013D.J0001.A001
BMC50718I 107: Page Requests 6 | Page Hits 1
BMC50718I 107: Page Reads 5 | Page Writes 1
BMC50718I 107: Write I/O Requests 1 | New Pages 0
BMC50716I 107: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50794I 103: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013A DSNUM 2
BMC50791I 103: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 103: RID INSERTS : 0 RID DELETES (PS): 0
BMC50791I 103: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 103: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 103: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50716I 106: Buffer Manager Statistics
BMC50717I 106: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013E.J0001.A001
BMC50718I 106: Page Requests 6 | Page Hits 1
BMC50718I 106: Page Reads 5 | Page Writes 1
BMC50718I 106: Write I/O Requests 1 | New Pages 0
BMC50716I 106: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50791I 104: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 104: RID INSERTS : 0 RID DELETES (PS): 0
BMC50791I 104: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 104: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 104: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50716I 105: Buffer Manager Statistics
BMC50717I 105: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013C.J0001.A002
BMC50717I 105: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013C.J0001.A003
BMC50718I 105: Page Requests 12 | Page Hits 2
BMC50718I 105: Page Reads 10 | Page Writes 1
BMC50718I 105: Write I/O Requests 2 | New Pages 0
BMC50716I 105: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50794I 104: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013A DSNUM 3
BMC50791I 104: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 104: RID INSERTS : 0 RID DELETES (PS): 0
BMC50791I 104: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 104: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 104: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50716I 103: Buffer Manager Statistics
BMC50717I 103: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013A.J0001.A001
BMC50717I 103: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013A.J0001.A002
BMC50718I 103: Page Requests 12 | Page Hits 2
BMC50718I 103: Page Reads 10 | Page Writes 1
BMC50718I 103: Write I/O Requests 2 | New Pages 0
BMC50716I 103: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50786I 108: INDEX APPLY TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:11
BMC50786I 107: INDEX APPLY TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:11
BMC50786I 106: INDEX APPLY TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:11
BMC50716I 104: Buffer Manager Statistics
BMC50717I 104: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013A.J0001.A003
BMC50717I 104: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013C.J0001.A001
BMC50718I 104: Page Requests 12 | Page Hits 2
BMC50718I 104: Page Reads 10 | Page Writes 1
BMC50718I 104: Write I/O Requests 2 | New Pages 0
BMC50716I 104: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50786I 105: INDEX APPLY TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:10
BMC50786I 103: INDEX APPLY TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:11
BMC50786I 104: INDEX APPLY TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:11
BMC50867I LOG RECORD STORE SPILL REQUESTS = 0, HIGH SPILL PAGE = 0, SPILL DATASETS CREATED = 0
BMC50868I LOG RECORD STORE WRITE REQUESTS = 0, WRITE WAIT TIME = 0.000, READ REQUESTS = 0 READ WAIT TIME = 0.000
BMC50786I 110: LOG RECORD SPILL TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:19
BMC50786I 111: INLINE IMAGE COPY APPEND TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:19
BMC50476I DDNAME = BMCCPY01, I/OS = 46, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50376I 2604 PAGES COPIED TO DATASET = 'ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.BMCCPY01'
BMC50476I DDNAME = BMCCPY02, I/OS = 45, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50376I 2596 PAGES COPIED TO DATASET = 'ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.BMCCPY02'
BMC50476I DDNAME = BMCCPY03, I/OS = 45, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50376I 2605 PAGES COPIED TO DATASET = 'ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.BMCCPY03'
BMC50865I TOTAL RECORDS INSERTED INTO LOG RECORD STORE, DATA =0, INDEX = 0
BMC50866I TOTAL TABLESPACE STRINGS PROCESSED = 0, WHEN NOT FULL = 0, FROM SPILL = 0
BMC50866I TOTAL INDEXSPACE STRINGS PROCESSED = 0, WHEN NOT FULL = 0, FROM SPILL = 0
BMC50866I TOTAL INDEXSPACE REQUE STRINGS PROCESSED = 0, WHEN NOT FULL = 0, FROM SPILL = 0
BMC50859I LOG RECORD STORE STATISTICS: MEMORY AVAILABLE = 28160K, MEMORY USED = 5120K
BMC50860I TOTAL WAIT TIME FOR LOG RECORD STORE MEMORY = 0.000 DATA = 0.000 INDEX = 0.000
BMC50880I RIDMAP: PART 0001: ROWS=616704, PAIRS=616704, STORAGE=4724K, MEM WAITS=0, WAIT TIME=0
BMC50881I RIDMAP: PART 0001: TRANS=0, ADDS=0, DELS=0, SPILL READS=0, WAIT TIME=0
BMC50880I RIDMAP: PART 0002: ROWS=337920, PAIRS=337920, STORAGE=2596K, MEM WAITS=3, WAIT TIME=0
BMC50881I RIDMAP: PART 0002: TRANS=0, ADDS=0, DELS=0, SPILL READS=0, WAIT TIME=0
BMC50880I RIDMAP: PART 0003: ROWS=126720, PAIRS=126720, STORAGE=2248K, MEM WAITS=4, WAIT TIME=0
BMC50881I RIDMAP: PART 0003: TRANS=0, ADDS=0, DELS=0, SPILL READS=0, WAIT TIME=0
BMC50880I RIDMAP: SUMMARY: ROWS=1081344, PAIRS=1081344, STORAGE=9568K, MEM WAITS=7, WAIT TIME=0
BMC50881I RIDMAP: SUMMARY: TRANS=0, ADDS=0, DELS=0, SPILL READS=0, WAIT TIME=0
BMC50882I RIDMAP: SUMMARY: MAX DATASPACES=1, USED DATASPACES=1, RIDMAPMEM=0K, USED MEM=10748K
BMC50883I RIDMAP: SUMMARY: MAX PIPES=4, PIPES USED=2, PIPE BUFFER SIZE=262144, PIPE WAITS=0, WAIT TIME=0
BMC50868I RIDMAP WRITE REQUESTS = 0, WRITE WAIT TIME = 0.000, READ REQUESTS = 0 READ WAIT TIME = 0.000
BMC50703I LOG PROCESSING COMPLETED, RC = 0, AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:21
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XV2B
BMC50004I LOGFINAL PHASE COMPLETE. ELAPSED TIME = 00:00:04
BMC50705I SQL PREPARE LOCK STARTED AT 00DAD563303C0133BA00
BMC50894I SWITCH PROCESS STARTING AT 1/29/2022 3:53:51
BMC51350I MATERIALIZATION OF PENDING DDL CHANGES COMPLETED FOR EXMPLE13.EXMPLE13 AT 03:53:51
BMC51297I ALL SPECIFIED LIMIT KEYS HAVE BEEN SUCCESSFULLY ALTERED
BMC50705I SQL PREPARE LOCK TERMINATED AT 00DAD56330451D458000
BMC51362I LPART PPART CARD ALTER TYPE LIMITKEY
BMC51363I 1 1 360448 REBALANCE X'276002281500000000000083E8'
BMC51363I 2 2 360448 REBALANCE X'36100428070000000000009CE8'
BMC51363I 3 3 360448 X'456912310000000000000083E8'
BMC50890I 6: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013A.I0001.A003'...
BMC50890I 1: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.I0001.A001'...
BMC50890I 9: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013C.I0001.A003'...
BMC50890I 4: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013A.I0001.A001'...
BMC50890I 7: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013C.I0001.A001'...
BMC50890I 2: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.I0001.A002'...
BMC50890I 8: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013C.I0001.A002'...
BMC50890I 3: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.I0001.A003'...
BMC50890I 5: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013A.I0001.A002'...
BMC50890I 10: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013B.I0001.A001'...
BMC50890I 12: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013E.I0001.A001'...
BMC50890I 11: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013D.I0001.A001'...
BMC50891I 7: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013C.I0001.A001' IS DELETED
BMC50891I 4: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013A.I0001.A001' IS DELETED
BMC50891I 9: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013C.I0001.A003' IS DELETED
BMC50891I 2: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.I0001.A002' IS DELETED
BMC50891I 10: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013B.I0001.A001' IS DELETED
BMC50891I 1: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.I0001.A001' IS DELETED
BMC50891I 3: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.I0001.A003' IS DELETED
BMC50891I 11: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013D.I0001.A001' IS DELETED
BMC50891I 12: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013E.I0001.A001' IS DELETED
BMC50891I 6: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013A.I0001.A003' IS DELETED
BMC50891I 8: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013C.I0001.A002' IS DELETED
BMC50891I 5: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013A.I0001.A002' IS DELETED
BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR REORG UTILITY SUCCESSFUL FOR ALL OBJECTS
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0
(C) COPYRIGHT 1988 - 2022 BMC SOFTWARE, INC.
REORG PLUS TECHNOLOGY IS PROTECTED BY ONE OR MORE OF THE FOLLOWING U.S. PATENTS: 5,222,235 AND 7,809,762
-BMC50001I UTILITY EXECUTION STARTING 1/29/2022 3:53:29 ...
BMC50002I UTILITY ID = 'EXAMPL13'. DB2 SUBSYSTEM ID = 'DEMO'. OPTION MODULE = 'ARU$OPTS'.
BMC50471I z/OS 2.4.0,PID=HBB77C0,DFSMS FOR Z/OS=2.4.0,DB2=13.1.501
BMC50471I REGION=0M,BELOW 16M=8840K,ABOVE 16M=1031048K,IEFUSI=NO,CPUs=7,GPs=5,zIIPs=2
BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040300M,MEMLIMIT SET BY:REGION=0
BMC50471I SMFID=DB2B,JOBID=J0709660,JOB=EXAMPL13,STEP=BMCREORG,CPU=8561-615 (z15)/1.71
0
BMC50471I REORG PLUS FOR DB2--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I SOLUTION COMMON CODE--V13.01.00 BASE
BMC50471I MAINT: BPJ1541 BPJ1713 BPJ2211
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922 BPJ0996 BPJ1164 BPJ1309 BPJ1386 BPJ1497 BPJ1594 BPJ1724 BPJ1809
BMC50471I BPJ1833 BPJ1891 BPJ1905 BPJ2109 BPJ2232 BPJ2297
BMC50471I BMC STATS API--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.02.01
BMC50471I MAINT: BPE0443 BPE0445 BPE0447 BPE0449 BPE0450 BPE0451 BPE0452 BPE0455 BPE0456 BPE0457 BPE0460 BPE0463
BMC50471I BPE0467 BPE0468 BPE0469 BPE0473 BPE0474 BPE0475 BPE0479 BPE0480 BPE0482 BPE0487 BPE0488 BPE0489
BMC50471I BPE0493 BPE0497 BPE0498 BPE0501 BPE0503 BPE0507 BPE0512 BPE0513 BPE0517 BPE0518 BPE0519 BPE0523
BMC50471I BPE0524 BPE0527 BPE0528 BPE0530 BPE0531 BPE0534 BPE0535 BPE0540 BPE0541 BPE0542 BPE0545 BPE0549
BMC50471I BPE0551 BPE0552 BPE0555 BPE0557
0
BMC50471I ANALMAX=1000% ICTYPE=AUTO SDUMP=YES
BMC50471I ARC=NO IDCACHE=10000 SHORTMEMORY=CONTINUE
BMC50471I ARCHDDN=SYSARC INDREFLM=10 SIXSNAP=NO
BMC50471I ARCHFORMAT=BMC INLINECP=YES SMAX=0
BMC50471I AVAILPAGEPCT=100 INVALIDATECACHE=YES SMCORE=(0K,0K)
BMC50471I BILDMAX=300% KEEPDICTIONARY=NO SORTDEVT=(,SYSALLDA)
BMC50471I BMCHIST=YES LEAFDSLM=200 SORTNUM=32
BMC50471I CBUFFS=30 LOCKROW=YES SPILDCLS=NONE
BMC50471I CONDEXEC=NO LOGFINAL=NONE SPILDSNP=&UID
BMC50471I COPYDDN=(BMCCPY,BMCCPZ) LOGMEM=0 SPILSCLS=NONE
BMC50471I COPYLVL=PART LOGSPIL=(20000,10000) SPILUNIT=WORK
BMC50471I COPYMAX=1000% LOGTHRSH=0 SQLDELAY=3
BMC50471I COPYSUBSET=NO LONGLOG=CONTINUE SQLRETRY=100
BMC50471I CPYRFAIL=TERM LONGNAMETRUNC=MIDDLE SSREPORT=REPORT_SWITCH
BMC50471I DATACAP=NO MAPTEXIT=(NONE,REXX) STAGEDSN=BMC
BMC50471I DDLDDN=DDLIN MAXNEWPARTS=2 STOP@CMT=YES
BMC50471I DEADLINE=NONE MAXRO=300 STOPDELAY=1
BMC50471I DELAY=1200 MAXSORTMEMORY=0 STOPRETRY=300
BMC50471I DELFILES=YES MAXTAPE=3 TAPEDISP=DELETE
BMC50471I DESCCDE=(3,7) MGEXTENT=CONTINUE TASKMAX=1000%
BMC50471I DRAINTYP=ALL MINSORTMEMORY=0 TERMEXIT=(NONE,REXX)
BMC50471I DRNDELAY=1 MSGLEVEL=1 TIMEOUT=TERM
BMC50471I DRNRETRY=255 OFFPOSLM=10 TOTALPAGEPCT=0
BMC50471I DRNWAIT=NONE OPNDB2ID=YES TSSAMPLEPCT=100
BMC50471I DSNUEXIT=(NONE,ASM) ORIGDISP=DELETE UBUFFS=20
BMC50471I DSNUTILB=YES PREFORMAT=NO UNLDDN=SYSREC
BMC50471I DSPLOCKS=DRNFAIL RCVICDDN=(BMCIRY,BMCIRZ) UNLDMAX=300%
BMC50471I DSRSEXIT=(NONE,REXX) RCVYDDN=(BMCRCY,BMCRCZ) UNLOAD=RELOAD
BMC50471I EXCLDUMP=(X37,X22,X06) REDEFINE=YES UXSTATE=SUP
BMC50471I FASTSWITCH=NO RENMMAX=30 WBUFFS=(20,10)
BMC50471I FILECHK=WARN RIDCWTO=NO WORKDDN=SYSUT1
BMC50471I FORCE_AT=(START,3) RIDMDSSZ=2097152 WORKUNIT=SYSALLDA
BMC50471I FORCE_RPT=NO RIDMMAXD=1 WRLOG=NO
BMC50471I FORCE=NONE RMAPMEM=0 XBMID=
BMC50471I FSFALLBACK=NO RORGMAX=300% ZIIP=ENABLED
BMC50471I FSTHRESHOLD=0 ROUTCDE=(11,1)
BMC50471I ICDDN=(BMCICY,BMCICZ) SCPYMAX=8
0
BMC50471I PLAN=ARU1310T
0
BMC50470I DDTYPE = UNLOAD WORK SORTWORK
BMC50470I ACTIVE = YES YES NO
BMC50470I IFALLOC = USE USE USE
BMC50470I ALLOC = N/A N/A ANY
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) N/A
BMC50470I VOLCNT = (25,25) (25,25) N/A
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) N/A
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) N/A
BMC50470I EXPDT = N/A N/A N/A
BMC50470I RETPD = N/A N/A N/A
BMC50470I GDGLIMIT = N/A N/A N/A
BMC50470I GDGEMPTY = N/A N/A N/A
BMC50470I GDGSCRAT = N/A N/A N/A
0
BMC50470I DDTYPE = ARCHIVE LOCPFCPY LOCPICPY
BMC50470I ACTIVE = NO YES YES
BMC50470I IFALLOC = USE USE USE
BMC50470I ALLOC = N/A N/A N/A
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (5,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = LOCBFCPY LOCBICPY REMPFCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I ALLOC = N/A N/A N/A
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = REMPICPY REMBFCPY REMBICPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I ALLOC = N/A N/A
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = SYSPUNCH
BMC50470I ACTIVE = YES
BMC50470I IFALLOC = USE
BMC50470I ALLOC = N/A
BMC50470I SMS = NO
BMC50470I SMSUNIT = NO
BMC50470I SIZEPCT = (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0)
BMC50470I VOLCNT = (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK))
BMC50470I DATACLAS = (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE)
BMC50470I THRESHLD = 0
BMC50470I MAXEXTSZ = ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 0
BMC50470I GDGEMPTY = NO
BMC50470I GDGSCRAT = NO
0
BMC50470I DDTYPE = LOCPLCPY LOCBLCPY
BMC50470I ACTIVE = NO NO
BMC50470I IFALLOC = USE USE
BMC50470I ALLOC = N/A N/A
BMC50470I SMS = NO NO
BMC50470I SMSUNIT = NO NO
BMC50470I SIZEPCT = (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5
BMC50470I GDGEMPTY = NO NO
BMC50470I GDGSCRAT = NO NO
0
BMC50470I DDTYPE = REMPLCPY REMBLCPY
BMC50470I ACTIVE = NO NO
BMC50470I IFALLOC = USE USE
BMC50470I ALLOC = N/A N/A
BMC50470I SMS = NO NO
BMC50470I SMSUNIT = NO NO
BMC50470I SIZEPCT = (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5
BMC50470I GDGEMPTY = NO NO
BMC50470I GDGSCRAT = NO NO
0
0
0
0
BMC50483I UNLOAD DSNPAT=&UID..BMC.&TSIX.&DDNAME
BMC50483I WORK DSNPAT=&UID..BMC.&TSIX.&DDNAME
BMC50483I SORTWORK DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I ARCHIVE DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I SYSPUNCH DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50483I LOCPFCPY DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
BMC50483I LOCPICPY DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
BMC50483I LOCBFCPY DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
BMC50483I LOCBICPY DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
BMC50483I LOCPLCPY DSNPAT=&UID.&DDNAME.&TSIX..T&TIME
BMC50483I LOCBLCPY DSNPAT=&UID.&DDNAME.&TSIX..T&TIME
0
BMC50483I REMPFCPY DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
BMC50483I REMPICPY DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
BMC50483I REMBFCPY DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
BMC50483I REMPLCPY DSNPAT=&UID.&DDNAME.&TSIX..T&TIME
BMC50483I REMBLCPY DSNPAT=&UID.&DDNAME.&TSIX..T&TIME
BMC50471I DB2 DSNHDECP MODULE SETTINGS:
BMC50471I VERSION = 1310
BMC50471I SUBSYSTEM DEFAULT = DEMO
BMC50471I CHARACTER SET = ALPHANUM
BMC50471I DATE FORMAT = USA
BMC50471I TIME FORMAT = USA
BMC50471I LOCAL DATE LENGTH = 0
BMC50471I LOCAL TIME LENGTH = 0
BMC50471I DECIMAL POINT = PERIOD
BMC50471I DECIMAL ARITHMETIC = 15
BMC50471I DELIMITER = DEFAULT
BMC50471I SQL DELIMITER = DEFAULT
BMC50471I ENCODING SCHEME = EBCDIC
BMC50471I APPL. ENCODING SCHEME = EBCDIC
BMC50471I MIXED = NO
BMC50471I EBCDIC CCSID = (37,65534,65534)
BMC50471I ASCII CCSID = (819,65534,65534)
BMC50471I UNICODE CCSID = (367,1208,1200)
BMC50471I IMPLICIT TIME ZONE = CURRENT (-06:00)
BMC50658I DB2 CURRENT FUNCTION LEVEL IS V13R1M501
BMC50659I DB2 CATALOG LEVEL IS V13R1M501
BMC50660I DB2 HIGHEST ACTIVATED FUNCTION LEVEL IS V13R1M501
BMC50661I DB2 CODE LEVEL IS V13R1M501
BMC50471I BMC_BMCUTIL ='BMCUTIL.CMN_BMCUTIL'
BMC50471I BMC_BMCSYNC ='BMCUTIL.CMN_BMCSYNC'
BMC50471I BMC_BMCHIST ='BMCUTIL.CMN_BMCHIST'
BMC50471I BMC_BMCDICT ='BMCUTIL.CMN_BMCDICT'
BMC50471I BMC_BMCXCOPY ='BMCUTIL.CMN_BMCXCOPY'
BMC50471I BMC_BMCSMARTSWITCH='BMCUTIL.CMN_BMCSWITCH'
BMC50471I DASD MANAGER PLUS TABLES:
BMC50471I ...'ATS131.RS_COLDIST_VW'
BMC50471I ...'ATS131.RS_COLDISTSTAT_VW'
BMC50471I ...'ATS131.RS_COLSTATS_VW'
BMC50471I ...'ATS131.RS_COLUMNS_VW'
BMC50471I ...'ATS131.RS_INDEXES_VW'
BMC50471I ...'ATS131.RS_INDEXPART_VW'
BMC50471I ...'ATS131.RS_IXPART_DIST_VW'
BMC50471I ...'ATS131.RS_KEYTGTDIST_VW'
BMC50471I ...'ATS131.RS_STOGROUP_VW'
BMC50471I ...'ATS131.RS_TABLEPART_VW'
BMC50471I ...'ATS131.RS_TABLES_VW'
BMC50471I ...'ATS131.RS_TABLESPACE_VW'
BMC50471I ...'ATS131.RS_TSPART_DIST_VW'
0
BMC50102I REORG TABLESPACE EXMPLE13.EXMPLE13
BMC50102I XBMID XV2B SHRLEVEL CHANGE
BMC50102I COPY YES
BMC50102I ORDER YES
BMC50102I ANALYZE SAMPLE
BMC50102I REBALANCE
BMC50102I FASTSWITCH YES
BMC50102I DDTYPE UNLOAD
BMC50102I UNIT (WORK)
BMC50102I DSNPAT 'ARU.EXMPL13A.DEMO.&DB.&TSIX.&DDNAME'
BMC50102I DDTYPE WORK
BMC50102I UNIT (WORK)
BMC50102I DSNPAT 'ARU.EXMPL13A.DEMO.&DB.&TSIX.&DDNAME'
BMC50102I DDTYPE LOCPFCPY
BMC50102I UNIT (WORK)
BMC50102I DSNPAT 'ARU.EXMPL13A.DEMO.&DB.&TSIX.&DDNAME'
BMC50102I
BMC50109I 'FASTSWITCH=YES' OPTION SPECIFIED. OPTION 'STAGEDSN=BMC' IGNORED
BMC50138I 'UPDATEDB2STATS NO' CHANGED TO 'UPDATEDB2STATS YES' DUE TO PENDING ALTER(S)
BMC50138I 'CPYRFAIL TERM' CHANGED TO 'CPYRFAIL COPYPEND' DUE TO PENDING ALTER(S)
BMC50004I UTILINIT PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC54000I SMARTSWITCH NOT SUPPORTED - NO BMC AMI UTILITIES VERSION FOUND
BMC54003I SMARTSWITCH RULE: FORCE_NO_SWITCH COMMENT: SMARTSWITCH NOT ACTIVATED, NO ROWS ON POLICY TABLE
BMC50199I REORG PLUS PROCESSING CONTINUES
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XV2B
BMC50244I PROCESSING PAGESET DBID(1955) PSID(2) PART(1) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00000000 FOR DBID(1955) PSID(2)
BMC50245I REGISTERING SYSTEM PAGE - 00000022 FOR DBID(1955) PSID(2)
BMC50244I PROCESSING PAGESET DBID(1955) PSID(2) PART(2) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00100000 FOR DBID(1955) PSID(2)
BMC50245I REGISTERING SYSTEM PAGE - 00100022 FOR DBID(1955) PSID(2)
BMC51301I 3: SAMPLING STATISTICS: PART=1,TP=8743,SP=117,SR=7916,AVGR=52,SD=66,SE=0,AVGF=6765,SD=65,SE=202,EP=11
BMC51301I 3: SAMPLING STATISTICS: PART=1,TP=8743,SP=232,SR=15763,AVGR=52,SD=66,SE=0,AVGF=6794,SD=65,SE=141,EP=21
BMC50244I PROCESSING PAGESET DBID(1955) PSID(2) PART(3) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00200000 FOR DBID(1955) PSID(2)
BMC50245I REGISTERING SYSTEM PAGE - 00200022 FOR DBID(1955) PSID(2)
BMC51301I 2: SAMPLING STATISTICS: PART=2,TP=4823,SP=109,SR=7527,AVGR=52,SD=66,SE=0,AVGF=6905,SD=65,SE=188,EP=8
BMC51301I 3: SAMPLING STATISTICS: PART=1,TP=8743,SP=346,SR=23597,AVGR=52,SD=66,SE=0,AVGF=6819,SD=65,SE=113,EP=30
BMC51301I 2: SAMPLING STATISTICS: PART=2,TP=4823,SP=217,SR=15135,AVGR=52,SD=66,SE=0,AVGF=6974,SD=65,SE=125,EP=14
BMC51301I 1: SAMPLING STATISTICS: PART=3,TP=1834,SP=99,SR=6983,AVGR=52,SD=66,SE=0,AVGF=7053,SD=65,SE=183,EP=6
BMC51301I 2: SAMPLING STATISTICS: PART=2,TP=4823,SP=324,SR=22232,AVGR=52,SD=66,SE=0,AVGF=6861,SD=65,SE=113,EP=26
BMC51301I 1: SAMPLING STATISTICS: PART=3,TP=1834,SP=201,SR=13997,AVGR=52,SD=66,SE=0,AVGF=6963,SD=65,SE=141,EP=15
BMC51301I 1: SAMPLING STATISTICS: PART=3,TP=1834,SP=297,SR=20648,AVGR=52,SD=66,SE=0,AVGF=6952,SD=65,SE=117,EP=23
BMC51265I ESTIMATED CARDINALITY OF SPACE = 1054040 AVG SORTWK ROW LENGTH = 52 AVG UNLOAD ROW LENGTH = 52
BMC50484I ESTIMATED CARDINALITY OF PART 0001 = 351346 AVG SORTWK ROW LENGTH = 52 AVG UNLOAD ROW LENGTH = 52
BMC50484I ESTIMATED CARDINALITY OF PART 0002 = 351346 AVG SORTWK ROW LENGTH = 52 AVG UNLOAD ROW LENGTH = 52
BMC50484I ESTIMATED CARDINALITY OF PART 0003 = 351348 AVG SORTWK ROW LENGTH = 52 AVG UNLOAD ROW LENGTH = 52
BMC51264I UNLOAD WILL READ 15392 DATA PAGES FROM SPACE 'EXMPLE13.EXMPLE13'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XV2B
BMC50004I ANALYZE PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XV2B
BMC50425I &JOBNAME = EXAMPL13 &STEPNAME = BMCREORG &DB = EXMPLE13 &TSIX = EXMPLE13 &RTYPE = TS
BMC50425I &UID = BMCPMN &DATE = 012922 &TIME = 035329 &SSID = DEMO &UTIL = EXAMPL13
BMC50425I &UTILPFX = EXAMPL13 &UTILSFX = &DATE8 = 01292022 &GRPNM = DEMO &VCAT = DEMOCAT
BMC50425I &TIME4 = 0353 &DATEJ = 2021363 &JDATE = 21363
BMC50702I LOG PROCESSING STARTED AT 1/29/2022 03:53:30
BMC50773I 101: LOG SCAN TASK STARTED AT 1/29/2022 03:53:30
BMC50706I MONITOR TRACE CLASS(1) STARTED, TRACE NUMBER = 06
BMC50877I POINT OF CONSISTENCY ESTABLISHED AT RBA/LRSN = 0000000002B5AB49F7DD
BMC50445I REORG PLUS DYNAMIC FILE ALLOCATION REPORT
BMC50446I UNIT OR KBYTES KBYTES ALOC ALOC
BMC50447I DDNAME DSNAME DATACLAS MGMTCLAS STORCLAS PRI SEC PRI SEC
BMC50448I BMCCPY01 ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.BMCCPY01*WORK 20534 2053 428 43 TRK
BMC50448I BMCCPY02 ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.BMCCPY02*WORK 20534 2053 428 43 TRK
BMC50448I BMCCPY03 ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.BMCCPY03*WORK 20534 2053 428 43 TRK
BMC50448I SYSUT101 ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT101*WORK 24707 2471 458 46 TRK
BMC50448I SYSUT102 ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT102*WORK 24707 2471 458 46 TRK
BMC50448I SYSUT103 ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT103*WORK 21619 2162 401 41 TRK
BMC50448I SYSUT104 ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT104*WORK 17501 1751 325 33 TRK
BMC50448I SYSUT105 ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT105*WORK 11324 1133 210 21 TRK
BMC50394I UNABLE TO LOCATE SORT WORK DATASETS, DDNAME = 'SORTWKNN'
BMC50474I BELOW 16M = 8076K, ABOVE 16M = 1015000K, CPUS = 5
BMC50479I TOTAL PAGES: 11132659, ALLOWED: 0; AVAILABLE PAGES: 3014227, ALLOWED: 3014227
BMC50719I 1 LOG APPLY TASKS, 6 INDEX APPLY TASKS, AVAILABLE MEMORY: 896056K
BMC50887I RIDMAP: RIDMAPMEM CHANGED TO 2097152K
BMC51302I MAX TASKS = 1, MAX PARTITIONS PER TASK = 3, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 3
BMC50864I LOGMEM OF 0K SPECIFIED, CHANGED TO 28160K
BMC50773I 109: LOG RECORD SORT TASK STARTED AT 1/29/2022 03:53:32
BMC50773I 110: LOG RECORD SPILL TASK STARTED AT 12/29/2022 03:53:32
BMC50773I 111: INLINE IMAGE COPY APPEND TASK STARTED AT 1/29/2022 03:53:32
BMC50847I 111: BUFFER ALLOCATIONS: CHANGED PAGE BUFFERS = 0, I/O BUFFERS = 800,LARGEST BLOCK SIZE = 8192
BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 2136K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50477I 1: PARTITION = 1, ROWS/KEYS = 616704, I/O WAITS = 1 ,DDNAME = SYS00039
BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE EXMPLE13.EXMPLE13 PARTITION 1
BMC51271I UNLOAD STATISTICS: 616704 ROWS/KEYS UNLOADED FROM PARTITION 1
BMC51281I UNLOAD STATISTICS: X'0000000002B5AB3BF0BA' IS THE HIGHEST LOGRBA FOR PARTITION 1
BMC50477I 1: PARTITION = 2, ROWS/KEYS = 337920, I/O WAITS = 1 ,DDNAME = SYS00040
BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE EXMPLE13.EXMPLE13 PARTITION 2
BMC51271I UNLOAD STATISTICS: 337920 ROWS/KEYS UNLOADED FROM PARTITION 2
BMC51281I UNLOAD STATISTICS: X'0000000002B5AB3C061C' IS THE HIGHEST LOGRBA FOR PARTITION 2
BMC50477I 1: PARTITION = 3, ROWS/KEYS = 126720, I/O WAITS = 2 ,DDNAME = SYS00041
BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE EXMPLE13.EXMPLE13 PARTITION 3
BMC51271I UNLOAD STATISTICS: 126720 ROWS/KEYS UNLOADED FROM PARTITION 3
BMC51281I UNLOAD STATISTICS: X'0000000002B5AB3C2000' IS THE HIGHEST LOGRBA FOR PARTITION 3
BMC51272I UNLOAD STATISTICS: 1081344 ROWS UNLOADED FROM SPACE 'EXMPLE13.EXMPLE13', 0 ROWS DISCARDED, 0 ROWS UPDATED
BMC51282I UNLOAD STATISTICS: X'0000000002B5AB3C2000' IS THE HIGHEST LOGRBA FOR SPACE 'EXMPLE13.EXMPLE13'
BMC50481I 1: SORT COMPLETE. ELAPSED TIME = 00:00:02
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A001'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A001'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A001'
BMC50482I 1: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A001'
BMC50477I 1: PARTITION = 1, ROWS/KEYS = 360448, I/O WAITS = 9 ,DDNAME = SYS00042
BMC51274I RELOAD STATISTICS: 360448 ROWS/KEYS LOADED INTO PARTITION 1
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A002'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A002'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A002'
BMC50482I 1: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A002'
BMC50477I 1: PARTITION = 2, ROWS/KEYS = 360448, I/O WAITS = 8 ,DDNAME = SYS00043
BMC51274I RELOAD STATISTICS: 360448 ROWS/KEYS LOADED INTO PARTITION 2
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A003'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A003'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A003'
BMC50482I 1: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.J0001.A003'
BMC50477I 1: PARTITION = 3, ROWS/KEYS = 360448, I/O WAITS = 9 ,DDNAME = SYS00044
BMC51274I RELOAD STATISTICS: 360448 ROWS/KEYS LOADED INTO PARTITION 3
BMC50773I 102: LOG APPLY TASK STARTED AT 1/29/2022 03:53:36
BMC50481I 1: REORG TASK COMPLETE. ELAPSED TIME = 00:00:03
BMC50277I XBM STATISTICS: DSN='DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.I0001.A001 ', READS 8743, HITS 0, WRITES 0, CACHE 0
BMC50277I XBM STATISTICS: DSN='DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.I0001.A002 ', READS 4823, HITS 0, WRITES 0, CACHE 0
BMC50277I XBM STATISTICS: DSN='DEMOCAT.DSNDBD.EXMPLE13.EXMPLE13.I0001.A003 ', READS 1834, HITS 0, WRITES 0, CACHE 0
BMC50476I DDNAME = SYSUT104, I/OS = 59, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSUT101, I/OS = 82, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSUT102, I/OS = 82, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSUT103, I/OS = 72, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSUT105, I/OS = 38, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC51275I RELOAD STATISTICS: 1081344 ROWS LOADED INTO SPACE 'EXMPLE13.EXMPLE13'
BMC50474I BELOW 16M = 7960K, ABOVE 16M = 980444K, CPUS = 5
BMC50479I TOTAL PAGES: 11126428, ALLOWED: 0; AVAILABLE PAGES: 3010377, ALLOWED: 3010377
BMC51303I MAX TASKS = 5, INDEXES PER TASK = 1, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 5
BMC50486I 4: BMCSORT STARTED, 256K BELOW 16M, 1356K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 3: BMCSORT STARTED, 256K BELOW 16M, 1416K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 5: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 2: BMCSORT STARTED, 256K BELOW 16M, 1416K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50476I DDNAME = SYSUT104, I/OS = 54, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50481I 1: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50476I DDNAME = SYSUT103, I/OS = 67, I/O WAITS = 5, RDB LOCK WAITS = 0
BMC50481I 4: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50476I DDNAME = SYSUT102, I/OS = 77, I/O WAITS = 4, RDB LOCK WAITS = 0
BMC50481I 3: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50476I DDNAME = SYSUT105, I/OS = 35, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50481I 5: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50476I DDNAME = SYSUT101, I/OS = 77, I/O WAITS = 4, RDB LOCK WAITS = 0
BMC50481I 2: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013A.J0001.A001'
BMC50477I 1: PARTITION = 1, ROWS/KEYS = 360448, I/O WAITS = 5 ,DDNAME = SYS00050
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:01 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013A.J0001.A002'
BMC50477I 1: PARTITION = 2, ROWS/KEYS = 360448, I/O WAITS = 5 ,DDNAME = SYS00055
BMC50773I 103: INDEX APPLY TASK STARTED AT 1/29/2022 03:53:39
BMC50482I 2: BUILD COMPLETE. ELAPSED TIME = 00:00:01 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013C.J0001.A001'
BMC50477I 2: PARTITION = 1, ROWS/KEYS = 360448, I/O WAITS = 5 ,DDNAME = SYS00053
BMC50482I 5: BUILD COMPLETE. ELAPSED TIME = 00:00:01 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013E.J0001.A001'
BMC50477I 5: PARTITION = 0, ROWS/KEYS = 1081344, I/O WAITS = 5 ,DDNAME = SYS00054
BMC50773I 106: INDEX APPLY TASK STARTED AT 1/29/2022 03:53:40
BMC51276I BUILD STATISTICS: 1081344 KEYS LOADED INTO INDEX 'ARU.ARX013E'
BMC50482I 4: BUILD COMPLETE. ELAPSED TIME = 00:00:01 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013D.J0001.A001'
BMC50477I 4: PARTITION = 0, ROWS/KEYS = 1081344, I/O WAITS = 6 ,DDNAME = SYS00051
BMC50773I 107: INDEX APPLY TASK STARTED AT 1/29/2022 03:53:40
BMC51276I BUILD STATISTICS: 1081344 KEYS LOADED INTO INDEX 'ARU.ARX013D'
BMC50482I 3: BUILD COMPLETE. ELAPSED TIME = 00:00:01 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013B.J0001.A001'
BMC50477I 3: PARTITION = 0, ROWS/KEYS = 1081344, I/O WAITS = 8 ,DDNAME = SYS00052
BMC50773I 108: INDEX APPLY TASK STARTED AT 1/29/2022 03:53:40
BMC51276I BUILD STATISTICS: 1081344 KEYS LOADED INTO INDEX 'ARU.ARX013B'
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013A.J0001.A003'
BMC50477I 1: PARTITION = 3, ROWS/KEYS = 360448, I/O WAITS = 5 ,DDNAME = SYS00057
BMC50773I 104: INDEX APPLY TASK STARTED AT 1/29/2022 03:53:40
BMC51276I BUILD STATISTICS: 1081344 KEYS LOADED INTO INDEX 'ARU.ARX013A'
BMC50482I 2: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013C.J0001.A002'
BMC50477I 2: PARTITION = 2, ROWS/KEYS = 360448, I/O WAITS = 5 ,DDNAME = SYS00056
BMC50482I 2: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.EXMPLE13.ARX013C.J0001.A003'
BMC50477I 2: PARTITION = 3, ROWS/KEYS = 360448, I/O WAITS = 5 ,DDNAME = SYS00058
BMC50773I 105: INDEX APPLY TASK STARTED AT 1/29/2022 03:53:41
BMC50829I LOGAPPLY PHASE STARTING AT 1/29/2022 03:53:41
BMC51276I BUILD STATISTICS: 1081344 KEYS LOADED INTO INDEX 'ARU.ARX013C'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT101', DSNAME = 'ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT101'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT105', DSNAME = 'ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT105'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT102', DSNAME = 'ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT102'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT103', DSNAME = 'ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT103'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT104', DSNAME = 'ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.SYSUT104'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XV2B
BMC50004I REORG PHASE COMPLETE. ELAPSED TIME = 00:00:10
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XV2B
BMC50877I POINT OF CONSISTENCY ESTABLISHED AT RBA/LRSN = 0000000002B5AB5465B2
BMC50778I LOG RECORD QUEUE SIZE AT OR BELOW THRESHOLD
BMC50004I LOGAPPLY PHASE COMPLETE. ELAPSED TIME = 00:00:06
BMC50830I LOGFINAL PHASE STARTING AT 1/29/2022 03:53:47
BMC50709I MONITOR TRACE CLASS(1) TRACE NUMBER = 06 STOPPED
BMC50786I 101: LOG SCAN TASK ENDED AT 1/29/2022 03:53:47, ELAPSED TIME = 00:00:17
BMC50720I 102: 0 NEW LOG APPLY BUFFERS, 0 REUSED, 163488 INITIAL MAXIMUM, 0 WAITS, BUFFER SIZE=606
BMC50741I 102: LOGAPPLY STATISTICS
BMC50742I 102: PROCESSED TRANSACTIONS
BMC50744I 102: INSERTS: 0 INSERTS(COMPENSATION): 0
BMC50745I 102: UPDATES: 0 UPDATES(COMPENSATION): 0
BMC50746I 102: DELETES: 0 DELETES(COMPENSATION): 0
BMC50743I 102: CONSOLIDATED TRANSACTIONS
BMC50744I 102: INSERTS: 0 INSERTS(COMPENSATION): 0
BMC50745I 102: UPDATES: 0 UPDATES(COMPENSATION): 0
BMC50746I 102: DELETES: 0 DELETES(COMPENSATION): 0
BMC50747I 102: PAGES UPDATED COUNTERS FOR EXMPLE13.EXMPLE13
BMC50748I 102: PART TOTAL PAGES DATA PAGES SPACE MAPS HEADER PAGES
BMC50749I 102: 1 1 0 0 1
BMC50749I 102: 2 1 0 0 1
BMC50749I 102: 3 1 0 0 1
BMC50716I 102: Buffer Manager Statistics
BMC50717I 102: DATASET=DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.J0001.A001
BMC50717I 102: DATASET=DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.J0001.A002
BMC50717I 102: DATASET=DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.J0001.A003
BMC50718I 102: Page Requests 33 | Page Hits 3
BMC50718I 102: Page Reads 30 | Page Writes 1
BMC50718I 102: Write I/O Requests 3 | New Pages 0
BMC50716I 102: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50786I 102: LOG APPLY TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:15
BMC50794I 106: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013E
BMC50791I 106: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 106: RID INSERTS : 0 RID DELETES (PS): 0
BMC50794I 104: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013C DSNUM 1
BMC50794I 107: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013D
BMC50791I 107: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 107: RID INSERTS : 0 RID DELETES (PS): 0
BMC50794I 108: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013B
BMC50794I 105: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013C DSNUM 2
BMC50791I 105: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 105: RID INSERTS : 0 RID DELETES (PS): 0
BMC50791I 108: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 108: RID INSERTS : 0 RID DELETES (PS): 0
BMC50791I 108: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 108: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 108: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50794I 103: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013A DSNUM 1
BMC50791I 103: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 103: RID INSERTS : 0 RID DELETES (PS): 0
BMC50791I 107: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 107: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 107: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50791I 106: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 105: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 106: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 105: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 106: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50791I 103: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 105: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50791I 103: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 103: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50716I 108: Buffer Manager Statistics
BMC50717I 108: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013B.J0001.A001
BMC50718I 108: Page Requests 6 | Page Hits 1
BMC50718I 108: Page Reads 5 | Page Writes 1
BMC50718I 108: Write I/O Requests 1 | New Pages 0
BMC50716I 108: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50794I 105: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013C DSNUM 3
BMC50791I 105: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 105: RID INSERTS : 0 RID DELETES (PS): 0
BMC50791I 105: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 105: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 105: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50716I 107: Buffer Manager Statistics
BMC50786I 109: LOG RECORD SORT TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:19
BMC50717I 107: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013D.J0001.A001
BMC50718I 107: Page Requests 6 | Page Hits 1
BMC50718I 107: Page Reads 5 | Page Writes 1
BMC50718I 107: Write I/O Requests 1 | New Pages 0
BMC50716I 107: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50794I 103: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013A DSNUM 2
BMC50791I 103: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 103: RID INSERTS : 0 RID DELETES (PS): 0
BMC50791I 103: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 103: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 103: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50716I 106: Buffer Manager Statistics
BMC50717I 106: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013E.J0001.A001
BMC50718I 106: Page Requests 6 | Page Hits 1
BMC50718I 106: Page Reads 5 | Page Writes 1
BMC50718I 106: Write I/O Requests 1 | New Pages 0
BMC50716I 106: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50791I 104: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 104: RID INSERTS : 0 RID DELETES (PS): 0
BMC50791I 104: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 104: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 104: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50716I 105: Buffer Manager Statistics
BMC50717I 105: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013C.J0001.A002
BMC50717I 105: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013C.J0001.A003
BMC50718I 105: Page Requests 12 | Page Hits 2
BMC50718I 105: Page Reads 10 | Page Writes 1
BMC50718I 105: Write I/O Requests 2 | New Pages 0
BMC50716I 105: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50794I 104: INDEX MAINTENANCE STATISTICS FOR INDEX ARU.ARX013A DSNUM 3
BMC50791I 104: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 104: RID INSERTS : 0 RID DELETES (PS): 0
BMC50791I 104: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 104: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 104: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50716I 103: Buffer Manager Statistics
BMC50717I 103: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013A.J0001.A001
BMC50717I 103: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013A.J0001.A002
BMC50718I 103: Page Requests 12 | Page Hits 2
BMC50718I 103: Page Reads 10 | Page Writes 1
BMC50718I 103: Write I/O Requests 2 | New Pages 0
BMC50716I 103: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50786I 108: INDEX APPLY TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:11
BMC50786I 107: INDEX APPLY TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:11
BMC50786I 106: INDEX APPLY TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:11
BMC50716I 104: Buffer Manager Statistics
BMC50717I 104: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013A.J0001.A003
BMC50717I 104: DATASET=DEMOCAT.DSNDBC.EXMPLE13.ARX013C.J0001.A001
BMC50718I 104: Page Requests 12 | Page Hits 2
BMC50718I 104: Page Reads 10 | Page Writes 1
BMC50718I 104: Write I/O Requests 2 | New Pages 0
BMC50716I 104: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50786I 105: INDEX APPLY TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:10
BMC50786I 103: INDEX APPLY TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:11
BMC50786I 104: INDEX APPLY TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:11
BMC50867I LOG RECORD STORE SPILL REQUESTS = 0, HIGH SPILL PAGE = 0, SPILL DATASETS CREATED = 0
BMC50868I LOG RECORD STORE WRITE REQUESTS = 0, WRITE WAIT TIME = 0.000, READ REQUESTS = 0 READ WAIT TIME = 0.000
BMC50786I 110: LOG RECORD SPILL TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:19
BMC50786I 111: INLINE IMAGE COPY APPEND TASK ENDED AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:19
BMC50476I DDNAME = BMCCPY01, I/OS = 46, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50376I 2604 PAGES COPIED TO DATASET = 'ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.BMCCPY01'
BMC50476I DDNAME = BMCCPY02, I/OS = 45, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50376I 2596 PAGES COPIED TO DATASET = 'ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.BMCCPY02'
BMC50476I DDNAME = BMCCPY03, I/OS = 45, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50376I 2605 PAGES COPIED TO DATASET = 'ARU.EXMPL13A.DEMO.EXMPLE13.EXMPLE13.BMCCPY03'
BMC50865I TOTAL RECORDS INSERTED INTO LOG RECORD STORE, DATA =0, INDEX = 0
BMC50866I TOTAL TABLESPACE STRINGS PROCESSED = 0, WHEN NOT FULL = 0, FROM SPILL = 0
BMC50866I TOTAL INDEXSPACE STRINGS PROCESSED = 0, WHEN NOT FULL = 0, FROM SPILL = 0
BMC50866I TOTAL INDEXSPACE REQUE STRINGS PROCESSED = 0, WHEN NOT FULL = 0, FROM SPILL = 0
BMC50859I LOG RECORD STORE STATISTICS: MEMORY AVAILABLE = 28160K, MEMORY USED = 5120K
BMC50860I TOTAL WAIT TIME FOR LOG RECORD STORE MEMORY = 0.000 DATA = 0.000 INDEX = 0.000
BMC50880I RIDMAP: PART 0001: ROWS=616704, PAIRS=616704, STORAGE=4724K, MEM WAITS=0, WAIT TIME=0
BMC50881I RIDMAP: PART 0001: TRANS=0, ADDS=0, DELS=0, SPILL READS=0, WAIT TIME=0
BMC50880I RIDMAP: PART 0002: ROWS=337920, PAIRS=337920, STORAGE=2596K, MEM WAITS=3, WAIT TIME=0
BMC50881I RIDMAP: PART 0002: TRANS=0, ADDS=0, DELS=0, SPILL READS=0, WAIT TIME=0
BMC50880I RIDMAP: PART 0003: ROWS=126720, PAIRS=126720, STORAGE=2248K, MEM WAITS=4, WAIT TIME=0
BMC50881I RIDMAP: PART 0003: TRANS=0, ADDS=0, DELS=0, SPILL READS=0, WAIT TIME=0
BMC50880I RIDMAP: SUMMARY: ROWS=1081344, PAIRS=1081344, STORAGE=9568K, MEM WAITS=7, WAIT TIME=0
BMC50881I RIDMAP: SUMMARY: TRANS=0, ADDS=0, DELS=0, SPILL READS=0, WAIT TIME=0
BMC50882I RIDMAP: SUMMARY: MAX DATASPACES=1, USED DATASPACES=1, RIDMAPMEM=0K, USED MEM=10748K
BMC50883I RIDMAP: SUMMARY: MAX PIPES=4, PIPES USED=2, PIPE BUFFER SIZE=262144, PIPE WAITS=0, WAIT TIME=0
BMC50868I RIDMAP WRITE REQUESTS = 0, WRITE WAIT TIME = 0.000, READ REQUESTS = 0 READ WAIT TIME = 0.000
BMC50703I LOG PROCESSING COMPLETED, RC = 0, AT 1/29/2022 03:53:51, ELAPSED TIME = 00:00:21
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XV2B
BMC50004I LOGFINAL PHASE COMPLETE. ELAPSED TIME = 00:00:04
BMC50705I SQL PREPARE LOCK STARTED AT 00DAD563303C0133BA00
BMC50894I SWITCH PROCESS STARTING AT 1/29/2022 3:53:51
BMC51350I MATERIALIZATION OF PENDING DDL CHANGES COMPLETED FOR EXMPLE13.EXMPLE13 AT 03:53:51
BMC51297I ALL SPECIFIED LIMIT KEYS HAVE BEEN SUCCESSFULLY ALTERED
BMC50705I SQL PREPARE LOCK TERMINATED AT 00DAD56330451D458000
BMC51362I LPART PPART CARD ALTER TYPE LIMITKEY
BMC51363I 1 1 360448 REBALANCE X'276002281500000000000083E8'
BMC51363I 2 2 360448 REBALANCE X'36100428070000000000009CE8'
BMC51363I 3 3 360448 X'456912310000000000000083E8'
BMC50890I 6: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013A.I0001.A003'...
BMC50890I 1: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.I0001.A001'...
BMC50890I 9: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013C.I0001.A003'...
BMC50890I 4: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013A.I0001.A001'...
BMC50890I 7: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013C.I0001.A001'...
BMC50890I 2: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.I0001.A002'...
BMC50890I 8: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013C.I0001.A002'...
BMC50890I 3: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.I0001.A003'...
BMC50890I 5: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013A.I0001.A002'...
BMC50890I 10: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013B.I0001.A001'...
BMC50890I 12: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013E.I0001.A001'...
BMC50890I 11: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013D.I0001.A001'...
BMC50891I 7: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013C.I0001.A001' IS DELETED
BMC50891I 4: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013A.I0001.A001' IS DELETED
BMC50891I 9: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013C.I0001.A003' IS DELETED
BMC50891I 2: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.I0001.A002' IS DELETED
BMC50891I 10: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013B.I0001.A001' IS DELETED
BMC50891I 1: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.I0001.A001' IS DELETED
BMC50891I 3: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.EXMPLE13.I0001.A003' IS DELETED
BMC50891I 11: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013D.I0001.A001' IS DELETED
BMC50891I 12: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013E.I0001.A001' IS DELETED
BMC50891I 6: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013A.I0001.A003' IS DELETED
BMC50891I 8: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013C.I0001.A002' IS DELETED
BMC50891I 5: DATASET 'DEMOCAT.DSNDBC.EXMPLE13.ARX013A.I0001.A002' IS DELETED
BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR REORG UTILITY SUCCESSFUL FOR ALL OBJECTS
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*