Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Example 7: Selective unload with discards to archive data set

In this example, REORG PLUS reorganizes a Partitioned by Growth table space containing only one table.

The table has one nonpartitioned secondary index.

Although the installation options enable dynamic allocation for the unload, work, and primary copy data sets, they also specify IFALLOC USE for these data sets. Therefore, the job does not have to specify ACTIVE NO to have REORG PLUS use the data sets allocated in the JCL.

In the SYSPRINT output, message BMC50477I (issued during the UNLOAD phase) indicates the total number of rows in the table space before the reorganization. Message BMC51272I (issued at the end of the UNLOAD phase) indicates the number of rows selected to be unloaded, the number of rows discarded, and the number of rows updated.

Related topic

Examples-of-REORG-PLUS-jobs

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

UNLOAD CONTINUE

Tells REORG PLUS to continue the reorganization with two-phase processing after the UNLOAD phase has unloaded the data

COPY YES

Creates a Db2 image copy of the table space

REORG PLUS makes four copies of the table space after reorganizing it.

REGISTER (ARUCPY1, ARUCPY3)

Specifies that only two of the four copies, ARUCPY1 and ARUCPY3, are to be registered in SYSIBM.SYSCOPY

COPYDDN (ARUCPY1, ARUCPY2)

  • Specifies ddnames of ARUCPY1 and ARUCPY2 for the two local data sets that receive full local image copies of the table space that you are reorganizing
  • Overrides the default names of the BMCCPY and BMCCPZ

RECOVERYDDN (ARUCPY3, ARUCPY4)

  • Specifies ddnames of ARUCPY3 and ARUCPY4 for the two data sets that receive full remote image copies of the table space that you are reorganizing
  • Overrides the default names of BMCRCY and BMCRCZ

ARCHDDN (ARUARC)

  • Specifies a ddname of ARUARC for the archive data set
  • Overrides the default name of SYSARC

REDEFINE NO

Tells REORG PLUS not to delete and redefine the VSAM data sets containing the Db2 objects

Instead, REORG PLUS will reset the HURBA.

ORDER NO

Performs no ordering at all, and the rows retain the order of the table before reorganization

SELECT * FROM

Specifies the table name that contains the rows and that only rows that meet the specified WHERE clause are to be unloaded and reloaded

WHERE

Specifies the conditions that must be true for rows to be unloaded and reloaded

//SYSREC

Contains the rows that you are reorganizing

//ARUCPY1

//ARUCPY2

//ARUCPY3

//ARUCPY4

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

//ARUARC

The ddname that is used for the data set that will contain the rows not selected

//SYSUT1

The SYSUT1 data set to be allocated for the nonpartitioned secondary index

The following figure shows the JCL for example 7: 

