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 1: VCAT-defined segmented table space with SYSIDCIN

In this example, REORG PLUS reorganizes a segmented VCAT-defined table space.

The table space has a clustering index that was defined using the Db2 CREATE INDEX DEFER command. The REORG PLUS job populates the clustering index as part of the reorganization.

REORG PLUS issues message BMC50482I in the SYSPRINT when it creates the index. Message BMC51276I indicates how many keys were loaded into the index. Because this example uses a VCAT-defined table space, a SYSIDCIN DD statement and its contents are included in the JCL.

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 and DD statements for this job:

Command options and DD statements used in JCL

Description

REORG TABLESPACE

Specifies that the table space named in the statement is to be reorganized

COPY YES

Creates a Db2 image copy of the table space

Because the default for the INLINECP installation option is YES, this copy is an inline image copy.

Because REGISTER is not specified, this statement defaults to REGISTER ALL. REORG PLUS makes four copies of the table space after reorganizing it, because four ddnames are specified in the JCL. The job registers all four copies in SYSIBM.SYSCOPY.

UPDATEDB2STATS YES

Requests that statistics be updated in the Db2 catalog

The SYSPRINT shows the messages that the Common Statistics component displays for the statistics being updated in the Db2 catalog.

DELETEFILES NO

Overrides the default and requests that REORG PLUS not delete the work files upon completion of the reorganization

DDTYPE ... ACTIVE NO

Overrides the default and requests that REORG PLUS not enable dynamic allocation for the specified data sets

//SYSIDCIN

Contains the IDCAMS command statements used to redefine VCAT-defined data sets

//SYSREC

Contains the rows that you are reorganizing

//BMCCPY

//BMCCPZ

//BMCRCY

//BMCRCZ

The default ddnames that are used for the data sets that receive a full image copy of the table space that you are reorganizing

The existence of the copy ddnames determines the number of copies made when COPY YES is specified.

The following figure shows JCL for example 1:

