Example 12: SHRLEVEL CHANGE with DDLIN and online repartitioning
In this example, REORG PLUS reorganizes a partitioned table space with three partitions.
The table has one clustering index and one nonpartitioned secondary index. This example uses SHRLEVEL CHANGE to keep the objects in RW status during most of the reorganization.
In the LOGAPPLY phase, REORG PLUS determines the rate at which it is applying log records. If REORG PLUS estimates that it can finish applying the log records (LOGFINAL phase) by the time specified by the DEADLINE option, and without exceeding the maximum time specified by MAXRO, REORG PLUS moves from the LOGAPPLY phase into the LOGFINAL phase and completes the reorganization.
The DDLIN data set supplies the ALTER INDEX commands. REORG PLUS performs online partition rebalancing in the staging data sets, and performs the limit-key updates in the UTILTERM phase.
Message 50041I indicates the status of zIIP processing. For this example, an XBM subsystem ID was specified for SHRLEVEL CHANGE processing. REORG PLUS uses the same XBM subsystem ID for zIIP processing.
The following table describes the key command options, installation options, and DD statements for this job:
Command options and DD statements used in JCL; installation options | Description |
|---|---|
REORG TABLESPACE | Specifies that the table space named in the statement is to be reorganized |
SHRLEVEL CHANGE | Specifies the reorganization type REORG PLUS will keep the original data sets in their original status (which can be RW) as long as possible. |
UNLOAD CONTINUE | Tells REORG PLUS to continue the reorganization with two-phase processing after the UNLOAD phase has unloaded the data |
XBMID XBMA | Specifies to use the XBM subsystem with the SSID of XBMA |
COPY YES | Creates full and incremental Db2 image copies of the table space SHRLEVEL CHANGE sets REGISTER ALL, so all copies are registered in SYSIBM.SYSCOPY. |
ORDER YES | Sorts the rows by table as well as by each table’s clustering key If no clustering key exists, x'00's are used. |
DEADLINE | Continues the reorganization only if REORG PLUS estimates that it can finish LOGFINAL processing by the time and date specified in the timestamp The UTILTERM phase can continue past the deadline. |
MAXRO 600 | Starts the LOGFINAL phase when REORG PLUS estimates that it can apply the remaining log records within 10 minutes (600 seconds) This estimate does not include the time needed to produce the incremental image copies and complete the UTILTERM phase processing. |
LONGLOG CONTINUE (installation option) | Tells REORG PLUS to continue the reorganization if the longlog condition still exists after the DELAY time expires |
DELAY 300 | Specifies the number of seconds that are to elapse from the time REORG PLUS detects a longlog condition until the time it performs the action specified on the LONGLOG option If the longlog condition no longer exists at the end of the time period specified by DELAY, the timer, is reset. When REORG PLUS detects the next longlog condition, it restarts the timer using the original DELAY value. |
RIDMAPMEM 0 (installation option) | REORG PLUS automatically calculates the RIDMAPMEM value to be used to store the RID translation maps. |
LOGMEM 0 (installation option) | REORG PLUS automatically calculates the amount of data space memory (in kilobytes) needed to hold the internal structures that REORG PLUS uses to store the log records |
LOGSPILL (1024, 1024) | Determines the primary and secondary space allocation (in kilobytes) for the spill data sets that hold the log records Each number can be a nonzero positive integer. |
SPILLDSNPAT | Tells REORG PLUS to use a particular pattern of variables and text to create a prefix for the spill data set name The spill data sets hold the log records and RID maps when they overflow memory. REORG PLUS dynamically allocates spill data sets as they are needed. The spill data sets are VSAM objects. |
SPILLUNIT | Specifies the DASD unit where REORG PLUS can allocate spill data sets The spill data sets hold the log records and RID maps when they overflow memory. REORG PLUS dynamically allocates spill data sets as they are needed. The spill data sets are VSAM objects. |
SPILLSTORCLAS | Specifies the SMS storage class that REORG PLUS uses to allocate spill data sets The spill data sets hold the log records and RID maps when they overflow memory. REORG PLUS dynamically allocates spill data sets as they are needed. The spill data sets are VSAM objects. |
ANALYZE | Gathers information about the objects that you are reorganizing and provides estimated sizes for SYSREC, SYSUT1, SORTWK, and copy data sets |
SIZEPCT (150,150) | Tells REORG PLUS to allocate 150% of the data set size that it calculated for the UNLOAD, WORK, and SORTWORK files The increase allows room for the unknown number of updates that are being applied to the data sets. |
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 |
DDLIN | DDLIN data set contains the SQL ALTER INDEX and ALTER TABLESPACE statements with the new limit key values to use to rebalance partitions |
//BMCCPY //BMCCPZ //BMCRCY //BMCRCZ | Default ddnames that are used for the data sets that receive a full image copy of the table space that you are reorganizing The existence of the copy ddnames determines the number of copies made. COPY YES is set for SHRLEVEL CHANGE. |
//BMCICY //BMCICZ //BMCIRY //BMCIRZ | Default ddnames that are used for the data sets that receive an incremental image copy of the table space that you are reorganizing The existence of the copy ddnames determines the number of copies made. COPY YES is set for SHRLEVEL CHANGE. |
The following figure shows the JCL for example 12:
// JOB
//*
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//* PARTITIONED TABLESPACE, CLUSTERING INDEX AND NONPARTITIONED *
//* SECONDARY INDEX. *
//* REORG TABLESPACE WITH SHRLEVEL CHANGE OPTION. *
//* ALTER PARTITIONING INDEX KEYS USING DDLIN OPTION. *
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//LARREORG EXEC PGM=ARUUMAIN,COND=(7,LT),
// PARM='<db2ssid>,LARCOPB.LARDBXAB,NEW,,MSGLEVEL(1),ARU$OPTS'
//STEPLIB DD DISP=SHR,DSN=<productLibraries>
// DD DISP=SHR,DSN=DB2.DSNEXIT
// DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSTERM DD SYSOUT=*
//*
//BMCCPY DD DSN=ARU.EXMPL12.BMCCPY,
// DISP=(,CATLG),
// SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCCPZ DD DSN=ARU.EXMPL12.BMCCPZ,
// DISP=(,CATLG),
// SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCRCY DD DSN=ARU.EXMPL12.BMCRCY,
// DISP=(,CATLG),
// SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCRCZ DD DSN=ARU.EXMPL12.BMCRCZ,
// DISP=(,CATLG),
// SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCICY DD DSN=ARU.EXMPL12.BMCICY,
// DISP=(,CATLG),
// SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCICZ DD DSN=ARU.EXMPL12.BMCICZ,
// DISP=(,CATLG),
// SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCIRY DD DSN=ARU.EXMPL12.BMCIRY,
// DISP=(,CATLG),
// SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCIRZ DD DSN=ARU.EXMPL12.BMCIRZ,
// DISP=(,CATLG),
// SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//*
//SYSIN DD *
REORG TABLESPACE LARDBXAB.LARSXABA
SHRLEVEL CHANGE
UNLOAD CONTINUE
XBMID XBMB
FASTSWITCH YES
COPY YES
ORDER YES
DEADLINE 2015-03-05-19.30.00.00
MAXRO 600
DELAY 300
LOGSPILL (1024,1024)
SPILLDSNPAT 'ARU.LARWORK.DEFF'
SPILLUNIT NONE
SPILLSTORCLAS COPYCLAS
ANALYZE
DDTYPE UNLOAD UNIT (WORK) SIZEPCT (150,150)
DSNPAT 'ARU.EXMPL12.&DB.&TSIX.&DDNAME'
DDTYPE WORK UNIT (WORK) SIZEPCT (150,150)
DSNPAT 'ARU.EXMPL12.&DB.&TSIX.&DDNAME'
DDTYPE LOCPFCPY ACTIVE NO
//DDLIN DD *
ALTER INDEX LARDBXAB.LARX001A
PART 1 VALUES ('2800-12-31-00.00.00.000000'),
PART 2 VALUES ('3800-12-31-00.00.00.000000'),
PART 3 VALUES ('4500-12-31-00.00.00.000000');
/*
//*
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//* PARTITIONED TABLESPACE, CLUSTERING INDEX AND NONPARTITIONED *
//* SECONDARY INDEX. *
//* REORG TABLESPACE WITH SHRLEVEL CHANGE OPTION. *
//* ALTER PARTITIONING INDEX KEYS USING DDLIN OPTION. *
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//LARREORG EXEC PGM=ARUUMAIN,COND=(7,LT),
// PARM='<db2ssid>,LARCOPB.LARDBXAB,NEW,,MSGLEVEL(1),ARU$OPTS'
//STEPLIB DD DISP=SHR,DSN=<productLibraries>
// DD DISP=SHR,DSN=DB2.DSNEXIT
// DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSTERM DD SYSOUT=*
//*
//BMCCPY DD DSN=ARU.EXMPL12.BMCCPY,
// DISP=(,CATLG),
// SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCCPZ DD DSN=ARU.EXMPL12.BMCCPZ,
// DISP=(,CATLG),
// SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCRCY DD DSN=ARU.EXMPL12.BMCRCY,
// DISP=(,CATLG),
// SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCRCZ DD DSN=ARU.EXMPL12.BMCRCZ,
// DISP=(,CATLG),
// SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCICY DD DSN=ARU.EXMPL12.BMCICY,
// DISP=(,CATLG),
// SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCICZ DD DSN=ARU.EXMPL12.BMCICZ,
// DISP=(,CATLG),
// SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCIRY DD DSN=ARU.EXMPL12.BMCIRY,
// DISP=(,CATLG),
// SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCIRZ DD DSN=ARU.EXMPL12.BMCIRZ,
// DISP=(,CATLG),
// SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//*
//SYSIN DD *
REORG TABLESPACE LARDBXAB.LARSXABA
SHRLEVEL CHANGE
UNLOAD CONTINUE
XBMID XBMB
FASTSWITCH YES
COPY YES
ORDER YES
DEADLINE 2015-03-05-19.30.00.00
MAXRO 600
DELAY 300
LOGSPILL (1024,1024)
SPILLDSNPAT 'ARU.LARWORK.DEFF'
SPILLUNIT NONE
SPILLSTORCLAS COPYCLAS
ANALYZE
DDTYPE UNLOAD UNIT (WORK) SIZEPCT (150,150)
DSNPAT 'ARU.EXMPL12.&DB.&TSIX.&DDNAME'
DDTYPE WORK UNIT (WORK) SIZEPCT (150,150)
DSNPAT 'ARU.EXMPL12.&DB.&TSIX.&DDNAME'
DDTYPE LOCPFCPY ACTIVE NO
//DDLIN DD *
ALTER INDEX LARDBXAB.LARX001A
PART 1 VALUES ('2800-12-31-00.00.00.000000'),
PART 2 VALUES ('3800-12-31-00.00.00.000000'),
PART 3 VALUES ('4500-12-31-00.00.00.000000');
/*
SYSPRINT for example 12
The following figure shows the SYSPRINT output for example 12:
***** B M C R E O R G P L U S F O R D B 2 V11R2.00 *****
(C) COPYRIGHT 1988 - 2015 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 3/04/2015 16:23:50 ...
BMC50002I UTILITY ID = 'LARCOPB.LARDBXAB'. DB2 SUBSYSTEM ID = 'DEHJ'. OPTION MODULE = 'ARU$OPTS'.
BMC50471I z/OS 2.1.0,PID=HBB7790,DFSMS FOR Z/OS=2.1.0,DB2=11.1.0
BMC50471I REGION=0M,BELOW 16M=8808K,ABOVE 16M=1312192K,IEFUSI=NO,CPUS=3
BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040311M,MEMLIMIT SET BY:REGION=0
BMC50471I REORG PLUS FOR DB2--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I SOLUTION COMMON CODE--V11.01.00
BMC50471I MAINT: BPJ0661 BPJ0667 BPJ0671 BPJ0674 BPJ0675 BPJ0676 BPJ0682 BPJ0686 BPJ0689 BPJ0697 BPJ0700 BPJ0702
BMC50471I BPJ0703 BPJ0706 BPJ0712 BPJ0715 BPJ0729 BPJ0773 BPJ0786 BPJ0794 BPJ0806 BPJ0830 BPJ0833 BPJ0839
BMC50471I BPJ0845 BPJ0866 BPJ0892 BPJ0913 BPJ0914 BPJ0916 BPJ0930 BPJ0944 BPJ0946
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922
BMC50471I BMC STATS API--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.01.00
BMC50471I MAINT: BPE0401 BPE0403 BPE0405 BPE0407 BPE0410 BPE0412 BPE0416 BPE0420 BPE0422 BPE0423 BPE0426 BPE0428
BMC50471I BPE0430 BPE0433 BPE0435 BPE0438 BPE0439
BMC50471I ANALMAX=1000% FSTHRESHOLD=0 ROUTCDE=(11,1)
BMC50471I ARC=NO ICDDN=(BMCICY,BMCICZ) SCPYMAX=8
BMC50471I ARCHDDN=SYSARC ICTYPE=AUTO SDUMP=YES
BMC50471I ARCHFORMAT=BMC IDCACHE=10000 SHORTMEMORY=CONTINUE
BMC50471I AVAILPAGEPCT=100 INDREFLM=10 SIXSNAP=NO
BMC50471I BILDMAX=300% INLINECP=YES SMAX=0
BMC50471I BMCHIST=YES KEEPDICTIONARY=NO SMCORE=(0K,0K)
BMC50471I CBUFFS=30 LEAFDSLM=200 SORTDEVT=(,SYSALLDA)
BMC50471I CONDEXEC=NO LOCKROW=YES SORTNUM=32
BMC50471I COPYDDN=(BMCCPY,BMCCPZ) LOGFINAL=NONE SPILDSNP=&UID
BMC50471I COPYLVL=PART LOGMEM=0 SPILSCLS=NONE
BMC50471I COPYMAX=1000% LOGSPIL=(20000,10000) SPILUNIT=WORK
BMC50471I COPYSUBSET=NO LOGTHRSH=0 SQLDELAY=3
BMC50471I CPYRFAIL=TERM LONGLOG=CONTINUE SQLRETRY=100
BMC50471I DATACAP=NO LONGNAMETRUNC=MIDDLE STAGEDSN=BMC
BMC50471I DDLDDN=DDLIN MAPTEXIT=(NONE,REXX) STOP@CMT=YES
BMC50471I DEADLINE=NONE MAXNEWPARTS=2 STOPDELAY=1
BMC50471I DELAY=1200 MAXRO=300 STOPRETRY=300
BMC50471I DELFILES=YES MAXSORTMEMORY=0 TAPEDISP=DELETE
BMC50471I DESCCDE=(3,7) MAXTAPE=3 TASKMAX=1000%
BMC50471I DRAINTYP=ALL MGEXTENT=CONTINUE TERMEXIT=(NONE,REXX)
BMC50471I DRNDELAY=1 MINSORTMEMORY=0 TIMEOUT=TERM
BMC50471I DRNRETRY=255 MSGLEVEL=1 TOTALPAGEPCT=0
BMC50471I DRNWAIT=NONE OFFPOSLM=10 TSSAMPLEPCT=100
BMC50471I DSNUEXIT=(NONE,ASM) OPNDB2ID=YES UBUFFS=20
BMC50471I DSNUTILB=YES ORIGDISP=DELETE UNLDDN=SYSREC
BMC50471I DSPLOCKS=DRNFAIL PREFORMAT=NO UNLDMAX=300%
BMC50471I DSRSEXIT=(NONE,REXX) RCVICDDN=(BMCIRY,BMCIRZ) UNLOAD=RELOAD
BMC50471I EXCLDUMP=(X37,X22,X06) RCVYDDN=(BMCRCY,BMCRCZ) UXSTATE=SUP
BMC50471I FASTSWITCH=NO REDEFINE=YES WBUFFS=(20,10)
BMC50471I FILECHK=WARN RENMMAX=30 WORKDDN=SYSUT1
BMC50471I FORCE_AT=(START,3) RIDMDSSZ=2097152 WORKUNIT=SYSALLDA
BMC50471I FORCE_RPT=NO RIDMMAXD=1 XBMID=
BMC50471I FORCE=NONE RMAPMEM=0 ZIIP=ENABLED
BMC50471I FSFALLBACK=NO RORGMAX=300%
BMC50471I PLAN=ARUQA
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
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
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
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
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
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
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
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
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
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 = 1110
BMC50471I SUBSYSTEM DEFAULT = DEHJ
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)
BMC50028I DB2 MODE = NFM
BMC50471I BMCUTIL ='BMCUTIL.CMN_BMCUTIL'
BMC50471I BMCSYNC ='BMCUTIL.CMN_BMCSYNC'
BMC50471I BMCHIST ='BMCUTIL.CMN_BMCHIST'
BMC50471I BMCDICT ='BMCUTIL.CMN_BMCDICT'
BMC50471I BMCXCOPY='BMCUTIL.CMN_BMCXCOPY'
BMC50471I DASD MANAGER PLUS TABLES:
BMC50102I REORG TABLESPACE LARDBXAB.LARSXABA
BMC50102I SHRLEVEL CHANGE
BMC50102I UNLOAD CONTINUE
BMC50102I XBMID XBMB
BMC50102I FASTSWITCH YES
BMC50102I COPY YES
BMC50102I ORDER YES
BMC50102I DEADLINE 2015-03-05-19.30.00.00
BMC50102I MAXRO 600
BMC50102I DELAY 300
BMC50102I LOGSPILL (1024,1024)
BMC50102I SPILLDSNPAT 'ARU.LARWORK.DEHJ'
BMC50102I SPILLUNIT NONE
BMC50102I SPILLSTORCLAS COPYCLAS
BMC50102I ANALYZE
BMC50102I DDTYPE UNLOAD UNIT (WORK) SIZEPCT (150,150)
BMC50102I DSNPAT 'ARU.EXMPL12.&DB.&TSIX.&DDNAME'
BMC50102I DDTYPE WORK UNIT (WORK) SIZEPCT (150,150)
BMC50102I DSNPAT 'ARU.EXMPL12.&DB.&TSIX.&DDNAME'
BMC50102I DDTYPE LOCPFCPY ACTIVE NO
BMC50109I 'FASTSWITCH=YES' OPTION SPECIFIED. OPTION 'STAGEDSN=BMC' IGNORED
BMC51291I A DDLIN DATASET HAS BEEN FOUND AND CONTAINS THE FOLLOWING STATEMENTS:
BMC50102I ALTER INDEX LARDBXAB.LARX001A
BMC50102I PART 1 VALUES ('2800-12-31-00.00.00.000000'),
BMC50102I PART 2 VALUES ('3800-12-31-00.00.00.000000'),
BMC50102I PART 3 VALUES ('4500-12-31-00.00.00.000000');
BMC51232I ALTER STATEMENT 1 WILL BE PROCESSED
BMC51293I 1 ALTER STATEMENT(S) WILL BE PROCESSED FROM THE DDLIN FILE
BMC50004I UTILINIT PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50244I PROCESSING PAGESET DBID(3473) PSID(2) PART(1) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00000000 FOR DBID(3473) PSID(2)
BMC51301I 3: SAMPLING STATISTICS: PART=1,TP=7103,SP=113,SR=654,AVGR=441,SD=65,SE=1,AVGF=578,SD=65,SE=10,EP=4
BMC50244I PROCESSING PAGESET DBID(3473) PSID(2) PART(2) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00100000 FOR DBID(3473) PSID(2)
BMC51301I 2: SAMPLING STATISTICS: PART=2,TP=7021,SP=112,SR=654,AVGR=441,SD=65,SE=0,AVGF=583,SD=65,SE=9,EP=3
BMC50244I PROCESSING PAGESET DBID(3473) PSID(2) PART(3) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00200000 FOR DBID(3473) PSID(2)
BMC51301I 1: SAMPLING STATISTICS: PART=3,TP=7020,SP=112,SR=660,AVGR=440,SD=65,SE=1,AVGF=589,SD=65,SE=7,EP=2
BMC51265I ESTIMATED CARDINALITY OF SPACE = 123299 AVG SORTWK ROW LENGTH = 441 AVG UNLOAD ROW LENGTH = 441
BMC50484I ESTIMATED CARDINALITY OF PART 0001 = 41043 AVG SORTWK ROW LENGTH = 441 AVG UNLOAD ROW LENGTH = 441
BMC50484I ESTIMATED CARDINALITY OF PART 0002 = 40920 AVG SORTWK ROW LENGTH = 441 AVG UNLOAD ROW LENGTH = 441
BMC50484I ESTIMATED CARDINALITY OF PART 0003 = 41336 AVG SORTWK ROW LENGTH = 440 AVG UNLOAD ROW LENGTH = 440
BMC51264I UNLOAD WILL READ 21138 DATA PAGES FROM SPACE 'LARDBXAB.LARSXABA'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I ANALYZE PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50425I &JOBNAME = CXBREXMC &STEPNAME = LARREORG &DB = LARDBXAB &TSIX = LARSXABA &RTYPE = TS
BMC50425I &UID = RDACXB2 &DATE = 030415 &TIME = 162350 &SSID = DEHJ &UTIL = LARCOPB.
BMC50425I &UTILPFX = LARCOPB &UTILSFX = LARDBXAB &DATE8 = 03042015 &GRPNM = DEHJ &VCAT = DEHJCAT
BMC50425I &TIME4 = 1623 &DATEJ = 2015063 &JDATE = 15063
BMC50702I LOG PROCESSING STARTED AT 03/04/2015 16:23:51
BMC50773I 101: LOG SCAN TASK STARTED AT 03/04/2015 16:23:51
BMC50706I MONITOR TRACE CLASS(1) STARTED, TRACE NUMBER = 05
BMC50877I POINT OF CONSISTENCY ESTABLISHED AT RBA/LRSN = 0000000004C272360000
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 SYSREC01 ARU.EXMPL12.LARDBXAB.LARSXABA.SYSREC01 *WORK 27056 6765 502 126 TRK
BMC50448I SYSREC02 ARU.EXMPL12.LARDBXAB.LARSXABA.SYSREC02 *WORK 26975 6744 500 125 TRK
BMC50448I SYSREC03 ARU.EXMPL12.LARDBXAB.LARSXABA.SYSREC03 *WORK 27188 6798 504 126 TRK
BMC50448I SYSUT1 ARU.EXMPL12.LARDBXAB.LARSXABA.SYSUT1 *WORK 1989 200 37 4 TRK
BMC50394I UNABLE TO LOCATE SORT WORK DATASETS, DDNAME = 'SORTWKNN'
BMC50474I BELOW 16M = 8292K, ABOVE 16M = 1299332K, CPUS = 3
BMC50479I TOTAL PAGES: 4136263, ALLOWED: 0; AVAILABLE PAGES: 809841, ALLOWED: 809841
BMC50719I 1 LOG APPLY TASKS, 4 INDEX APPLY TASKS, AVAILABLE MEMORY: 1154082K
BMC50887I RIDMAP: RIDMAPMEM CHANGED TO 2097152K
BMC50864I LOGMEM OF 0K SPECIFIED, CHANGED TO 25600K
BMC51302I MAX TASKS = 1, MAX PARTITIONS PER TASK = 3, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 3
BMC50773I 107: LOG RECORD SORT TASK STARTED AT 03/04/2015 16:23:53
BMC50773I 108: LOG RECORD SPILL TASK STARTED AT 03/04/2015 16:23:53
BMC50773I 109: INLINE IMAGE COPY APPEND TASK STARTED AT 03/04/2015 16:23:53
BMC50847I 109: BUFFER ALLOCATIONS: CHANGED PAGE BUFFERS = 0, I/O BUFFERS = 200,LARGEST BLOCK SIZE = 4096
BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1852K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50477I 1: PARTITION = 1, ROWS/KEYS = 40592, I/O WAITS = 2 ,DDNAME = SYS00006
BMC50477I 1: PARTITION = 2, ROWS/KEYS = 40120, I/O WAITS = 4 ,DDNAME = SYS00007
BMC50477I 1: PARTITION = 3, ROWS/KEYS = 40120, I/O WAITS = 12 ,DDNAME = SYS00008
BMC50481I 1: SORT COMPLETE. ELAPSED TIME = 00:00:01
BMC50481I 1: UNLOAD TASK COMPLETE. ELAPSED TIME = 00:00:01
BMC50476I DDNAME = SYSREC01, I/OS = 61, I/O WAITS = 33, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC02, I/OS = 68, I/O WAITS = 11, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC03, I/OS = 46, I/O WAITS = 6, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSUT1, I/OS = 6, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC51271I UNLOAD STATISTICS: 42373 ROWS/KEYS UNLOADED FROM PARTITION 1
BMC51281I UNLOAD STATISTICS: X'00000000000000000000' IS THE HIGHEST LOGRBA FOR PARTITION 1
BMC51286I RELOADING OF DATASET 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A001' WILL REQUIRE 7415 PAGES
BMC51290I RELOADING OF DATASET 'DEHJCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A001' WILL REQUIRE 268 PAGES (APPROX.)
BMC51271I UNLOAD STATISTICS: 47200 ROWS/KEYS UNLOADED FROM PARTITION 2
BMC51281I UNLOAD STATISTICS: X'00000000000000000000' IS THE HIGHEST LOGRBA FOR PARTITION 2
BMC51286I RELOADING OF DATASET 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A002' WILL REQUIRE 8258 PAGES
BMC51290I RELOADING OF DATASET 'DEHJCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A002' WILL REQUIRE 298 PAGES (APPROX.)
BMC51271I UNLOAD STATISTICS: 31259 ROWS/KEYS UNLOADED FROM PARTITION 3
BMC51281I UNLOAD STATISTICS: X'00000000000000000000' IS THE HIGHEST LOGRBA FOR PARTITION 3
BMC51286I RELOADING OF DATASET 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A003' WILL REQUIRE 5468 PAGES
BMC51290I RELOADING OF DATASET 'DEHJCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A003' WILL REQUIRE 196 PAGES (APPROX.)
BMC51288I RELOADING OF DATASET 'DEHJCAT.DSNDBD.LARDBXAB.LARX001B.J0001.A001' MAY REQUIRE 621 PAGES
BMC51272I UNLOAD STATISTICS: 120832 ROWS UNLOADED FROM SPACE 'LARDBXAB.LARSXABA', 0 ROWS DISCARDED, 0 ROWS UPDATED
BMC51282I UNLOAD STATISTICS: X'00000000000000000000' IS THE HIGHEST LOGRBA FOR SPACE 'LARDBXAB.LARSXABA'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I UNLOAD PHASE COMPLETE. ELAPSED TIME = 00:00:03
BMC50277I XBM STATISTICS: DSN='DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.I0001.A001 ', READS 7103, HITS 0, WRITES 0, CACHE 0
BMC50277I XBM STATISTICS: DSN='DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.I0001.A002 ', READS 7021, HITS 0, WRITES 0, CACHE 0
BMC50277I XBM STATISTICS: DSN='DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.I0001.A003 ', READS 7020, HITS 0, WRITES 0, CACHE 0
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8224K, ABOVE 16M = 1296920K, CPUS = 3
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A002'
BMC50479I TOTAL PAGES: 4111891, ALLOWED: 0; AVAILABLE PAGES: 808786, ALLOWED: 808786
BMC51303I MAX TASKS = 1, INDEXES PER TASK = 1, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 1
BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50476I DDNAME = SYSUT1, I/OS = 4, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50481I 1: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50482I 0: BUILD COMPLETE. ELAPSED TIME = 00:00:01 DSN = 'DEHJCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A002'
BMC50477I 0: PARTITION = 2, ROWS/KEYS = 47200, I/O WAITS = 5 ,DDNAME = SYS00016
BMC50482I 0: RELOAD COMPLETE. ELAPSED TIME = 00:00:01 DSN = 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A002'
BMC50477I 0: PARTITION = 2, ROWS/KEYS = 47200, I/O WAITS = 18 ,DDNAME = SYS00012
BMC51274I RELOAD STATISTICS: 47200 ROWS/KEYS LOADED INTO PARTITION 2
BMC50773I 103: INDEX APPLY TASK STARTED AT 03/04/2015 16:23:57
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.LARDBXAB.LARX001B.J0001.A001'
BMC50477I 1: PARTITION = 0, ROWS/KEYS = 120832, I/O WAITS = 5 ,DDNAME = SYS00020
BMC50773I 106: INDEX APPLY TASK STARTED AT 03/04/2015 16:23:57
BMC51276I BUILD STATISTICS: 120832 KEYS LOADED INTO INDEX 'LARDBXAB.LARX001B'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A001'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A003'
BMC50476I DDNAME = SYSREC02, I/OS = 64, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50482I 0: BUILD COMPLETE. ELAPSED TIME = 00:00:04 DSN = 'DEHJCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A001'
BMC50477I 0: PARTITION = 1, ROWS/KEYS = 42373, I/O WAITS = 5 ,DDNAME = SYS00028
BMC50482I 0: RELOAD COMPLETE. ELAPSED TIME = 00:00:04 DSN = 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A001'
BMC50477I 0: PARTITION = 1, ROWS/KEYS = 42373, I/O WAITS = 12 ,DDNAME = SYS00024
BMC51274I RELOAD STATISTICS: 42373 ROWS/KEYS LOADED INTO PARTITION 1
BMC50773I 104: INDEX APPLY TASK STARTED AT 03/04/2015 16:24:01
BMC50476I DDNAME = SYSREC01, I/OS = 57, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50482I 0: BUILD COMPLETE. ELAPSED TIME = 00:00:02 DSN = 'DEHJCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A003'
BMC50477I 0: PARTITION = 3, ROWS/KEYS = 31259, I/O WAITS = 5 ,DDNAME = SYS00037
BMC50482I 0: RELOAD COMPLETE. ELAPSED TIME = 00:00:03 DSN = 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A003'
BMC50477I 0: PARTITION = 3, ROWS/KEYS = 31259, I/O WAITS = 8 ,DDNAME = SYS00033
BMC51274I RELOAD STATISTICS: 31259 ROWS/KEYS LOADED INTO PARTITION 3
BMC50773I 105: INDEX APPLY TASK STARTED AT 03/04/2015 16:24:02
BMC50476I DDNAME = SYSREC03, I/OS = 42, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC51276I BUILD STATISTICS: 120832 KEYS LOADED INTO INDEX 'LARDBXAB.LARX001A'
BMC51275I RELOAD STATISTICS: 120832 ROWS LOADED INTO SPACE 'LARDBXAB.LARSXABA'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC03', DSNAME = 'ARU.EXMPL12.LARDBXAB.LARSXABA.SYSREC03'
BMC50773I 102: LOG APPLY TASK STARTED AT 03/04/2015 16:24:02
BMC50829I LOGAPPLY PHASE STARTING AT 03/04/2015 16:24:02
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC01', DSNAME = 'ARU.EXMPL12.LARDBXAB.LARSXABA.SYSREC01'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC02', DSNAME = 'ARU.EXMPL12.LARDBXAB.LARSXABA.SYSREC02'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT1 ', DSNAME = 'ARU.EXMPL12.LARDBXAB.LARSXABA.SYSUT1'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I RELOAD PHASE COMPLETE. ELAPSED TIME = 00:00:06
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50877I POINT OF CONSISTENCY ESTABLISHED AT RBA/LRSN = 0000000004C27248C000
BMC50778I LOG RECORD QUEUE SIZE AT OR BELOW THRESHOLD
BMC50004I LOGAPPLY PHASE COMPLETE. ELAPSED TIME = 00:00:06
BMC50830I LOGFINAL PHASE STARTING AT 03/04/2015 16:24:08
BMC50709I MONITOR TRACE CLASS(1) TRACE NUMBER = 05 STOPPED
BMC50786I 101: LOG SCAN TASK ENDED AT 03/04/2015 16:24:08, ELAPSED TIME = 00:00:16
BMC50720I 102: 0 NEW LOG APPLY BUFFERS, 0 REUSED, 16637 INITIAL MAXIMUM, 0 WAITS, BUFFER SIZE=8380
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 LARDBXAB.LARSXABA
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=DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.J0001.A001
BMC50717I 102: DATASET=DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.J0001.A002
BMC50717I 102: DATASET=DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.J0001.A003
BMC50718I 102: Page Requests 6 | Page Hits 0
BMC50718I 102: Page Reads 6 | 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 03/04/2015 16:24:12, ELAPSED TIME = 00:00:10
BMC50786I 107: LOG RECORD SORT TASK ENDED AT 03/04/2015 16:24:12, ELAPSED TIME = 00:00:19
BMC50786I 109: INLINE IMAGE COPY APPEND TASK ENDED AT 03/04/2015 16:24:12, ELAPSED TIME = 00:00:19
BMC50794I 104: INDEX MAINTENANCE STATISTICS FOR INDEX LARDBXAB.LARX001A DSNUM 1
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 104: Buffer Manager Statistics
BMC50717I 104: DATASET=DEHJCAT.DSNDBC.LARDBXAB.LARX001A.J0001.A001
BMC50718I 104: Page Requests 5 | Page Hits 1
BMC50718I 104: Page Reads 4 | Page Writes 1
BMC50718I 104: Write I/O Requests 1 | New Pages 0
BMC50716I 104: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50786I 104: INDEX APPLY TASK ENDED AT 03/04/2015 16:24:16, ELAPSED TIME = 00:00:15
BMC50794I 105: INDEX MAINTENANCE STATISTICS FOR INDEX LARDBXAB.LARX001A 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 105: Buffer Manager Statistics
BMC50717I 105: DATASET=DEHJCAT.DSNDBC.LARDBXAB.LARX001A.J0001.A003
BMC50718I 105: Page Requests 5 | Page Hits 1
BMC50718I 105: Page Reads 4 | Page Writes 1
BMC50718I 105: Write I/O Requests 1 | New Pages 0
BMC50716I 105: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50786I 105: INDEX APPLY TASK ENDED AT 03/04/2015 16:24:17, ELAPSED TIME = 00:00:15
BMC50794I 103: INDEX MAINTENANCE STATISTICS FOR INDEX LARDBXAB.LARX001A 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 103: Buffer Manager Statistics
BMC50717I 103: DATASET=DEHJCAT.DSNDBC.LARDBXAB.LARX001A.J0001.A002
BMC50718I 103: Page Requests 5 | Page Hits 1
BMC50718I 103: Page Reads 4 | Page Writes 1
BMC50718I 103: Write I/O Requests 1 | New Pages 0
BMC50716I 103: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50786I 103: INDEX APPLY TASK ENDED AT 03/04/2015 16:24:17, ELAPSED TIME = 00:00:20
BMC50794I 106: INDEX MAINTENANCE STATISTICS FOR INDEX LARDBXAB.LARX001B
BMC50791I 106: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 106: RID INSERTS : 0 RID DELETES (PS): 0
BMC50791I 106: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 106: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 106: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50716I 106: Buffer Manager Statistics
BMC50717I 106: DATASET=DEHJCAT.DSNDBC.LARDBXAB.LARX001B.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
BMC50786I 106: INDEX APPLY TASK ENDED AT 03/04/2015 16:24:17, ELAPSED TIME = 00:00:20
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 108: LOG RECORD SPILL TASK ENDED AT 03/04/2015 16:24:17, ELAPSED TIME = 00:00:24
BMC50476I DDNAME = BMCCPY, I/OS = 182, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCCPZ, I/OS = 182, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCY, I/OS = 182, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCZ, I/OS = 182, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50376I 21150 PAGES COPIED TO DATASET = 'ARU.EXMPL12.BMCCPY'
BMC50376I 21150 PAGES COPIED TO DATASET = 'ARU.EXMPL12.BMCCPZ'
BMC50376I 21150 PAGES COPIED TO DATASET = 'ARU.EXMPL12.BMCRCY'
BMC50376I 21150 PAGES COPIED TO DATASET = 'ARU.EXMPL12.BMCRCZ'
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 = 25600K, 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=40592, PAIRS=40592, STORAGE=344K, 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=40120, PAIRS=40120, STORAGE=336K, MEM WAITS=0, WAIT TIME=0
BMC50881I RIDMAP: PART 0002: TRANS=0, ADDS=0, DELS=0, SPILL READS=0, WAIT TIME=0
BMC50880I RIDMAP: PART 0003: ROWS=40120, PAIRS=40120, STORAGE=340K, MEM WAITS=0, WAIT TIME=0
BMC50881I RIDMAP: PART 0003: TRANS=0, ADDS=0, DELS=0, SPILL READS=0, WAIT TIME=0
BMC50880I RIDMAP: SUMMARY: ROWS=120832, PAIRS=120832, STORAGE=1020K, MEM WAITS=0, 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=2044K
BMC50883I RIDMAP: SUMMARY: MAX PIPES=9, PIPES USED=4, 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 03/04/2015 16:24:17, ELAPSED TIME = 00:00:25
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I LOGFINAL PHASE COMPLETE. ELAPSED TIME = 00:00:09
BMC50894I SWITCH PROCESS STARTING AT 3/04/2015 16:24:17
BMC50895I SWITCH PROCESS COMPLETE. ELAPSED TIME = 00:00:00
BMC51297I ALL SPECIFIED LIMIT KEYS HAVE BEEN SUCCESSFULLY ALTERED
BMC51362I LPART PPART CARD ALTER TYPE LIMITKEY
BMC51363I 1 1 42373 DDLIN X'28001231000000000000'
BMC51363I 2 2 47200 DDLIN X'38001231000000000000'
BMC51363I 3 3 31259 DDLIN X'FFFFFFFFFFFFFFFFFFFF'
BMC50890I 1: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A001'...
BMC50890I 6: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A003'...
BMC50890I 2: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A002'...
BMC50890I 4: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A001'...
BMC50890I 5: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A002'...
BMC50890I 3: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A003'...
BMC50890I 7: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARX001B.I0001.A001'...
BMC50891I 6: DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A003' IS DELETED
BMC50891I 1: DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A001' IS DELETED
BMC50891I 4: DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A001' IS DELETED
BMC50891I 5: DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A002' IS DELETED
BMC50891I 2: DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A002' IS DELETED
BMC50891I 7: DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARX001B.I0001.A001' IS DELETED
BMC50891I 3: DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A003' IS DELETED
BMC50501I DB2 OBJECT STATISTICS
BMC50515I TABLESPACE LARDBXAB.LARSXABA PARTS = 3 TABLES = 1 SEGSIZE = 0 DSSIZE = 0G PAGESIZE = 4K
BMC50516I PART NACTIVE CARD EXTENTS DBCARD PCOMP KSAVED PSAVED
BMC50517I 1 7416 42373 10 0 0 0 0
BMC50517I 2 8259 47200 7 0 0 0 0
BMC50517I 3 5469 31259 4 0 0 0 0
BMC50518I TABLE LARDBXAB.LART001
BMC50519I ROWAVG NPAGES CARD PCTPAGES
BMC50520I 441 20132 120832 95
BMC50525I INDEX LARDBXAB.LARX001A
BMC50526I FIRST KEY COLUMN = C009_TIMESTAMP
BMC50527I CLUSTER = Y UNIQUE = U COMPRESS = N PAGESIZE = 4K KEYLEN = 10 COLCOUNT = 1
BMC50528I PART NACTIVE CARD EXTENTS LEVELS
BMC50529I 1 268 42373 1 2
BMC50529I 2 297 47200 3 2
BMC50529I 3 198 31259 4 2
BMC50525I INDEX LARDBXAB.LARX001B
BMC50526I FIRST KEY COLUMN = C001_INTEGER
BMC50527I CLUSTER = N UNIQUE = D COMPRESS = N PAGESIZE = 4K KEYLEN = 5 COLCOUNT = 1
BMC50528I PART NACTIVE CARD EXTENTS LEVELS
BMC50529I 0 442 120832 1 3
BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR REORG UTILITY SUCCESSFUL FOR ALL OBJECTS
BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0
(C) COPYRIGHT 1988 - 2015 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 3/04/2015 16:23:50 ...
BMC50002I UTILITY ID = 'LARCOPB.LARDBXAB'. DB2 SUBSYSTEM ID = 'DEHJ'. OPTION MODULE = 'ARU$OPTS'.
BMC50471I z/OS 2.1.0,PID=HBB7790,DFSMS FOR Z/OS=2.1.0,DB2=11.1.0
BMC50471I REGION=0M,BELOW 16M=8808K,ABOVE 16M=1312192K,IEFUSI=NO,CPUS=3
BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040311M,MEMLIMIT SET BY:REGION=0
BMC50471I REORG PLUS FOR DB2--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I SOLUTION COMMON CODE--V11.01.00
BMC50471I MAINT: BPJ0661 BPJ0667 BPJ0671 BPJ0674 BPJ0675 BPJ0676 BPJ0682 BPJ0686 BPJ0689 BPJ0697 BPJ0700 BPJ0702
BMC50471I BPJ0703 BPJ0706 BPJ0712 BPJ0715 BPJ0729 BPJ0773 BPJ0786 BPJ0794 BPJ0806 BPJ0830 BPJ0833 BPJ0839
BMC50471I BPJ0845 BPJ0866 BPJ0892 BPJ0913 BPJ0914 BPJ0916 BPJ0930 BPJ0944 BPJ0946
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922
BMC50471I BMC STATS API--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.01.00
BMC50471I MAINT: BPE0401 BPE0403 BPE0405 BPE0407 BPE0410 BPE0412 BPE0416 BPE0420 BPE0422 BPE0423 BPE0426 BPE0428
BMC50471I BPE0430 BPE0433 BPE0435 BPE0438 BPE0439
BMC50471I ANALMAX=1000% FSTHRESHOLD=0 ROUTCDE=(11,1)
BMC50471I ARC=NO ICDDN=(BMCICY,BMCICZ) SCPYMAX=8
BMC50471I ARCHDDN=SYSARC ICTYPE=AUTO SDUMP=YES
BMC50471I ARCHFORMAT=BMC IDCACHE=10000 SHORTMEMORY=CONTINUE
BMC50471I AVAILPAGEPCT=100 INDREFLM=10 SIXSNAP=NO
BMC50471I BILDMAX=300% INLINECP=YES SMAX=0
BMC50471I BMCHIST=YES KEEPDICTIONARY=NO SMCORE=(0K,0K)
BMC50471I CBUFFS=30 LEAFDSLM=200 SORTDEVT=(,SYSALLDA)
BMC50471I CONDEXEC=NO LOCKROW=YES SORTNUM=32
BMC50471I COPYDDN=(BMCCPY,BMCCPZ) LOGFINAL=NONE SPILDSNP=&UID
BMC50471I COPYLVL=PART LOGMEM=0 SPILSCLS=NONE
BMC50471I COPYMAX=1000% LOGSPIL=(20000,10000) SPILUNIT=WORK
BMC50471I COPYSUBSET=NO LOGTHRSH=0 SQLDELAY=3
BMC50471I CPYRFAIL=TERM LONGLOG=CONTINUE SQLRETRY=100
BMC50471I DATACAP=NO LONGNAMETRUNC=MIDDLE STAGEDSN=BMC
BMC50471I DDLDDN=DDLIN MAPTEXIT=(NONE,REXX) STOP@CMT=YES
BMC50471I DEADLINE=NONE MAXNEWPARTS=2 STOPDELAY=1
BMC50471I DELAY=1200 MAXRO=300 STOPRETRY=300
BMC50471I DELFILES=YES MAXSORTMEMORY=0 TAPEDISP=DELETE
BMC50471I DESCCDE=(3,7) MAXTAPE=3 TASKMAX=1000%
BMC50471I DRAINTYP=ALL MGEXTENT=CONTINUE TERMEXIT=(NONE,REXX)
BMC50471I DRNDELAY=1 MINSORTMEMORY=0 TIMEOUT=TERM
BMC50471I DRNRETRY=255 MSGLEVEL=1 TOTALPAGEPCT=0
BMC50471I DRNWAIT=NONE OFFPOSLM=10 TSSAMPLEPCT=100
BMC50471I DSNUEXIT=(NONE,ASM) OPNDB2ID=YES UBUFFS=20
BMC50471I DSNUTILB=YES ORIGDISP=DELETE UNLDDN=SYSREC
BMC50471I DSPLOCKS=DRNFAIL PREFORMAT=NO UNLDMAX=300%
BMC50471I DSRSEXIT=(NONE,REXX) RCVICDDN=(BMCIRY,BMCIRZ) UNLOAD=RELOAD
BMC50471I EXCLDUMP=(X37,X22,X06) RCVYDDN=(BMCRCY,BMCRCZ) UXSTATE=SUP
BMC50471I FASTSWITCH=NO REDEFINE=YES WBUFFS=(20,10)
BMC50471I FILECHK=WARN RENMMAX=30 WORKDDN=SYSUT1
BMC50471I FORCE_AT=(START,3) RIDMDSSZ=2097152 WORKUNIT=SYSALLDA
BMC50471I FORCE_RPT=NO RIDMMAXD=1 XBMID=
BMC50471I FORCE=NONE RMAPMEM=0 ZIIP=ENABLED
BMC50471I FSFALLBACK=NO RORGMAX=300%
BMC50471I PLAN=ARUQA
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
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
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
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
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
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
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
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
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
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 = 1110
BMC50471I SUBSYSTEM DEFAULT = DEHJ
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)
BMC50028I DB2 MODE = NFM
BMC50471I BMCUTIL ='BMCUTIL.CMN_BMCUTIL'
BMC50471I BMCSYNC ='BMCUTIL.CMN_BMCSYNC'
BMC50471I BMCHIST ='BMCUTIL.CMN_BMCHIST'
BMC50471I BMCDICT ='BMCUTIL.CMN_BMCDICT'
BMC50471I BMCXCOPY='BMCUTIL.CMN_BMCXCOPY'
BMC50471I DASD MANAGER PLUS TABLES:
BMC50102I REORG TABLESPACE LARDBXAB.LARSXABA
BMC50102I SHRLEVEL CHANGE
BMC50102I UNLOAD CONTINUE
BMC50102I XBMID XBMB
BMC50102I FASTSWITCH YES
BMC50102I COPY YES
BMC50102I ORDER YES
BMC50102I DEADLINE 2015-03-05-19.30.00.00
BMC50102I MAXRO 600
BMC50102I DELAY 300
BMC50102I LOGSPILL (1024,1024)
BMC50102I SPILLDSNPAT 'ARU.LARWORK.DEHJ'
BMC50102I SPILLUNIT NONE
BMC50102I SPILLSTORCLAS COPYCLAS
BMC50102I ANALYZE
BMC50102I DDTYPE UNLOAD UNIT (WORK) SIZEPCT (150,150)
BMC50102I DSNPAT 'ARU.EXMPL12.&DB.&TSIX.&DDNAME'
BMC50102I DDTYPE WORK UNIT (WORK) SIZEPCT (150,150)
BMC50102I DSNPAT 'ARU.EXMPL12.&DB.&TSIX.&DDNAME'
BMC50102I DDTYPE LOCPFCPY ACTIVE NO
BMC50109I 'FASTSWITCH=YES' OPTION SPECIFIED. OPTION 'STAGEDSN=BMC' IGNORED
BMC51291I A DDLIN DATASET HAS BEEN FOUND AND CONTAINS THE FOLLOWING STATEMENTS:
BMC50102I ALTER INDEX LARDBXAB.LARX001A
BMC50102I PART 1 VALUES ('2800-12-31-00.00.00.000000'),
BMC50102I PART 2 VALUES ('3800-12-31-00.00.00.000000'),
BMC50102I PART 3 VALUES ('4500-12-31-00.00.00.000000');
BMC51232I ALTER STATEMENT 1 WILL BE PROCESSED
BMC51293I 1 ALTER STATEMENT(S) WILL BE PROCESSED FROM THE DDLIN FILE
BMC50004I UTILINIT PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50244I PROCESSING PAGESET DBID(3473) PSID(2) PART(1) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00000000 FOR DBID(3473) PSID(2)
BMC51301I 3: SAMPLING STATISTICS: PART=1,TP=7103,SP=113,SR=654,AVGR=441,SD=65,SE=1,AVGF=578,SD=65,SE=10,EP=4
BMC50244I PROCESSING PAGESET DBID(3473) PSID(2) PART(2) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00100000 FOR DBID(3473) PSID(2)
BMC51301I 2: SAMPLING STATISTICS: PART=2,TP=7021,SP=112,SR=654,AVGR=441,SD=65,SE=0,AVGF=583,SD=65,SE=9,EP=3
BMC50244I PROCESSING PAGESET DBID(3473) PSID(2) PART(3) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00200000 FOR DBID(3473) PSID(2)
BMC51301I 1: SAMPLING STATISTICS: PART=3,TP=7020,SP=112,SR=660,AVGR=440,SD=65,SE=1,AVGF=589,SD=65,SE=7,EP=2
BMC51265I ESTIMATED CARDINALITY OF SPACE = 123299 AVG SORTWK ROW LENGTH = 441 AVG UNLOAD ROW LENGTH = 441
BMC50484I ESTIMATED CARDINALITY OF PART 0001 = 41043 AVG SORTWK ROW LENGTH = 441 AVG UNLOAD ROW LENGTH = 441
BMC50484I ESTIMATED CARDINALITY OF PART 0002 = 40920 AVG SORTWK ROW LENGTH = 441 AVG UNLOAD ROW LENGTH = 441
BMC50484I ESTIMATED CARDINALITY OF PART 0003 = 41336 AVG SORTWK ROW LENGTH = 440 AVG UNLOAD ROW LENGTH = 440
BMC51264I UNLOAD WILL READ 21138 DATA PAGES FROM SPACE 'LARDBXAB.LARSXABA'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I ANALYZE PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50425I &JOBNAME = CXBREXMC &STEPNAME = LARREORG &DB = LARDBXAB &TSIX = LARSXABA &RTYPE = TS
BMC50425I &UID = RDACXB2 &DATE = 030415 &TIME = 162350 &SSID = DEHJ &UTIL = LARCOPB.
BMC50425I &UTILPFX = LARCOPB &UTILSFX = LARDBXAB &DATE8 = 03042015 &GRPNM = DEHJ &VCAT = DEHJCAT
BMC50425I &TIME4 = 1623 &DATEJ = 2015063 &JDATE = 15063
BMC50702I LOG PROCESSING STARTED AT 03/04/2015 16:23:51
BMC50773I 101: LOG SCAN TASK STARTED AT 03/04/2015 16:23:51
BMC50706I MONITOR TRACE CLASS(1) STARTED, TRACE NUMBER = 05
BMC50877I POINT OF CONSISTENCY ESTABLISHED AT RBA/LRSN = 0000000004C272360000
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 SYSREC01 ARU.EXMPL12.LARDBXAB.LARSXABA.SYSREC01 *WORK 27056 6765 502 126 TRK
BMC50448I SYSREC02 ARU.EXMPL12.LARDBXAB.LARSXABA.SYSREC02 *WORK 26975 6744 500 125 TRK
BMC50448I SYSREC03 ARU.EXMPL12.LARDBXAB.LARSXABA.SYSREC03 *WORK 27188 6798 504 126 TRK
BMC50448I SYSUT1 ARU.EXMPL12.LARDBXAB.LARSXABA.SYSUT1 *WORK 1989 200 37 4 TRK
BMC50394I UNABLE TO LOCATE SORT WORK DATASETS, DDNAME = 'SORTWKNN'
BMC50474I BELOW 16M = 8292K, ABOVE 16M = 1299332K, CPUS = 3
BMC50479I TOTAL PAGES: 4136263, ALLOWED: 0; AVAILABLE PAGES: 809841, ALLOWED: 809841
BMC50719I 1 LOG APPLY TASKS, 4 INDEX APPLY TASKS, AVAILABLE MEMORY: 1154082K
BMC50887I RIDMAP: RIDMAPMEM CHANGED TO 2097152K
BMC50864I LOGMEM OF 0K SPECIFIED, CHANGED TO 25600K
BMC51302I MAX TASKS = 1, MAX PARTITIONS PER TASK = 3, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 3
BMC50773I 107: LOG RECORD SORT TASK STARTED AT 03/04/2015 16:23:53
BMC50773I 108: LOG RECORD SPILL TASK STARTED AT 03/04/2015 16:23:53
BMC50773I 109: INLINE IMAGE COPY APPEND TASK STARTED AT 03/04/2015 16:23:53
BMC50847I 109: BUFFER ALLOCATIONS: CHANGED PAGE BUFFERS = 0, I/O BUFFERS = 200,LARGEST BLOCK SIZE = 4096
BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1852K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50477I 1: PARTITION = 1, ROWS/KEYS = 40592, I/O WAITS = 2 ,DDNAME = SYS00006
BMC50477I 1: PARTITION = 2, ROWS/KEYS = 40120, I/O WAITS = 4 ,DDNAME = SYS00007
BMC50477I 1: PARTITION = 3, ROWS/KEYS = 40120, I/O WAITS = 12 ,DDNAME = SYS00008
BMC50481I 1: SORT COMPLETE. ELAPSED TIME = 00:00:01
BMC50481I 1: UNLOAD TASK COMPLETE. ELAPSED TIME = 00:00:01
BMC50476I DDNAME = SYSREC01, I/OS = 61, I/O WAITS = 33, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC02, I/OS = 68, I/O WAITS = 11, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC03, I/OS = 46, I/O WAITS = 6, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSUT1, I/OS = 6, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC51271I UNLOAD STATISTICS: 42373 ROWS/KEYS UNLOADED FROM PARTITION 1
BMC51281I UNLOAD STATISTICS: X'00000000000000000000' IS THE HIGHEST LOGRBA FOR PARTITION 1
BMC51286I RELOADING OF DATASET 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A001' WILL REQUIRE 7415 PAGES
BMC51290I RELOADING OF DATASET 'DEHJCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A001' WILL REQUIRE 268 PAGES (APPROX.)
BMC51271I UNLOAD STATISTICS: 47200 ROWS/KEYS UNLOADED FROM PARTITION 2
BMC51281I UNLOAD STATISTICS: X'00000000000000000000' IS THE HIGHEST LOGRBA FOR PARTITION 2
BMC51286I RELOADING OF DATASET 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A002' WILL REQUIRE 8258 PAGES
BMC51290I RELOADING OF DATASET 'DEHJCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A002' WILL REQUIRE 298 PAGES (APPROX.)
BMC51271I UNLOAD STATISTICS: 31259 ROWS/KEYS UNLOADED FROM PARTITION 3
BMC51281I UNLOAD STATISTICS: X'00000000000000000000' IS THE HIGHEST LOGRBA FOR PARTITION 3
BMC51286I RELOADING OF DATASET 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A003' WILL REQUIRE 5468 PAGES
BMC51290I RELOADING OF DATASET 'DEHJCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A003' WILL REQUIRE 196 PAGES (APPROX.)
BMC51288I RELOADING OF DATASET 'DEHJCAT.DSNDBD.LARDBXAB.LARX001B.J0001.A001' MAY REQUIRE 621 PAGES
BMC51272I UNLOAD STATISTICS: 120832 ROWS UNLOADED FROM SPACE 'LARDBXAB.LARSXABA', 0 ROWS DISCARDED, 0 ROWS UPDATED
BMC51282I UNLOAD STATISTICS: X'00000000000000000000' IS THE HIGHEST LOGRBA FOR SPACE 'LARDBXAB.LARSXABA'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I UNLOAD PHASE COMPLETE. ELAPSED TIME = 00:00:03
BMC50277I XBM STATISTICS: DSN='DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.I0001.A001 ', READS 7103, HITS 0, WRITES 0, CACHE 0
BMC50277I XBM STATISTICS: DSN='DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.I0001.A002 ', READS 7021, HITS 0, WRITES 0, CACHE 0
BMC50277I XBM STATISTICS: DSN='DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.I0001.A003 ', READS 7020, HITS 0, WRITES 0, CACHE 0
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8224K, ABOVE 16M = 1296920K, CPUS = 3
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A002'
BMC50479I TOTAL PAGES: 4111891, ALLOWED: 0; AVAILABLE PAGES: 808786, ALLOWED: 808786
BMC51303I MAX TASKS = 1, INDEXES PER TASK = 1, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 1
BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50476I DDNAME = SYSUT1, I/OS = 4, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50481I 1: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50482I 0: BUILD COMPLETE. ELAPSED TIME = 00:00:01 DSN = 'DEHJCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A002'
BMC50477I 0: PARTITION = 2, ROWS/KEYS = 47200, I/O WAITS = 5 ,DDNAME = SYS00016
BMC50482I 0: RELOAD COMPLETE. ELAPSED TIME = 00:00:01 DSN = 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A002'
BMC50477I 0: PARTITION = 2, ROWS/KEYS = 47200, I/O WAITS = 18 ,DDNAME = SYS00012
BMC51274I RELOAD STATISTICS: 47200 ROWS/KEYS LOADED INTO PARTITION 2
BMC50773I 103: INDEX APPLY TASK STARTED AT 03/04/2015 16:23:57
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.LARDBXAB.LARX001B.J0001.A001'
BMC50477I 1: PARTITION = 0, ROWS/KEYS = 120832, I/O WAITS = 5 ,DDNAME = SYS00020
BMC50773I 106: INDEX APPLY TASK STARTED AT 03/04/2015 16:23:57
BMC51276I BUILD STATISTICS: 120832 KEYS LOADED INTO INDEX 'LARDBXAB.LARX001B'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A001'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A003'
BMC50476I DDNAME = SYSREC02, I/OS = 64, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50482I 0: BUILD COMPLETE. ELAPSED TIME = 00:00:04 DSN = 'DEHJCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A001'
BMC50477I 0: PARTITION = 1, ROWS/KEYS = 42373, I/O WAITS = 5 ,DDNAME = SYS00028
BMC50482I 0: RELOAD COMPLETE. ELAPSED TIME = 00:00:04 DSN = 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A001'
BMC50477I 0: PARTITION = 1, ROWS/KEYS = 42373, I/O WAITS = 12 ,DDNAME = SYS00024
BMC51274I RELOAD STATISTICS: 42373 ROWS/KEYS LOADED INTO PARTITION 1
BMC50773I 104: INDEX APPLY TASK STARTED AT 03/04/2015 16:24:01
BMC50476I DDNAME = SYSREC01, I/OS = 57, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50482I 0: BUILD COMPLETE. ELAPSED TIME = 00:00:02 DSN = 'DEHJCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A003'
BMC50477I 0: PARTITION = 3, ROWS/KEYS = 31259, I/O WAITS = 5 ,DDNAME = SYS00037
BMC50482I 0: RELOAD COMPLETE. ELAPSED TIME = 00:00:03 DSN = 'DEHJCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A003'
BMC50477I 0: PARTITION = 3, ROWS/KEYS = 31259, I/O WAITS = 8 ,DDNAME = SYS00033
BMC51274I RELOAD STATISTICS: 31259 ROWS/KEYS LOADED INTO PARTITION 3
BMC50773I 105: INDEX APPLY TASK STARTED AT 03/04/2015 16:24:02
BMC50476I DDNAME = SYSREC03, I/OS = 42, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC51276I BUILD STATISTICS: 120832 KEYS LOADED INTO INDEX 'LARDBXAB.LARX001A'
BMC51275I RELOAD STATISTICS: 120832 ROWS LOADED INTO SPACE 'LARDBXAB.LARSXABA'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC03', DSNAME = 'ARU.EXMPL12.LARDBXAB.LARSXABA.SYSREC03'
BMC50773I 102: LOG APPLY TASK STARTED AT 03/04/2015 16:24:02
BMC50829I LOGAPPLY PHASE STARTING AT 03/04/2015 16:24:02
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC01', DSNAME = 'ARU.EXMPL12.LARDBXAB.LARSXABA.SYSREC01'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC02', DSNAME = 'ARU.EXMPL12.LARDBXAB.LARSXABA.SYSREC02'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT1 ', DSNAME = 'ARU.EXMPL12.LARDBXAB.LARSXABA.SYSUT1'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I RELOAD PHASE COMPLETE. ELAPSED TIME = 00:00:06
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50877I POINT OF CONSISTENCY ESTABLISHED AT RBA/LRSN = 0000000004C27248C000
BMC50778I LOG RECORD QUEUE SIZE AT OR BELOW THRESHOLD
BMC50004I LOGAPPLY PHASE COMPLETE. ELAPSED TIME = 00:00:06
BMC50830I LOGFINAL PHASE STARTING AT 03/04/2015 16:24:08
BMC50709I MONITOR TRACE CLASS(1) TRACE NUMBER = 05 STOPPED
BMC50786I 101: LOG SCAN TASK ENDED AT 03/04/2015 16:24:08, ELAPSED TIME = 00:00:16
BMC50720I 102: 0 NEW LOG APPLY BUFFERS, 0 REUSED, 16637 INITIAL MAXIMUM, 0 WAITS, BUFFER SIZE=8380
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 LARDBXAB.LARSXABA
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=DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.J0001.A001
BMC50717I 102: DATASET=DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.J0001.A002
BMC50717I 102: DATASET=DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.J0001.A003
BMC50718I 102: Page Requests 6 | Page Hits 0
BMC50718I 102: Page Reads 6 | 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 03/04/2015 16:24:12, ELAPSED TIME = 00:00:10
BMC50786I 107: LOG RECORD SORT TASK ENDED AT 03/04/2015 16:24:12, ELAPSED TIME = 00:00:19
BMC50786I 109: INLINE IMAGE COPY APPEND TASK ENDED AT 03/04/2015 16:24:12, ELAPSED TIME = 00:00:19
BMC50794I 104: INDEX MAINTENANCE STATISTICS FOR INDEX LARDBXAB.LARX001A DSNUM 1
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 104: Buffer Manager Statistics
BMC50717I 104: DATASET=DEHJCAT.DSNDBC.LARDBXAB.LARX001A.J0001.A001
BMC50718I 104: Page Requests 5 | Page Hits 1
BMC50718I 104: Page Reads 4 | Page Writes 1
BMC50718I 104: Write I/O Requests 1 | New Pages 0
BMC50716I 104: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50786I 104: INDEX APPLY TASK ENDED AT 03/04/2015 16:24:16, ELAPSED TIME = 00:00:15
BMC50794I 105: INDEX MAINTENANCE STATISTICS FOR INDEX LARDBXAB.LARX001A 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 105: Buffer Manager Statistics
BMC50717I 105: DATASET=DEHJCAT.DSNDBC.LARDBXAB.LARX001A.J0001.A003
BMC50718I 105: Page Requests 5 | Page Hits 1
BMC50718I 105: Page Reads 4 | Page Writes 1
BMC50718I 105: Write I/O Requests 1 | New Pages 0
BMC50716I 105: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50786I 105: INDEX APPLY TASK ENDED AT 03/04/2015 16:24:17, ELAPSED TIME = 00:00:15
BMC50794I 103: INDEX MAINTENANCE STATISTICS FOR INDEX LARDBXAB.LARX001A 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 103: Buffer Manager Statistics
BMC50717I 103: DATASET=DEHJCAT.DSNDBC.LARDBXAB.LARX001A.J0001.A002
BMC50718I 103: Page Requests 5 | Page Hits 1
BMC50718I 103: Page Reads 4 | Page Writes 1
BMC50718I 103: Write I/O Requests 1 | New Pages 0
BMC50716I 103: Write I/O time 0:00:00 | Read I/O time 0:00:00
BMC50786I 103: INDEX APPLY TASK ENDED AT 03/04/2015 16:24:17, ELAPSED TIME = 00:00:20
BMC50794I 106: INDEX MAINTENANCE STATISTICS FOR INDEX LARDBXAB.LARX001B
BMC50791I 106: PAGE READS : 2 KEY INSERTS : 0
BMC50791I 106: RID INSERTS : 0 RID DELETES (PS): 0
BMC50791I 106: ROOT SPLITS : 0 NON-LEAF SPLITS : 0
BMC50791I 106: LEAF SPLITS : 0 PAGE FREES : 0
BMC50791I 106: NEW PAGES : 0 BUFF PAGE READS : 0
BMC50716I 106: Buffer Manager Statistics
BMC50717I 106: DATASET=DEHJCAT.DSNDBC.LARDBXAB.LARX001B.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
BMC50786I 106: INDEX APPLY TASK ENDED AT 03/04/2015 16:24:17, ELAPSED TIME = 00:00:20
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 108: LOG RECORD SPILL TASK ENDED AT 03/04/2015 16:24:17, ELAPSED TIME = 00:00:24
BMC50476I DDNAME = BMCCPY, I/OS = 182, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCCPZ, I/OS = 182, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCY, I/OS = 182, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCZ, I/OS = 182, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50376I 21150 PAGES COPIED TO DATASET = 'ARU.EXMPL12.BMCCPY'
BMC50376I 21150 PAGES COPIED TO DATASET = 'ARU.EXMPL12.BMCCPZ'
BMC50376I 21150 PAGES COPIED TO DATASET = 'ARU.EXMPL12.BMCRCY'
BMC50376I 21150 PAGES COPIED TO DATASET = 'ARU.EXMPL12.BMCRCZ'
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 = 25600K, 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=40592, PAIRS=40592, STORAGE=344K, 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=40120, PAIRS=40120, STORAGE=336K, MEM WAITS=0, WAIT TIME=0
BMC50881I RIDMAP: PART 0002: TRANS=0, ADDS=0, DELS=0, SPILL READS=0, WAIT TIME=0
BMC50880I RIDMAP: PART 0003: ROWS=40120, PAIRS=40120, STORAGE=340K, MEM WAITS=0, WAIT TIME=0
BMC50881I RIDMAP: PART 0003: TRANS=0, ADDS=0, DELS=0, SPILL READS=0, WAIT TIME=0
BMC50880I RIDMAP: SUMMARY: ROWS=120832, PAIRS=120832, STORAGE=1020K, MEM WAITS=0, 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=2044K
BMC50883I RIDMAP: SUMMARY: MAX PIPES=9, PIPES USED=4, 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 03/04/2015 16:24:17, ELAPSED TIME = 00:00:25
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I LOGFINAL PHASE COMPLETE. ELAPSED TIME = 00:00:09
BMC50894I SWITCH PROCESS STARTING AT 3/04/2015 16:24:17
BMC50895I SWITCH PROCESS COMPLETE. ELAPSED TIME = 00:00:00
BMC51297I ALL SPECIFIED LIMIT KEYS HAVE BEEN SUCCESSFULLY ALTERED
BMC51362I LPART PPART CARD ALTER TYPE LIMITKEY
BMC51363I 1 1 42373 DDLIN X'28001231000000000000'
BMC51363I 2 2 47200 DDLIN X'38001231000000000000'
BMC51363I 3 3 31259 DDLIN X'FFFFFFFFFFFFFFFFFFFF'
BMC50890I 1: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A001'...
BMC50890I 6: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A003'...
BMC50890I 2: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A002'...
BMC50890I 4: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A001'...
BMC50890I 5: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A002'...
BMC50890I 3: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A003'...
BMC50890I 7: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARX001B.I0001.A001'...
BMC50891I 6: DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A003' IS DELETED
BMC50891I 1: DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A001' IS DELETED
BMC50891I 4: DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A001' IS DELETED
BMC50891I 5: DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A002' IS DELETED
BMC50891I 2: DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A002' IS DELETED
BMC50891I 7: DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARX001B.I0001.A001' IS DELETED
BMC50891I 3: DATASET 'DEHJCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A003' IS DELETED
BMC50501I DB2 OBJECT STATISTICS
BMC50515I TABLESPACE LARDBXAB.LARSXABA PARTS = 3 TABLES = 1 SEGSIZE = 0 DSSIZE = 0G PAGESIZE = 4K
BMC50516I PART NACTIVE CARD EXTENTS DBCARD PCOMP KSAVED PSAVED
BMC50517I 1 7416 42373 10 0 0 0 0
BMC50517I 2 8259 47200 7 0 0 0 0
BMC50517I 3 5469 31259 4 0 0 0 0
BMC50518I TABLE LARDBXAB.LART001
BMC50519I ROWAVG NPAGES CARD PCTPAGES
BMC50520I 441 20132 120832 95
BMC50525I INDEX LARDBXAB.LARX001A
BMC50526I FIRST KEY COLUMN = C009_TIMESTAMP
BMC50527I CLUSTER = Y UNIQUE = U COMPRESS = N PAGESIZE = 4K KEYLEN = 10 COLCOUNT = 1
BMC50528I PART NACTIVE CARD EXTENTS LEVELS
BMC50529I 1 268 42373 1 2
BMC50529I 2 297 47200 3 2
BMC50529I 3 198 31259 4 2
BMC50525I INDEX LARDBXAB.LARX001B
BMC50526I FIRST KEY COLUMN = C001_INTEGER
BMC50527I CLUSTER = N UNIQUE = D COMPRESS = N PAGESIZE = 4K KEYLEN = 5 COLCOUNT = 1
BMC50528I PART NACTIVE CARD EXTENTS LEVELS
BMC50529I 0 442 120832 1 3
BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR REORG UTILITY SUCCESSFUL FOR ALL OBJECTS
BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*