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 3: Index-only reorganization

In this example, a non-unique, nonpartitioned secondary index is reorganized.

Because this reorganization processes only an index, an SYSREC data set is not required and no image copy is requested. The default DDTYPE option enables REORG PLUS to dynamically allocate one SYSUT1 data set. This data set will contain the unloaded index key-RID pairs and serve as input for BMCSORT. Statistics for the reorganized index are reported but are not recorded in the Db2 catalog or DASD MANAGER PLUS tables.

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

Command options used in JCL

Description

REORG INDEX

Specifies that the index named in the statement is to be reorganized

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.

 The following figure shows the JCL for example 3:

//  JOBCARD
//**********************ARUEX003***************************************
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//*   PBG TABLESPACE, ONE INDEX (NONUNIQUE, NONCLUSTERED)             *
//*                                                                   *
//*  REORG INDEX ONLY                                                 *
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//*====================================================================
//*  Replace "DB2SYS" by your DB2 subsystem name.                     *
//*  Use your DB2 product install libraries for STEPLIBS :            *
//*     PRODUCT.LIBRARIES                                             *
//*     DB2.DSNEXIT                                                   *
//*     DB2.DSNLOAD                                                   *
//*====================================================================
//EXAMPL3   EXEC PGM=ARUUMAIN,
//          PARM='DB2SYS,ARUEX03,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=*
//*
//SYSIN     DD  *
REORG INDEX ARU.TS00211
REDEFINE NO
DDTYPE WORK ACTIVE YES
  DSNPAT 'ARU.EXAMPL03.&DDNAME'
/*

SYSPRINT for example 3

The following figure shows the SYSPRINT output for example 3:

 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/19/2022   23:52:43 ...
 BMC50002I UTILITY ID = 'EXAMPL03'.  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=8832K,ABOVE 16M=1027648K,IEFUSI=NO,CPUs=7,GPs=5,zIIPs=2
 BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040296M,MEMLIMIT SET BY:REGION=0
 BMC50471I SMFID=DB2B,JOBID=J0644919,JOB=EXAMPL03,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 INDEX ARU.TS00211
 BMC50102I REDEFINE NO
 BMC50102I DDTYPE WORK ACTIVE YES
 BMC50102I   DSNPAT 'ARU.EXMPL03.&DDNAME'
 
 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
 BMC51265I ESTIMATED CARDINALITY OF SPACE = 10000    
 BMC51264I UNLOAD WILL READ 78 DATA PAGES FROM SPACE 'ARUDB002.TS00211'
 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  = EXAMPL03  &STEPNAME = BMCREORG  &DB       = ARUDB002  &TSIX     = TS00211   &RTYPE    = IX      
 BMC50425I &UID      = BMCPMN    &DATE     = 121921    &TIME     = 235243    &SSID     = DEMO      &UTIL     = EXAMPL03
 BMC50425I &UTILPFX  = EXAMPL03  &UTILSFX  =           &DATE8    = 1192022  &GRPNM    = DEMO      &VCAT     = DEMOCAT
 BMC50425I &TIME4    = 2352      &DATEJ    = 2021353   &JDATE    = 21353                                               
 
 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 SYSUT1   ARU.EXMPL03.SYSUT1                           SYSALLDA                        206       21        4         1  TRK
 
 BMC50394I UNABLE TO LOCATE SORT WORK DATASETS, DDNAME = 'SORTWKNN'
 BMC50474I BELOW 16M = 8412K, ABOVE 16M = 1020536K, CPUS = 5
 BMC50479I TOTAL PAGES: 13451538, ALLOWED: 0; AVAILABLE PAGES: 7452052, ALLOWED: 7452052
 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 = 1 ,DDNAME = SYS00010
 BMC51278I UNLOAD STATISTICS:  10000 KEYS UNLOADED FROM INDEX 'ARU.TS00211'
 BMC50481I 1: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.ARUDB002.TS00211.I0001.A001'
 BMC50477I 1: PARTITION =    0, ROWS/KEYS = 10000, I/O WAITS = 7 ,DDNAME = SYS00014
 BMC50481I 1: REORG TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50476I DDNAME = SYSUT1, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC51276I BUILD  STATISTICS:  10000 KEYS LOADED INTO INDEX 'ARU.TS00211'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT1  ', DSNAME = 'ARU.EXMPL03.SYSUT1'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I REORG PHASE COMPLETE.  ELAPSED TIME = 00:00:01
 
 BMC50501I DB2 OBJECT STATISTICS
0BMC50525I     INDEX   ARU.TS00211
 BMC50526I             FIRST KEY COLUMN = EMPHIREDATE
 BMC50527I             CLUSTER = N   UNIQUE = D   COMPRESS = N   PAGESIZE = 4K   KEYLEN =   14   COLCOUNT = 3
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0        80      10000         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*