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 3: Partial reorganization with SHRLEVEL REFERENCE and a single copy of a subset of partitions

This example illustrates a partial reorganization of a 16-partition storage-group-defined table space.

The table has three indexes: the clustering index, a unique nonpartitioned secondary index (NPSI), and a non-unique nonpartitioned secondary index.

In case 1, REORG PLUS reorganizes partitions 1 through 5, 8, and 16. In case 2, only partitions 1 through 5 are reorganized. This case illustrates creating a single copy of a subset of partitions. The following attributes of this job enable this copy:

  • A contiguous subset of partitions is specified with the PART option.
  • COPYLVL FULL is specified.
  • A different options module, ARU$OPTS, is specified on the EXEC statement. This options module changes the default value for the COPYSUBSET installation option to YES.

Another difference between the two cases is the data availability during the job as specified by the SHRLEVEL option:

  • Case 1 uses the default, SHRLEVEL NONE. Therefore, the data is unavailable during the job.

  • Case 2 specifies SHRLEVEL REFERENCE, which allows the data to be available in read-only status during the job.

    REORG PLUS messages BMC50890I and BMC50891I detail the rename and delete activity associated with the staging data sets.

Message 50041I indicates the status of zIIP processing. For this example, the ZIIP installation option is ENABLED, but an XBM subsystem was not specified. REORG PLUS automatically located an available XBM subsystem to provide 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

PART 1:5,8,16 (case 1)

PART 1:5 (case 2)

Reorganizes partitions 1 through 5, 8, and 16 (case 1)

Reorganizes contiguous partitions 1-5 to enable a single copy of a subset of partitions (case 2)

For case 2, COPYSUBSET=YES is also set in the installation options for these copies.

COPYLVL FULL

requests a full image copy for a partitioned table space

This option is required to create a copy of the subset of partitions in case 2.

COPY YES

Creates Db2 image copies of table space partitions 1 through 5, 8, and 16 (case 1)

Creates a single image copy of table space partitions 1 through 5 (case 2)

Because REGISTER is not specified, this statement defaults to REGISTER ALL. REORG PLUS makes four copies of the table space after reorganizing it registering all four copies in SYSIBM.SYSCOPY.

REDEFINE NO (case 1)

REDEFINE YES (default) (case 2)

In case 1, REDEFINE NO tells REORG PLUS not to delete and redefine the VSAM data sets containing the Db2 objects. Instead, REORG PLUS will reset the high-used RBA (HURBA).

In case 2, the default of REDEFINE YES tells REORG PLUS to delete and redefine the VSAM data sets containing the Db2 objects.

BMCSTATS YES

Tells REORG PLUS to save the BMC statistics in the DASD MANAGER PLUS database statistics tables

The JCL for this example also includes a DD statement for the ASUSRPRT data set. This DD statement tells REORG PLUS not to print the statistics from the Common Statistics component to SYSPRINT, but to send them to a separate data set. This example shows a portion of this ASUSRPRT data set for case 2.

SHRLEVEL NONE (case 1)

SHRLEVEL REFERENCE (case 2)

In case 1, the default SHRLEVEL NONE is used. The objects that you are reorganizing are stopped and unavailable during the job.

In case 2, SHRLEVEL REFERENCE is specified. The objects that you are reorganizing are available in read-only status during the job.

DDTYPE LOCBFCPY ACTIVE YES

DDTYPE REMPFCPY ACTIVE YES

DDTYPE REMBFCPY ACTIVE YES

Activates dynamic allocation for the local backup copy and the remote copies, overriding the installation defaults

The following figure shows the JCL for case 1 of example 3: 

//        JOB
//*
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//*   PARTITIONED TABLESPACE, 16 PARTS, 3 INDEXES, STOGROUP DEFINED   *
//*   -CLUSTERING INDEX, UNIQUE                                       *
//*   -SECONDARY INDEX, UNIQUE                                        *
//*   -SECONDARY INDEX, NONUNIQUE                                     *
//*                                                                   *
//*   REORG PART 1-5, 8 AND 16,
//*   ONE SYSREC PER PART,                                            *
//*   DO NOT REDEFINE SPACE                                           *
//*   MAKE 4 COPIES OF EACH PART REORGED.                             *
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//BMCREORG EXEC PGM=ARUUMAIN,
//             PARM='<db2ssid>,EXMPL03A,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=*
//SYSUDUMP  DD  SYSOUT=*
//SYSTERM   DD  SYSOUT=*
//ASUSRPRT  DD  SYSOUT=*
//*
//SYSIN     DD  *
REORG TABLESPACE ARUDB007.TS007 PART 1:5, 8, 16
      COPY YES
      REDEFINE NO
      BMCSTATS YES
      DDTYPE UNLOAD
        DSNPAT 'ARU.EXMPL03A.&DDNAME'
      DDTYPE WORK
        DSNPAT 'ARU.EXMPL03A.&DDNAME'
      DDTYPE LOCPFCPY
        DSNPAT 'ARU.EXMPL03A.&DDNAME'
      DDTYPE LOCBFCPY ACTIVE YES
        DSNPAT 'ARU.EXMPL03A.&DDNAME'
      DDTYPE REMPFCPY ACTIVE YES
        DSNPAT 'ARU.EXMPL03A.&DDNAME'
      DDTYPE REMBFCPY ACTIVE YES
        DSNPAT 'ARU.EXMPL03A.&DDNAME'
