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 5: Restart of a paused reorganization job

In this example, REORG PLUS restarts the reorganization job from example 3 in the RELOAD phase.

Because this job dynamically allocates the unload and index work files, REORG PLUS manages the allocation of these data sets (including their disposition) appropriately for a restarted job. The command statement options are not changed for this restart.

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.

Related topic

Examples-of-REORG-PLUS-jobs

Because no copy option is specified in the command statement, message BMC50387W is produced. This message indicates that the table space state is set to copy pending after the utility completes. The job completes with return code 4.

The following table describes the key command options for this job:

Command options used in JCL

Description

REORG TABLESPACE

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

PART 01

Limits the reorganization to partition 1

BMCSTATS YES

UPDATEDB2STATS YES

Tells REORG PLUS to update statistics in the DASD MANAGER PLUS database statistics tables and the Db2 catalog

The JCL for this example also includes the DD statement //ASUSRPRT DD DUMMY. This DD statement tells REORG PLUS not to produce a report of the statistics.

The following figure shows the JCL for example 5:

//  JOBCARD
//**********************ARUEX005***************************************
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//*  PARTITIONED TABLESPACE, ONE CLUSTERING INDEX, TWO SECONDARY      *
//*  INDEXES.                                                         *
//*  RESTART FROM UNLOAD PAUSE OF PART 01 - UTILID MUST BE THE SAME   *
//*          NAME AS EXAMPL04                                         *
//*                                                                   *
//*  NOTE: UNLOAD PAUSE OPTION IN REORG COMMAND DOES NOT HAVE TO BE   *
//*        DELETED IN RESTART JOB.  ALSO, NOTE MESSAGE FROM           *
//*        UPDATEDB2STATS YES.                                        *
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//*====================================================================
//*  Replace "DB2SYS" by your DB2 subsystem name.                     *
//*  Use your DB2 product install libraries for STEPLIBS :            *
//*     PRODUCT.LIBRARIES                                             *
//*     DB2.DSNEXIT                                                   *
//*     DB2.DSNLOAD                                                   *
//*====================================================================
//EXAMPL5   EXEC PGM=ARUUMAIN,
//          PARM='DB2SYS,ARUEX05,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=*
//ASUSRPRT  DD  DUMMY
//*
//SYSIN     DD  *
REORG TABLESPACE ARUDB032.TS032 PART 01
UNLOAD PAUSE
DDTYPE UNLOAD ACTIVE YES
  DSNPAT 'ARU.EXAMPL05.&DDNAME'
DDTYPE WORK ACTIVE YES
  DSNPAT 'ARU.EXAMPL05.&DDNAME'
