Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see REORG PLUS for DB2 13.1.

Example 15: Materializing pending definition changes

In this example, REORG PLUS performs a SHRLEVEL CHANGE reorganization of a partitioned table space that has a pending buffer pool ALTER. During the reorganization, REORG PLUS materializes the pending definition change.

Message 50138I shows which options have been changed because pending definition changes exist on the table space.

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 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 15:

//               JOB
//*******************************************************************
//*  PARTITIONED TABLE SPACE (UTS)                                  *
//*  WITH PENDING DDL - ALTER BUFFERPOOL ISSUED PRIOR TO REORG      *
//*******************************************************************
//LARREORG EXEC PGM=ARUUMAIN,REGION=0M,COND=(7,LT),
// PARM='<db2ssid>,EXM15B.RG1,NEW,,MSGLEVEL(1),ARU$OPTS'
//STEPLIB   DD  DISP=SHR,DSN=<productLibraries>
//          DD  DISP=SHR,DB2.DSNEXIT
//          DD  DISP=SHR,DB2.DSNLOAD
//SYSPRINT  DD  SYSOUT=*
//SYSOUT    DD  SYSOUT=*
//UTPRINT   DD  SYSOUT=*
//SYSMDUMP  DD DSN=ARU.LARWORK.DEHJ.EXM15B.LARSA1BA.SYSMDUMP,
//  DISP=(,CATLG),
//  SPACE=(CYL,(1,100),RLSE),UNIT=WORK,FREE=CLOSE
//SYSERR    DD DSN=ARU.LARWORK.DEHJ.EXM15B.LARSA1BA.SYSERR,
//  DISP=(,CATLG),
//  SPACE=(CYL,(1,100),RLSE),UNIT=WORK,FREE=CLOSE
//*
//SYSIN     DD *
REORG TABLESPACE EXM15B.LARSA1BA
  XBMID XBMB SHRLEVEL CHANGE
  COPY YES
  ORDER YES
  ANALYZE SAMPLE
  FASTSWITCH YES
  DDTYPE UNLOAD
    UNIT (WORK)
    DSNPAT 'ARU.LARREORG.DEHJ.&DB.&TSIX.&DDNAME'
  DDTYPE WORK
    UNIT (WORK)
    DSNPAT 'ARU.LARREORG.DEHJ.&DB.&TSIX.&DDNAME'
  DDTYPE LOCPFCPY
    UNIT (WORK)
    DSNPAT 'ARU.LARREORG.DEHJ.&DB.&TSIX.&DDNAME'