//        JOB
//*
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
/*  SEGMENTED TABLESPACE, VCAT DEFINED, INDEX CREATED WITH DEFER     *
/*  YES. REORG TABLESPACE WITH REDEFINE YES AND SYSIDCIN IS USED,    *
/*  4 COPIES (TWO LOCALS & TWO REMOTES),                             *
/*  REGISTER ALL COPIES (DEFAULT), UPDATE DB2 CATALOG WITH STATS     *
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//BMCREORG  EXEC PGM=ARUUMAIN,
//             PARM='<db2ssid>,ARU01,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=*
//*
//SYSIDCIN  DD  *
 DELETE -
   (DEHJCAT.DSNDBC.ARUDB001.TS00111.I0001.A001) -
   PURGE -
   CLUSTER -
   CATALOG(DEHJCAT)
 DELETE -
   (DEHJCAT.DSNDBC.ARUDB001.TS001.I0001.A001) -
   PURGE -
   CLUSTER -
   CATALOG(DEHJCAT)
 DEFINE CLUSTER( -
                NAME(DEHJCAT.DSNDBC.ARUDB001.TS001.I0001.A001) -
                LINEAR     -
                REUSE -
                VOLUMES(TMO053 ARU4CD ARU112) -
                CYLINDERS (1 1) -
                SHAREOPTIONS(3 3) -
               ) -
        DATA   ( -
                NAME(DEHJCAT.DSNDBD.ARUDB001.TS001.I0001.A001) -
               ) -
        CATALOG(DEHJCAT)
 DEFINE CLUSTER( -
                 NAME(DEHJCAT.DSNDBC.ARUDB001.TS00111.I0001.A001) -
                 LINEAR -
                 REUSE -
                 VOLUMES(TMO055 ARU4CD ARU112) -
                 CYLINDERS (10 5) -
                 SHAREOPTIONS(3 3) -
                ) -
         DATA   ( -
                 NAME(DEHJCAT.DSNDBD.ARUDB001.TS00111.I0001.A001) -
                ) -
         CATALOG(DEHJCAT)
/*
//SYSREC    DD DSN=ARU.EXMPL01.SYSREC,
//          UNIT=WORK,SPACE=(CYL,(20,10)),
//          DISP=(MOD,CATLG,CATLG)
//*
//BMCCPY    DD DSN=ARU.EXMPL01.BMCCPY,
//             UNIT=WORK,SPACE=(CYL,(5,5)),
//             DISP=(,CATLG)
//BMCCPZ    DD DSN=ARU.EXMPL01.BMCCPZ,
//             UNIT=WORK,SPACE=(CYL,(5,5)),
//             DISP=(,CATLG)
//BMCRCY    DD DSN=ARU.EXMPL01.BMCRCY,
//             UNIT=WORK,SPACE=(CYL,(5,5)),
//             DISP=(,CATLG)
//BMCRCZ    DD DSN=ARU.EXMPL01.BMCRCZ,
//             UNIT=WORK,SPACE=(CYL,(5,5)),
//             DISP=(,CATLG)
//*
//SYSIN     DD  *
REORG TABLESPACE ARUDB001.TS001
COPY YES
UPDATEDB2STATS YES
REDEFINE YES
DELETEFILES NO
DDTYPE UNLOAD ACTIVE NO
DDTYPE WORK ACTIVE NO
DDTYPE LOCPFCPY ACTIVE NO
/*

SYSPRINT for example 1

The following figure shows the SYSPRINT output for example 1:

                                *****  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    2/28/2015   14:38:33 ...
 BMC50002I UTILITY ID = 'ARU01'.  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=8824K,ABOVE 16M=1312976K,IEFUSI=NO,CPUS=3
 BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040311M,MEMLIMIT SET BY:REGION=0

 BMC50471I REORG PLUS FOR DB2--V11.02.00
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I DB2 UTILITIES COMMON CODE--V11.02.00
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I SOLUTION COMMON CODE--V11.01.00
 BMC50471I   MAINT: BPJ0661  BPJ0667  BPJ0671  BPJ0674  BPJ0675  BPJ0676  BPJ0682  BPJ0686  BPJ0689  BPJ0697  BPJ0700  BPJ0702
 BMC50471I          BPJ0703  BPJ0706  BPJ0712  BPJ0715  BPJ0729  BPJ0773  BPJ0786  BPJ0794  BPJ0806  BPJ0830  BPJ0833  BPJ0839
 BMC50471I          BPJ0845  BPJ0866  BPJ0892  BPJ0913  BPJ0914  BPJ0916  BPJ0930  BPJ0944  BPJ0946
 BMC50471I BMCSORT ENGINE--V02.04.01
 BMC50471I   MAINT: BPJ0691  BPJ0718  BPJ0881  BPJ0922
 BMC50471I BMC STATS API--V11.02.00
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I EXTENDED BUFFER MANAGER--V06.01.00
 BMC50471I   MAINT: BPE0401  BPE0403  BPE0405  BPE0407  BPE0410  BPE0412  BPE0416  BPE0420  BPE0422  BPE0423  BPE0426  BPE0428
 BMC50471I          BPE0430  BPE0433  BPE0435  BPE0438  BPE0439

 BMC50471I ANALMAX=1000%                           FSTHRESHOLD=0                           ROUTCDE=(11,1)     
 BMC50471I ARC=NO                                  ICDDN=(BMCICY,BMCICZ)                   SCPYMAX=8          
 BMC50471I ARCHDDN=SYSARC                          ICTYPE=AUTO                             SDUMP=YES          
 BMC50471I ARCHFORMAT=BMC                          IDCACHE=10000                           SHORTMEMORY=CONTINUE
 BMC50471I AVAILPAGEPCT=100                        INDREFLM=10                             SIXSNAP=NO         
 BMC50471I BILDMAX=300%                            INLINECP=YES                            SMAX=0               
 BMC50471I BMCHIST=YES                             KEEPDICTIONARY=NO                       SMCORE=(0K,0K)     
 BMC50471I CBUFFS=30                               LEAFDSLM=200                            SORTDEVT=(,SYSALLDA)
 BMC50471I CONDEXEC=NO                             LOCKROW=YES                             SORTNUM=32         
 BMC50471I COPYDDN=(BMCCPY,BMCCPZ)                 LOGFINAL=NONE                           SPILDSNP=&UID       
 BMC50471I COPYLVL=PART                            LOGMEM=0                                SPILSCLS=NONE      
 BMC50471I COPYMAX=1000%                           LOGSPIL=(20000,10000)                   SPILUNIT=WORK       
 BMC50471I COPYSUBSET=NO                           LOGTHRSH=0                              SQLDELAY=3         
 BMC50471I CPYRFAIL=TERM                           LONGLOG=CONTINUE                        SQLRETRY=100        
 BMC50471I DATACAP=NO                              LONGNAMETRUNC=MIDDLE                    STAGEDSN=BMC       
 BMC50471I DDLDDN=DDLIN                            MAPTEXIT=(NONE,REXX)                    STOP@CMT=YES       
 BMC50471I DEADLINE=NONE                           MAXNEWPARTS=2                           STOPDELAY=1        
 BMC50471I DELAY=1200                              MAXRO=300                               STOPRETRY=300      
 BMC50471I DELFILES=YES                            MAXSORTMEMORY=0                         TAPEDISP=DELETE     
 BMC50471I DESCCDE=(3,7)                           MAXTAPE=3                               TASKMAX=1000%      
 BMC50471I DRAINTYP=ALL                            MGEXTENT=CONTINUE                       TERMEXIT=(NONE,REXX)
 BMC50471I DRNDELAY=1                              MINSORTMEMORY=0                         TIMEOUT=TERM       
 BMC50471I DRNRETRY=255                            MSGLEVEL=1                              TOTALPAGEPCT=0      
 BMC50471I DRNWAIT=NONE                            OFFPOSLM=10                             TSSAMPLEPCT=100    
 BMC50471I DSNUEXIT=(NONE,ASM)                     OPNDB2ID=YES                            UBUFFS=20          
 BMC50471I DSNUTILB=YES                            ORIGDISP=DELETE                         UNLDDN=SYSREC      
 BMC50471I DSPLOCKS=DRNFAIL                        PREFORMAT=NO                            UNLDMAX=300%       
 BMC50471I DSRSEXIT=(NONE,REXX)                    RCVICDDN=(BMCIRY,BMCIRZ)                UNLOAD=RELOAD      
 BMC50471I EXCLDUMP=(X37,X22,X06)                  RCVYDDN=(BMCRCY,BMCRCZ)                 UXSTATE=SUP        
 BMC50471I FASTSWITCH=NO                           REDEFINE=YES                            WBUFFS=(20,10)      
 BMC50471I FILECHK=WARN                            RENMMAX=30                              WORKDDN=SYSUT1     
 BMC50471I FORCE_AT=(START,3)                      RIDMDSSZ=2097152                        WORKUNIT=SYSALLDA   
 BMC50471I FORCE_RPT=NO                            RIDMMAXD=1                              XBMID=             
 BMC50471I FORCE=NONE                              RMAPMEM=0                               ZIIP=ENABLED        
 BMC50471I FSFALLBACK=NO                           RORGMAX=300%                            

 BMC50471I PLAN=ARUQA

 BMC50470I DDTYPE   = UNLOAD                             WORK                                 SORTWORK
 BMC50470I ACTIVE   = YES                                YES                                  NO
 BMC50470I IFALLOC  = USE                                USE                                  USE
 BMC50470I ALLOC    = N/A                                N/A                                  ANY
 BMC50470I SMS      = NO                                 NO                                   NO
 BMC50470I SMSUNIT  = NO                                 NO                                   NO
 BMC50470I SIZEPCT  = (100,100)                          (100,100)                            (100,100)
 BMC50470I UNIT     = (SYSALLDA,SYSALLDA)                (SYSALLDA,SYSALLDA)                  (SYSALLDA,SYSALLDA)
 BMC50470I UNITCNT  = (0,0)                              (0,0)                                N/A
 BMC50470I VOLCNT   = (25,25)                            (25,25)                              N/A
 BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK))          ((30000,TRK),(30000,TRK))            N/A
 BMC50470I DSNTYPE  = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I DATACLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I MGMTCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I STORCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I THRESHLD = 0                                  0                                    0
 BMC50470I MAXEXTSZ = ((0,K),(0,K))                      ((0,K),(0,K))                        N/A
 BMC50470I EXPDT    = N/A                                N/A                                  N/A
 BMC50470I RETPD    = N/A                                N/A                                  N/A
 BMC50470I GDGLIMIT = N/A                                N/A                                  N/A
 BMC50470I GDGEMPTY = N/A                                N/A                                  N/A
 BMC50470I GDGSCRAT = N/A                                N/A                                  N/A

 BMC50470I DDTYPE   = ARCHIVE                            LOCPFCPY                             LOCPICPY
 BMC50470I ACTIVE   = NO                                 YES                                  YES
 BMC50470I IFALLOC  = USE                                USE                                  USE
 BMC50470I ALLOC    = N/A                                N/A                                  N/A
 BMC50470I SMS      = NO                                 NO                                   NO
 BMC50470I SMSUNIT  = NO                                 NO                                   NO
 BMC50470I SIZEPCT  = (100,100)                          (100,100)                            (5,100)
 BMC50470I UNIT     = (SYSALLDA,SYSALLDA)                (SYSALLDA,SYSALLDA)                  (SYSALLDA,SYSALLDA)
 BMC50470I UNITCNT  = (0,0)                              (0,0)                                (0,0)
 BMC50470I VOLCNT   = (25,25)                            (25,25)                              (25,25)
 BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK))          ((30000,TRK),(30000,TRK))            ((30000,TRK),(30000,TRK))
 BMC50470I DSNTYPE  = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I DATACLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I MGMTCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I STORCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I THRESHLD = 0                                  0                                    0
 BMC50470I MAXEXTSZ = ((0,K),(0,K))                      ((0,K),(0,K))                        ((0,K),(0,K))
 BMC50470I EXPDT    =
 BMC50470I RETPD    =
 BMC50470I GDGLIMIT = 5                                  5                                    5
 BMC50470I GDGEMPTY = NO                                 NO                                   NO
 BMC50470I GDGSCRAT = NO                                 NO                                   NO

 BMC50470I DDTYPE   = LOCBFCPY                           LOCBICPY                             REMPFCPY
 BMC50470I ACTIVE   = NO                                 NO                                   NO
 BMC50470I IFALLOC  = USE                                USE                                  USE
 BMC50470I ALLOC    = N/A                                N/A                                  N/A
 BMC50470I SMS      = NO                                 NO                                   NO
 BMC50470I SMSUNIT  = NO                                 NO                                   NO
 BMC50470I SIZEPCT  = (100,100)                          (100,100)                            (100,100)
 BMC50470I UNIT     = (SYSALLDA,SYSALLDA)                (SYSALLDA,SYSALLDA)                  (SYSALLDA,SYSALLDA)
 BMC50470I UNITCNT  = (0,0)                              (0,0)                                (0,0)
 BMC50470I VOLCNT   = (25,25)                            (25,25)                              (25,25)
 BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK))          ((30000,TRK),(30000,TRK))            ((30000,TRK),(30000,TRK))
 BMC50470I DSNTYPE  = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I DATACLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I MGMTCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I STORCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I THRESHLD = 0                                  0                                    0
 BMC50470I MAXEXTSZ = ((0,K),(0,K))                      ((0,K),(0,K))                        ((0,K),(0,K))
 BMC50470I EXPDT    =
 BMC50470I RETPD    =
 BMC50470I GDGLIMIT = 5                                  5                                    5
 BMC50470I GDGEMPTY = NO                                 NO                                   NO
 BMC50470I GDGSCRAT = NO                                 NO                                   NO

 BMC50470I DDTYPE   = REMPICPY                           REMBFCPY                             REMBICPY
 BMC50470I ACTIVE   = NO                                 NO                                   NO
 BMC50470I IFALLOC  = USE                                USE                                  USE
 BMC50470I ALLOC    = N/A                                N/A
 BMC50470I SMS      = NO                                 NO                                   NO
 BMC50470I SMSUNIT  = NO                                 NO                                   NO
 BMC50470I SIZEPCT  = (100,100)                          (100,100)                            (100,100)
 BMC50470I UNIT     = (SYSALLDA,SYSALLDA)                (SYSALLDA,SYSALLDA)                  (SYSALLDA,SYSALLDA)
 BMC50470I UNITCNT  = (0,0)                              (0,0)                                (0,0)
 BMC50470I VOLCNT   = (25,25)                            (25,25)                              (25,25)
 BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK))          ((30000,TRK),(30000,TRK))            ((30000,TRK),(30000,TRK))
 BMC50470I DSNTYPE  = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I DATACLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I MGMTCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I STORCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I THRESHLD = 0                                  0                                    0
 BMC50470I MAXEXTSZ = ((0,K),(0,K))                      ((0,K),(0,K))                        ((0,K),(0,K))
 BMC50470I EXPDT    =
 BMC50470I RETPD    =
 BMC50470I GDGLIMIT = 5                                  5                                    5
 BMC50470I GDGEMPTY = NO                                 NO                                   NO
 BMC50470I GDGSCRAT = NO                                 NO                                   NO

 BMC50470I DDTYPE   = SYSPUNCH
 BMC50470I ACTIVE   = YES
 BMC50470I IFALLOC  = USE
 BMC50470I ALLOC    = N/A
 BMC50470I SMS      = NO
 BMC50470I SMSUNIT  = NO
 BMC50470I SIZEPCT  = (100,100)
 BMC50470I UNIT     = (SYSALLDA,SYSALLDA)
 BMC50470I UNITCNT  = (0,0)
 BMC50470I VOLCNT   = (25,25)
 BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK))
 BMC50470I DATACLAS = (NONE,NONE)
 BMC50470I MGMTCLAS = (NONE,NONE)
 BMC50470I STORCLAS = (NONE,NONE)
 BMC50470I THRESHLD = 0
 BMC50470I MAXEXTSZ = ((0,K),(0,K))
 BMC50470I EXPDT    =
 BMC50470I RETPD    =
 BMC50470I GDGLIMIT = 0
 BMC50470I GDGEMPTY = NO
 BMC50470I GDGSCRAT = NO

 BMC50470I DDTYPE   = LOCPLCPY                           LOCBLCPY
 BMC50470I ACTIVE   = NO                                 NO
 BMC50470I IFALLOC  = USE                                USE
 BMC50470I ALLOC    = N/A                                N/A
 BMC50470I SMS      = NO                                 NO
 BMC50470I SMSUNIT  = NO                                 NO
 BMC50470I SIZEPCT  = (100,100)                          (100,100)
 BMC50470I UNIT     = (SYSALLDA,SYSALLDA)                (SYSALLDA,SYSALLDA)
 BMC50470I UNITCNT  = (0,0)                              (0,0)
 BMC50470I VOLCNT   = (25,25)                            (25,25)
 BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK))          ((30000,TRK),(30000,TRK))
 BMC50470I DSNTYPE  = (NONE,NONE)                        (NONE,NONE)
 BMC50470I DATACLAS = (NONE,NONE)                        (NONE,NONE)
 BMC50470I MGMTCLAS = (NONE,NONE)                        (NONE,NONE)
 BMC50470I STORCLAS = (NONE,NONE)                        (NONE,NONE)
 BMC50470I THRESHLD = 0                                  0
 BMC50470I MAXEXTSZ = ((0,K),(0,K))                      ((0,K),(0,K))
 BMC50470I EXPDT    =
 BMC50470I RETPD    =
 BMC50470I GDGLIMIT = 5                                  5
 BMC50470I GDGEMPTY = NO                                 NO
 BMC50470I GDGSCRAT = NO                                 NO

 BMC50470I DDTYPE   = REMPLCPY                           REMBLCPY
 BMC50470I ACTIVE   = NO                                 NO
 BMC50470I IFALLOC  = USE                                USE
 BMC50470I ALLOC    = N/A                                N/A
 BMC50470I SMS      = NO                                 NO
 BMC50470I SMSUNIT  = NO                                 NO
 BMC50470I SIZEPCT  = (100,100)                          (100,100)
 BMC50470I UNIT     = (SYSALLDA,SYSALLDA)                (SYSALLDA,SYSALLDA)
 BMC50470I UNITCNT  = (0,0)                              (0,0)
 BMC50470I VOLCNT   = (25,25)                            (25,25)
 BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK))          ((30000,TRK),(30000,TRK))
 BMC50470I DSNTYPE  = (NONE,NONE)                        (NONE,NONE)
 BMC50470I DATACLAS = (NONE,NONE)                        (NONE,NONE)
 BMC50470I MGMTCLAS = (NONE,NONE)                        (NONE,NONE)
 BMC50470I STORCLAS = (NONE,NONE)                        (NONE,NONE)
 BMC50470I THRESHLD = 0                                  0
 BMC50470I MAXEXTSZ = ((0,K),(0,K))                      ((0,K),(0,K))
 BMC50470I EXPDT    =
 BMC50470I RETPD    =
 BMC50470I GDGLIMIT = 5                                  5
 BMC50470I GDGEMPTY = NO                                 NO
 BMC50470I GDGSCRAT = NO                                 NO




 BMC50483I UNLOAD     DSNPAT=&UID..BMC.&TSIX.&DDNAME
 BMC50483I WORK       DSNPAT=&UID..BMC.&TSIX.&DDNAME
 BMC50483I SORTWORK   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I ARCHIVE    DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I SYSPUNCH   DSNPAT=&UID.&UTILPFX.&DDNAME

 BMC50483I LOCPFCPY   DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
 BMC50483I LOCPICPY   DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
 BMC50483I LOCBFCPY   DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
 BMC50483I LOCBICPY   DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
 BMC50483I LOCPLCPY   DSNPAT=&UID.&DDNAME.&TSIX..T&TIME
 BMC50483I LOCBLCPY   DSNPAT=&UID.&DDNAME.&TSIX..T&TIME

 BMC50483I REMPFCPY   DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
 BMC50483I REMPICPY   DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
 BMC50483I REMBFCPY   DSNPAT=&UID.&DDNAME.&TSIX..F&PART..T&TIME
 BMC50483I REMPLCPY   DSNPAT=&UID.&DDNAME.&TSIX..T&TIME
 BMC50483I REMBLCPY   DSNPAT=&UID.&DDNAME.&TSIX..T&TIME

 BMC50471I DB2 DSNHDECP MODULE SETTINGS:
 BMC50471I VERSION                 = 1110
 BMC50471I SUBSYSTEM DEFAULT       = DEHJ
 BMC50471I CHARACTER SET           = ALPHANUM
 BMC50471I DATE FORMAT             = USA
 BMC50471I TIME FORMAT             = USA
 BMC50471I LOCAL DATE LENGTH       = 0
 BMC50471I LOCAL TIME LENGTH       = 0
 BMC50471I DECIMAL POINT           = PERIOD
 BMC50471I DECIMAL ARITHMETIC      = 15
 BMC50471I DELIMITER               = DEFAULT
 BMC50471I SQL DELIMITER           = DEFAULT
 BMC50471I ENCODING SCHEME         = EBCDIC
 BMC50471I APPL. ENCODING SCHEME   = EBCDIC
 BMC50471I MIXED                   = NO
 BMC50471I EBCDIC CCSID            = (37,65534,65534)
 BMC50471I ASCII CCSID             = (819,65534,65534)
 BMC50471I UNICODE CCSID           = (367,1208,1200)
 BMC50471I IMPLICIT TIME ZONE      = CURRENT (-06:00)

 BMC50028I DB2 MODE = NFM
 BMC50471I BMCUTIL ='BMCUTIL.CMN_BMCUTIL'
 BMC50471I BMCSYNC ='BMCUTIL.CMN_BMCSYNC'
 BMC50471I BMCHIST ='BMCUTIL.CMN_BMCHIST'
 BMC50471I BMCDICT ='BMCUTIL.CMN_BMCDICT'
 BMC50471I BMCXCOPY='BMCUTIL.CMN_BMCXCOPY'
 BMC50471I DASD MANAGER PLUS TABLES:


 BMC50102I REORG TABLESPACE ARUDB001.TS001
 BMC50102I COPY YES
 BMC50102I UPDATEDB2STATS YES
 BMC50102I REDEFINE YES
 BMC50102I DELETEFILES NO
 BMC50102I DDTYPE UNLOAD ACTIVE NO
 BMC50102I DDTYPE WORK ACTIVE NO
 BMC50102I DDTYPE LOCPFCPY ACTIVE NO

 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(0) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00000000 FOR DBID(4086) PSID(2)
 BMC51301I 1: SAMPLING STATISTICS: PART=0,TP=656,SP=92,SR=1377,AVGR=173,SD=65,SE=0,AVGF=1496,SD=65,SE=57,EP=11
 BMC51265I ESTIMATED CARDINALITY OF SPACE = 9788  AVG SORTWK ROW LENGTH = 173  AVG UNLOAD ROW LENGTH = 173
 BMC50484I ESTIMATED CARDINALITY OF TABLE TS0011 = 9788  AVG SORTWK ROW LENGTH = 173  AVG UNLOAD ROW LENGTH = 173
 BMC51264I UNLOAD WILL READ 654 DATA PAGES FROM SPACE 'ARUDB001.TS001'
 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  = CXBAEXM1  &STEPNAME = BMCREORG  &DB       = ARUDB001  &TSIX     = TS001     &RTYPE    = TS
 BMC50425I &UID      = RDACXB2   &DATE     = 022815    &TIME     = 143833    &SSID     = DEHJ      &UTIL     = ARU01
 BMC50425I &UTILPFX  = ARU01     &UTILSFX  =           &DATE8    = 02282015  &GRPNM    = DEHJ      &VCAT     = DEHJCAT
 BMC50425I &TIME4    = 1438      &DATEJ    = 2015059   &JDATE    = 15059

 BMC50445I REORG PLUS DYNAMIC FILE ALLOCATION REPORT
 BMC50394I UNABLE TO LOCATE SORT WORK DATASETS, DDNAME = 'SORTWKNN'
 BMC50474I BELOW 16M = 8164K, ABOVE 16M = 1303292K, CPUS = 3
 BMC50479I TOTAL PAGES: 4911995, ALLOWED: 0; AVAILABLE PAGES: 3326447, ALLOWED: 3326447
 BMC51302I MAX TASKS = 1, 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
 BMC50477I 1: PARTITION =    0, ROWS/KEYS = 10000, I/O WAITS = 2 ,DDNAME = SYS00017
 BMC51272I UNLOAD STATISTICS:  10000 ROWS UNLOADED FROM SPACE 'ARUDB001.TS001', 0 ROWS DISCARDED, 0 ROWS UPDATED
 BMC51282I UNLOAD STATISTICS:  X'0000000004AB740956FB' IS THE HIGHEST LOGRBA FOR SPACE 'ARUDB001.TS001'
 BMC50481I 1: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.ARUDB001.TS001.I0001.A001'
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.ARUDB001.TS00111.I0001.A001'
 BMC50477I 1: PARTITION =    0, ROWS/KEYS = 10000, I/O WAITS = 5 ,DDNAME = SYS00024
 BMC50482I 1: RELOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.ARUDB001.TS001.I0001.A001'
 BMC50477I 1: PARTITION =    0, ROWS/KEYS = 10000, I/O WAITS = 5 ,DDNAME = SYS00020
 BMC50481I 1: REORG TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50476I DDNAME = SYSREC, I/OS = 9, I/O WAITS = 4, RDB LOCK WAITS = 0
 BMC51276I BUILD  STATISTICS:  10000 KEYS LOADED INTO INDEX 'ARU.TS00111'
 BMC51275I RELOAD STATISTICS:  10000 ROWS LOADED INTO SPACE 'ARUDB001.TS001'
 BMC50476I DDNAME = BMCCPY, I/OS = 7, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPZ, I/OS = 7, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCY, I/OS = 7, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCZ, I/OS = 7, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50376I 657 PAGES COPIED TO DATASET = 'ARU.EXMPL01.BMCCPY'
 BMC50376I 657 PAGES COPIED TO DATASET = 'ARU.EXMPL01.BMCCPZ'
 BMC50376I 657 PAGES COPIED TO DATASET = 'ARU.EXMPL01.BMCRCY'
 BMC50376I 657 PAGES COPIED TO DATASET = 'ARU.EXMPL01.BMCRCZ'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I REORG PHASE COMPLETE.  ELAPSED TIME = 00:00:02

1BMCSTATS V11.02.00 REPORT FOR DEHJ V1115 (111)       TIME 2015-02-28-14.38.34.889043                                          1


   INDEX --------------- ARU.TS00111
     ASSOCIATIONS
       TABLESPACE ------ ARUDB001.TS001
       TABLE ----------- ARU.TS0011
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------R  LOCATION------------------DEHJ
       SAMPLING---------------------N
     ATTRIBUTES
       PIECESIZE--------------2097152  TYPE TS----------------(BLANK)  UNIQUERULE-------------------D  KEYLENGTH-------------------51
       SPARSE-----------------------N  INDEXTYPE--------------------2  CLUSTERING-------------------Y  COLCOUNT---------------------2
       INDEXSPACE-------------TS00111  PGSIZE-----------------------4  EXTTYPE----------------(BLANK)  COMPRESS---------------------N
       COLNAME----------------EMPNAME
     STATISTICS
       FIRSTKEYCARD-----------------1  FULLKEYCARD--------------10000  NACTIVE--------------------174  TBCARDF------------------10000
       NUMNONLEAF-------------------4  NLEVELS----------------------3  CLUSTERRATIO---------------100  NLEAF----------------------167
       AVGKEYLEN-------------------51  REORGSPACE------------------15  REORGSPACE_KB--------------720  REORGNLEVELS-----------------3
       HIGH2K-----X'00D1C1C3D8E4C5D3'  HIGH2K (CHAR)---------.JACQUEL  LOW2K------X'00D1C1C3D8E4C5D3'  LOW2K (CHAR)----------.JACQUEL
       DATAREPEAT-----------------589
     ALLOCATION
       SPACE----------------------150  SPACE_KB------------------7200  NUMDATASETS------------------1

   INDEXPART ----------- ARU.TS00111
     ASSOCIATIONS
       TABLESPACE ------ ARUDB001.TS001
       TABLE ----------- ARU.TS0011
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------R  LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY------------------------10  SQTY-------------------------5  PCTFREE---------------------10  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------E  NLAVGKEYLEN-----------------51  VCATNAME---------------DEHJCAT
       RBA_FORMAT------------EXTENDED  STORNAME---------------DEHJCAT
     STATISTICS
       FIRSTKEYCARD-----------------1  FULLKEYCARD--------------10000  CARD---------------------10000  NACTIVE--------------------174
       CLUSTERRATIO---------------100  NUMNONLEAF-------------------4  NLEVELS----------------------3  FAROFFPOS--------------------0
       NEAROFFPOS------------------65  LEAFDIST---------------------1  NLEAF----------------------167  FREE------------------------75
       FULL-------------------------0  AVGKEYLEN-------------------51
       LEAFNEAR---------------------3  LEAFFAR----------------------0  PSEUDO_DEL_RIDS--------------0  REORGSPACE------------------15
       REORGSPACE_KB--------------720  REORGNLEVELS-----------------3  PCTUSED---------------------10  PQTYROWS----------------106067
       DATAREPEAT-----------------589
     ALLOCATION
       IPREFIX----------------------I  SPACE----------------------150  SPACE_KB------------------7200  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------TMO003

   COLUMN -------------- EMPNAME
     ASSOCIATIONS
       TABLESPACE ------ ARUDB001.TS001
       TABLE ----------- ARU.TS0011
     ATTRIBUTES
       COLNO------------------------3  COLTYPE-------------------CHAR  LENGTH----------------------40  NULLS------------------------Y
     STATISTICS
       COLCARD----------------------1  COLNULLS---------------------0  COLAVG----------------------41  COLMIN----------------------41
       COLMAX----------------------41
       HIGH2K-----X'00D1C1C3D8E4C5D3'  HIGH2K (CHAR)---------.JACQUEL  LOW2K------X'00D1C1C3D8E4C5D3'  LOW2K (CHAR)----------.JACQUEL

       MOST FREQUENT VALUES
1BMCSTATS V11.02.00 REPORT FOR DEHJ V1115 (111)       TIME 2015-02-28-14.38.34.889043                                          2

        FREQUENCY-------------1.000000     COLVAL-X'00D1C1C3D8E4C5D3E8D540D2C1E8C540C8C1E6D2C9D5E2C6E2E2E2E2E2E2E2E2E2E2E2E2E2E2E2'
                                           (CHAR)-----------------------------------------.JACQUELYN KAYE HAWKINSFSSSSSSSSSSSSSSSSS

   KEYCARD ------------- EMPNAME
     ASSOCIATIONS
       TABLESPACE ------ ARUDB001.TS001
       TABLE ----------- ARU.TS0011
     ATTRIBUTES AND STATISTICS
       COLUMN-----------------EMPNAME  COLCARD----------------------1  COLTYPE-------------------CHAR  LENGTH----------------------40
       COLUMN-------------------EMPNO  COLCARD------------------10000  COLTYPE-------------------CHAR  LENGTH-----------------------9
1BMCSTATS V11.02.00 REPORT FOR DEHJ V1115 (111)       TIME 2015-02-28-14.38.34.889043                                          1


 TABLESPACE ------------ ARUDB001.TS001
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------R  LOCATION------------------DEHJ
       SAMPLING---------------------N
     ATTRIBUTES
       PARTITIONS-------------------0  NTABLES----------------------1  PGSIZE-----------------------4  SEGSIZE---------------------64
       DSSIZE-----------------------0
       MAXROWS--------------------255  TYPE-------------------(BLANK)  ENCODING---------------------E  MAXPARTITIONS----------------0
       LOB--------------------------N  XML--------------------------N  MEMBER_CLUSTER---------(BLANK)
     STATISTICS
       NACTIVE--------------------656  REORGSPACE------------------60  REORGSPACE_KB-------------2880  ROWMAXFOUND----------------179
       ROWMINFOUND----------------179  ROWAVG---------------------179
     ALLOCATION
       SPACE-----------------------90  SPACE_KB------------------4320  NUMDATASETS------------------1

   TABLEPART ----------- ARUDB001.TS001
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------R
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------1  SQTY-------------------------1  PCTFREE---------------------20  FREEPAGE---------------------9
       ALLOCUNIT--------------------C  STORTYPE---------------------E  COMPRESS---------------(BLANK)  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  VCATNAME---------------DEHJCAT  STORNAME----------------------
     STATISTICS
       CARD---------------------10000  NACTIVE--------------------656  NPAGES---------------------589  ROWAVG---------------------179
       ROWMAXFOUND----------------179  ROWMINFOUND----------------179  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL-------------------------0  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE------------------66
       PCTPAGES--------------------89  PERCDROP---------------------0  REORGSPACE------------------60  REORGSPACE_KB-------------2880
       PCTUSED---------------------66  PQTYROWS------------------1958
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------90  SPACE_KB------------------4320  NUMDATASETS------------------1
       EXTENTS----------------------3  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------ARU4D3

   TABLE --------------- ARU.TS0011
     ASSOCIATIONS
       TABLESPACE ------ ARUDB001.TS001
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------R  LOCATION----------------(NULL)
     STATISTICS
       CARD---------------------10000  NPAGES---------------------589  SPACE_KB---------------------0  AVGNONCOMPROWLEN----------(-1)
       ROWAVG---------------------179  ROWMAXFOUND----------------179  ROWMINFOUND----------------179  INDREF-----------------------0
       PCTPAGES--------------------89  PCTROWCOMP-------------------0
 BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR REORG UTILITY SUCCESSFUL FOR ALL OBJECTS
 BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0

Related topic

Examples-of-REORG-PLUS-jobs

 

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