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 10: DSNUTILB reorganization and index that contains keys with random ordering

In this example, REORG PLUS invokes DSNUTILB to reorganize a segmented table space that has an associated index that contains keys with random ordering. This job is a two-phase table space reorganization.

Because this job invokes DSNUTILB, ACTIVE YES must be specified for all work files that the reorganization job requires. ACTIVE YES is required for at least the primary local copy data set (DDTYPE LOCPFCPY) when COPY YES is specified.

Note

All copy data sets for a DSNUTILB reorganization are dynamically allocated, even if you specify ACTIVE YES for only the primary local copy data set.

When REORG PLUS must invoke DSNUTILB, the SYSPRINT displays message BMC50182I, indicating the reason for invoking DSNUTILB.

DSNU050I messages show the REORG command and the TEMPLATE statements that are created from the REORG PLUS command and installation option values.

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

COPY YES INLINE YES

Creates an inline Db2 image copy of the table space

COPYDDN BMCPY

  • Specifies the ddname BMCPY for the data set that receives the full local image copy of the table space that you are reorganizing
  • Overrides the default name of BMCCPY

RECOVERYDDN BMRPY

  • Specifies a ddname of BMRPY for data set that receives the full remote image copy of the table space that you are reorganizing
  • Overrides the default names of BMCRCY

ORDER YES

Tells REORG PLUS to sort the rows

ORDER YES is passed to DSNUTILB as SORTDATA YES, and DSNUTILB will sort the clustering keys

REDEFINE NO

Tells REORG PLUS not to delete and redefine the VSAM data sets for the table space

Because this job invokes DSNUTILB, REORG PLUS passes this option to the IBM Db2 REORG utility as REUSE.

SORTDEVT

Specifies the device type for the sort work files that are allocated dynamically

Because this job invokes DSNUTILB, REORG PLUS passes this option to the Db2 REORG utility for processing.

SORTNUM

Affects the allocation of sort work files

Because this job invokes DSNUTILB, REORG PLUS passes this option to the Db2 REORG utility as the number of sort work files to allocate dynamically.

DDTYPE LOCBFCPY ACTIVE YES

DDTYPE REMPFCPY ACTIVE YES

DDTYPE REMBFCPY ACTIVE YES

Activates dynamic data set allocation for the specified data set types

IFALLOC

Because this job invokes DSNUTILB, REORG PLUS ignores this option.

DSNPAT

Specifies a pattern of variables and text that REORG PLUS uses to create data set names for dynamic data set allocation, overriding the default patterns

Because this job invokes DSNUTILB, REORG PLUS includes this pattern in the TEMPLATE control statement that it builds for the Db2 REORG utility.

UNIT

MAXEXTSZ

UNITCNT

VOLCNT

THRESHLD

Specifies allocation information for the data sets that you are dynamically allocating

Because this job invokes DSNUTILB, REORG PLUS includes this information in the TEMPLATE control statement that it builds for the Db2 REORG utility.

UPDATEDB2STATS YES

Requests that statistics be updated in the Db2 catalog

Because this job invokes DSNUTILB, REORG PLUS passes this option to the STATISTICS option of the Db2 REORG utility as STATISTICS TABLE (ALL) INDEX (ALL) REPORT YES UPDATE ALL.

The following figure shows the JCL for example 10:

//        JOB
//*
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//*  SEGMENTED TABLESPACE WITH AN ASSOCIATED INDEX CONTAINING A       *
//*  RANDOM INDEX KEY. DSNUTILB INVOKED DUE TO RANDOM INDEX KEY.      *
//*  NOTE THE BMC OPTIONS TRANSLATED TO DSNUTILB OPTIONS.             *
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//LARREORG EXEC PGM=ARUUMAIN,REGION=0M,COND=(7,LT),
// PARM='<db2ssid>,ARUDB070.RG1,NEW,,MSGLEVEL(1),ARU$OPTS'
//STEPLIB   DD  DISP=SHR,DSN=<productLibraries>
//          DD  DISP=SHR,DSN=DB2.DSNEXIT
//          DD  DISP=SHR,DSN=DB2.DSNLOAD
//SYSPRINT  DD  SYSOUT=*
//SYSOUT    DD  SYSOUT=*
//UTPRINT   DD  SYSOUT=*
//SYSTERM   DD  SYSOUT=*
//*
//SYSIN     DD *
REORG TABLESPACE ARUDB070.LARS$JBA
  SHRLEVEL NONE
  UNLOAD CONTINUE
  COPY YES
  INLINE YES
  COPYLVL FULL
  COPYDDN BMCPY
  RECOVERYDDN BMRPY
  PREFORMAT YES
  REDEFINE NO
  ORDER YES
  UPDATEDB2STATS YES
  SORTDEVT 3390
  SORTNUM 12
  SORTDATA
  DDTYPE UNLOAD UNIT (WORK) IFALLOC USE
  DSNPAT 'ARU.LARREORG.DEHJ.ARUDB070.&DDNAME'
  MAXEXTSZ 100 UNITCNT (1,15) VOLCNT AUTO
  DDTYPE WORK UNIT (WORK) IFALLOC USE
  DSNPAT 'ARU.LARREORG.DEHJ.ARUDB070.&DDNAME'
  DDTYPE LOCPFCPY IFALLOC USE  DSNPAT
  'ARU.LARREORG.DEHJ.&DB.&TSIX.&DDNAME'
  UNIT (WORK) THRESHLD 10000
  DDTYPE LOCBFCPY ACTIVE YES IFALLOC USE  DSNPAT
  'ARU.LARREORG.DEHJ.&DB.&TSIX.&DDNAME' UNIT (WORK)
  DDTYPE REMPFCPY ACTIVE YES UNIT (WORK) IFALLOC USE
  DSNPAT 'ARU.LARREORG.DEHJ.&DB.&TSIX.&DDNAME'
  DDTYPE REMBFCPY ACTIVE YES UNIT (WORK) IFALLOC USE
  DSNPAT 'ARU.LARREORG.DEHJ.&DB.&TSIX.&DDNAME'