/*

SYSPRINT for example 15

The following figure shows the SYSPRINT for example 15.

Note

To reduce the length of the output in this book, the figure shows one set of statistics for each object type. Ellipses (...) at the beginning of the line indicate the omitted statistics sections.

                                *****  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/30/2015   10:59:55 ...
 BMC50002I UTILITY ID = 'EXM15B.RG1'.  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=8820K,ABOVE 16M=1310388K,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  BPJ0996
 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  BPE0440

 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 (-05: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 EXM15B.LARSA1BA
 BMC50102I   XBMID XBMB SHRLEVEL CHANGE
 BMC50102I   COPY YES
 BMC50102I   ORDER YES
 BMC50102I   ANALYZE SAMPLE
 BMC50102I   FASTSWITCH YES
 BMC50102I   DDTYPE UNLOAD
 BMC50102I     UNIT (WORK)
 BMC50102I     DSNPAT 'ARU.LARREORG.DEHJ.&DB.&TSIX.&DDNAME'
 BMC50102I   DDTYPE WORK
 BMC50102I     UNIT (WORK)
 BMC50102I     DSNPAT 'ARU.LARREORG.DEHJ.&DB.&TSIX.&DDNAME'
 BMC50102I   DDTYPE LOCPFCPY
 BMC50102I     UNIT (WORK)
 BMC50102I     DSNPAT 'ARU.LARREORG.DEHJ.&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

 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50244I PROCESSING PAGESET DBID(1674) PSID(2) PART(1) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00000000 FOR DBID(1674) PSID(2)
 BMC51301I 3: SAMPLING STATISTICS: PART=1,TP=145,SP=70,SR=132,AVGR=441,SD=65,SE=1,AVGF=188,SD=65,SE=35,EP=49
 BMC50244I PROCESSING PAGESET DBID(1674) PSID(2) PART(2) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00100000 FOR DBID(1674) PSID(2)
 BMC51301I 2: SAMPLING STATISTICS: PART=2,TP=61,SP=59,SR=32,AVGR=434,SD=65,SE=5,AVGF=54,SD=65,SE=21,EP=53
 BMC50244I PROCESSING PAGESET DBID(1674) PSID(2) PART(3) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00200000 FOR DBID(1674) PSID(2)
 BMC51301I 1: SAMPLING STATISTICS: PART=3,TP=283,SP=84,SR=507,AVGR=441,SD=65,SE=1,AVGF=603,SD=65,SE=92,EP=50
 BMC51301I 1: SAMPLING STATISTICS: PART=3,TP=283,SP=167,SR=984,AVGR=441,SD=65,SE=0,AVGF=589,SD=65,SE=64,EP=98
 BMC51301I 1: SAMPLING STATISTICS: PART=3,TP=283,SP=249,SR=1504,AVGR=441,SD=65,SE=0,AVGF=604,SD=65,SE=53,EP=146
 BMC51265I ESTIMATED CARDINALITY OF SPACE = 1997  AVG SORTWK ROW LENGTH = 441  AVG UNLOAD ROW LENGTH = 441
 BMC50484I ESTIMATED CARDINALITY OF PART 0001 = 268  AVG SORTWK ROW LENGTH = 441  AVG UNLOAD ROW LENGTH = 441
 BMC50484I ESTIMATED CARDINALITY OF PART 0002 = 32  AVG SORTWK ROW LENGTH = 434  AVG UNLOAD ROW LENGTH = 434
 BMC50484I ESTIMATED CARDINALITY OF PART 0003 = 1697  AVG SORTWK ROW LENGTH = 441  AVG UNLOAD ROW LENGTH = 441
 BMC51264I UNLOAD WILL READ 483 DATA PAGES FROM SPACE 'EXM15B.LARSA1BA'
 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  = CXBHJEDA  &STEPNAME = LARREORG  &DB       = EXM15B    &TSIX     = LARSA1BA  &RTYPE    = TS
 BMC50425I &UID      = RDACXB2   &DATE     = 033015    &TIME     = 105955    &SSID     = DEHJ      &UTIL     = EXM15B.R
 BMC50425I &UTILPFX  = EXM15B    &UTILSFX  = RG1       &DATE8    = 03302015  &GRPNM    = DEHJ      &VCAT     = DEHJCAT
 BMC50425I &TIME4    = 1059      &DATEJ    = 2015089   &JDATE    = 15089

 BMC50702I LOG PROCESSING STARTED AT 03/30/2015 10:59:56
 BMC50773I 101: LOG SCAN TASK STARTED AT 03/30/2015 10:59:56
 BMC50706I MONITOR TRACE CLASS(1) STARTED, TRACE NUMBER = 05
 BMC50877I POINT OF CONSISTENCY ESTABLISHED AT RBA/LRSN = 000000000526C4846000
 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.LARREORG.DEHJ.EXM15B.LARSA1BA.BMCCPY01  *WORK                            580       58       13         2  TRK
 BMC50448I BMCCPY02 ARU.LARREORG.DEHJ.EXM15B.LARSA1BA.BMCCPY02  *WORK                            392       39        9         1  TRK
 BMC50448I BMCCPY03 ARU.LARREORG.DEHJ.EXM15B.LARSA1BA.BMCCPY03  *WORK                           1132      113       24         3  TRK
 BMC50448I SYSUT101 ARU.LARREORG.DEHJ.EXM15B.LARSA1BA.SYSUT101  *WORK                            902       91       17         2  TRK
 BMC50448I SYSUT102 ARU.LARREORG.DEHJ.EXM15B.LARSA1BA.SYSUT102  *WORK                             24        3        1         1  TRK

 BMC50394I UNABLE TO LOCATE SORT WORK DATASETS, DDNAME = 'SORTWKNN'
 BMC50474I BELOW 16M = 8048K, ABOVE 16M = 1295504K, CPUS = 3
 BMC50479I TOTAL PAGES: 3847996, ALLOWED: 0; AVAILABLE PAGES: 261710, ALLOWED: 261710
 BMC50719I 3 LOG APPLY TASKS, 4 INDEX APPLY TASKS, AVAILABLE MEMORY: 1137297K
 BMC50887I RIDMAP: RIDMAPMEM CHANGED TO 2097152K
 BMC50864I LOGMEM OF 0K SPECIFIED, CHANGED TO 27136K
 BMC51302I MAX TASKS = 3, MAX PARTITIONS PER TASK = 1, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 1
 BMC50773I 109: LOG RECORD SORT TASK STARTED AT 03/30/2015 10:59:58
 BMC50773I 110: LOG RECORD SPILL TASK STARTED AT 03/30/2015 10:59:58
 BMC50773I 111: INLINE IMAGE COPY APPEND TASK STARTED AT 03/30/2015 10:59:58
 BMC50847I 111: BUFFER ALLOCATIONS: CHANGED PAGE BUFFERS = 0, I/O BUFFERS = 600,LARGEST BLOCK SIZE = 8192
 BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 3: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 2: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50477I 1: PARTITION =    1, ROWS/KEYS = 312, I/O WAITS = 1 ,DDNAME = SYS00015
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE EXM15B.LARSA1BA PARTITION 1
 BMC51271I UNLOAD STATISTICS:  312 ROWS/KEYS UNLOADED FROM PARTITION 1
 BMC51281I UNLOAD STATISTICS:  X'00000000000000000000' IS THE HIGHEST LOGRBA FOR PARTITION 1
 BMC50477I 2: PARTITION =    2, ROWS/KEYS = 32, I/O WAITS = 1 ,DDNAME = SYS00017
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE EXM15B.LARSA1BA PARTITION 2
 BMC51271I UNLOAD STATISTICS:  32 ROWS/KEYS UNLOADED FROM PARTITION 2
 BMC51281I UNLOAD STATISTICS:  X'00000000000000000000' IS THE HIGHEST LOGRBA FOR PARTITION 2
 BMC50481I 1: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 2: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50477I 3: PARTITION =    3, ROWS/KEYS = 1704, I/O WAITS = 1 ,DDNAME = SYS00016
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE EXM15B.LARSA1BA PARTITION 3
 BMC51271I UNLOAD STATISTICS:  1704 ROWS/KEYS UNLOADED FROM PARTITION 3
 BMC51281I UNLOAD STATISTICS:  X'00000000000000000000' IS THE HIGHEST LOGRBA FOR PARTITION 3
 BMC51272I UNLOAD STATISTICS:  2048 ROWS UNLOADED FROM SPACE 'EXM15B.LARSA1BA', 0 ROWS DISCARDED, 0 ROWS UPDATED
 BMC51282I UNLOAD STATISTICS:  X'00000000000000000000' IS THE HIGHEST LOGRBA FOR SPACE 'EXM15B.LARSA1BA'
 BMC50481I 3: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.EXM15B.LARSA1BA.J0001.A002'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.EXM15B.LARSA1BA.J0001.A001'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.EXM15B.LARSA1BA.J0001.A003'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.EXM15B.LARSA1BA.J0001.A002'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.EXM15B.LARSA1BA.J0001.A001'
 BMC50482I 2: BUILD COMPLETE.  ELAPSED TIME = 00:00:07  DSN = 'DEHJCAT.DSNDBD.EXM15B.LARXPC1A.J0001.A002'
 BMC50477I 2: PARTITION =    2, ROWS/KEYS = 32, I/O WAITS = 5 ,DDNAME = SYS00025
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:07  DSN = 'DEHJCAT.DSNDBD.EXM15B.LARXPC1A.J0001.A001'
 BMC50477I 1: PARTITION =    1, ROWS/KEYS = 312, I/O WAITS = 5 ,DDNAME = SYS00026
 BMC50482I 2: RELOAD COMPLETE.  ELAPSED TIME = 00:00:07  DSN = 'DEHJCAT.DSNDBD.EXM15B.LARSA1BA.J0001.A002'
 BMC50477I 2: PARTITION =    2, ROWS/KEYS = 32, I/O WAITS = 5 ,DDNAME = SYS00021
 BMC51274I RELOAD STATISTICS:  32 ROWS/KEYS LOADED INTO PARTITION 2
 BMC50482I 1: RELOAD COMPLETE.  ELAPSED TIME = 00:00:07  DSN = 'DEHJCAT.DSNDBD.EXM15B.LARSA1BA.J0001.A001'
 BMC50477I 1: PARTITION =    1, ROWS/KEYS = 312, I/O WAITS = 5 ,DDNAME = SYS00020
 BMC51274I RELOAD STATISTICS:  312 ROWS/KEYS LOADED INTO PARTITION 1
 BMC50773I 105: INDEX APPLY TASK STARTED AT 03/30/2015 11:00:07
 BMC50773I 102: LOG APPLY TASK STARTED AT 03/30/2015 11:00:08
 BMC50481I 2: REORG TASK COMPLETE.  ELAPSED TIME = 00:00:09
 BMC50773I 103: LOG APPLY TASK STARTED AT 03/30/2015 11:00:08
 BMC50481I 1: REORG TASK COMPLETE.  ELAPSED TIME = 00:00:09
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.EXM15B.LARSA1BA.J0001.A003'
 BMC50482I 3: BUILD COMPLETE.  ELAPSED TIME = 00:00:07  DSN = 'DEHJCAT.DSNDBD.EXM15B.LARXPC1A.J0001.A003'
 BMC50477I 3: PARTITION =    3, ROWS/KEYS = 1704, I/O WAITS = 5 ,DDNAME = SYS00029
 BMC50482I 3: RELOAD COMPLETE.  ELAPSED TIME = 00:00:09  DSN = 'DEHJCAT.DSNDBD.EXM15B.LARSA1BA.J0001.A003'
 BMC50477I 3: PARTITION =    3, ROWS/KEYS = 1704, I/O WAITS = 5 ,DDNAME = SYS00027
 BMC51274I RELOAD STATISTICS:  1704 ROWS/KEYS LOADED INTO PARTITION 3
 BMC50773I 104: LOG APPLY TASK STARTED AT 03/30/2015 11:00:08
 BMC50481I 3: REORG TASK COMPLETE.  ELAPSED TIME = 00:00:10
 BMC50277I XBM STATISTICS: DSN='DEHJCAT.DSNDBD.EXM15B.LARSA1BA.I0001.A001    ', READS 145, HITS 0, WRITES 0, CACHE 0
 BMC50277I XBM STATISTICS: DSN='DEHJCAT.DSNDBD.EXM15B.LARSA1BA.I0001.A002    ', READS 98, HITS 0, WRITES 0, CACHE 0
 BMC50277I XBM STATISTICS: DSN='DEHJCAT.DSNDBD.EXM15B.LARSA1BA.I0001.A003    ', READS 283, HITS 0, WRITES 0, CACHE 0
 BMC50476I DDNAME = SYSUT102, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSUT101, I/OS = 5, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51276I BUILD  STATISTICS:  2048 KEYS LOADED INTO INDEX 'EXM15B.LARXPC1A'
 BMC51275I RELOAD STATISTICS:  2048 ROWS LOADED INTO SPACE 'EXM15B.LARSA1BA'
 BMC50474I BELOW 16M = 7908K, ABOVE 16M = 1253452K, CPUS = 3
 BMC50479I TOTAL PAGES: 3850509, ALLOWED: 0; AVAILABLE PAGES: 263069, ALLOWED: 263069
 BMC51303I MAX TASKS = 2, INDEXES PER TASK = 1, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 2
 BMC50486I 2: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50476I DDNAME = SYSUT101, I/OS = 3, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSUT102, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50481I 1: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 2: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50482I 2: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.EXM15B.LARXNS1C.J0001.A001'
 BMC50477I 2: PARTITION =    0, ROWS/KEYS = 2048, I/O WAITS = 5 ,DDNAME = SYS00034
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.EXM15B.LARXPS1B.J0001.A001'
 BMC50477I 1: PARTITION =    1, ROWS/KEYS = 312, I/O WAITS = 5 ,DDNAME = SYS00035
 BMC50773I 108: INDEX APPLY TASK STARTED AT 03/30/2015 11:00:10
 BMC50773I 106: INDEX APPLY TASK STARTED AT 03/30/2015 11:00:10
 BMC51276I BUILD  STATISTICS:  2048 KEYS LOADED INTO INDEX 'EXM15B.LARXNS1C'
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.EXM15B.LARXPS1B.J0001.A002'
 BMC50477I 1: PARTITION =    2, ROWS/KEYS = 32, I/O WAITS = 5 ,DDNAME = SYS00037
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.EXM15B.LARXPS1B.J0001.A003'
 BMC50477I 1: PARTITION =    3, ROWS/KEYS = 1704, I/O WAITS = 5 ,DDNAME = SYS00039
 BMC51276I BUILD  STATISTICS:  2048 KEYS LOADED INTO INDEX 'EXM15B.LARXPS1B'
 BMC50773I 107: INDEX APPLY TASK STARTED AT 03/30/2015 11:00:12
 BMC50829I LOGAPPLY PHASE STARTING AT 03/30/2015 11:00:12
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT102', DSNAME = 'ARU.LARREORG.DEHJ.EXM15B.LARSA1BA.SYSUT102'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT101', DSNAME = 'ARU.LARREORG.DEHJ.EXM15B.LARSA1BA.SYSUT101'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I REORG PHASE COMPLETE.  ELAPSED TIME = 00:00:15

 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50877I POINT OF CONSISTENCY ESTABLISHED AT RBA/LRSN = 000000000526C4955000
 BMC50778I LOG RECORD QUEUE SIZE AT OR BELOW THRESHOLD
 BMC50004I LOGAPPLY PHASE COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50830I LOGFINAL PHASE STARTING AT 03/30/2015 11:00:13
 BMC50709I MONITOR TRACE CLASS(1) TRACE NUMBER = 05 STOPPED
 BMC50786I 101: LOG SCAN TASK ENDED AT 03/30/2015 11:00:13, ELAPSED TIME = 00:00:17
 BMC50720I 104: 0 NEW LOG APPLY BUFFERS, 0 REUSED, 3686 INITIAL MAXIMUM, 0 WAITS, BUFFER SIZE=9324
 BMC50741I 104: LOGAPPLY STATISTICS
 BMC50742I 104: PROCESSED TRANSACTIONS
 BMC50744I 104:    INSERTS:          0 INSERTS(COMPENSATION):          0
 BMC50745I 104:    UPDATES:          0 UPDATES(COMPENSATION):          0
 BMC50746I 104:    DELETES:          0 DELETES(COMPENSATION):          0
 BMC50743I 104: CONSOLIDATED TRANSACTIONS
 BMC50744I 104:    INSERTS:          0 INSERTS(COMPENSATION):          0
 BMC50745I 104:    UPDATES:          0 UPDATES(COMPENSATION):          0
 BMC50746I 104:    DELETES:          0 DELETES(COMPENSATION):          0
 BMC50747I 104: PAGES UPDATED COUNTERS FOR EXM15B.LARSA1BA
 BMC50748I 104:     PART     TOTAL PAGES     DATA PAGES     SPACE MAPS     HEADER PAGES
 BMC50749I 104:        3              1              0               0               1
 BMC50716I 104: Buffer Manager Statistics
 BMC50717I 104:  DATASET=DEHJCAT.DSNDBC.EXM15B.LARSA1BA.J0001.A003
 BMC50718I 104:        Page Requests          2 |            Page Hits          0
 BMC50718I 104:           Page Reads          2 |          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: LOG APPLY TASK ENDED AT 03/30/2015 11:00:14, ELAPSED TIME = 00:00:05
 BMC50720I 102: 0 NEW LOG APPLY BUFFERS, 0 REUSED, 3686 INITIAL MAXIMUM, 0 WAITS, BUFFER SIZE=9324
 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 EXM15B.LARSA1BA
 BMC50748I 102:     PART     TOTAL PAGES     DATA PAGES     SPACE MAPS     HEADER PAGES
 BMC50749I 102:        1              1              0               0               1
 BMC50716I 102: Buffer Manager Statistics
 BMC50717I 102:  DATASET=DEHJCAT.DSNDBC.EXM15B.LARSA1BA.J0001.A001
 BMC50718I 102:        Page Requests          2 |            Page Hits          0
 BMC50718I 102:           Page Reads          2 |          Page Writes          1
 BMC50718I 102:   Write I/O Requests          1 |            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/30/2015 11:00:18, ELAPSED TIME = 00:00:10
 BMC50720I 103: 0 NEW LOG APPLY BUFFERS, 0 REUSED, 3686 INITIAL MAXIMUM, 0 WAITS, BUFFER SIZE=9324
 BMC50741I 103: LOGAPPLY STATISTICS
 BMC50742I 103: PROCESSED TRANSACTIONS
 BMC50744I 103:    INSERTS:          0 INSERTS(COMPENSATION):          0
 BMC50745I 103:    UPDATES:          0 UPDATES(COMPENSATION):          0
 BMC50746I 103:    DELETES:          0 DELETES(COMPENSATION):          0
 BMC50743I 103: CONSOLIDATED TRANSACTIONS
 BMC50744I 103:    INSERTS:          0 INSERTS(COMPENSATION):          0
 BMC50745I 103:    UPDATES:          0 UPDATES(COMPENSATION):          0
 BMC50746I 103:    DELETES:          0 DELETES(COMPENSATION):          0
 BMC50747I 103: PAGES UPDATED COUNTERS FOR EXM15B.LARSA1BA
 BMC50748I 103:     PART     TOTAL PAGES     DATA PAGES     SPACE MAPS     HEADER PAGES
 BMC50749I 103:        2              1              0               0               1
 BMC50716I 103: Buffer Manager Statistics
 BMC50717I 103:  DATASET=DEHJCAT.DSNDBC.EXM15B.LARSA1BA.J0001.A002
 BMC50718I 103:        Page Requests          2 |            Page Hits          0
 BMC50718I 103:           Page Reads          2 |          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: LOG APPLY TASK ENDED AT 03/30/2015 11:00:18, ELAPSED TIME = 00:00:10
 BMC50786I 111: INLINE IMAGE COPY APPEND TASK ENDED AT 03/30/2015 11:00:18, ELAPSED TIME = 00:00:19
 BMC50786I 109: LOG RECORD SORT TASK ENDED AT 03/30/2015 11:00:18, ELAPSED TIME = 00:00:19
 BMC50794I 108: INDEX MAINTENANCE STATISTICS FOR INDEX EXM15B.LARXNS1C
 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
 BMC50716I 108: Buffer Manager Statistics
 BMC50717I 108:  DATASET=DEHJCAT.DSNDBC.EXM15B.LARXNS1C.J0001.A001
 BMC50718I 108:        Page Requests          5 |            Page Hits          1
 BMC50718I 108:           Page Reads          4 |          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
 BMC50786I 108: INDEX APPLY TASK ENDED AT 03/30/2015 11:00:20, ELAPSED TIME = 00:00:10
 BMC50794I 106: INDEX MAINTENANCE STATISTICS FOR INDEX EXM15B.LARXPC1A DSNUM 3
 BMC50791I 106:   PAGE READS  :         3  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
 BMC50794I 106: INDEX MAINTENANCE STATISTICS FOR INDEX EXM15B.LARXPS1B DSNUM 1
 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.EXM15B.LARXPC1A.J0001.A003
 BMC50717I 106:  DATASET=DEHJCAT.DSNDBC.EXM15B.LARXPS1B.J0001.A001
 BMC50718I 106:        Page Requests         11 |            Page Hits          1
 BMC50718I 106:           Page Reads         10 |          Page Writes          2
 BMC50718I 106:   Write I/O Requests          3 |            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/30/2015 11:00:20, ELAPSED TIME = 00:00:10
 BMC50794I 107: INDEX MAINTENANCE STATISTICS FOR INDEX EXM15B.LARXPS1B DSNUM 2
 BMC50791I 107:   PAGE READS  :         2  KEY INSERTS     :         0
 BMC50791I 107:   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
 BMC50794I 107: INDEX MAINTENANCE STATISTICS FOR INDEX EXM15B.LARXPS1B DSNUM 3
 BMC50791I 107:   PAGE READS  :         2  KEY INSERTS     :         0
 BMC50791I 107:   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
 BMC50716I 107: Buffer Manager Statistics
 BMC50717I 107:  DATASET=DEHJCAT.DSNDBC.EXM15B.LARXPS1B.J0001.A002
 BMC50717I 107:  DATASET=DEHJCAT.DSNDBC.EXM15B.LARXPS1B.J0001.A003
 BMC50718I 107:        Page Requests         10 |            Page Hits          2
 BMC50718I 107:           Page Reads          8 |          Page Writes          1
 BMC50718I 107:   Write I/O Requests          2 |            New Pages          0
 BMC50716I 107:       Write I/O time    0:00:00 |        Read I/O time    0:00:00
 BMC50786I 107: INDEX APPLY TASK ENDED AT 03/30/2015 11:00:22, ELAPSED TIME = 00:00:10
 BMC50794I 105: INDEX MAINTENANCE STATISTICS FOR INDEX EXM15B.LARXPC1A DSNUM 2
 BMC50791I 105:   PAGE READS  :         3  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
 BMC50794I 105: INDEX MAINTENANCE STATISTICS FOR INDEX EXM15B.LARXPC1A DSNUM 1
 BMC50791I 105:   PAGE READS  :         3  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.EXM15B.LARXPC1A.J0001.A001
 BMC50717I 105:  DATASET=DEHJCAT.DSNDBC.EXM15B.LARXPC1A.J0001.A002
 BMC50718I 105:        Page Requests         12 |            Page Hits          1
 BMC50718I 105:           Page Reads         11 |          Page Writes          2
 BMC50718I 105:   Write I/O Requests          3 |            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/30/2015 11:00:22, ELAPSED TIME = 00:00:15
 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 03/30/2015 11:00:22, ELAPSED TIME = 00:00:24
 BMC50476I DDNAME = BMCCPY01, I/OS = 3, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50376I 68 PAGES COPIED TO DATASET = 'ARU.LARREORG.DEHJ.EXM15B.LARSA1BA.BMCCPY01'
 BMC50476I DDNAME = BMCCPY02, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50376I 54 PAGES COPIED TO DATASET = 'ARU.LARREORG.DEHJ.EXM15B.LARSA1BA.BMCCPY02'
 BMC50476I DDNAME = BMCCPY03, I/OS = 4, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50376I 132 PAGES COPIED TO DATASET = 'ARU.LARREORG.DEHJ.EXM15B.LARSA1BA.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 = 27136K, 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=312, PAIRS=312, STORAGE=4K, 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=32, PAIRS=32, STORAGE=4K, 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=1704, PAIRS=1704, STORAGE=16K, 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=2048, PAIRS=2048, STORAGE=24K, 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=1020K
 BMC50883I RIDMAP: SUMMARY: MAX PIPES=12, PIPES USED=3, 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/30/2015 11:00:22, ELAPSED TIME = 00:00:26
 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/30/2015  11:00:23

 BMC51350I MATERIALIZATION OF PENDING DDL CHANGES COMPLETED FOR EXM15B.LARSA1BA AT 11:00:23

 BMC50895I SWITCH PROCESS COMPLETE.  ELAPSED TIME =  00:00:00

 BMC50890I 9: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.EXM15B.LARXPS1B.I0001.A003'...
 BMC50890I 3: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.EXM15B.LARSA1BA.I0001.A003'...
 BMC50890I 6: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.EXM15B.LARXPC1A.I0001.A003'...
 BMC50890I 7: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.EXM15B.LARXPS1B.I0001.A001'...
 BMC50890I 1: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.EXM15B.LARSA1BA.I0001.A001'...
 BMC50890I 5: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.EXM15B.LARXPC1A.I0001.A002'...
 BMC50890I 4: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.EXM15B.LARXPC1A.I0001.A001'...
 BMC50890I 2: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.EXM15B.LARSA1BA.I0001.A002'...
 BMC50890I 8: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.EXM15B.LARXPS1B.I0001.A002'...
 BMC50890I 10: ATTEMPTING TO DELETE DATASET 'DEHJCAT.DSNDBC.EXM15B.LARXNS1C.I0001.A001'...
 BMC50891I 3: DATASET 'DEHJCAT.DSNDBC.EXM15B.LARSA1BA.I0001.A003' IS DELETED
 BMC50891I 5: DATASET 'DEHJCAT.DSNDBC.EXM15B.LARXPC1A.I0001.A002' IS DELETED
 BMC50891I 8: DATASET 'DEHJCAT.DSNDBC.EXM15B.LARXPS1B.I0001.A002' IS DELETED
 BMC50891I 1: DATASET 'DEHJCAT.DSNDBC.EXM15B.LARSA1BA.I0001.A001' IS DELETED
 BMC50891I 6: DATASET 'DEHJCAT.DSNDBC.EXM15B.LARXPC1A.I0001.A003' IS DELETED
 BMC50891I 2: DATASET 'DEHJCAT.DSNDBC.EXM15B.LARSA1BA.I0001.A002' IS DELETED
 BMC50891I 4: DATASET 'DEHJCAT.DSNDBC.EXM15B.LARXPC1A.I0001.A001' IS DELETED
 BMC50891I 9: DATASET 'DEHJCAT.DSNDBC.EXM15B.LARXPS1B.I0001.A003' IS DELETED
 BMC50891I 7: DATASET 'DEHJCAT.DSNDBC.EXM15B.LARXPS1B.I0001.A001' IS DELETED
 BMC50891I 10: DATASET 'DEHJCAT.DSNDBC.EXM15B.LARXNS1C.I0001.A001' IS DELETED

 BMCSTATS V11.02.00 REPORT FOR DEHJ V1115 (111)       TIME 2015-03-30-10.59.56.758063                                          1


   INDEX --------------- EXM15B.LARXPC1A
     ASSOCIATIONS
       TABLESPACE ------ EXM15B.LARSA1BA
       TABLE ----------- EXM15B.LART001
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------R  LOCATION------------------DEHJ
       SAMPLING---------------------N
     ATTRIBUTES
       PIECESIZE--------------------0  TYPE TS----------------------R  UNIQUERULE-------------------D  KEYLENGTH-------------------10
       SPARSE-----------------------N  INDEXTYPE--------------------P  CLUSTERING-------------------Y  COLCOUNT---------------------1
       INDEXSPACE------------LARXPC1A  PGSIZE-----------------------8  EXTTYPE----------------(BLANK)  COMPRESS---------------------Y
       COLNAME---------C009_TIMESTAMP
     STATISTICS
       FIRSTKEYCARD--------------2048  FULLKEYCARD---------------2048  NACTIVE---------------------22  TBCARDF-------------------2048
       NUMNONLEAF-------------------3  NLEVELS----------------------2  CLUSTERRATIO----------------97  NLEAF-----------------------10
       AVGKEYLEN-------------------10  REORGSPACE------------------45  REORGSPACE_KB-------------2160  REORGNLEVELS-----------------2
       HIGH2K-----X'4460070200000000'  HIGH2K (CHAR)---------.-......  LOW2K------X'1910020200000000'  LOW2K (CHAR)----------........
       DATAREPEAT------------------49
     ALLOCATION
       SPACE----------------------270  SPACE_KB-----------------12960

   INDEXPART ----------- EXM15B.LARXPC1A PART 001
     ASSOCIATIONS
       TABLESPACE ------ EXM15B.LARSA1BA
       TABLE ----------- EXM15B.LART001
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------R  LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------6  SQTY-------------------------3  PCTFREE----------------------0  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  NLAVGKEYLEN------------------3  VCATNAME---------------DEHJCAT
       RBA_FORMAT------------EXTENDED  STORNAME--------------ARULARSG
     STATISTICS
       FIRSTKEYCARD---------------312  FULLKEYCARD----------------312  CARD-----------------------312  NACTIVE----------------------6
       CLUSTERRATIO----------------97  NUMNONLEAF-------------------1  NLEVELS----------------------2  FAROFFPOS--------------------0
       NEAROFFPOS-------------------7  LEAFDIST--------------------50  NLEAF------------------------2  FREE------------------------13
       FULL-------------------------0  AVGKEYLEN-------------------10
       LEAFNEAR---------------------1  LEAFFAR----------------------0  PSEUDO_DEL_RIDS--------------0  REORGSPACE------------------15
       REORGSPACE_KB--------------720  REORGNLEVELS-----------------2  PCTUSED---------------------16  PQTYROWS----------------242172
       DATAREPEAT-------------------8
     ALLOCATION
       IPREFIX----------------------J  SPACE-----------------------90  SPACE_KB------------------4320  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------ARU381

   . . .

   COLUMN -------------- C009_TIMESTAMP
     ASSOCIATIONS
       TABLESPACE ------ EXM15B.LARSA1BA
       TABLE ----------- EXM15B.LART001
     ATTRIBUTES
       COLNO------------------------9  COLTYPE---------------TIMESTMP  LENGTH----------------------10  NULLS------------------------N
     STATISTICS
       COLCARD-------------------2048  COLNULLS---------------------0  COLAVG----------------------10  COLMIN----------------------10
       COLMAX----------------------10
       HIGH2K-----X'4460070200000000'  HIGH2K (CHAR)---------.-......  LOW2K------X'1910020200000000'  LOW2K (CHAR)----------........

       MOST FREQUENT VALUES
        FREQUENCY-------------0.000488     COLVAL-X'23400102000000000000'
                                           (CHAR)--------------. ........
        FREQUENCY-------------0.000488     COLVAL-X'23400202000000000000'
                                           (CHAR)--------------. ........
        FREQUENCY-------------0.000488     COLVAL-X'23400302000000000000'
                                           (CHAR)--------------. ........
        FREQUENCY-------------0.000488     COLVAL-X'23400402000000000000'
                                           (CHAR)--------------. ........
        FREQUENCY-------------0.000488     COLVAL-X'23400502000000000000'
                                           (CHAR)--------------. ........
        FREQUENCY-------------0.000488     COLVAL-X'23400602000000000000'
 BMCSTATS V11.02.00 REPORT FOR DEHJ V1115 (111)       TIME 2015-03-30-10.59.56.758063                                          3

                                           (CHAR)--------------. ........
        FREQUENCY-------------0.000488     COLVAL-X'23400702000000000000'
                                           (CHAR)--------------. ........
        FREQUENCY-------------0.000488     COLVAL-X'23400802000000000000'
                                           (CHAR)--------------. ........
        FREQUENCY-------------0.000488     COLVAL-X'23500102000000000000'
                                           (CHAR)--------------.&........
        FREQUENCY-------------0.000488     COLVAL-X'23500202000000000000'
                                           (CHAR)--------------.&........

   COLUMN -------------- C009_TIMESTAMP PART 001
     ATTRIBUTES
       COLNO------------------------9  COLTYPE---------------TIMESTMP  LENGTH----------------------10  NULLS------------------------N
     STATISTICS
       COLCARD--------------------312  COLNULLS---------------------0  COLAVG----------------------10  COLMIN----------------------10
       COLMAX----------------------10
       HIGH2K-----X'2290070200000000'  HIGH2K (CHAR)---------........  LOW2K------X'1910020200000000'  LOW2K (CHAR)----------........
       HIGHK------X'2290080200000000'  HIGHK (CHAR)----------........  LOWK-------X'1910010200000000'  LOWK (CHAR)-----------........

       MOST FREQUENT VALUES
        FREQUENCY-------------0.003205     COLVAL-X'19300402000000000000'
                                           (CHAR)--------------..........
        FREQUENCY-------------0.003205     COLVAL-X'19300302000000000000'
                                           (CHAR)--------------..........
        FREQUENCY-------------0.003205     COLVAL-X'19300202000000000000'
                                           (CHAR)--------------..........
        FREQUENCY-------------0.003205     COLVAL-X'19300102000000000000'
                                           (CHAR)--------------..........
        FREQUENCY-------------0.003205     COLVAL-X'19200802000000000000'
                                           (CHAR)--------------..........
        FREQUENCY-------------0.003205     COLVAL-X'19200702000000000000'
                                           (CHAR)--------------..........
        FREQUENCY-------------0.003205     COLVAL-X'19200602000000000000'
                                           (CHAR)--------------..........
        FREQUENCY-------------0.003205     COLVAL-X'19200502000000000000'
                                           (CHAR)--------------..........
        FREQUENCY-------------0.003205     COLVAL-X'19200402000000000000'
                                           (CHAR)--------------..........
        FREQUENCY-------------0.003205     COLVAL-X'19200302000000000000'
                                           (CHAR)--------------..........

   . . .                                        

   INDEX --------------- EXM15B.LARXPS1B
     ASSOCIATIONS
       TABLESPACE ------ EXM15B.LARSA1BA
       TABLE ----------- EXM15B.LART001
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------R  LOCATION------------------DEHJ
       SAMPLING---------------------N
     ATTRIBUTES
       PIECESIZE--------------------0  TYPE TS----------------------R  UNIQUERULE-------------------D  KEYLENGTH--------------------5
       SPARSE-----------------------N  INDEXTYPE--------------------D  CLUSTERING-------------------N  COLCOUNT---------------------1
       INDEXSPACE------------LARXPS1B  PGSIZE-----------------------8  EXTTYPE----------------(BLANK)  COMPRESS---------------------N
       COLNAME-----------C001_INTEGER
     STATISTICS
       FIRSTKEYCARD--------------2160  FULLKEYCARD---------------2160  NACTIVE---------------------18  TBCARDF-------------------2048
       NUMNONLEAF-------------------3  NLEVELS----------------------2  CLUSTERRATIO-----------------5  NLEAF------------------------6
       AVGKEYLEN--------------------5  REORGSPACE------------------45  REORGSPACE_KB-------------2160  REORGNLEVELS-----------------2
       HIGH2K-----------X'008009C41E'  HIGH2K (CHAR)------------...D.  LOW2K------------X'0080000002'  LOW2K (CHAR)-------------.....
       DATAREPEAT----------------1947
     ALLOCATION
       SPACE----------------------270  SPACE_KB-----------------12960

   INDEXPART ----------- EXM15B.LARXPS1B PART 001
     ASSOCIATIONS
       TABLESPACE ------ EXM15B.LARSA1BA
       TABLE ----------- EXM15B.LART001
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------R  LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------6  SQTY-------------------------3  PCTFREE----------------------0  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  NLAVGKEYLEN------------------5  VCATNAME---------------DEHJCAT
       RBA_FORMAT------------EXTENDED  STORNAME--------------ARULARSG
     STATISTICS
       FIRSTKEYCARD---------------312  FULLKEYCARD----------------312  CARD-----------------------312  NACTIVE----------------------5
       CLUSTERRATIO----------------22  NUMNONLEAF-------------------1  NLEVELS----------------------2  FAROFFPOS--------------------0
       NEAROFFPOS-----------------241  LEAFDIST---------------------0  NLEAF------------------------1  FREE------------------------11
       FULL-------------------------0  AVGKEYLEN--------------------5
       LEAFNEAR---------------------0  LEAFFAR----------------------0  PSEUDO_DEL_RIDS--------------0  REORGSPACE------------------15
       REORGSPACE_KB--------------720  REORGNLEVELS-----------------2  PCTUSED---------------------16  PQTYROWS----------------291036
       DATAREPEAT-----------------242
     ALLOCATION
       IPREFIX----------------------J  SPACE-----------------------90  SPACE_KB------------------4320  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------ARU381

  . . .

   COLUMN -------------- C001_INTEGER
     ASSOCIATIONS
       TABLESPACE ------ EXM15B.LARSA1BA
       TABLE ----------- EXM15B.LART001
     ATTRIBUTES
       COLNO------------------------1  COLTYPE----------------INTEGER  LENGTH-----------------------4  NULLS------------------------Y
     STATISTICS
       COLCARD-------------------2160  COLNULLS---------------------0  COLAVG-----------------------5  COLMIN-----------------------5
       COLMAX-----------------------5
       HIGH2K-----------X'008009C41E'  HIGH2K (CHAR)------------...D.  LOW2K------------X'0080000002'  LOW2K (CHAR)-------------.....

       MOST FREQUENT VALUES
       FREQUENCY-------------0.000488  COLVAL-----------X'008009C41F'
                                       (CHAR)-------------------...D.
       FREQUENCY-------------0.000488  COLVAL-----------X'008009C41E'
                                       (CHAR)-------------------...D.
       FREQUENCY-------------0.000488  COLVAL-----------X'008009C41D'
                                       (CHAR)-------------------...D.
       FREQUENCY-------------0.000488  COLVAL-----------X'008009C41B'
                                       (CHAR)-------------------...D.
       FREQUENCY-------------0.000488  COLVAL-----------X'008009C41A'
                                       (CHAR)-------------------...D.
       FREQUENCY-------------0.000488  COLVAL-----------X'008009C419'
 BMCSTATS V11.02.00 REPORT FOR DEHJ V1115 (111)       TIME 2015-03-30-10.59.56.758063                                          3

                                       (CHAR)-------------------...D.
       FREQUENCY-------------0.000488  COLVAL-----------X'008009C417'
                                       (CHAR)-------------------...D.
       FREQUENCY-------------0.000488  COLVAL-----------X'008009C416'
                                       (CHAR)-------------------...D.
       FREQUENCY-------------0.000488  COLVAL-----------X'008009C415'
                                       (CHAR)-------------------...D.
       FREQUENCY-------------0.000488  COLVAL-----------X'008009C413'
                                       (CHAR)-------------------...D.

   COLUMN -------------- C001_INTEGER PART 001
     ATTRIBUTES
       COLNO------------------------1  COLTYPE----------------INTEGER  LENGTH-----------------------4  NULLS------------------------Y
     STATISTICS
       COLCARD--------------------312  COLNULLS---------------------0  COLAVG-----------------------5  COLMIN-----------------------5
       COLMAX-----------------------5
       HIGH2K-----------X'008009C418'  HIGH2K (CHAR)------------...D.  LOW2K------------X'0080000005'  LOW2K (CHAR)-------------.....
       HIGHK------------X'008009C41C'  HIGHK (CHAR)-------------...D.  LOWK-------------X'0080000001'  LOWK (CHAR)--------------.....

       MOST FREQUENT VALUES
       FREQUENCY-------------0.003205  COLVAL-----------X'00800975E8'
                                       (CHAR)-------------------....Y
       FREQUENCY-------------0.003205  COLVAL-----------X'00800975EC'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.003205  COLVAL-----------X'00800975F0'
                                       (CHAR)-------------------....0
       FREQUENCY-------------0.003205  COLVAL-----------X'00800975F4'
                                       (CHAR)-------------------....4
       FREQUENCY-------------0.003205  COLVAL-----------X'00800975F8'
                                       (CHAR)-------------------....8
       FREQUENCY-------------0.003205  COLVAL-----------X'00800975FC'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.003205  COLVAL-----------X'0080099CF4'
                                       (CHAR)-------------------....4
       FREQUENCY-------------0.003205  COLVAL-----------X'0080099CF8'
                                       (CHAR)-------------------....8
       FREQUENCY-------------0.003205  COLVAL-----------X'0080099CFC'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.003205  COLVAL-----------X'0080099D00'
                                       (CHAR)-------------------.....

  . . .

   INDEX --------------- EXM15B.LARXNS1C
     ASSOCIATIONS
       TABLESPACE ------ EXM15B.LARSA1BA
       TABLE ----------- EXM15B.LART001
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------R  LOCATION------------------DEHJ
       SAMPLING---------------------N
     ATTRIBUTES
       PIECESIZE-----------------4096  TYPE TS----------------------R  UNIQUERULE-------------------D  KEYLENGTH------------------453
       SPARSE-----------------------N  INDEXTYPE--------------------2  CLUSTERING-------------------N  COLCOUNT---------------------3
       INDEXSPACE------------LARXNS1C  PGSIZE----------------------16  EXTTYPE----------------(BLANK)  COMPRESS---------------------N
       COLNAME----------C002_SMALLINT
     STATISTICS
       FIRSTKEYCARD--------------1853  FULLKEYCARD---------------2048  NACTIVE---------------------42  TBCARDF-------------------2048
       NUMNONLEAF-------------------1  NLEVELS----------------------2  CLUSTERRATIO-----------------1  NLEAF-----------------------38
       AVGKEYLEN------------------285  REORGSPACE------------------15  REORGSPACE_KB--------------720  REORGNLEVELS-----------------2
       HIGH2K---------------X'00A6E6'  HIGH2K (CHAR)--------------.wW  LOW2K----------------X'008008'  LOW2K (CHAR)---------------...
       DATAREPEAT----------------2011
     ALLOCATION
       SPACE----------------------420  SPACE_KB-----------------20160  NUMDATASETS------------------1

   INDEXPART ----------- EXM15B.LARXNS1C
     ASSOCIATIONS
       TABLESPACE ------ EXM15B.LARSA1BA
       TABLE ----------- EXM15B.LART001
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------R  LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY------------------------28  SQTY-------------------------7  PCTFREE----------------------0  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  NLAVGKEYLEN------------------6  VCATNAME---------------DEHJCAT
       RBA_FORMAT------------EXTENDED  STORNAME--------------ARULARSG
     STATISTICS
       FIRSTKEYCARD--------------1853  FULLKEYCARD---------------2048  CARD----------------------2048  NACTIVE---------------------42
       CLUSTERRATIO-----------------1  NUMNONLEAF-------------------1  NLEVELS----------------------2  FAROFFPOS------------------589
       NEAROFFPOS----------------1421  LEAFDIST---------------------2  NLEAF-----------------------38  FREE------------------------30
       FULL------------------------37  AVGKEYLEN------------------285
       LEAFNEAR---------------------1  LEAFFAR----------------------0  PSEUDO_DEL_RIDS--------------0  REORGSPACE------------------15
       REORGSPACE_KB--------------720  REORGNLEVELS-----------------2  PCTUSED----------------------3  PQTYROWS-----------------69023
       DATAREPEAT----------------2011
     ALLOCATION
       IPREFIX----------------------J  SPACE----------------------420  SPACE_KB-----------------20160  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------ARU381

   COLUMN -------------- C002_SMALLINT
     ASSOCIATIONS
       TABLESPACE ------ EXM15B.LARSA1BA
       TABLE ----------- EXM15B.LART001
     ATTRIBUTES
       COLNO------------------------2  COLTYPE---------------SMALLINT  LENGTH-----------------------2  NULLS------------------------Y
     STATISTICS
       COLCARD-------------------1853  COLNULLS---------------------0  COLAVG-----------------------3  COLMIN-----------------------3
       COLMAX-----------------------3
       HIGH2K---------------X'00A6E6'  HIGH2K (CHAR)--------------.wW  LOW2K----------------X'008008'  LOW2K (CHAR)---------------...

       MOST FREQUENT VALUES
 BMCSTATS V11.02.00 REPORT FOR DEHJ V1115 (111)       TIME 2015-03-30-10.59.56.758063                                          2

       FREQUENCY-------------0.001953  COLVAL---------------X'009BAF'
                                       (CHAR)---------------------...
       FREQUENCY-------------0.001465  COLVAL---------------X'009EA3'
                                       (CHAR)---------------------..t
       FREQUENCY-------------0.001465  COLVAL---------------X'0099CC'
                                       (CHAR)---------------------.r.
       FREQUENCY-------------0.001465  COLVAL---------------X'008485'
                                       (CHAR)---------------------.de
       FREQUENCY-------------0.001465  COLVAL---------------X'008472'
                                       (CHAR)---------------------.d.
       FREQUENCY-------------0.001465  COLVAL---------------X'008448'
                                       (CHAR)---------------------.d.
       FREQUENCY-------------0.001465  COLVAL---------------X'008315'
                                       (CHAR)---------------------.c.
       FREQUENCY-------------0.001465  COLVAL---------------X'0081E0'
                                       (CHAR)---------------------.a.
       FREQUENCY-------------0.001465  COLVAL---------------X'008199'
                                       (CHAR)---------------------.ar
       FREQUENCY-------------0.001465  COLVAL---------------X'0080A7'
                                       (CHAR)---------------------..x

   KEYCARD ------------- C002_SMALLINT
     ASSOCIATIONS
       TABLESPACE ------ EXM15B.LARSA1BA
       TABLE ----------- EXM15B.LART001
     ATTRIBUTES AND STATISTICS
       COLUMN-----------C002_SMALLINT  COLCARD-------------------1853  COLTYPE---------------SMALLINT  LENGTH-----------------------2
       COLUMN------------C006_VARCHAR  COLCARD-------------------2048  COLTYPE----------------VARCHAR  LENGTH---------------------195
       COLUMN---------------C005_CHAR  COLCARD-------------------2048  COLTYPE-------------------CHAR  LENGTH---------------------254
 BMCSTATS V11.02.00 REPORT FOR DEHJ V1115 (111)       TIME 2015-03-30-10.59.56.758063                                          1


 TABLESPACE ------------ EXM15B.LARSA1BA
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------R  LOCATION------------------DEHJ
       SAMPLING---------------------N
     ATTRIBUTES
       PARTITIONS-------------------3  NTABLES----------------------1  PGSIZE-----------------------8  SEGSIZE---------------------48
       DSSIZE-----------------4194304
       MAXROWS--------------------255  TYPE-------------------------R  ENCODING---------------------U  MAXPARTITIONS----------------0
       LOB--------------------------N  XML--------------------------N  MEMBER_CLUSTER---------(BLANK)
     STATISTICS
       NACTIVE--------------------245  REORGSPACE------------------90  REORGSPACE_KB-------------4320  ROWMAXFOUND----------------168
       ROWMINFOUND----------------102  ROWAVG---------------------138
     ALLOCATION
       SPACE---------------------1260  SPACE_KB-----------------60480

   TABLEPART ----------- EXM15B.LARSA1BA PART 001
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------R
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY------------------------28  SQTY-------------------------6  PCTFREE---------------------25  FREEPAGE---------------------1
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  VCATNAME---------------DEHJCAT  STORNAME--------------ARULARSG
     STATISTICS
       CARD-----------------------312  NACTIVE---------------------65  NPAGES-----------------------8  ROWAVG---------------------139
       ROWMAXFOUND----------------161  ROWMINFOUND----------------113  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL-------------------------0  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE-------------------8
       PCTPAGES--------------------12  PERCDROP---------------------0  REORGSPACE------------------30  REORGSPACE_KB-------------1440
       PCTUSED----------------------3  PQTYROWS-----------------52627  NDICTIONARY------------------8  PCTROWCOMP-----------------100
       PAGESAVE---------------------0
     ALLOCATION
       IPREFIX----------------------J  SPACE----------------------420  SPACE_KB-----------------20160  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------ARU381

   . . .

   TABLE --------------- EXM15B.LART001
     ASSOCIATIONS
       TABLESPACE ------ EXM15B.LARSA1BA
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------R  LOCATION----------------(NULL)
     STATISTICS
       CARD----------------------2048  NPAGES----------------------49  SPACE_KB-----------------60480  AVGNONCOMPROWLEN----------(-1)
       ROWAVG---------------------138  ROWMAXFOUND----------------168  ROWMINFOUND----------------102  INDREF-----------------------0
       PCTPAGES--------------------20  PCTROWCOMP-----------------100
 BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR REORG UTILITY SUCCESSFUL FOR ALL OBJECTS
 BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0

Related topic

Examples-of-REORG-PLUS-jobs

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*