/*

 The following figure shows the JCL for case 2 of example 3:

//        JOB
//*
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//*   PARTITIONED TABLESPACE, 16 PARTS, 3 INDEXES, STOGROUP-DEFINED   *
//*   -CLUSTERING INDEX, UNIQUE                                       *
//*   -SECONDARY INDEX, UNIQUE                                        *
//*   -SECONDARY INDEX, NONUNIQUE                                     *
//*                                                                   *
//*   REORG PARTS 1-5,          SHRLEVEL REFERENCE                    *
//*   ONE SYSREC PER PART,                                            *
//*   REDEFINE SPACE (USING REDEFINE YES OPTION),                     *
//*   MAKE 4 COPIES OF EACH PART REORGED (LOCAL AND REMOTE COPIES),   *
//*   ONE IMAGE COPY DATASET FOR ALL PARTS (COPYSUBSET=YES).          *
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//BMCREORG EXEC PGM=ARUUMAIN,
//             PARM='db2ssid,EXMPL03B,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=*
//SYSUDUMP  DD  SYSOUT=*
//SYSTERM   DD  SYSOUT=*
//ASUSRPRT  DD  SYSOUT=*
//*
//SYSIN     DD  *
REORG TABLESPACE ARUDB007.TS007 PART 1:5
      SHRLEVEL REFERENCE
      COPY YES
      COPYLVL FULL
      BMCSTATS YES
      DDTYPE WORK
        DSNPAT 'ARU.EXMPL03B.&DDNAME'
      DDTYPE LOCPFCPY
        DSNPAT 'ARU.EXMPL03B.&DDNAME'
      DDTYPE LOCBFCPY ACTIVE YES
        DSNPAT 'ARU.EXMPL03B.&DDNAME'
      DDTYPE REMPFCPY ACTIVE YES
        DSNPAT 'ARU.EXMPL03B.&DDNAME'
      DDTYPE REMBFCPY ACTIVE YES
        DSNPAT 'ARU.EXMPL03B.&DDNAME'
/*

SYSPRINT for example 3, case 1

The following figure shows the SYSPRINT output for case 1 of example 3:

                                *****  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/05/2015   13:40:51 ...
 BMC50002I UTILITY ID = 'EXMPL03A'.  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=8836K,ABOVE 16M=1305696K,IEFUSI=NO,CPUS=3
 BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040310M,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 ARUDB007.TS007 PART 1:5, 8, 16
 BMC50102I       COPY YES
 BMC50102I       REDEFINE NO
 BMC50102I       BMCSTATS YES
 BMC50102I       DDTYPE UNLOAD
 BMC50102I         DSNPAT 'ARU.EXMPL03A.&DDNAME'
 BMC50102I       DDTYPE WORK
 BMC50102I         DSNPAT 'ARU.EXMPL03A.&DDNAME'
 BMC50102I       DDTYPE LOCPFCPY
 BMC50102I         DSNPAT 'ARU.EXMPL03A.&DDNAME'
 BMC50102I       DDTYPE LOCBFCPY ACTIVE YES
 BMC50102I         DSNPAT 'ARU.EXMPL03A.&DDNAME'
 BMC50102I       DDTYPE REMPFCPY ACTIVE YES
 BMC50102I         DSNPAT 'ARU.EXMPL03A.&DDNAME'
 BMC50102I       DDTYPE REMBFCPY ACTIVE YES
 BMC50102I         DSNPAT 'ARU.EXMPL03A.&DDNAME'

 BMC50004I UTILINIT PHASE COMPLETE.  ELAPSED TIME = 00:00:00

 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50244I PROCESSING PAGESET DBID(4086) PSID(2) PART(1) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00000000 FOR DBID(4086) PSID(2)
 BMC51301I 7: SAMPLING STATISTICS: PART=1,TP=94,SP=92,SR=1610,AVGR=101,SD=65,SE=0,AVGF=1750,SD=65,SE=147,EP=36
 BMC50244I PROCESSING PAGESET DBID(4086) PSID(2) PART(2) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00100000 FOR DBID(4086) PSID(2)
 BMC51301I 6: SAMPLING STATISTICS: PART=2,TP=3,SP=1,SR=10,AVGR=133,SD=64,SE=0,AVGF=1000,SD=64,SE=0,EP=0
 BMC50244I PROCESSING PAGESET DBID(4086) PSID(2) PART(3) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00200000 FOR DBID(4086) PSID(2)
 BMC51301I 5: SAMPLING STATISTICS: PART=3,TP=3,SP=1,SR=10,AVGR=159,SD=64,SE=0,AVGF=1000,SD=64,SE=0,EP=0
 BMC50244I PROCESSING PAGESET DBID(4086) PSID(2) PART(4) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00300000 FOR DBID(4086) PSID(2)
 BMC51301I 7: SAMPLING STATISTICS: PART=4,TP=3,SP=1,SR=10,AVGR=112,SD=64,SE=0,AVGF=1000,SD=64,SE=0,EP=0
 BMC50244I PROCESSING PAGESET DBID(4086) PSID(2) PART(5) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00400000 FOR DBID(4086) PSID(2)
 BMC50244I PROCESSING PAGESET DBID(4086) PSID(2) PART(8) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00700000 FOR DBID(4086) PSID(2)
 BMC50244I PROCESSING PAGESET DBID(4086) PSID(2) PART(16) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00F00000 FOR DBID(4086) PSID(2)
 BMC51301I 5: SAMPLING STATISTICS: PART=16,TP=23,SP=21,SR=404,AVGR=101,SD=65,SE=0,AVGF=1923,SD=65,SE=295,EP=6
 BMC51265I ESTIMATED CARDINALITY OF SPACE = 2044  AVG SORTWK ROW LENGTH = 101  AVG UNLOAD ROW LENGTH = 101
 BMC50484I ESTIMATED CARDINALITY OF PART 0001 = 1610  AVG SORTWK ROW LENGTH = 101  AVG UNLOAD ROW LENGTH = 101
 BMC50484I ESTIMATED CARDINALITY OF PART 0002 = 10  AVG SORTWK ROW LENGTH = 133  AVG UNLOAD ROW LENGTH = 133
 BMC50484I ESTIMATED CARDINALITY OF PART 0003 = 10  AVG SORTWK ROW LENGTH = 159  AVG UNLOAD ROW LENGTH = 159
 BMC50484I ESTIMATED CARDINALITY OF PART 0004 = 10  AVG SORTWK ROW LENGTH = 112  AVG UNLOAD ROW LENGTH = 112
 BMC50484I ESTIMATED CARDINALITY OF PART 0005 = 0  AVG SORTWK ROW LENGTH = 0  AVG UNLOAD ROW LENGTH = 0
 BMC50484I ESTIMATED CARDINALITY OF PART 0008 = 0  AVG SORTWK ROW LENGTH = 0  AVG UNLOAD ROW LENGTH = 0
 BMC50484I ESTIMATED CARDINALITY OF PART 0016 = 404  AVG SORTWK ROW LENGTH = 101  AVG UNLOAD ROW LENGTH = 101
 BMC51264I UNLOAD WILL READ 116 DATA PAGES FROM SPACE 'ARUDB007.TS007'
 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  = CXBAEXM3  &STEPNAME = BMCREORG  &DB       = ARUDB007  &TSIX     = TS007     &RTYPE    = TS
 BMC50425I &UID      = RDACXB2   &DATE     = 030515    &TIME     = 134051    &SSID     = DEHJ      &UTIL     = EXMPL03A
 BMC50425I &UTILPFX  = EXMPL03A  &UTILSFX  =           &DATE8    = 03052015  &GRPNM    = DEHJ      &VCAT     = DEHJCAT
 BMC50425I &TIME4    = 1340      &DATEJ    = 2015064   &JDATE    = 15064

 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.EXMPL03A.BMCCPY01                        SYSALLDA                        376       37        8         1  TRK
 BMC50448I BMCCPY02 ARU.EXMPL03A.BMCCPY02                        SYSALLDA                       1488      148       31         4  TRK
 BMC50448I BMCCPY03 ARU.EXMPL03A.BMCCPY03                        SYSALLDA                       1488      148       31         4  TRK
 BMC50448I BMCCPY04 ARU.EXMPL03A.BMCCPY04                        SYSALLDA                       1488      148       31         4  TRK
 BMC50448I BMCCPY05 ARU.EXMPL03A.BMCCPY05                        SYSALLDA                          8        0        1         0  TRK
 BMC50448I BMCCPY08 ARU.EXMPL03A.BMCCPY08                        SYSALLDA                          8        0        1         0  TRK
 BMC50448I BMCCPY16 ARU.EXMPL03A.BMCCPY16                        SYSALLDA                         92        9        2         1  TRK
 BMC50448I BMCCPZ01 ARU.EXMPL03A.BMCCPZ01                        SYSALLDA                        376       37        8         1  TRK
 BMC50448I BMCCPZ02 ARU.EXMPL03A.BMCCPZ02                        SYSALLDA                       1488      148       31         4  TRK
 BMC50448I BMCCPZ03 ARU.EXMPL03A.BMCCPZ03                        SYSALLDA                       1488      148       31         4  TRK
 BMC50448I BMCCPZ04 ARU.EXMPL03A.BMCCPZ04                        SYSALLDA                       1488      148       31         4  TRK
 BMC50448I BMCCPZ05 ARU.EXMPL03A.BMCCPZ05                        SYSALLDA                          8        0        1         0  TRK
 BMC50448I BMCCPZ08 ARU.EXMPL03A.BMCCPZ08                        SYSALLDA                          8        0        1         0  TRK
 BMC50448I BMCCPZ16 ARU.EXMPL03A.BMCCPZ16                        SYSALLDA                         92        9        2         1  TRK
 BMC50448I BMCRCY01 ARU.EXMPL03A.BMCRCY01                        SYSALLDA                        376       37        8         1  TRK
 BMC50448I BMCRCY02 ARU.EXMPL03A.BMCRCY02                        SYSALLDA                       1488      148       31         4  TRK
 BMC50448I BMCRCY03 ARU.EXMPL03A.BMCRCY03                        SYSALLDA                       1488      148       31         4  TRK
 BMC50448I BMCRCY04 ARU.EXMPL03A.BMCRCY04                        SYSALLDA                       1488      148       31         4  TRK
 BMC50448I BMCRCY05 ARU.EXMPL03A.BMCRCY05                        SYSALLDA                          8        0        1         0  TRK
 BMC50448I BMCRCY08 ARU.EXMPL03A.BMCRCY08                        SYSALLDA                          8        0        1         0  TRK
 BMC50448I BMCRCY16 ARU.EXMPL03A.BMCRCY16                        SYSALLDA                         92        9        2         1  TRK
 BMC50448I BMCRCZ01 ARU.EXMPL03A.BMCRCZ01                        SYSALLDA                        376       37        8         1  TRK
 BMC50448I BMCRCZ02 ARU.EXMPL03A.BMCRCZ02                        SYSALLDA                       1488      148       31         4  TRK
 BMC50448I BMCRCZ03 ARU.EXMPL03A.BMCRCZ03                        SYSALLDA                       1488      148       31         4  TRK
 BMC50448I BMCRCZ04 ARU.EXMPL03A.BMCRCZ04                        SYSALLDA                       1488      148       31         4  TRK
 BMC50448I BMCRCZ05 ARU.EXMPL03A.BMCRCZ05                        SYSALLDA                          8        0        1         0  TRK
 BMC50448I BMCRCZ08 ARU.EXMPL03A.BMCRCZ08                        SYSALLDA                          8        0        1         0  TRK
 BMC50448I BMCRCZ16 ARU.EXMPL03A.BMCRCZ16                        SYSALLDA                         92        9        2         1  TRK
 BMC50448I SYSREC01 ARU.EXMPL03A.SYSREC01                        SYSALLDA                        227       57        5         2  TRK
 BMC50448I SYSREC02 ARU.EXMPL03A.SYSREC02                        SYSALLDA                          2        1        1         1  TRK
 BMC50448I SYSREC03 ARU.EXMPL03A.SYSREC03                        SYSALLDA                          2        1        1         1  TRK
 BMC50448I SYSREC04 ARU.EXMPL03A.SYSREC04                        SYSALLDA                          2        1        1         1  TRK
 BMC50448I SYSREC05 ARU.EXMPL03A.SYSREC05                        SYSALLDA                          1        1        1         1  TRK
 BMC50448I SYSREC08 ARU.EXMPL03A.SYSREC08                        SYSALLDA                          1        1        1         1  TRK
 BMC50448I SYSREC16 ARU.EXMPL03A.SYSREC16                        SYSALLDA                         57       15        2         1  TRK
 BMC50448I SYSUT101 ARU.EXMPL03A.SYSUT101                        SYSALLDA                         56        6        2         1  TRK
 BMC50448I SYSUT102 ARU.EXMPL03A.SYSUT102                        SYSALLDA                         42        5        1         1  TRK

 BMC50394I UNABLE TO LOCATE SORT WORK DATASETS, DDNAME = 'SORTWKNN'
 BMC50509I STATISTICS COLLECTION FOR INDEX SPACE ARU.TS00712 BYPASSED DUE TO PARTIAL TABLE SPACE REORG
 BMC50509I STATISTICS COLLECTION FOR INDEX SPACE ARU.TS00713 BYPASSED DUE TO PARTIAL TABLE SPACE REORG
 BMC50474I BELOW 16M = 8128K, ABOVE 16M = 1290008K, CPUS = 3
 BMC50479I TOTAL PAGES: 4225223, ALLOWED: 0; AVAILABLE PAGES: 813013, ALLOWED: 813013
 BMC51302I MAX TASKS = 7, MAX PARTITIONS 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
 BMC50486I 5: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50477I 1: PARTITION =    1, ROWS/KEYS = 1610, I/O WAITS = 1 ,DDNAME = SYS00046
 BMC51271I UNLOAD STATISTICS:  1610 ROWS/KEYS UNLOADED FROM PARTITION 1
 BMC51281I UNLOAD STATISTICS:  X'0000000004CBAE4C4E4F' IS THE HIGHEST LOGRBA FOR PARTITION 1
 BMC50481I 1: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50486I 6: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50477I 5: PARTITION =    5, ROWS/KEYS = 0, I/O WAITS = 1 ,DDNAME = SYS00048
 BMC51271I UNLOAD STATISTICS:  0 ROWS/KEYS UNLOADED FROM PARTITION 5
 BMC51281I UNLOAD STATISTICS:  X'0000000004CBAC16C3EE' IS THE HIGHEST LOGRBA FOR PARTITION 5
 BMC50486I 2: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A001'
 BMC50477I 6: PARTITION =    8, ROWS/KEYS = 0, I/O WAITS = 1 ,DDNAME = SYS00050
 BMC51271I UNLOAD STATISTICS:  0 ROWS/KEYS UNLOADED FROM PARTITION 8
 BMC51281I UNLOAD STATISTICS:  X'0000000004CBAC441CE6' IS THE HIGHEST LOGRBA FOR PARTITION 8
 BMC50486I 7: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50477I 2: PARTITION =    2, ROWS/KEYS = 10, I/O WAITS = 1 ,DDNAME = SYS00053
 BMC50482I 5: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.ARUDB007.TS00711.I0001.A005'
 BMC50477I 5: PARTITION =    5, ROWS/KEYS = 0, I/O WAITS = 5 ,DDNAME = SYS00049
 BMC51271I UNLOAD STATISTICS:  10 ROWS/KEYS UNLOADED FROM PARTITION 2
 BMC51281I UNLOAD STATISTICS:  X'0000000004CBAE3A76F3' IS THE HIGHEST LOGRBA FOR PARTITION 2
 BMC50481I 2: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50486I 4: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.ARUDB007.TS00711.I0001.A001'
 BMC50477I 1: PARTITION =    1, ROWS/KEYS = 1610, I/O WAITS = 5 ,DDNAME = SYS00051
 BMC50477I 7: PARTITION =   16, ROWS/KEYS = 414, I/O WAITS = 1 ,DDNAME = SYS00056
 BMC51271I UNLOAD STATISTICS:  414 ROWS/KEYS UNLOADED FROM PARTITION 16
 BMC51281I UNLOAD STATISTICS:  X'0000000004CBAE516791' IS THE HIGHEST LOGRBA FOR PARTITION 16
 BMC50482I 6: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.ARUDB007.TS00711.I0001.A008'
 BMC50477I 6: PARTITION =    8, ROWS/KEYS = 0, I/O WAITS = 5 ,DDNAME = SYS00052
 BMC50486I 3: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50481I 7: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A005'
 BMC50482I 1: RELOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A001'
 BMC50477I 1: PARTITION =    1, ROWS/KEYS = 1610, I/O WAITS = 3 ,DDNAME = SYS00047
 BMC51274I RELOAD STATISTICS:  1610 ROWS/KEYS LOADED INTO PARTITION 1
 BMC50477I 4: PARTITION =    4, ROWS/KEYS = 10, I/O WAITS = 1 ,DDNAME = SYS00057
 BMC50482I 5: RELOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A005'
 BMC50477I 5: PARTITION =    5, ROWS/KEYS = 0, I/O WAITS = 3 ,DDNAME = SYS00054
 BMC51274I RELOAD STATISTICS:  0 ROWS/KEYS LOADED INTO PARTITION 5
 BMC51271I UNLOAD STATISTICS:  10 ROWS/KEYS UNLOADED FROM PARTITION 4
 BMC51281I UNLOAD STATISTICS:  X'0000000004CBAE3ADA8C' IS THE HIGHEST LOGRBA FOR PARTITION 4
 BMC50481I 4: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50477I 3: PARTITION =    3, ROWS/KEYS = 10, I/O WAITS = 1 ,DDNAME = SYS00060
 BMC51271I UNLOAD STATISTICS:  10 ROWS/KEYS UNLOADED FROM PARTITION 3
 BMC51281I UNLOAD STATISTICS:  X'0000000004CBAE3AA905' IS THE HIGHEST LOGRBA FOR PARTITION 3
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A002'
 BMC51272I UNLOAD STATISTICS:  2054 ROWS UNLOADED FROM SPACE 'ARUDB007.TS007', 0 ROWS DISCARDED, 0 ROWS UPDATED
 BMC51282I UNLOAD STATISTICS:  X'0000000004CBAE516791' IS THE HIGHEST LOGRBA FOR SPACE 'ARUDB007.TS007'
 BMC50481I 3: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50476I DDNAME = BMCCPY01, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPZ01, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCY01, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCZ01, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50376I 65 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPY01'
 BMC50376I 65 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPZ01'
 BMC50376I 65 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCY01'
 BMC50376I 65 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCZ01'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A016'
 BMC50481I 1: REORG TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50482I 2: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.ARUDB007.TS00711.I0001.A002'
 BMC50477I 2: PARTITION =    2, ROWS/KEYS = 10, I/O WAITS = 5 ,DDNAME = SYS00062
 BMC50482I 2: RELOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A002'
 BMC50477I 2: PARTITION =    2, ROWS/KEYS = 10, I/O WAITS = 3 ,DDNAME = SYS00055
 BMC51274I RELOAD STATISTICS:  10 ROWS/KEYS LOADED INTO PARTITION 2
 BMC50476I DDNAME = BMCCPY05, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPZ05, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCY05, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCZ05, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 3 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPY05'
 BMC50376I 3 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPZ05'
 BMC50376I 3 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCY05'
 BMC50376I 3 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCZ05'
 BMC50481I 5: REORG TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A008'
 BMC50482I 7: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.ARUDB007.TS00711.I0001.A016'
 BMC50477I 7: PARTITION =   16, ROWS/KEYS = 414, I/O WAITS = 5 ,DDNAME = SYS00064
 BMC50482I 6: RELOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A008'
 BMC50477I 6: PARTITION =    8, ROWS/KEYS = 0, I/O WAITS = 3 ,DDNAME = SYS00058
 BMC51274I RELOAD STATISTICS:  0 ROWS/KEYS LOADED INTO PARTITION 8
 BMC50482I 7: RELOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A016'
 BMC50477I 7: PARTITION =   16, ROWS/KEYS = 414, I/O WAITS = 3 ,DDNAME = SYS00059
 BMC51274I RELOAD STATISTICS:  414 ROWS/KEYS LOADED INTO PARTITION 16
 BMC50476I DDNAME = BMCCPY02, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPZ02, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCY02, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCZ02, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPY02'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPZ02'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCY02'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCZ02'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A004'
 BMC50481I 2: REORG TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50476I DDNAME = BMCCPY08, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPZ08, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCY08, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCZ08, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 3 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPY08'
 BMC50376I 3 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPZ08'
 BMC50376I 3 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCY08'
 BMC50376I 3 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCZ08'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A003'
 BMC50481I 6: REORG TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50476I DDNAME = BMCCPY16, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPZ16, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCY16, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCZ16, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50376I 19 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPY16'
 BMC50376I 19 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPZ16'
 BMC50376I 19 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCY16'
 BMC50376I 19 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCZ16'
 BMC50482I 4: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.ARUDB007.TS00711.I0001.A004'
 BMC50477I 4: PARTITION =    4, ROWS/KEYS = 10, I/O WAITS = 5 ,DDNAME = SYS00065
 BMC50482I 4: RELOAD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A004'
 BMC50477I 4: PARTITION =    4, ROWS/KEYS = 10, I/O WAITS = 3 ,DDNAME = SYS00061
 BMC51274I RELOAD STATISTICS:  10 ROWS/KEYS LOADED INTO PARTITION 4
 BMC50481I 7: REORG TASK COMPLETE.  ELAPSED TIME = 00:00:02
 BMC50476I DDNAME = BMCCPY04, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPZ04, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCY04, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCZ04, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPY04'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPZ04'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCY04'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCZ04'
 BMC50482I 3: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.ARUDB007.TS00711.I0001.A003'
 BMC50477I 3: PARTITION =    3, ROWS/KEYS = 10, I/O WAITS = 5 ,DDNAME = SYS00066
 BMC50481I 4: REORG TASK COMPLETE.  ELAPSED TIME = 00:00:02
 BMC50482I 3: RELOAD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A003'
 BMC50477I 3: PARTITION =    3, ROWS/KEYS = 10, I/O WAITS = 3 ,DDNAME = SYS00063
 BMC51274I RELOAD STATISTICS:  10 ROWS/KEYS LOADED INTO PARTITION 3
 BMC50476I DDNAME = BMCCPY03, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPZ03, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCY03, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCZ03, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPY03'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPZ03'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCY03'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCZ03'
 BMC50481I 3: REORG TASK COMPLETE.  ELAPSED TIME = 00:00:02
 BMC50476I DDNAME = SYSREC01, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC02, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC03, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC04, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC05, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC08, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC16, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSUT101, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSUT102, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC51276I BUILD  STATISTICS:  2054 KEYS LOADED INTO INDEX 'ARU.TS00711'
 BMC51275I RELOAD STATISTICS:  2054 ROWS LOADED INTO SPACE 'ARUDB007.TS007'
 BMC50474I BELOW 16M = 7996K, ABOVE 16M = 1287684K, CPUS = 3
 BMC50479I TOTAL PAGES: 4215763, ALLOWED: 0; AVAILABLE PAGES: 812205, ALLOWED: 812205
 BMC51303I MAX TASKS = 2, INDEXES PER TASK = 1, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 2
 BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 2: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50476I DDNAME = SYSUT101, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50481I 1: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50482I 1: UPDATE COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.ARUDB007.TS00712.I0001.A001'
 BMC50477I 1: PARTITION =    0, ROWS/KEYS = 2054, I/O WAITS = 6 ,DDNAME = SYS00069
 BMC51277I BUILD  STATISTICS:  2054 KEY-RID PAIRS UPDATED IN INDEX 'ARU.TS00712'
 BMC50476I DDNAME = SYSUT102, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50481I 2: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50482I 2: UPDATE COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.ARUDB007.TS00713.I0001.A001'
 BMC50477I 2: PARTITION =    0, ROWS/KEYS = 2054, I/O WAITS = 7 ,DDNAME = SYS00070
 BMC51277I BUILD  STATISTICS:  2054 KEY-RID PAIRS UPDATED IN INDEX 'ARU.TS00713'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT102', DSNAME = 'ARU.EXMPL03A.SYSUT102'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT101', DSNAME = 'ARU.EXMPL03A.SYSUT101'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC16', DSNAME = 'ARU.EXMPL03A.SYSREC16'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC08', DSNAME = 'ARU.EXMPL03A.SYSREC08'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC05', DSNAME = 'ARU.EXMPL03A.SYSREC05'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC04', DSNAME = 'ARU.EXMPL03A.SYSREC04'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC03', DSNAME = 'ARU.EXMPL03A.SYSREC03'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC02', DSNAME = 'ARU.EXMPL03A.SYSREC02'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC01', DSNAME = 'ARU.EXMPL03A.SYSREC01'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I REORG PHASE COMPLETE.  ELAPSED TIME = 00:00:11

 BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR REORG UTILITY SUCCESSFUL FOR ALL OBJECTS
 BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0

SYSPRINT for example 3, case 2

The following figure shows the SYSPRINT output for case 2 of example 3:

                                *****  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/05/2015   13:41:55 ...
 BMC50002I UTILITY ID = 'EXMPL03B'.  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=8836K,ABOVE 16M=1304160K,IEFUSI=NO,CPUS=3
 BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040306M,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 ARUDB007.TS007 PART 1:5
 BMC50102I       SHRLEVEL REFERENCE
 BMC50102I       COPY YES
 BMC50102I       COPYLVL FULL
 BMC50102I       BMCSTATS YES
 BMC50102I       DDTYPE WORK
 BMC50102I         DSNPAT 'ARU.EXMPL03B.&DDNAME'
 BMC50102I       DDTYPE LOCPFCPY
 BMC50102I         DSNPAT 'ARU.EXMPL03B.&DDNAME'
 BMC50102I       DDTYPE LOCBFCPY ACTIVE YES
 BMC50102I         DSNPAT 'ARU.EXMPL03B.&DDNAME'
 BMC50102I       DDTYPE REMPFCPY ACTIVE YES
 BMC50102I         DSNPAT 'ARU.EXMPL03B.&DDNAME'
 BMC50102I       DDTYPE REMBFCPY ACTIVE YES
 BMC50102I         DSNPAT 'ARU.EXMPL03B.&DDNAME'

 BMC50138I 'COPYLVL FULL' CHANGED TO 'COPYLVL PART' DUE TO PARTIAL REORG AND COPYSUBSET NOT TURNED ON
 BMC50004I UTILINIT PHASE COMPLETE.  ELAPSED TIME = 00:00:00

 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50244I PROCESSING PAGESET DBID(4086) PSID(2) PART(1) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00000000 FOR DBID(4086) PSID(2)
 BMC51301I 5: SAMPLING STATISTICS: PART=1,TP=64,SP=62,SR=1610,AVGR=101,SD=65,SE=0,AVGF=2596,SD=65,SE=110,EP=6
 BMC50244I PROCESSING PAGESET DBID(4086) PSID(2) PART(2) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00100000 FOR DBID(4086) PSID(2)
 BMC51301I 4: SAMPLING STATISTICS: PART=2,TP=3,SP=1,SR=10,AVGR=133,SD=64,SE=0,AVGF=1000,SD=64,SE=0,EP=0
 BMC50244I PROCESSING PAGESET DBID(4086) PSID(2) PART(3) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00200000 FOR DBID(4086) PSID(2)
 BMC51301I 3: SAMPLING STATISTICS: PART=3,TP=3,SP=1,SR=10,AVGR=159,SD=64,SE=0,AVGF=1000,SD=64,SE=0,EP=0
 BMC50244I PROCESSING PAGESET DBID(4086) PSID(2) PART(4) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00300000 FOR DBID(4086) PSID(2)
 BMC51301I 5: SAMPLING STATISTICS: PART=4,TP=3,SP=1,SR=10,AVGR=112,SD=64,SE=0,AVGF=1000,SD=64,SE=0,EP=0
 BMC50244I PROCESSING PAGESET DBID(4086) PSID(2) PART(5) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00400000 FOR DBID(4086) PSID(2)
 BMC51265I ESTIMATED CARDINALITY OF SPACE = 1640  AVG SORTWK ROW LENGTH = 102  AVG UNLOAD ROW LENGTH = 102
 BMC50484I ESTIMATED CARDINALITY OF PART 0001 = 1610  AVG SORTWK ROW LENGTH = 101  AVG UNLOAD ROW LENGTH = 101
 BMC50484I ESTIMATED CARDINALITY OF PART 0002 = 10  AVG SORTWK ROW LENGTH = 133  AVG UNLOAD ROW LENGTH = 133
 BMC50484I ESTIMATED CARDINALITY OF PART 0003 = 10  AVG SORTWK ROW LENGTH = 159  AVG UNLOAD ROW LENGTH = 159
 BMC50484I ESTIMATED CARDINALITY OF PART 0004 = 10  AVG SORTWK ROW LENGTH = 112  AVG UNLOAD ROW LENGTH = 112
 BMC50484I ESTIMATED CARDINALITY OF PART 0005 = 0  AVG SORTWK ROW LENGTH = 0  AVG UNLOAD ROW LENGTH = 0
 BMC51264I UNLOAD WILL READ 65 DATA PAGES FROM SPACE 'ARUDB007.TS007'
 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  = CXBBEXM3  &STEPNAME = BMCREORG  &DB       = ARUDB007  &TSIX     = TS007     &RTYPE    = TS
 BMC50425I &UID      = RDACXB2   &DATE     = 030515    &TIME     = 134155    &SSID     = DEHJ      &UTIL     = EXMPL03B
 BMC50425I &UTILPFX  = EXMPL03B  &UTILSFX  =           &DATE8    = 03052015  &GRPNM    = DEHJ      &VCAT     = DEHJCAT
 BMC50425I &TIME4    = 1341      &DATEJ    = 2015064   &JDATE    = 15064

 BMC50877I POINT OF CONSISTENCY ESTABLISHED AT RBA/LRSN = 0000000004CBAE7FE000
 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.EXMPL03B.BMCCPY01                        SYSALLDA                        256       25        6         1  TRK
 BMC50448I BMCCPY02 ARU.EXMPL03B.BMCCPY02                        SYSALLDA                         12        1        1         1  TRK
 BMC50448I BMCCPY03 ARU.EXMPL03B.BMCCPY03                        SYSALLDA                         12        1        1         1  TRK
 BMC50448I BMCCPY04 ARU.EXMPL03B.BMCCPY04                        SYSALLDA                         12        1        1         1  TRK
 BMC50448I BMCCPY05 ARU.EXMPL03B.BMCCPY05                        SYSALLDA                          8        0        1         0  TRK
 BMC50448I BMCCPZ01 ARU.EXMPL03B.BMCCPZ01                        SYSALLDA                        256       25        6         1  TRK
 BMC50448I BMCCPZ02 ARU.EXMPL03B.BMCCPZ02                        SYSALLDA                         12        1        1         1  TRK
 BMC50448I BMCCPZ03 ARU.EXMPL03B.BMCCPZ03                        SYSALLDA                         12        1        1         1  TRK
 BMC50448I BMCCPZ04 ARU.EXMPL03B.BMCCPZ04                        SYSALLDA                         12        1        1         1  TRK
 BMC50448I BMCCPZ05 ARU.EXMPL03B.BMCCPZ05                        SYSALLDA                          8        0        1         0  TRK
 BMC50448I BMCRCY01 ARU.EXMPL03B.BMCRCY01                        SYSALLDA                        256       25        6         1  TRK
 BMC50448I BMCRCY02 ARU.EXMPL03B.BMCRCY02                        SYSALLDA                         12        1        1         1  TRK
 BMC50448I BMCRCY03 ARU.EXMPL03B.BMCRCY03                        SYSALLDA                         12        1        1         1  TRK
 BMC50448I BMCRCY04 ARU.EXMPL03B.BMCRCY04                        SYSALLDA                         12        1        1         1  TRK
 BMC50448I BMCRCY05 ARU.EXMPL03B.BMCRCY05                        SYSALLDA                          8        0        1         0  TRK
 BMC50448I BMCRCZ01 ARU.EXMPL03B.BMCRCZ01                        SYSALLDA                        256       25        6         1  TRK
 BMC50448I BMCRCZ02 ARU.EXMPL03B.BMCRCZ02                        SYSALLDA                         12        1        1         1  TRK
 BMC50448I BMCRCZ03 ARU.EXMPL03B.BMCRCZ03                        SYSALLDA                         12        1        1         1  TRK
 BMC50448I BMCRCZ04 ARU.EXMPL03B.BMCRCZ04                        SYSALLDA                         12        1        1         1  TRK
 BMC50448I BMCRCZ05 ARU.EXMPL03B.BMCRCZ05                        SYSALLDA                          8        0        1         0  TRK
 BMC50448I SYSUT101 ARU.EXMPL03B.SYSUT101                        SYSALLDA                         45        5        1         1  TRK
 BMC50448I SYSUT102 ARU.EXMPL03B.SYSUT102                        SYSALLDA                         34        4        1         1  TRK

 BMC50394I UNABLE TO LOCATE SORT WORK DATASETS, DDNAME = 'SORTWKNN'
 BMC50509I STATISTICS COLLECTION FOR INDEX SPACE ARU.TS00712 BYPASSED DUE TO PARTIAL TABLE SPACE REORG
 BMC50509I STATISTICS COLLECTION FOR INDEX SPACE ARU.TS00713 BYPASSED DUE TO PARTIAL TABLE SPACE REORG
 BMC50474I BELOW 16M = 8160K, ABOVE 16M = 1292884K, CPUS = 3
 BMC50388I 17: COPY OF SECONDARY INDEX: 'DEHJCAT.DSNDBD.ARUDB007.TS00712.I0001.A001' STARTED
 BMC50388I 18: COPY OF SECONDARY INDEX: 'DEHJCAT.DSNDBD.ARUDB007.TS00713.I0001.A001' STARTED
 BMC50389I 17: COPY OF SECONDARY INDEX: 'DEHJCAT.DSNDBD.ARUDB007.TS00712.I0001.A001' COMPLETE
 BMC50389I 18: COPY OF SECONDARY INDEX: 'DEHJCAT.DSNDBD.ARUDB007.TS00713.I0001.A001' COMPLETE
 BMC50479I TOTAL PAGES: 4337033, ALLOWED: 0; AVAILABLE PAGES: 1019593, ALLOWED: 1019593
 BMC51302I MAX TASKS = 5, MAX PARTITIONS 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
 BMC50486I 5: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50477I 1: PARTITION =    1, ROWS/KEYS = 1610, I/O WAITS = 1 ,DDNAME = SYS00039
 BMC51271I UNLOAD STATISTICS:  1610 ROWS/KEYS UNLOADED FROM PARTITION 1
 BMC51281I UNLOAD STATISTICS:  X'0000000004CBAE55C000' IS THE HIGHEST LOGRBA FOR PARTITION 1
 BMC50481I 1: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50486I 4: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50477I 5: PARTITION =    5, ROWS/KEYS = 0, I/O WAITS = 1 ,DDNAME = SYS00040
 BMC51271I UNLOAD STATISTICS:  0 ROWS/KEYS UNLOADED FROM PARTITION 5
 BMC51281I UNLOAD STATISTICS:  X'0000000004CBAE55C000' IS THE HIGHEST LOGRBA FOR PARTITION 5
 BMC50486I 3: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50477I 4: PARTITION =    4, ROWS/KEYS = 10, I/O WAITS = 1 ,DDNAME = SYS00043
 BMC51271I UNLOAD STATISTICS:  10 ROWS/KEYS UNLOADED FROM PARTITION 4
 BMC51281I UNLOAD STATISTICS:  X'0000000004CBAE55C000' IS THE HIGHEST LOGRBA FOR PARTITION 4
 BMC50481I 4: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A001'
 BMC50486I 2: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50477I 3: PARTITION =    3, ROWS/KEYS = 10, I/O WAITS = 1 ,DDNAME = SYS00048
 BMC51271I UNLOAD STATISTICS:  10 ROWS/KEYS UNLOADED FROM PARTITION 3
 BMC51281I UNLOAD STATISTICS:  X'0000000004CBAE55C000' IS THE HIGHEST LOGRBA FOR PARTITION 3
 BMC50481I 3: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50482I 5: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.BMCDBD.ARUDB007.TS00711.I0001.A005'
 BMC50477I 5: PARTITION =    5, ROWS/KEYS = 0, I/O WAITS = 5 ,DDNAME = SYS00045
 BMC50477I 2: PARTITION =    2, ROWS/KEYS = 10, I/O WAITS = 1 ,DDNAME = SYS00051
 BMC51271I UNLOAD STATISTICS:  10 ROWS/KEYS UNLOADED FROM PARTITION 2
 BMC51281I UNLOAD STATISTICS:  X'0000000004CBAE55C000' IS THE HIGHEST LOGRBA FOR PARTITION 2
 BMC51272I UNLOAD STATISTICS:  1640 ROWS UNLOADED FROM SPACE 'ARUDB007.TS007', 0 ROWS DISCARDED, 0 ROWS UPDATED
 BMC51282I UNLOAD STATISTICS:  X'0000000004CBAE55C000' IS THE HIGHEST LOGRBA FOR SPACE 'ARUDB007.TS007'
 BMC50481I 2: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A004'
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.BMCDBD.ARUDB007.TS00711.I0001.A001'
 BMC50477I 1: PARTITION =    1, ROWS/KEYS = 1610, I/O WAITS = 5 ,DDNAME = SYS00050
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A003'
 BMC50482I 1: RELOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A001'
 BMC50477I 1: PARTITION =    1, ROWS/KEYS = 1610, I/O WAITS = 3 ,DDNAME = SYS00042
 BMC51274I RELOAD STATISTICS:  1610 ROWS/KEYS LOADED INTO PARTITION 1
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A005'
 BMC50476I DDNAME = BMCCPY01, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPZ01, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCY01, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCZ01, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50376I 65 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCCPY01'
 BMC50376I 65 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCCPZ01'
 BMC50376I 65 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCRCY01'
 BMC50376I 65 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCRCZ01'
 BMC50482I 4: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.BMCDBD.ARUDB007.TS00711.I0001.A004'
 BMC50477I 4: PARTITION =    4, ROWS/KEYS = 10, I/O WAITS = 5 ,DDNAME = SYS00059
 BMC50482I 5: RELOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A005'
 BMC50477I 5: PARTITION =    5, ROWS/KEYS = 0, I/O WAITS = 3 ,DDNAME = SYS00056
 BMC51274I RELOAD STATISTICS:  0 ROWS/KEYS LOADED INTO PARTITION 5
 BMC50482I 4: RELOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A004'
 BMC50477I 4: PARTITION =    4, ROWS/KEYS = 10, I/O WAITS = 3 ,DDNAME = SYS00049
 BMC51274I RELOAD STATISTICS:  10 ROWS/KEYS LOADED INTO PARTITION 4
 BMC50481I 1: REORG TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50482I 3: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.BMCDBD.ARUDB007.TS00711.I0001.A003'
 BMC50477I 3: PARTITION =    3, ROWS/KEYS = 10, I/O WAITS = 5 ,DDNAME = SYS00061
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A002'
 BMC50476I DDNAME = BMCCPY05, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPZ05, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCY05, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCZ05, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 3 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCCPY05'
 BMC50376I 3 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCCPZ05'
 BMC50376I 3 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCRCY05'
 BMC50376I 3 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCRCZ05'
 BMC50482I 3: RELOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A003'
 BMC50477I 3: PARTITION =    3, ROWS/KEYS = 10, I/O WAITS = 3 ,DDNAME = SYS00055
 BMC51274I RELOAD STATISTICS:  10 ROWS/KEYS LOADED INTO PARTITION 3
 BMC50481I 5: REORG TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50476I DDNAME = BMCCPY04, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPZ04, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCY04, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCZ04, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCCPY04'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCCPZ04'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCRCY04'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCRCZ04'
 BMC50476I DDNAME = BMCCPY03, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPZ03, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCY03, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCZ03, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCCPY03'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCCPZ03'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCRCY03'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCRCZ03'
 BMC50481I 4: REORG TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50481I 3: REORG TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50482I 2: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.BMCDBD.ARUDB007.TS00711.I0001.A002'
 BMC50477I 2: PARTITION =    2, ROWS/KEYS = 10, I/O WAITS = 5 ,DDNAME = SYS00063
 BMC50482I 2: RELOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A002'
 BMC50477I 2: PARTITION =    2, ROWS/KEYS = 10, I/O WAITS = 3 ,DDNAME = SYS00058
 BMC51274I RELOAD STATISTICS:  10 ROWS/KEYS LOADED INTO PARTITION 2
 BMC50476I DDNAME = BMCCPY02, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPZ02, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCY02, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCZ02, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCCPY02'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCCPZ02'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCRCY02'
 BMC50376I 4 PAGES COPIED TO DATASET = 'ARU.EXMPL03B.BMCRCZ02'
 BMC50481I 2: REORG TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50476I DDNAME = SYSUT101, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSUT102, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC51276I BUILD  STATISTICS:  1640 KEYS LOADED INTO INDEX 'ARU.TS00711'
 BMC51275I RELOAD STATISTICS:  1640 ROWS LOADED INTO SPACE 'ARUDB007.TS007'
 BMC50474I BELOW 16M = 8032K, ABOVE 16M = 1289952K, CPUS = 3
 BMC50479I TOTAL PAGES: 4281473, ALLOWED: 0; AVAILABLE PAGES: 1019801, ALLOWED: 1019801
 BMC51303I MAX TASKS = 2, INDEXES PER TASK = 1, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 2
 BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 2: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50476I DDNAME = SYSUT101, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50481I 1: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50482I 1: UPDATE COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.BMCDBD.ARUDB007.TS00712.I0001.A001'
 BMC50477I 1: PARTITION =    0, ROWS/KEYS = 1640, I/O WAITS = 6 ,DDNAME = SYS00066
 BMC50476I DDNAME = SYSUT102, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50481I 2: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51277I BUILD  STATISTICS:  1640 KEY-RID PAIRS UPDATED IN INDEX 'ARU.TS00712'
 BMC50482I 2: UPDATE COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.BMCDBD.ARUDB007.TS00713.I0001.A001'
 BMC50477I 2: PARTITION =    0, ROWS/KEYS = 1640, I/O WAITS = 5 ,DDNAME = SYS00067
 BMC51277I BUILD  STATISTICS:  1640 KEY-RID PAIRS UPDATED IN INDEX 'ARU.TS00713'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT102', DSNAME = 'ARU.EXMPL03B.SYSUT102'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT101', DSNAME = 'ARU.EXMPL03B.SYSUT101'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I REORG PHASE COMPLETE.  ELAPSED TIME = 00:00:07

 BMC50894I RENAME PROCESS STARTING AT   3/05/2015  13:42:05
 BMC50890I 11: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS00712.I0001.A001'...
 BMC50890I 12: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS00713.I0001.A001'...
 BMC50890I 1: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS007.I0001.A001'...
 BMC50890I 8: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS00711.I0001.A003'...
 BMC50890I 6: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS00711.I0001.A001'...
 BMC50890I 9: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS00711.I0001.A004'...
 BMC50890I 5: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS007.I0001.A005'...
 BMC50890I 10: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS00711.I0001.A005'...
 BMC50890I 7: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS00711.I0001.A002'...
 BMC50890I 4: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS007.I0001.A004'...
 BMC50891I 11: DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS00712.I0001.A001' IS RENAMED
 BMC50890I 2: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS007.I0001.A002'...
 BMC50890I 3: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS007.I0001.A003'...
 BMC50891I 12: DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS00713.I0001.A001' IS RENAMED
 BMC50890I 11: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS00712.I0001.A001'...
 BMC50891I 1: DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS007.I0001.A001' IS RENAMED
 BMC50890I 12: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS00713.I0001.A001'...
 BMC50890I 1: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A001'...
 BMC50891I 6: DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS00711.I0001.A001' IS RENAMED
 BMC50891I 4: DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS007.I0001.A004' IS RENAMED
 BMC50891I 9: DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS00711.I0001.A004' IS RENAMED
 BMC50891I 7: DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS00711.I0001.A002' IS RENAMED
 BMC50890I 6: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS00711.I0001.A001'...
 BMC50891I 8: DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS00711.I0001.A003' IS RENAMED
 BMC50890I 4: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A004'...
 BMC50890I 7: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS00711.I0001.A002'...
 BMC50890I 9: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS00711.I0001.A004'...
 BMC50891I 2: DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS007.I0001.A002' IS RENAMED
 BMC50891I 10: DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS00711.I0001.A005' IS RENAMED
 BMC50891I 5: DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS007.I0001.A005' IS RENAMED
 BMC50891I 3: DATASET 'DEHJCAT.DSNDBC.ARUDB007.TS007.I0001.A003' IS RENAMED
 BMC50890I 8: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS00711.I0001.A003'...
 BMC50891I 11: DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS00712.I0001.A001' IS RENAMED
 BMC50890I 2: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A002'...
 BMC50890I 10: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS00711.I0001.A005'...
 BMC50890I 3: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A003'...
 BMC50890I 11: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS00712.I0001.A001'...
 BMC50890I 5: ATTEMPTING TO RENAME DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A005'...
 BMC50891I 11: DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS00712.I0001.A001' IS RENAMED
 BMC50890I 11: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS00712.I0001.A001'...
 BMC50891I 12: DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS00713.I0001.A001' IS RENAMED
 BMC50890I 12: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS00713.I0001.A001'...
 BMC50891I 12: DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS00713.I0001.A001' IS RENAMED
 BMC50890I 12: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS00713.I0001.A001'...
 BMC50891I 1: DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A001' IS RENAMED
 BMC50890I 1: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS007.I0001.A001'...
 BMC50891I 1: DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS007.I0001.A001' IS RENAMED
 BMC50890I 1: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A001'...
 BMC50891I 6: DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS00711.I0001.A001' IS RENAMED
 BMC50890I 6: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS00711.I0001.A001'...
 BMC50891I 6: DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS00711.I0001.A001' IS RENAMED
 BMC50890I 6: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS00711.I0001.A001'...
 BMC50891I 8: DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS00711.I0001.A003' IS RENAMED
 BMC50890I 8: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS00711.I0001.A003'...
 BMC50891I 8: DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS00711.I0001.A003' IS RENAMED
 BMC50890I 8: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS00711.I0001.A003'...
 BMC50891I 9: DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS00711.I0001.A004' IS RENAMED
 BMC50890I 9: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS00711.I0001.A004'...
 BMC50891I 9: DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS00711.I0001.A004' IS RENAMED
 BMC50890I 9: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS00711.I0001.A004'...
 BMC50891I 4: DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A004' IS RENAMED
 BMC50890I 4: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS007.I0001.A004'...
 BMC50891I 4: DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS007.I0001.A004' IS RENAMED
 BMC50890I 4: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A004'...
 BMC50891I 7: DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS00711.I0001.A002' IS RENAMED
 BMC50890I 7: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS00711.I0001.A002'...
 BMC50891I 7: DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS00711.I0001.A002' IS RENAMED
 BMC50890I 7: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS00711.I0001.A002'...
 BMC50891I 10: DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS00711.I0001.A005' IS RENAMED
 BMC50890I 10: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS00711.I0001.A005'...
 BMC50891I 10: DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS00711.I0001.A005' IS RENAMED
 BMC50890I 10: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS00711.I0001.A005'...
 BMC50891I 2: DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A002' IS RENAMED
 BMC50890I 2: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS007.I0001.A002'...
 BMC50891I 2: DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS007.I0001.A002' IS RENAMED
 BMC50890I 2: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A002'...
 BMC50891I 3: DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A003' IS RENAMED
 BMC50890I 3: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS007.I0001.A003'...
 BMC50891I 3: DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS007.I0001.A003' IS RENAMED
 BMC50890I 3: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A003'...
 BMC50891I 5: DATASET 'DEHJCAT.DSNDBD.ARUDB007.TS007.I0001.A005' IS RENAMED
 BMC50890I 5: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS007.I0001.A005'...
 BMC50891I 11: DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS00712.I0001.A001' IS RENAMED
 BMC50891I 5: DATASET 'DEHJCAT.BMCDBC.ARUDB007.TS007.I0001.A005' IS RENAMED
 BMC50890I 5: ATTEMPTING TO RENAME DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A005'...
 BMC50891I 12: DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS00713.I0001.A001' IS RENAMED
 BMC50891I 1: DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A001' IS RENAMED
 BMC50891I 6: DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS00711.I0001.A001' IS RENAMED
 BMC50891I 8: DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS00711.I0001.A003' IS RENAMED
 BMC50891I 9: DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS00711.I0001.A004' IS RENAMED
 BMC50891I 4: DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A004' IS RENAMED
 BMC50891I 7: DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS00711.I0001.A002' IS RENAMED
 BMC50891I 10: DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS00711.I0001.A005' IS RENAMED
 BMC50891I 2: DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A002' IS RENAMED
 BMC50891I 3: DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A003' IS RENAMED
 BMC50891I 5: DATASET 'DEHJCAT.BMCDBD.ARUDB007.TS007.I0001.A005' IS RENAMED
 BMC50895I RENAME PROCESS COMPLETE.  ELAPSED TIME =  00:00:01

 BMC50890I 1: ATTEMPTING TO DELETE DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS007.I0001.A001'...
 BMC50890I 9: ATTEMPTING TO DELETE DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS00711.I0001.A004'...
 BMC50890I 3: ATTEMPTING TO DELETE DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS007.I0001.A003'...
 BMC50890I 4: ATTEMPTING TO DELETE DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS007.I0001.A004'...
 BMC50890I 8: ATTEMPTING TO DELETE DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS00711.I0001.A003'...
 BMC50890I 7: ATTEMPTING TO DELETE DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS00711.I0001.A002'...
 BMC50890I 2: ATTEMPTING TO DELETE DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS007.I0001.A002'...
 BMC50890I 6: ATTEMPTING TO DELETE DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS00711.I0001.A001'...
 BMC50890I 12: ATTEMPTING TO DELETE DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS00713.I0001.A001'...
 BMC50890I 10: ATTEMPTING TO DELETE DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS00711.I0001.A005'...
 BMC50890I 5: ATTEMPTING TO DELETE DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS007.I0001.A005'...
 BMC50890I 11: ATTEMPTING TO DELETE DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS00712.I0001.A001'...
 BMC50891I 1: DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS007.I0001.A001' IS DELETED
 BMC50891I 10: DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS00711.I0001.A005' IS DELETED
 BMC50891I 3: DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS007.I0001.A003' IS DELETED
 BMC50891I 12: DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS00713.I0001.A001' IS DELETED
 BMC50891I 6: DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS00711.I0001.A001' IS DELETED
 BMC50891I 4: DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS007.I0001.A004' IS DELETED
 BMC50891I 2: DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS007.I0001.A002' IS DELETED
 BMC50891I 8: DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS00711.I0001.A003' IS DELETED
 BMC50891I 9: DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS00711.I0001.A004' IS DELETED
 BMC50891I 7: DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS00711.I0001.A002' IS DELETED
 BMC50891I 11: DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS00712.I0001.A001' IS DELETED
 BMC50891I 5: DATASET 'DEHJCAT.OLDDBC.ARUDB007.TS007.I0001.A005' IS DELETED

 BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR REORG UTILITY SUCCESSFUL FOR ALL OBJECTS
 BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0

ASUSRPRT for example 3, case 2

The following figure shows a portion of the statistics report sent to ASUSRPRT for case 2 of example 3. This figure shows one set of statistics for each object type. Ellipses (...) at the beginning of a line indicate the omitted statistics sections.

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


   INDEX --------------- ARU.TS00711
     ASSOCIATIONS
       TABLESPACE ------ ARUDB007.TS007
       TABLE ----------- ARU.TS0071
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------N  UTILCODE---------------------R  LOCATION------------------DEHJ
       SAMPLING---------------------N
     ATTRIBUTES
       PIECESIZE--------------------0  TYPE TS----------------(BLANK)  UNIQUERULE-------------------U  KEYLENGTH-------------------34
       SPARSE-----------------------N  INDEXTYPE--------------------2  CLUSTERING-------------------Y  COLCOUNT---------------------3
       INDEXSPACE-------------TS00711  PGSIZE-----------------------4  EXTTYPE----------------(BLANK)  COMPRESS---------------------N
       COLNAME------------EMPHIREDATE
     STATISTICS
       FIRSTKEYCARD----------------89  FULLKEYCARD---------------2084  NACTIVE--------------------105  TBCARDF-------------------2084
       NUMNONLEAF------------------16  NLEVELS----------------------2  CLUSTERRATIO---------------100  NLEAF-----------------------31
       AVGKEYLEN-------------------34  REORGSPACE------------------18  REORGSPACE_KB--------------864  REORGNLEVELS-----------------2
       HIGH2K-----------X'0022000101'  HIGH2K (CHAR)------------.....  LOW2K------------X'0014690308'  LOW2K (CHAR)-------------.....
       DATAREPEAT------------------77
     ALLOCATION
       SPACE-----------------------46  SPACE_KB------------------2208

   INDEXPART ----------- ARU.TS00711 PART 001
     ASSOCIATIONS
       TABLESPACE ------ ARUDB007.TS007
       TABLE ----------- ARU.TS0071
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------N  UTILCODE---------------------R  LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------1  SQTY------------------------15  PCTFREE---------------------15  FREEPAGE---------------------9
       ALLOCUNIT--------------------T  STORTYPE---------------------I  NLAVGKEYLEN-----------------15  VCATNAME---------------DEHJCAT
       RBA_FORMAT------------EXTENDED  STORNAME--------------ARULARSG
     STATISTICS
       FIRSTKEYCARD----------------17  FULLKEYCARD---------------1610  CARD----------------------1610  NACTIVE---------------------26
       CLUSTERRATIO---------------100  NUMNONLEAF-------------------1  NLEVELS----------------------2  FAROFFPOS--------------------0
       NEAROFFPOS-------------------6  LEAFDIST--------------------15  NLEAF-----------------------20  FREE------------------------17
       FULL-------------------------0  AVGKEYLEN-------------------34
       LEAFNEAR---------------------3  LEAFFAR----------------------0  PSEUDO_DEL_RIDS--------------0  REORGSPACE-------------------3
       REORGSPACE_KB--------------144  REORGNLEVELS-----------------2  PCTUSED----------------------9  PQTYROWS-------------------670
       DATAREPEAT------------------56
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------31  SPACE_KB------------------1488  NUMDATASETS------------------1
       EXTENTS----------------------2  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------DWB010

. . .   

   COLUMN -------------- EMPHIREDATE
     ASSOCIATIONS
       TABLESPACE ------ ARUDB007.TS007
       TABLE ----------- ARU.TS0071
     ATTRIBUTES
       COLNO------------------------6  COLTYPE-------------------DATE  LENGTH-----------------------4  NULLS------------------------Y
       SCALE------------------------0
     STATISTICS
       COLCARD---------------------89  COLNULLS---------------------0  COLAVG-----------------------5  COLMIN-----------------------5
 BMCSTATS V11.02.00 REPORT FOR DEHJ V1115 (111)       TIME 2015-03-05-13.41.58.272985                                          8

       COLMAX-----------------------5
       HIGH2K-----------X'0022000101'  HIGH2K (CHAR)------------.....  LOW2K------------X'0014690308'  LOW2K (CHAR)-------------.....

       MOST FREQUENT VALUES
       FREQUENCY-------------0.383877  COLVAL-----------X'0014881209'
                                       (CHAR)-------------------..h..
       FREQUENCY-------------0.195777  COLVAL-----------X'0022000101'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.191939  COLVAL-----------X'0014030101'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.191939  COLVAL-----------X'0014690308'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.191939  COLVAL-----------X'0014721112'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.191939  COLVAL-----------X'0014820101'
                                       (CHAR)-------------------..b..
       FREQUENCY-------------0.191939  COLVAL-----------X'0014820707'
                                       (CHAR)-------------------..b..
       FREQUENCY-------------0.191939  COLVAL-----------X'0014850131'
                                       (CHAR)-------------------..e..
       FREQUENCY-------------0.191939  COLVAL-----------X'0022000228'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.000960  COLVAL-----------X'0019900324'
                                       (CHAR)-------------------.....

   KEYCARD ------------- EMPHIREDATE
     ASSOCIATIONS
       TABLESPACE ------ ARUDB007.TS007
       TABLE ----------- ARU.TS0071
     ATTRIBUTES AND STATISTICS
       COLUMN-------------EMPHIREDATE  COLCARD---------------------89  COLTYPE-------------------DATE  LENGTH-----------------------4
       COLUMN-------------------EMPNO  COLCARD-------------------2084  COLTYPE-------------------CHAR  LENGTH-----------------------9
       COLUMN-------------EMPDEPTNAME  COLCARD-------------------2084  COLTYPE----------------VARCHAR  LENGTH----------------------18

   COLUMN -------------- EMPHIREDATE PART 001
     ATTRIBUTES
       COLNO------------------------6  COLTYPE-------------------DATE  LENGTH-----------------------4  NULLS------------------------Y
       SCALE------------------------0
     STATISTICS
       COLCARD---------------------17  COLNULLS---------------------0  COLAVG-----------------------5  COLMIN-----------------------5
       COLMAX-----------------------5
       HIGH2K-----------X'0019890129'  HIGH2K (CHAR)------------..i..  LOW2K------------X'0014690308'  LOW2K (CHAR)-------------.....
       HIGHK------------X'0019890130'  HIGHK (CHAR)-------------..i..  LOWK-------------X'0014030101'  LOWK (CHAR)--------------.....

       MOST FREQUENT VALUES
       FREQUENCY-------------0.248447  COLVAL-----------X'0014881209'
                                       (CHAR)-------------------..h..
       FREQUENCY-------------0.124224  COLVAL-----------X'0014850131'
                                       (CHAR)-------------------..e..
       FREQUENCY-------------0.124224  COLVAL-----------X'0014820707'
                                       (CHAR)-------------------..b..
       FREQUENCY-------------0.124224  COLVAL-----------X'0014820101'
                                       (CHAR)-------------------..b..
       FREQUENCY-------------0.124224  COLVAL-----------X'0014721112'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.124224  COLVAL-----------X'0014690308'
                                       (CHAR)-------------------.....
 BMCSTATS V11.02.00 REPORT FOR DEHJ V1115 (111)       TIME 2015-03-05-13.41.58.272985                                          9

       FREQUENCY-------------0.124224  COLVAL-----------X'0014030101'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.000621  COLVAL-----------X'0019890130'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.000621  COLVAL-----------X'0019890129'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.000621  COLVAL-----------X'0019890128'
                                       (CHAR)-------------------..i..

   KEYCARD ------------- EMPHIREDATE PART 001
     ATTRIBUTES AND STATISTICS
       COLUMN-------------EMPHIREDATE  COLCARD---------------------17  COLTYPE-------------------DATE  LENGTH-----------------------4
       COLUMN-------------------EMPNO  COLCARD-------------------1610  COLTYPE-------------------CHAR  LENGTH-----------------------9
       COLUMN-------------EMPDEPTNAME  COLCARD-------------------1610  COLTYPE----------------VARCHAR  LENGTH----------------------18

. . .   


 TABLESPACE ------------ ARUDB007.TS007
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------N  UTILCODE---------------------R  LOCATION------------------DEHJ
       SAMPLING---------------------N
     ATTRIBUTES
       PARTITIONS------------------16  NTABLES----------------------1  PGSIZE-----------------------4  SEGSIZE----------------------0
       DSSIZE-----------------------0
       MAXROWS--------------------255  TYPE-------------------(BLANK)  ENCODING---------------------E  MAXPARTITIONS----------------0
       LOB--------------------------N  XML--------------------------N  MEMBER_CLUSTER---------(BLANK)
     STATISTICS
       NACTIVE--------------------116  REORGSPACE------------------31  REORGSPACE_KB-------------1488  ROWMAXFOUND----------------165
       ROWMINFOUND----------------107  ROWAVG---------------------109
     ALLOCATION
       SPACE-----------------------53  SPACE_KB------------------2544

   TABLEPART ----------- ARUDB007.TS007    PART 001
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------N  LOCATION----------------(NULL)  UTILCODE---------------------R
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------2  SQTY-------------------------1  PCTFREE---------------------20  FREEPAGE---------------------9
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------(BLANK)  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  VCATNAME---------------DEHJCAT  STORNAME--------------ARULARSG
     STATISTICS
       CARD----------------------1610  NACTIVE---------------------64  NPAGES----------------------56  ROWAVG---------------------108
       ROWMAXFOUND----------------118  ROWMINFOUND----------------107  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL-------------------------0  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE------------------65
       PCTPAGES--------------------87  PERCDROP---------------------0  REORGSPACE------------------15  REORGSPACE_KB--------------720
       PCTUSED---------------------50  PQTYROWS------------------9343
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------30  SPACE_KB------------------1440  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------DWB010

. . .  


   TABLE --------------- ARU.TS0071
     ASSOCIATIONS
       TABLESPACE ------ ARUDB007.TS007
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------N  UTILCODE---------------------R  LOCATION----------------(NULL)
     STATISTICS
       CARD----------------------2084  NPAGES----------------------77  SPACE_KB------------------2544  AVGNONCOMPROWLEN----------(-1)
       ROWAVG---------------------109  ROWMAXFOUND----------------165  ROWMINFOUND----------------107  INDREF-----------------------0
       PCTPAGES--------------------66  PCTROWCOMP-------------------0

Related topic

Examples-of-REORG-PLUS-jobs

 

 

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