//  JOBCARD
//**********************ARUEX007***************************************
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//*     PBG TABLESPACE, ONE TABLE, ONE INDEX                          *
//*   REORG TABLESPACE RETAINING ONLY SELECTED ROWS                   *
//*   ALL DELETED ROWS GO TO THE ARCHIVE DATASET                      *
//*   MAKE 4 COPIES (TWO LOCALS, TWO REMOTES)                         *
//*   REGISTER ONLY THE PRIMARY COPIES.                               *
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//*====================================================================
//*  Replace "DB2SYS" by your DB2 subsystem name.                     *
//*  Use your DB2 product install libraries for STEPLIBS :            *
//*     PRODUCT.LIBRARIES                                             *
//*     DB2.DSNEXIT                                                   *
//*     DB2.DSNLOAD                                                   *
//*====================================================================
//EXAMPL7   EXEC PGM=ARUUMAIN,
//          PARM='DB2SYS,ARUEX07,NEW/RESTART,,MSGLEVEL(1)'
//*               SSID,UTILID,RSTART,NOTIFY,MSGLEVEL
//STEPLIB   DD DISP=SHR,DSN=PRODUCT.LIBRARIES
//          DD DISP=SHR,DSN=DB2.DSNEXIT
//          DD DISP=SHR,DSN=DB2.DSNLOAD
//*
//SYSPRINT  DD  SYSOUT=*
//UTPRINT   DD  SYSOUT=*
//*
//SYSREC    DD DSN=ARU.INPUT.EXAMPL07.SYSREC,
//          DISP=(MOD,CATLG,CATLG),
//          UNIT=WORK,SPACE=(CYL,(30,10))
//*
//ARUCPY1   DD DSN=ARU.EXAMPL07.ARUCPY1,
//          DISP=(,CATLG),
//          SPACE=(CYL,(1,1),RLSE),UNIT=WORK
//ARUCPY2   DD DSN=ARU.EXAMPL07.ARUCPY2,
//          DISP=(,CATLG),
//          SPACE=(CYL,(1,1),RLSE),UNIT=WORK
//ARUCPY3   DD DSN=ARU.EXAMPL07.ARUCPY3,
//          DISP=(,CATLG),
//          SPACE=(CYL,(1,1),RLSE),UNIT=WORK
//ARUCPY4   DD DSN=ARU.EXAMPL07.ARUCPY4,
//          DISP=(,CATLG),
//          SPACE=(CYL,(1,1),RLSE),UNIT=WORK
//*
//ARUARC    DD DSN=ARU.EXAMPL07.ARUARC,
//          DISP=(MOD,CATLG,CATLG),
//          UNIT=WORK,SPACE=(CYL,(10,10))
//*
//SYSUT1    DD DSN=ARU.EXAMPL07.SYSUT1,
//          DISP=(MOD,CATLG,CATLG),
//          UNIT=WORK,SPACE=(CYL,(1,1),RLSE)
//*
//SYSIN     DD  *
REORG TABLESPACE ARUDB210.TS210
UNLOAD CONTINUE
COPY YES REGISTER (ARUCPY1, ARUCPY3)
COPYDDN (ARUCPY1, ARUCPY2)
RECOVERYDDN (ARUCPY3, ARUCPY4)
ARCHDDN (ARUARC)
REDEFINE NO
ORDER NO
SELECT * FROM ARU.TS2101 WHERE
         (COL1_CHAR = 'JEREMY' AND COL2_DECIMAL = 111.0000)