BMCSTATS YES
UPDATEDB2STATS YES
/*

SYSPRINT for example 5

The following figure shows the SYSPRINT output for example 5:

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    0:38:38 ...
 BMC50002I UTILITY ID = 'EXAMPL04'.  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=8840K,ABOVE 16M=1032612K,IEFUSI=NO,CPUs=7,GPs=5,zIIPs=2
 BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040300M,MEMLIMIT SET BY:REGION=0
 BMC50471I SMFID=DB2B,JOBID=J0645358,JOB=EXAMPL05,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'
 BMC50003I RESTARTING UTILITY: COMMAND = 'REORG', PHASE = 'RELOAD'
 
0
 BMC50102I REORG TABLESPACE ARUDB032.TS032 PART 01
 BMC50102I UNLOAD PAUSE
 BMC50102I DDTYPE UNLOAD ACTIVE YES
 BMC50102I   DSNPAT 'ARU.EXMPL04.&DDNAME'
 BMC50102I DDTYPE WORK ACTIVE YES
 BMC50102I   DSNPAT 'ARU.EXMPL04.&DDNAME'
 BMC50102I BMCSTATS YES
 BMC50102I UPDATEDB2STATS YES
 
 BMC50004I UTILINIT PHASE COMPLETE.  ELAPSED TIME = 00:00:00
 
 BMC50425I &JOBNAME  = EXAMPL05  &STEPNAME = BMCREORG  &DB       = ARUDB032  &TSIX     = TS032     &RTYPE    = TS      
 BMC50425I &UID      = BMCPMN    &DATE     = 12022    &TIME     = 003838    &SSID     = DEMO      &UTIL     = EXAMPL04
 BMC50425I &UTILPFX  = EXAMPL04  &UTILSFX  =           &DATE8    = 01202022  &GRPNM    = DEMO      &VCAT     = DEMOCAT
 BMC50425I &TIME4    = 0038      &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 SYSREC01 ARU.EXMPL04.SYSREC01                         SYSALLDA                         11        3        1         1  TRK
 BMC50448I SYSUT101 ARU.EXMPL04.SYSUT101                         SYSALLDA                          3        1        1         1  TRK
 BMC50448I SYSUT102 ARU.EXMPL04.SYSUT102                         SYSALLDA                          2        1        1         1  TRK
 BMC50394I UNABLE TO LOCATE SORT WORK DATASETS, DDNAME = 'SORTWKNN'
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50509I STATISTICS COLLECTION FOR INDEX SPACE ARU.TS03212 BYPASSED DUE TO PARTIAL TABLE SPACE REORG
 BMC50509I STATISTICS COLLECTION FOR INDEX SPACE ARU.TS03213 BYPASSED DUE TO PARTIAL TABLE SPACE REORG
 BMC50474I BELOW 16M = 8004K, ABOVE 16M = 1017856K, CPUS = 5
 BMC50482I 0: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.ARUDB032.TS03211.I0001.A001'
 BMC50477I 0: PARTITION =    1, ROWS/KEYS = 100, I/O WAITS = 5 ,DDNAME = SYS00010
 BMC50482I 0: RELOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.ARUDB032.TS032.I0001.A001'
 BMC50477I 0: PARTITION =    1, ROWS/KEYS = 100, I/O WAITS = 8 ,DDNAME = SYS00008
 BMC51274I RELOAD STATISTICS:  100 ROWS/KEYS LOADED INTO PARTITION 1
 BMC50476I DDNAME = SYSREC01, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51276I BUILD  STATISTICS:  100 KEYS LOADED INTO INDEX 'ARU.TS03211'
 BMC51275I RELOAD STATISTICS:  100 ROWS LOADED INTO SPACE 'ARUDB032.TS032'
 BMC50479I TOTAL PAGES: 13308056, ALLOWED: 0; AVAILABLE PAGES: 7168399, ALLOWED: 7168399
 BMC51303I MAX TASKS = 2, INDEXES PER TASK = 1, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 2
 BMC50486I 2: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50476I DDNAME = SYSUT102, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50481I 2: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50476I DDNAME = SYSUT101, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50481I 1: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50482I 2: UPDATE COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.ARUDB032.TS03213.I0001.A001'
 BMC50477I 2: PARTITION =    0, ROWS/KEYS = 100, I/O WAITS = 4 ,DDNAME = SYS00013
 BMC51277I BUILD  STATISTICS:  100 KEY-RID PAIRS UPDATED IN INDEX 'ARU.TS03213'
 BMC50482I 1: UPDATE COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.ARUDB032.TS03212.I0001.A001'
 BMC50477I 1: PARTITION =    0, ROWS/KEYS = 100, I/O WAITS = 4 ,DDNAME = SYS00014
 BMC51277I BUILD  STATISTICS:  100 KEY-RID PAIRS UPDATED IN INDEX 'ARU.TS03212'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT101', DSNAME = 'ARU.EXMPL04.SYSUT101'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT102', DSNAME = 'ARU.EXMPL04.SYSUT102'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC01', DSNAME = 'ARU.EXMPL04.SYSREC01'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I RELOAD PHASE COMPLETE.  ELAPSED TIME = 00:00:01
 
 BMC50387W IMAGE COPY REQUIRED.  TABLE SPACE ARUDB032.TS032 STATE SET TO "COPY PENDING"
 BMC278098I AGGREGATE STATISTICS NOT PRODUCED FOR INDEX ARU.TS03211                                                             
 BMC278098I AGGREGATE STATISTICS NOT PRODUCED FOR TABLESPACE ARUDB032.TS032                                                     
 BMC278098I AGGREGATE STATISTICS NOT PRODUCED FOR TABLE ARU.TS0321                                                              
 BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR REORG UTILITY SUCCESSFUL FOR ALL OBJECTS
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 4

 

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