/*

SYSPRINT for example 10

The following figure shows the SYSPRINT output for example 10:

                                *****  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/02/2015   22:13:26 ...
 BMC50002I UTILITY ID = 'ARUDB070.RG1'.  DB2 SUBSYSTEM ID = 'DEHJ'.  OPTION MODULE = 'ARU$OPTS'.
 BMC50471I z/OS 2.1.0,PID=HBB7790,DFSMS FOR Z/OS=2.1.0,DB2=11.1.0
 BMC50471I REGION=0M,BELOW 16M=8844K,ABOVE 16M=1312304K,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 ARUDB070.LARS$JBA
 BMC50102I   SHRLEVEL NONE
 BMC50102I   UNLOAD CONTINUE
 BMC50102I   COPY YES
 BMC50102I   INLINE YES
 BMC50102I   COPYLVL FULL
 BMC50102I   COPYDDN BMCPY
 BMC50102I   RECOVERYDDN BMRPY
 BMC50102I   PREFORMAT YES
 BMC50102I   REDEFINE NO
 BMC50102I   ORDER YES
 BMC50102I   UPDATEDB2STATS YES
 BMC50102I   SORTDEVT 3390
 BMC50102I   SORTNUM 12
 BMC50102I   SORTDATA
 BMC50102I   DDTYPE UNLOAD UNIT (WORK) IFALLOC USE
 BMC50102I   DSNPAT 'ARU.LARREORG.DEHJ.ARUDB070.&DDNAME'
 BMC50102I   MAXEXTSZ 100 UNITCNT (1,15) VOLCNT AUTO
 BMC50102I   DDTYPE WORK UNIT (WORK) IFALLOC USE
 BMC50102I   DSNPAT 'ARU.LARREORG.DEHJ.ARUDB070.&DDNAME'
 BMC50102I   DDTYPE LOCPFCPY IFALLOC USE  DSNPAT
 BMC50102I   'ARU.LARREORG.DEHJ.&DB.&TSIX.&DDNAME'
 BMC50102I   UNIT (WORK) THRESHLD 10000
 BMC50102I   DDTYPE LOCBFCPY ACTIVE YES IFALLOC USE  DSNPAT
 BMC50102I   'ARU.LARREORG.DEHJ.&DB.&TSIX.&DDNAME' UNIT (WORK)
 BMC50102I   DDTYPE REMPFCPY ACTIVE YES UNIT (WORK) IFALLOC USE
 BMC50102I   DSNPAT 'ARU.LARREORG.DEHJ.&DB.&TSIX.&DDNAME'
 BMC50102I   DDTYPE REMBFCPY ACTIVE YES UNIT (WORK) IFALLOC USE
 BMC50102I   DSNPAT 'ARU.LARREORG.DEHJ.&DB.&TSIX.&DDNAME'

 BMC50182I DSNUTILB REQUIRED: INDEX CONTAINS A RANDOM KEY INDEX 'ARUDB070 '.'LARX001D '
 BMC50004I UTILINIT PHASE COMPLETE.  ELAPSED TIME = 00:00:00

1DSNU000I    061 22:13:26.90 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = ARUDB070.RG1
 DSNU1044I   061 22:13:26.96 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
 DSNU050I    061 22:13:26.97 DSNUGUTC -  TEMPLATE BMC00001 DSN 'ARU.LARREORG.DEHJ.&DB..&SN..BMCRCZ' UNIT WORK VOLCNT
  25 PCTPRIME 100
 DSNU1035I   061 22:13:26.97 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
 DSNU050I    061 22:13:26.97 DSNUGUTC -  TEMPLATE BMC00002 DSN 'ARU.LARREORG.DEHJ.&DB..&SN..BMRPY' UNIT WORK VOLCNT
 25 PCTPRIME 100
 DSNU1035I   061 22:13:26.97 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
 DSNU050I    061 22:13:26.97 DSNUGUTC -  TEMPLATE BMC00003 DSN 'ARU.LARREORG.DEHJ.&DB..&SN..BMCCPZ' UNIT WORK VOLCNT
  25 PCTPRIME 100
 DSNU1035I   061 22:13:26.97 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
 DSNU050I    061 22:13:26.97 DSNUGUTC -  TEMPLATE BMC00004 DSN 'ARU.LARREORG.DEHJ.&DB..&SN..BMCPY' UNIT WORK VOLCNT
 25 PCTPRIME 100 LIMIT(9 MB, BMC00005)
 DSNU1035I   061 22:13:26.97 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
 DSNU050I    061 22:13:26.97 DSNUGUTC -  TEMPLATE BMC00005 DSN 'ARU.LARREORG.DEHJ.&DB..&SN..BMCPY' UNIT SYSALLDA
 VOLCNT 25 PCTPRIME 100
 DSNU1035I   061 22:13:26.97 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
 DSNU050I    061 22:13:26.97 DSNUGUTC -  TEMPLATE BMC00006 DSN 'ARU.LARREORG.DEHJ.ARUDB070.SYSREC' UNIT WORK UNCNT 1
  DISP(NEW, DELETE, CATLG) PCTPRIME 100 MAXPRIME 100
 DSNU1035I   061 22:13:26.97 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
 DSNU050I    061 22:13:26.98 DSNUGUTC -  TEMPLATE BMC00007 DSN '&USERID..ARUDB070.SYSPUNCH' UNIT SYSALLDA VOLCNT 25
 PCTPRIME 100
 DSNU1035I   061 22:13:26.98 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
 DSNU050I    061 22:13:26.98 DSNUGUTC -  REORG TABLESPACE ARUDB070.LARS$JBA REUSE COPYDDN(BMC00004, BMC00003)
 RECOVERYDDN(BMC00002, BMC00001) UNLDDN(BMC00006) SHRLEVEL NONE UNLOAD CONTINUE STATISTICS TABLE ALL INDEX ALL
 REPORT YES UPDATE ALL HISTORY ALL FORCEROLLUP YES PUNCHDDN BMC00007 SORTDEVT 3390 SORTNUM 12 PREFORMAT
 DSNU2904I *DEHJ 061 22:13:27.03 DSNURFTB - DATA RECORDS WILL BE UNLOADED VIA TABLE SPACE SCAN
 DSNU1038I   061 22:13:27.05 DSNUGDYN - DATASET ALLOCATED.  TEMPLATE=BMC00004
                        DDNAME=SYS00003
                        DSN=ARU.LARREORG.DEHJ.ARUDB070.LARS$JBA.BMCPY
 DSNU1038I   061 22:13:27.07 DSNUGDYN - DATASET ALLOCATED.  TEMPLATE=BMC00003
                        DDNAME=SYS00004
                        DSN=ARU.LARREORG.DEHJ.ARUDB070.LARS$JBA.BMCCPZ
 DSNU1038I   061 22:13:27.09 DSNUGDYN - DATASET ALLOCATED.  TEMPLATE=BMC00002
                        DDNAME=SYS00005
                        DSN=ARU.LARREORG.DEHJ.ARUDB070.LARS$JBA.BMRPY
 DSNU1038I   061 22:13:27.11 DSNUGDYN - DATASET ALLOCATED.  TEMPLATE=BMC00001
                        DDNAME=SYS00006
                        DSN=ARU.LARREORG.DEHJ.ARUDB070.LARS$JBA.BMCRCZ
 DSNU1038I   061 22:13:27.17 DSNUGDYN - DATASET ALLOCATED.  TEMPLATE=BMC00006
                        DDNAME=SYS00007
                        DSN=ARU.LARREORG.DEHJ.ARUDB070.SYSREC
 DSNU252I    061 22:13:27.57 DSNURULD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=2048 FOR TABLESPACE
 ARUDB070.LARS$JBA
 DSNU250I    061 22:13:27.57 DSNURULD - UNLOAD PHASE COMPLETE, ELAPSED TIME=00:00:00
 DSNU395I    061 22:13:28.18 DSNURPIB - INDEXES WILL BE BUILT IN PARALLEL, NUMBER OF TASKS = 4
 DSNU3345I   061 22:13:28.18 DSNURPIB - MAXIMUM UTILITY PARALLELISM IS 8 BASED ON NUMBER OF PARTITIONS, INDEXES AND
 STATISTICS
 DSNU397I    061 22:13:28.18 DSNURPIB - NUMBER OF TASKS CONSTRAINED BY CPUS TO 8
 DSNU400I    061 22:13:28.39 DSNURBID - COPY PROCESSED FOR TABLESPACE ARUDB070.LARS$JBA
                       NUMBER OF PAGES=316
                       AVERAGE PERCENT FREE SPACE PER PAGE = 25.20
                       PERCENT OF CHANGED PAGES =100.00
                       ELAPSED TIME=00:00:01
 DSNU304I  *DEHJ 061 22:13:28.54 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=2048 FOR TABLE ARUDB070.LART001
 DSNU302I    061 22:13:28.54 DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=2048
 DSNU300I    061 22:13:28.54 DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED TIME=00:00:00
 DSNU394I  *DEHJ 061 22:13:29.14 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=2048 FOR INDEX ARUDB070.LARX001A
 DSNU394I  *DEHJ 061 22:13:29.18 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=2048 FOR INDEX ARUDB070.LARX001D
 DSNU391I    061 22:13:29.22 DSNURPTB - SORTBLD PHASE STATISTICS. NUMBER OF INDEXES = 2
 DSNU392I    061 22:13:29.22 DSNURPTB - SORTBLD PHASE COMPLETE, ELAPSED TIME = 00:00:00
 DSNU428I    061 22:13:29.28 DSNURORG - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE ARUDB070.LARS$JBA
 DSNU613I  *DEHJ 061 22:13:29.32 DSNUSUTP - SYSTABLEPART CATALOG STATISTICS FOR ARUDB070.LARS$JBA PARTITION 0
                               CARD              = 2048
                               CARDF             = 2.048E+03
                               NEARINDREF        = 0
                               FARINDREF         = 0
                               PERCACTIVE        = 8
                               PERCDROP          = 0
                               PAGESAVE          = 0
                               SPACE             = 10080
                               SPACEF            = 1.008E+04
                               PQTY              = 2500
                               SQTY              = 1000
                               DSNUM             = 1
                               EXTENTS           = 1
 DSNU610I  *DEHJ 061 22:13:29.32 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR ARUDB070.LARS$JBA SUCCESSFUL
 DSNU614I  *DEHJ 061 22:13:29.34 DSNUSUTB - SYSTABLES CATALOG STATISTICS FOR ARUDB070.LART001
                               CARD              = 2048
                               CARDF             = 2.048E+03
                               NPAGES            = 258
                               NPAGESF           = 2.58E+02
                               PCTPAGES          = 80
                               PCTROWCOMP        = 0
                               AVGROWLEN         = 447
                               SPACEF            = 1.032E+03
 DSNU610I  *DEHJ 061 22:13:29.34 DSNUSUTB - SYSTABLES CATALOG UPDATE FOR ARUDB070.LART001 SUCCESSFUL
 DSNU615I  *DEHJ 061 22:13:29.35 DSNUSUCO - SYSCOLUMNS CATALOG STATISTICS FOR C001_INTEGER
                               COLCARD           = 2048
                               COLCARDF          = 2.048E+03
                               HIGH2KEY          = X'008009C41E'
                               LOW2KEY           = X'0080000002'
 DSNU615I  *DEHJ 061 22:13:29.36 DSNUSUCO - SYSCOLUMNS CATALOG STATISTICS FOR C002_SMALLINT
                               COLCARD           = 1888
                               COLCARDF          = 1.888E+03
                               HIGH2KEY          = X'00A6E6'
                               LOW2KEY           = X'008008'
 DSNU615I  *DEHJ 061 22:13:29.36 DSNUSUCO - SYSCOLUMNS CATALOG STATISTICS FOR C003_REAL
                               COLCARD           = 1888
                               COLCARDF          = 1.888E+03
                               HIGH2KEY          = X'00C47FD500'
                               LOW2KEY           = X'00C21D0000'
 DSNU615I  *DEHJ 061 22:13:29.36 DSNUSUCO - SYSCOLUMNS CATALOG STATISTICS FOR C004_DOUBLE
                               COLCARD           = 2048
                               COLCARDF          = 2.048E+03
                               HIGH2KEY          = X'00C47FEF0000000000'
                               LOW2KEY           = X'00C21F000000000000'
 DSNU615I  *DEHJ 061 22:13:29.36 DSNUSUCO - SYSCOLUMNS CATALOG STATISTICS FOR C005_CHAR
                               COLCARD           = 2048
                               COLCARDF          = 2.048E+03
                               HIGH2KEY          = X'C1C4F9F6C1C1C1F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0
                                                     F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0
                                                     F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0
                                                     F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0
                                                     F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0
                                                     F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0
                                                     F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0
                                                     F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0
                                                     F0F0F0F0F0F0F0F0F0F0F0F0F0F0'
                               LOW2KEY           = X'C1C1C1C3C1C1C1F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0
                                                     F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0
                                                     F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0
                                                     F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0
                                                     F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0
                                                     F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0
                                                     F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0
                                                     F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0
                                                     F0F0F0F0F0F0F0F0F0F0F0F0F0F0'
 DSNU615I  *DEHJ 061 22:13:29.36 DSNUSUCO - SYSCOLUMNS CATALOG STATISTICS FOR C006_VARCHAR
                               COLCARD           = 1824
                               COLCARDF          = 1.824E+03
                               HIGH2KEY          = X'00F9F7F9C9D9D8D2D7E2F6D4C8F7'
                               LOW2KEY           = X'00C1C1E4C4C4F7F6F6C4F3C4D7E7F2C3D2D2F6F6C1C8C9E3E6E6E8D6F3C5
                                                     F6E2E2F6C1'
 DSNU615I  *DEHJ 061 22:13:29.37 DSNUSUCO - SYSCOLUMNS CATALOG STATISTICS FOR C007_DATE
                               COLCARD           = 1952
                               COLCARDF          = 1.952E+03
                               HIGH2KEY          = X'19981129'
                               LOW2KEY           = X'19100226'
 DSNU615I  *DEHJ 061 22:13:29.37 DSNUSUCO - SYSCOLUMNS CATALOG STATISTICS FOR C008_TIME
                               COLCARD           = 1888
                               COLCARDF          = 1.888E+03
                               HIGH2KEY          = X'235914'
                               LOW2KEY           = X'000215'
 DSNU615I  *DEHJ 061 22:13:29.37 DSNUSUCO - SYSCOLUMNS CATALOG STATISTICS FOR C010_DECIMAL
                               COLCARD           = 2048
                               COLCARDF          = 2.048E+03
                               HIGH2KEY          = X'00F0000000000327410000000000000000'
                               LOW2KEY           = X'00F0000000000000420000000000000000'
 DSNU615I  *DEHJ 061 22:13:29.37 DSNUSUCO - SYSCOLUMNS CATALOG STATISTICS FOR C011_LVARCHAR
                               COLCARD           = 2048
                               COLCARDF          = 2.048E+03
                               HIGH2KEY          = X'00F9F8E9F0C4C6E4E2D6D5C3E3D1E8F3F2F1D7E8E6E2F1F6E9C8C8D2E5C7
                                                     D1D2E5D6E7E4F0D6F9F0C6F6E4D4F4D6E3C8E7C3F4D3D8E3C3C5C6D1C7C8
                                                     F8C6C5C2D5F1C3F3E4C4F4D1E5C4E9D3F4C4D1C5F8F2C3D9C2F0E9C6E3E7
                                                     C9F3D6F0C2F5F3F5D5E9E9'
                               LOW2KEY           = X'00C1C1D8F7E9F8F6D5D2E3D1F4F4E4F0E8E9E3F5E8C8D3C1F7D4D8C9C2C4
                                                     F1C1E5D5F0C7F7F5D4D1C1D5C8D7D9E5E2C6C4F8F0F9F5D1F7D6C1E4D8C7
                                                     F9C3D1C9F0C4C4F3F4D8D5F6E8D5E6F9F7F7E2E4D1D8C2E2D5F4C8E8F6F5
                                                     F9F0E6E2D5C6D7C3F0C4D2'
 DSNU610I  *DEHJ 061 22:13:29.37 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ARUDB070.LART001 SUCCESSFUL
 DSNU612I  *DEHJ 061 22:13:29.37 DSNUSUTS - SYSTABLESPACE CATALOG STATISTICS FOR ARUDB070.LARS$JBA
                               NACTIVE           = 2520
                               NACTIVEF          = 2.52E+03
 DSNU610I  *DEHJ 061 22:13:29.37 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR ARUDB070.LARS$JBA SUCCESSFUL
 DSNU618I  *DEHJ 061 22:13:29.38 DSNUSUIP - SYSINDEXPART CATALOG STATISTICS FOR ARUDB070.LARX001A PARTITION 0
                               CARD              = 2048
                               CARDF             = 2.048E+03
                               NEAROFFPOS        = 51
                               NEAROFFPOSF       = 5.1E+01
                               FAROFFPOS         = 0
                               FAROFFPOSF        = 0.0E0
                               LEAFDIST          = 20
                               LEAFNEAR          = 2
                               LEAFFAR           = 0
                               SPACE             = 4320
                               SPACEF            = 4.32E+03
                               DSNUM             = 1
                               EXTENTS           = 3
                               P_DEL_ENT         = 0
                               PQTY              = 1000
                               SQTY              = 500
 DSNU610I  *DEHJ 061 22:13:29.38 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR ARUDB070.LARX001A SUCCESSFUL
 DSNU618I  *DEHJ 061 22:13:29.39 DSNUSUIP - SYSINDEXPART CATALOG STATISTICS FOR ARUDB070.LARX001D PARTITION 0
                               CARD              = 2048
                               CARDF             = 2.048E+03
                               NEAROFFPOS        = 1806
                               NEAROFFPOSF       = 1.806E+03
                               FAROFFPOS         = 241
                               FAROFFPOSF        = 2.41E+02
                               LEAFDIST          = 18
                               LEAFNEAR          = 2
                               LEAFFAR           = 0
                               SPACE             = 4320
                               SPACEF            = 4.32E+03
                               DSNUM             = 1
                               EXTENTS           = 4
                               P_DEL_ENT         = 0
                               PQTY              = 1000
                               SQTY              = 500
 DSNU610I  *DEHJ 061 22:13:29.39 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR ARUDB070.LARX001D SUCCESSFUL
 DSNU615I  *DEHJ 061 22:13:29.39 DSNUSUCO - SYSCOLUMNS CATALOG STATISTICS FOR C009_TIMESTAMP
                               COLCARD           = 2048
                               COLCARDF          = 2.048E+03
                               HIGH2KEY          = X'44600702000000000000'
                               LOW2KEY           = X'19100202000000000000'
 DSNU610I  *DEHJ 061 22:13:29.39 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ARUDB070.LARX001A SUCCESSFUL
 DSNU617I  *DEHJ 061 22:13:29.39 DSNUSUIX - SYSINDEXES CATALOG STATISTICS FOR ARUDB070.LARX001A
                               CLUSTERED         = Y
                               CLUSTERRATIO      = 100
                               CLUSTERRATIOF     = 1.0E+00
                               FIRSTKEYCARD      = 2048
                               FIRSTKEYCARDF     = 2.048E+03
                               FULLKEYCARD       = 2048
                               FULLKEYCARDF      = 2.048E+03
                               NLEAF             = 10
                               NLEVELS           = 2
                               SPACEF            = 4.32E+03
                               DATAREPEATFACTORF = 2.58E+02
 DSNU610I  *DEHJ 061 22:13:29.39 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR ARUDB070.LARX001A SUCCESSFUL
 DSNU615I  *DEHJ 061 22:13:29.40 DSNUSUCO - SYSCOLUMNS CATALOG STATISTICS FOR C009_TIMESTAMP
                               COLCARD           = 2048
                               COLCARDF          = 2.048E+03
                               HIGH2KEY          = X'44600702000000000000'
                               LOW2KEY           = X'19100202000000000000'
 DSNU610I  *DEHJ 061 22:13:29.40 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ARUDB070.LARX001D SUCCESSFUL
 DSNU617I  *DEHJ 061 22:13:29.40 DSNUSUIX - SYSINDEXES CATALOG STATISTICS FOR ARUDB070.LARX001D
                               CLUSTERED         = N
                               CLUSTERRATIO      = 30
                               CLUSTERRATIOF     = 3.0224609375E-01
                               FIRSTKEYCARD      = 2048
                               FIRSTKEYCARDF     = 2.048E+03
                               FULLKEYCARD       = 2048
                               FULLKEYCARDF      = 2.048E+03
                               NLEAF             = 11
                               NLEVELS           = 2
                               SPACEF            = 4.32E+03
                               DATAREPEATFACTORF = 1.975E+03
 DSNU610I  *DEHJ 061 22:13:29.40 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR ARUDB070.LARX001D SUCCESSFUL
 DSNU616I  *DEHJ 061 22:13:29.40 DSNUSUCD - SYSCOLDIST CATALOG STATISTICS FOR
                                        C009_TIMESTAMP
                               FREQUENCY           COLVALUE
                               ---------           --------
                               4.8828125E-04       X'44500702000000000000'
                               4.8828125E-04       X'40500302000000000000'
                               4.8828125E-04       X'41500202000000000000'
                               4.8828125E-04       X'42500102000000000000'
                               4.8828125E-04       X'37200402000000000000'
                               4.8828125E-04       X'36200502000000000000'
                               4.8828125E-04       X'32200102000000000000'
                               4.8828125E-04       X'31200202000000000000'
                               4.8828125E-04       X'35200602000000000000'
                               4.8828125E-04       X'30200302000000000000'
 DSNU610I  *DEHJ 061 22:13:29.41 DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR ARUDB070.LARX001D SUCCESSFUL
 DSNU620I  *DEHJ 061 22:13:29.41 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2015-03-02-22.13.27.141614
 DSNU010I    061 22:13:29.49 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
 BMC50004I DSNUTILB PHASE COMPLETE.  ELAPSED TIME = 00:00:02

 BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0

Related topic

Examples-of-REORG-PLUS-jobs

 

 

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