/*

SYSPRINT for example 7

The following figure shows the SYSPRINT output for example 7:

1                               *****  B M C   R E O R G   P L U S   F O R   D B 2    V13R1.00  *****
                                             (C) COPYRIGHT 1988 - 2022 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   1/20/2022    1:57:04 ...
 BMC50002I UTILITY ID = 'EXMPL07R'.  DB2 SUBSYSTEM ID = 'DEMO'.  OPTION MODULE = 'ARU$OPTS'.
 BMC50471I z/OS 2.4.0,PID=HBB77C0,DFSMS FOR Z/OS=2.4.0,DB2=13.1.501
 BMC50471I REGION=0M,BELOW 16M=8836K,ABOVE 16M=1033700K,IEFUSI=NO,CPUs=7,GPs=5,zIIPs=2
 BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040300M,MEMLIMIT SET BY:REGION=0
 BMC50471I SMFID=DB2B,JOBID=J0646441,JOB=EXMPL07R,STEP=BMCREORG,CPU=8561-615 (z15)/1.71
0
 BMC50471I REORG PLUS FOR DB2--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I DB2 UTILITIES COMMON CODE--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I SOLUTION COMMON CODE--V13.01.00 BASE
 BMC50471I   MAINT: BPJ1541  BPJ1713  BPJ2211
 BMC50471I BMCSORT ENGINE--V02.04.01
 BMC50471I   MAINT: BPJ0691  BPJ0718  BPJ0881  BPJ0922  BPJ0996  BPJ1164  BPJ1309  BPJ1386  BPJ1497  BPJ1594  BPJ1724  BPJ1809
 BMC50471I          BPJ1833  BPJ1891  BPJ1905  BPJ2109  BPJ2232  BPJ2297
 BMC50471I BMC STATS API--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I EXTENDED BUFFER MANAGER--V06.02.01
 BMC50471I   MAINT: BPE0443  BPE0445  BPE0447  BPE0449  BPE0450  BPE0451  BPE0452  BPE0455  BPE0456  BPE0457  BPE0460  BPE0463
 BMC50471I          BPE0467  BPE0468  BPE0469  BPE0473  BPE0474  BPE0475  BPE0479  BPE0480  BPE0482  BPE0487  BPE0488  BPE0489
 BMC50471I          BPE0493  BPE0497  BPE0498  BPE0501  BPE0503  BPE0507  BPE0512  BPE0513  BPE0517  BPE0518  BPE0519  BPE0523
 BMC50471I          BPE0524  BPE0527  BPE0528  BPE0530  BPE0531  BPE0534  BPE0535  BPE0540  BPE0541  BPE0542  BPE0545  BPE0549
 BMC50471I          BPE0551  BPE0552  BPE0555  BPE0557
0
 BMC50471I ANALMAX=1000%                           ICTYPE=AUTO                             SDUMP=YES                          
 BMC50471I ARC=NO                                  IDCACHE=10000                           SHORTMEMORY=CONTINUE               
 BMC50471I ARCHDDN=SYSARC                          INDREFLM=10                             SIXSNAP=NO                         
 BMC50471I ARCHFORMAT=BMC                          INLINECP=YES                            SMAX=0                             
 BMC50471I AVAILPAGEPCT=100                        INVALIDATECACHE=YES                     SMCORE=(0K,0K)                     
 BMC50471I BILDMAX=300%                            KEEPDICTIONARY=NO                       SORTDEVT=(,SYSALLDA)               
 BMC50471I BMCHIST=YES                             LEAFDSLM=200                            SORTNUM=32                         
 BMC50471I CBUFFS=30                               LOCKROW=YES                             SPILDCLS=NONE                      
 BMC50471I CONDEXEC=NO                             LOGFINAL=NONE                           SPILDSNP=&UID                      
 BMC50471I COPYDDN=(BMCCPY,BMCCPZ)                 LOGMEM=0                                SPILSCLS=NONE                      
 BMC50471I COPYLVL=PART                            LOGSPIL=(20000,10000)                   SPILUNIT=WORK                      
 BMC50471I COPYMAX=1000%                           LOGTHRSH=0                              SQLDELAY=3                         
 BMC50471I COPYSUBSET=NO                           LONGLOG=CONTINUE                        SQLRETRY=100                       
 BMC50471I CPYRFAIL=TERM                           LONGNAMETRUNC=MIDDLE                    SSREPORT=REPORT_SWITCH             
 BMC50471I DATACAP=NO                              MAPTEXIT=(NONE,REXX)                    STAGEDSN=BMC                       
 BMC50471I DDLDDN=DDLIN                            MAXNEWPARTS=2                           STOP@CMT=YES                       
 BMC50471I DEADLINE=NONE                           MAXRO=300                               STOPDELAY=1                        
 BMC50471I DELAY=1200                              MAXSORTMEMORY=0                         STOPRETRY=300                      
 BMC50471I DELFILES=YES                            MAXTAPE=3                               TAPEDISP=DELETE                    
 BMC50471I DESCCDE=(3,7)                           MGEXTENT=CONTINUE                       TASKMAX=1000%                      
 BMC50471I DRAINTYP=ALL                            MINSORTMEMORY=0                         TERMEXIT=(NONE,REXX)               
 BMC50471I DRNDELAY=1                              MSGLEVEL=1                              TIMEOUT=TERM                       
 BMC50471I DRNRETRY=255                            OFFPOSLM=10                             TOTALPAGEPCT=0                     
 BMC50471I DRNWAIT=NONE                            OPNDB2ID=YES                            TSSAMPLEPCT=100                    
 BMC50471I DSNUEXIT=(NONE,ASM)                     ORIGDISP=DELETE                         UBUFFS=20                          
 BMC50471I DSNUTILB=YES                            PREFORMAT=NO                            UNLDDN=SYSREC                      
 BMC50471I DSPLOCKS=DRNFAIL                        RCVICDDN=(BMCIRY,BMCIRZ)                UNLDMAX=300%                       
 BMC50471I DSRSEXIT=(NONE,REXX)                    RCVYDDN=(BMCRCY,BMCRCZ)                 UNLOAD=RELOAD                      
 BMC50471I EXCLDUMP=(X37,X22,X06)                  REDEFINE=YES                            UXSTATE=SUP                        
 BMC50471I FASTSWITCH=NO                           RENMMAX=30                              WBUFFS=(20,10)                     
 BMC50471I FILECHK=WARN                            RIDCWTO=NO                              WORKDDN=SYSUT1                     
 BMC50471I FORCE_AT=(START,3)                      RIDMDSSZ=2097152                        WORKUNIT=SYSALLDA                  
 BMC50471I FORCE_RPT=NO                            RIDMMAXD=1                              WRLOG=NO                           
 BMC50471I FORCE=NONE                              RMAPMEM=0                               XBMID=                             
 BMC50471I FSFALLBACK=NO                           RORGMAX=300%                            ZIIP=ENABLED                       
 BMC50471I FSTHRESHOLD=0                           ROUTCDE=(11,1)                                                             
 BMC50471I ICDDN=(BMCICY,BMCICZ)                   SCPYMAX=8                                                                  
0
 BMC50471I PLAN=ARU1310T
0
 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                                
0
 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                                 
0
 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                                 
0
 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                                 
0
 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                                                                                                         
0
 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                                                                      
0
 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                                                                      
0
0
0
0
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
0
 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
0
 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                 = 1310
 BMC50471I SUBSYSTEM DEFAULT       = DEMO
 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)  
 
 BMC50658I DB2 CURRENT FUNCTION LEVEL IS V13R1M501  
 BMC50659I DB2 CATALOG LEVEL IS V13R1M501  
 BMC50660I DB2 HIGHEST ACTIVATED FUNCTION LEVEL IS V13R1M501  
 BMC50661I DB2 CODE LEVEL IS V13R1M501
 
 BMC50471I BMC_BMCUTIL       ='BMCUTIL.CMN_BMCUTIL'
 BMC50471I BMC_BMCSYNC       ='BMCUTIL.CMN_BMCSYNC'
 BMC50471I BMC_BMCHIST       ='BMCUTIL.CMN_BMCHIST'
 BMC50471I BMC_BMCDICT       ='BMCUTIL.CMN_BMCDICT'
 BMC50471I BMC_BMCXCOPY      ='BMCUTIL.CMN_BMCXCOPY'
 BMC50471I BMC_BMCSMARTSWITCH='BMCUTIL.CMN_BMCSWITCH'
 BMC50471I DASD MANAGER PLUS TABLES:
 BMC50471I ...'ATS131.RS_COLDIST_VW'
 BMC50471I ...'ATS131.RS_COLDISTSTAT_VW'
 BMC50471I ...'ATS131.RS_COLSTATS_VW'
 BMC50471I ...'ATS131.RS_COLUMNS_VW'
 BMC50471I ...'ATS131.RS_INDEXES_VW'
 BMC50471I ...'ATS131.RS_INDEXPART_VW'
 BMC50471I ...'ATS131.RS_IXPART_DIST_VW'
 BMC50471I ...'ATS131.RS_KEYTGTDIST_VW'
 BMC50471I ...'ATS131.RS_STOGROUP_VW'
 BMC50471I ...'ATS131.RS_TABLEPART_VW'
 BMC50471I ...'ATS131.RS_TABLES_VW'
 BMC50471I ...'ATS131.RS_TABLESPACE_VW'
 BMC50471I ...'ATS131.RS_TSPART_DIST_VW'
 
0
 BMC50102I REORG TABLESPACE ARUDB210.TS210
 BMC50102I UNLOAD CONTINUE
 BMC50102I COPY YES REGISTER (ARUCPY1, ARUCPY3)
 BMC50102I COPYDDN (ARUCPY1, ARUCPY2)
 BMC50102I RECOVERYDDN (ARUCPY3, ARUCPY4)
 BMC50102I ARCHDDN (ARUARC)
 BMC50102I REDEFINE NO
 BMC50102I ORDER NO
 BMC50102I SELECT * FROM ARU.TS2101 WHERE
 BMC50102I          (COL1_CHAR = 'JEREMY' AND COL2_DECIMAL = 111.0000)
 
 BMC50004I UTILINIT PHASE COMPLETE.  ELAPSED TIME = 00:00:00
 
 BMC54000I SMARTSWITCH NOT SUPPORTED - NO BMC AMI UTILITIES VERSION FOUND
 BMC54003I SMARTSWITCH RULE: FORCE_NO_SWITCH  COMMENT: SMARTSWITCH NOT ACTIVATED, NO ROWS ON POLICY TABLE
 
 BMC50199I REORG PLUS PROCESSING CONTINUES
 
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50244I PROCESSING PAGESET DBID(1951) PSID(2) PART(1) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00000000 FOR DBID(1951) PSID(2)
 BMC50245I REGISTERING SYSTEM PAGE - 00000002 FOR DBID(1951) PSID(2)
 BMC51301I 1: SAMPLING STATISTICS: PART=1,TP=68,SP=66,SR=1266,AVGR=66,SD=65,SE=0,AVGF=1918,SD=65,SE=259,EP=36
 BMC51265I ESTIMATED CARDINALITY OF SPACE = 1266  AVG SORTWK ROW LENGTH = 66  AVG UNLOAD ROW LENGTH = 66
 BMC50484I ESTIMATED CARDINALITY OF PART 0001 = 1266  AVG SORTWK ROW LENGTH = 66  AVG UNLOAD ROW LENGTH = 66
 BMC51264I UNLOAD WILL READ 66 DATA PAGES FROM SPACE 'ARUDB210.TS210'
 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  = EXMPL07R  &STEPNAME = BMCREORG  &DB       = ARUDB210  &TSIX     = TS210     &RTYPE    = TS      
 BMC50425I &UID      = BMCPMN    &DATE     = 122021    &TIME     = 015704    &SSID     = DEMO      &UTIL     = EXMPL07R
 BMC50425I &UTILPFX  = EXMPL07R  &UTILSFX  =           &DATE8    = 12202021  &GRPNM    = DEMO      &VCAT     = DEMOCAT
 BMC50425I &TIME4    = 0157      &DATEJ    = 2021354   &JDATE    = 21354                                               
 
 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 ARUCPY11 BMCPMN.ARUCPY11.TS210.F001.T015704           SYSALLDA                    4193268   419326    65535     30561  TRK
 BMC50448I ARUCPY12 BMCPMN.ARUCPY12.TS210.F002.T015704           SYSALLDA                    4193268   419326    65535     30561  TRK
 BMC50448I ARUCPY13 BMCPMN.ARUCPY13.TS210.F003.T015704           SYSALLDA                    4193268   419326    65535     30561  TRK
 BMC50448I SYSREC01 BMCPMN.BMC.TS210.SYSREC01                    SYSALLDA                         94       10        2         1  TRK
 BMC50448I SYSREC02 BMCPMN.BMC.TS210.SYSREC02                    SYSALLDA                          1        1        1         1  TRK
 BMC50448I SYSREC03 BMCPMN.BMC.TS210.SYSREC03                    SYSALLDA                          1        1        1         1  TRK
 
 BMC50394I UNABLE TO LOCATE SORT WORK DATASETS, DDNAME = 'SORTWKNN'
 BMC50474I BELOW 16M = 8384K, ABOVE 16M = 1023888K, CPUS = 5
 BMC50479I TOTAL PAGES: 13674060, ALLOWED: 0; AVAILABLE PAGES: 7713539, ALLOWED: 7713539
 BMC51302I MAX TASKS = 1, MAX PARTITIONS PER TASK = 3, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 3
 BMC50477I 1: PARTITION =    1, ROWS/KEYS = 1266, I/O WAITS = 1 ,DDNAME = SYS00012
 BMC50481I 1: UNLOAD TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50476I DDNAME = SYSREC01, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC02, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC03, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = ARUARC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSUT1, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC51271I UNLOAD STATISTICS:  204 ROWS/KEYS UNLOADED FROM PARTITION 1
 BMC51281I UNLOAD STATISTICS:  X'00000000028B93B41A7D' IS THE HIGHEST LOGRBA FOR PARTITION 1
 BMC51286I RELOADING OF DATASET 'DEMOCAT.DSNDBD.ARUDB210.TS210.I0001.A001' WILL REQUIRE 38 PAGES
 BMC51288I RELOADING OF DATASET 'DEMOCAT.DSNDBD.ARUDB210.TS21011.I0001.A001' MAY REQUIRE 6 PAGES
 BMC51272I UNLOAD STATISTICS:  204 ROWS UNLOADED FROM SPACE 'ARUDB210.TS210', 1062 ROWS DISCARDED, 0 ROWS UPDATED
 BMC51282I UNLOAD STATISTICS:  X'00000000028B93B41A7D' IS THE HIGHEST LOGRBA FOR SPACE 'ARUDB210.TS210'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I UNLOAD PHASE COMPLETE.  ELAPSED TIME = 00:00:01
 
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8200K, ABOVE 16M = 1020376K, CPUS = 5
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB210.TS210.I0001.A001'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB210.TS210.I0001.A001'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB210.TS210.I0001.A001'
 BMC50482I 0: RELOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.ARUDB210.TS210.I0001.A001'
 BMC50477I 0: PARTITION =    1, ROWS/KEYS = 204, I/O WAITS = 8 ,DDNAME = SYS00015
 BMC51274I RELOAD STATISTICS:  204 ROWS/KEYS LOADED INTO PARTITION 1
 BMC50476I DDNAME = SYSREC01, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51275I RELOAD STATISTICS:  204 ROWS LOADED INTO SPACE 'ARUDB210.TS210'
 BMC50479I TOTAL PAGES: 13675358, ALLOWED: 0; AVAILABLE PAGES: 7714969, ALLOWED: 7714969
 BMC51303I MAX TASKS = 1, INDEXES PER TASK = 1, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 1
 BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50476I DDNAME = SYSUT1, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50481I 1: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.ARUDB210.TS21011.I0001.A001'
 BMC50477I 1: PARTITION =    0, ROWS/KEYS = 204, I/O WAITS = 5 ,DDNAME = SYS00017
 BMC51276I BUILD  STATISTICS:  204 KEYS LOADED INTO INDEX 'ARU.TS21011'
 BMC50476I DDNAME = ARUCPY1, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = ARUCPY2, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = ARUCPY3, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = ARUCPY4, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 42 PAGES COPIED TO DATASET = 'ARU.EXMPL07.ARUCPY1'
 BMC50376I 42 PAGES COPIED TO DATASET = 'ARU.EXMPL07.ARUCPY2'
BMC50376I 42 PAGES COPIED TO DATASET = 'ARU.EXMPL07.ARUCPY3'
 BMC50376I 42 PAGES COPIED TO DATASET = 'ARU.EXMPL07.ARUCPY4'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC03', DSNAME = 'BMCPMN.BMC.TS210.SYSREC03'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC02', DSNAME = 'BMCPMN.BMC.TS210.SYSREC02'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC  ', DSNAME = 'ARU.EXMPL07.SYSREC'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC01', DSNAME = 'BMCPMN.BMC.TS210.SYSREC01'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT1  ', DSNAME = 'ARU.EXMPL07.SYSUT1'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I RELOAD PHASE COMPLETE.  ELAPSED TIME = 00:00:01
 
 BMC50501I DB2 OBJECT STATISTICS
0BMC50515I TABLESPACE  ARUDB210.TS210  PARTS   = 1         TABLES  = 1     SEGSIZE = 32    DSSIZE =    4G    PAGESIZE = 4K
0BMC50516I             PART  NACTIVE       CARD   EXTENTS   DBCARD PCOMP   KSAVED  PSAVED
 BMC50517I                1       39        204         1        0     0        0       0
 BMC50518I   TABLE     ARU.TS2101
 BMC50519I             ROWAVG    NPAGES       CARD   PCTPAGES
 BMC50520I                 66        37        204         94
0BMC50525I     INDEX   ARU.TS21011
 BMC50526I             FIRST KEY COLUMN = COL1_CHAR
 BMC50527I             CLUSTER = N   UNIQUE = D   COMPRESS = N   PAGESIZE = 4K   KEYLEN =   20   COLCOUNT = 3
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0         5        204         1        2
 BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR REORG UTILITY SUCCESSFUL FOR ALL OBJECTS
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0

 

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