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 9: Partition-by-growth table space

In this example, REORG PLUS reorganizes a partition-by-growth table space.

The job is a SHRLEVEL NONE, two-phase, full table space reorganization. During the reorganization, REORG PLUS adds new partitions, indicated by message BMC50175I.

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

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

UNLOAD CONTINUE

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

MAXNEWPARTS

Specifies the maximum number of partitions that REORG PLUS can add during a reorganization and the maximum number of partitions added by Db2 that REORG PLUS can support

COPY YES

Creates a Db2 image copy of the table space

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

COPYLVL PART

Allocates an image copy data set for each partition that you are reorganizing

REDEFINE YES

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

ORDER YES

Sorts the data rows

BMCSTATS YES UPDATEDB2STATS YES

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

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

The following figure shows the JCL for example 9:

//  JOBCARD
//**********************ARUEX009***************************************
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//*  FULL UNIVERSAL (PARTITION BY GROWTH) TABLESPACE REORG WITH       *
//*  THE USE OF THE MAXNEWPARTS OPTION.                               *
//*  PARTITIONS ADDED DURING REORG (SEE REORG MESSAGES BMC50175I).    *
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//*====================================================================
//*  Replace "DB2SYS" by your DB2 subsystem name.                     *
//*  Use your DB2 product install libraries for STEPLIBS :            *
//*     PRODUCT.LIBRARIES                                             *
//*     DB2.DSNEXIT                                                   *
//*     DB2.DSNLOAD                                                   *
//*====================================================================
//EXAMPL9   EXEC PGM=ARUUMAIN,
//          PARM='DB2SYS,ARUEX09,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 TABLESPACE EXAMPLD3.EXAMPABA
 SHRLEVEL NONE
 UNLOAD CONTINUE
 MAXNEWPARTS 10
 COPY YES
 REGISTER ALL
 COPYLVL PART
 ORDER YES
 ANALYZE SAMPLE
 KEEPDICTIONARY NO
 PREFORMAT YES
 UPDATEDB2STATS YES
 BMCSTATS YES
 DDTYPE UNLOAD ACTIVE YES UNIT (WORK) SIZEPCT (150,150)
 DSNPAT 'ARU.EXAMPL09.&DB.&TSIX.&DDNAME'
 DDTYPE WORK   ACTIVE YES UNIT (WORK) SIZEPCT (150,150)
 DSNPAT 'ARU.EXAMPL09.&DB.&TSIX.&DDNAME'
 DDTYPE LOCPFCPY ACTIVE YES UNIT (WORK) SIZEPCT (200,200)
 DSNPAT 'ARU.EXAMPL09.&DB.&TSIX.&DDNAME'
/*

SYSPRINT for example 9

The following figure shows the SYSPRINT output for example 9:

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   01/20/2022    3:10:46 ...
 BMC50002I UTILITY ID = 'EXAMPL09'.  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=8820K,ABOVE 16M=1025416K,IEFUSI=NO,CPUs=7,GPs=5,zIIPs=2
 BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040294M,MEMLIMIT SET BY:REGION=0
 BMC50471I SMFID=DB2B,JOBID=J0646879,JOB=EXAMPL09,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 EXAMPLD3.EXAMPABA
 BMC50102I  SHRLEVEL NONE
 BMC50102I  UNLOAD CONTINUE
 BMC50102I  MAXNEWPARTS 10
 BMC50102I  COPY YES
 BMC50102I  REGISTER ALL
 BMC50102I  COPYLVL PART
 BMC50102I  ORDER YES
 BMC50102I  ANALYZE SAMPLE
 BMC50102I  KEEPDICTIONARY NO
 BMC50102I  PREFORMAT YES
 BMC50102I  UPDATEDB2STATS YES
 BMC50102I  BMCSTATS YES
 BMC50102I  DDTYPE UNLOAD ACTIVE YES UNIT (WORK) SIZEPCT (150,150)
 BMC50102I  DSNPAT 'ARU.EXMPL09.&DB.&TSIX.&DDNAME'
 BMC50102I  DDTYPE WORK   ACTIVE YES UNIT (WORK) SIZEPCT (150,150)
 BMC50102I  DSNPAT 'ARU.EXMPL09.&DB.&TSIX.&DDNAME'
 BMC50102I  DDTYPE LOCPFCPY ACTIVE YES UNIT (WORK) SIZEPCT (200,200)
 BMC50102I  DSNPAT 'ARU.EXMPL09.&DB.&TSIX.&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
 BMC50244I PROCESSING PAGESET DBID(1950) PSID(2) PART(1) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00000000 FOR DBID(1950) PSID(2)
 BMC50245I REGISTERING SYSTEM PAGE - 00000022 FOR DBID(1950) PSID(2)
 BMC51301I 1: SAMPLING STATISTICS: PART=1,TP=54566,SP=208,SR=3363,AVGR=52,SD=65,SE=0,AVGF=1616,SD=65,SE=135,EP=123
 BMC51301I 1: SAMPLING STATISTICS: PART=1,TP=54566,SP=417,SR=7777,AVGR=52,SD=66,SE=0,AVGF=1864,SD=65,SE=97,EP=221
 BMC51301I 1: SAMPLING STATISTICS: PART=1,TP=54566,SP=625,SR=12073,AVGR=52,SD=66,SE=0,AVGF=1931,SD=65,SE=79,EP=321
 BMC51265I ESTIMATED CARDINALITY OF SPACE = 1053418  AVG SORTWK ROW LENGTH = 52  AVG UNLOAD ROW LENGTH = 42
 BMC50484I ESTIMATED CARDINALITY OF PART 0001 = 131008  AVG SORTWK ROW LENGTH = 52  AVG UNLOAD ROW LENGTH = 42
 BMC50484I ESTIMATED CARDINALITY OF PART 0002 = 131008  AVG SORTWK ROW LENGTH = 52  AVG UNLOAD ROW LENGTH = 42
 BMC50484I ESTIMATED CARDINALITY OF PART 0003 = 131008  AVG SORTWK ROW LENGTH = 52  AVG UNLOAD ROW LENGTH = 42
 BMC50484I ESTIMATED CARDINALITY OF PART 0004 = 131008  AVG SORTWK ROW LENGTH = 52  AVG UNLOAD ROW LENGTH = 42
 BMC50484I ESTIMATED CARDINALITY OF PART 0005 = 131008  AVG SORTWK ROW LENGTH = 52  AVG UNLOAD ROW LENGTH = 42
 BMC50484I ESTIMATED CARDINALITY OF PART 0006 = 131008  AVG SORTWK ROW LENGTH = 52  AVG UNLOAD ROW LENGTH = 42
 BMC50484I ESTIMATED CARDINALITY OF PART 0007 = 131008  AVG SORTWK ROW LENGTH = 52  AVG UNLOAD ROW LENGTH = 42
 BMC50484I ESTIMATED CARDINALITY OF PART 0008 = 131008  AVG SORTWK ROW LENGTH = 52  AVG UNLOAD ROW LENGTH = 42
 BMC50484I ESTIMATED CARDINALITY OF PART 0009 = 5354  AVG SORTWK ROW LENGTH = 52  AVG UNLOAD ROW LENGTH = 42
 BMC51264I UNLOAD WILL READ 54553 DATA PAGES FROM SPACE 'EXAMPLD3.EXAMPABA'
 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  = EXAMPL09  &STEPNAME = BMCREORG  &DB       = EXAMPLD3  &TSIX     = EXAMPABA  &RTYPE    = TS      
 BMC50425I &UID      = BMCPMN    &DATE     = 012022    &TIME     = 031046    &SSID     = DEMO      &UTIL     = EXAMPL09
 BMC50425I &UTILPFX  = EXAMPL09  &UTILSFX  =           &DATE8    = 01202022  &GRPNM    = DEMO      &VCAT     = DEMOCAT

 BMC50425I &TIME4    = 0310      &DATEJ    = 2022354   &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 BMCCPY01 ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY01      *WORK                        2097088   209708    43690      4369  TRK
 BMC50448I BMCCPY02 ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY02      *WORK                        2097088   209708    43690      4369  TRK
 BMC50448I BMCCPY03 ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY03      *WORK                        2097088   209708    43690      4369  TRK
 BMC50448I BMCCPY04 ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY04      *WORK                        2097088   209708    43690      4369  TRK
 BMC50448I BMCCPY05 ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY05      *WORK                        2097088   209708    43690      4369  TRK
 BMC50448I BMCCPY06 ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY06      *WORK                        2097088   209708    43690      4369  TRK
 BMC50448I BMCCPY07 ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY07      *WORK                        2097088   209708    43690      4369  TRK
 BMC50448I BMCCPY08 ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY08      *WORK                        2097088   209708    43690      4369  TRK
 BMC50448I BMCCPY09 ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY09      *WORK                        2097088   209708    43690      4369  TRK
 BMC50448I BMCCPY10 ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY10      *WORK                        2097088   209708    43690      4369  TRK
 BMC50448I SYSREC01 ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC01      *WORK                          12282     1920      228        36  TRK
 BMC50448I SYSREC02 ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC02      *WORK                          12282     1920      228        36  TRK
 BMC50448I SYSREC03 ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC03      *WORK                          12282     1920      228        36  TRK
 BMC50448I SYSREC04 ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC04      *WORK                          12282     1920      228        36  TRK
 BMC50448I SYSREC05 ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC05      *WORK                          12282     1920      228        36  TRK
 BMC50448I SYSREC06 ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC06      *WORK                          12282     1920      228        36  TRK
 BMC50448I SYSREC07 ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC07      *WORK                          12282     1920      228        36  TRK
 BMC50448I SYSREC08 ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC08      *WORK                          12282     1920      228        36  TRK
 BMC50448I SYSREC09 ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC09      *WORK                            503       78       10         2  TRK
 BMC50448I SYSREC10 ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC10      *WORK                              2        2        1         1  TRK
 BMC50448I SYSUT1   ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSUT1        *WORK                          26243     2625      486        49  TRK
 
 BMC50394I UNABLE TO LOCATE SORT WORK DATASETS, DDNAME = 'SORTWKNN'
 BMC50474I BELOW 16M = 8100K, ABOVE 16M = 1008996K, CPUS = 5
 BMC50479I TOTAL PAGES: 12851911, ALLOWED: 0; AVAILABLE PAGES: 6757504, ALLOWED: 6757504
 BMC51302I MAX TASKS = 1, MAX PARTITIONS PER TASK = 10, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 10
 BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 2076K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50477I 1: PARTITION =    1, ROWS/KEYS = 1081344, I/O WAITS = 224 ,DDNAME = SYS00015
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE EXAMPLD3.EXAMPABA PARTITION 1
 BMC50481I 1: SORT COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50481I 1: UNLOAD TASK COMPLETE.  ELAPSED TIME = 00:00:02
 BMC50476I DDNAME = SYSREC01, I/OS = 29, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC02, I/OS = 29, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC03, I/OS = 29, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC04, I/OS = 29, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC05, I/OS = 29, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC06, I/OS = 29, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC07, I/OS = 29, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC08, I/OS = 29, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC09, I/OS = 8, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC10, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSUT1, I/OS = 59, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC51271I UNLOAD STATISTICS:  131008 ROWS/KEYS UNLOADED FROM PARTITION 1
 BMC51281I UNLOAD STATISTICS:  X'00000000028BBB02AC83' IS THE HIGHEST LOGRBA FOR PARTITION 1
 BMC51286I RELOADING OF DATASET 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A001' WILL REQUIRE 262134 PAGES
 BMC51271I UNLOAD STATISTICS:  131008 ROWS/KEYS UNLOADED FROM PARTITION 2
 BMC51281I UNLOAD STATISTICS:  X'00000000000000000000' IS THE HIGHEST LOGRBA FOR PARTITION 2
 BMC51286I RELOADING OF DATASET 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A002' WILL REQUIRE 262134 PAGES
 BMC51271I UNLOAD STATISTICS:  131008 ROWS/KEYS UNLOADED FROM PARTITION 3
 BMC51281I UNLOAD STATISTICS:  X'00000000000000000000' IS THE HIGHEST LOGRBA FOR PARTITION 3
 BMC51286I RELOADING OF DATASET 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A003' WILL REQUIRE 262134 PAGES
 BMC51271I UNLOAD STATISTICS:  131008 ROWS/KEYS UNLOADED FROM PARTITION 4
 BMC51281I UNLOAD STATISTICS:  X'00000000000000000000' IS THE HIGHEST LOGRBA FOR PARTITION 4
 BMC51286I RELOADING OF DATASET 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A004' WILL REQUIRE 262134 PAGES
 BMC51271I UNLOAD STATISTICS:  131008 ROWS/KEYS UNLOADED FROM PARTITION 5
 BMC51281I UNLOAD STATISTICS:  X'00000000000000000000' IS THE HIGHEST LOGRBA FOR PARTITION 5
 BMC51286I RELOADING OF DATASET 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A005' WILL REQUIRE 262134 PAGES
 BMC51271I UNLOAD STATISTICS:  131008 ROWS/KEYS UNLOADED FROM PARTITION 6
 BMC51281I UNLOAD STATISTICS:  X'00000000000000000000' IS THE HIGHEST LOGRBA FOR PARTITION 6
 BMC51286I RELOADING OF DATASET 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A006' WILL REQUIRE 262134 PAGES
 BMC51271I UNLOAD STATISTICS:  131008 ROWS/KEYS UNLOADED FROM PARTITION 7
 BMC51281I UNLOAD STATISTICS:  X'00000000000000000000' IS THE HIGHEST LOGRBA FOR PARTITION 7
 BMC51286I RELOADING OF DATASET 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A007' WILL REQUIRE 262134 PAGES
 BMC51271I UNLOAD STATISTICS:  131008 ROWS/KEYS UNLOADED FROM PARTITION 8
 BMC51281I UNLOAD STATISTICS:  X'00000000000000000000' IS THE HIGHEST LOGRBA FOR PARTITION 8
 BMC51286I RELOADING OF DATASET 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A008' WILL REQUIRE 262134 PAGES
 BMC51271I UNLOAD STATISTICS:  33280 ROWS/KEYS UNLOADED FROM PARTITION 9
 BMC51281I UNLOAD STATISTICS:  X'00000000000000000000' IS THE HIGHEST LOGRBA FOR PARTITION 9
 BMC51286I RELOADING OF DATASET 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A009' WILL REQUIRE 66637 PAGES
 BMC51288I RELOADING OF DATASET 'DEMOCAT.DSNDBD.EXAMPLD3.LARX003A.I0001.A001' MAY REQUIRE 5386 PAGES
 BMC51272I UNLOAD STATISTICS:  1081344 ROWS UNLOADED FROM SPACE 'EXAMPLD3.EXAMPABA', 0 ROWS DISCARDED, 0 ROWS UPDATED
 BMC51282I UNLOAD STATISTICS:  X'00000000028BBB02AC83' IS THE HIGHEST LOGRBA FOR SPACE 'EXAMPLD3.EXAMPABA'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I UNLOAD PHASE COMPLETE.  ELAPSED TIME = 00:00:04
 
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50175I PARTITION  2 ADDED TO PARTITION BY GROWTH OBJECT EXAMPLD3.EXAMPABA
 BMC50175I PARTITION  3 ADDED TO PARTITION BY GROWTH OBJECT EXAMPLD3.EXAMPABA
 BMC50175I PARTITION  4 ADDED TO PARTITION BY GROWTH OBJECT EXAMPLD3.EXAMPABA
 BMC50175I PARTITION  5 ADDED TO PARTITION BY GROWTH OBJECT EXAMPLD3.EXAMPABA
 BMC50175I PARTITION  6 ADDED TO PARTITION BY GROWTH OBJECT EXAMPLD3.EXAMPABA
 BMC50175I PARTITION  7 ADDED TO PARTITION BY GROWTH OBJECT EXAMPLD3.EXAMPABA
 BMC50175I PARTITION  8 ADDED TO PARTITION BY GROWTH OBJECT EXAMPLD3.EXAMPABA
 BMC50175I PARTITION  9 ADDED TO PARTITION BY GROWTH OBJECT EXAMPLD3.EXAMPABA
 BMC50474I BELOW 16M = 7916K, ABOVE 16M = 1004780K, CPUS = 5
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A005'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A005'
 BMC50479I TOTAL PAGES: 12669608, ALLOWED: 0; AVAILABLE PAGES: 6574272, ALLOWED: 6574272
 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 = 54, I/O WAITS = 4, RDB LOCK WAITS = 0
 BMC50481I 1: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A003'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A003'
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.EXAMPLD3.LARX003A.I0001.A001'
 BMC50477I 1: PARTITION =    0, ROWS/KEYS = 1081344, I/O WAITS = 7 ,DDNAME = SYS00034
 BMC51276I BUILD  STATISTICS:  1081344 KEYS LOADED INTO INDEX 'EXAMPLD3.LARX003A'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A006'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A006'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A007'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A007'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A008'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A008'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A002'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A002'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A004'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A004'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A001'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A001'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A009'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A009'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A005'
 BMC50482I 0: RELOAD COMPLETE.  ELAPSED TIME = 00:00:17  DSN = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A005'
 BMC50477I 0: PARTITION =    5, ROWS/KEYS = 131008, I/O WAITS = 1539 ,DDNAME = SYS00029
 BMC51274I RELOAD STATISTICS:  131008 ROWS/KEYS LOADED INTO PARTITION 5
 BMC50476I DDNAME = BMCCPY05, I/OS = 2241, I/O WAITS = 716, RDB LOCK WAITS = 0
 BMC50376I 262192 PAGES COPIED TO DATASET = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY05'
 BMC50476I DDNAME = SYSREC05, I/OS = 26, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A003'
 BMC50482I 0: RELOAD COMPLETE.  ELAPSED TIME = 00:00:20  DSN = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A003'
 BMC50477I 0: PARTITION =    3, ROWS/KEYS = 131008, I/O WAITS = 1560 ,DDNAME = SYS00032
 BMC51274I RELOAD STATISTICS:  131008 ROWS/KEYS LOADED INTO PARTITION 3
 BMC50476I DDNAME = BMCCPY03, I/OS = 2241, I/O WAITS = 674, RDB LOCK WAITS = 0
 BMC50376I 262192 PAGES COPIED TO DATASET = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY03'
 BMC50476I DDNAME = SYSREC03, I/OS = 26, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A006'
 BMC50482I 0: RELOAD COMPLETE.  ELAPSED TIME = 00:00:21  DSN = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A006'
 BMC50477I 0: PARTITION =    6, ROWS/KEYS = 131008, I/O WAITS = 1544 ,DDNAME = SYS00036
 BMC51274I RELOAD STATISTICS:  131008 ROWS/KEYS LOADED INTO PARTITION 6
 BMC50476I DDNAME = BMCCPY06, I/OS = 2241, I/O WAITS = 661, RDB LOCK WAITS = 0
 BMC50376I 262192 PAGES COPIED TO DATASET = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY06'
 BMC50476I DDNAME = SYSREC06, I/OS = 26, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A007'
 BMC50482I 0: RELOAD COMPLETE.  ELAPSED TIME = 00:00:21  DSN = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A007'
 BMC50477I 0: PARTITION =    7, ROWS/KEYS = 131008, I/O WAITS = 1559 ,DDNAME = SYS00038
 BMC51274I RELOAD STATISTICS:  131008 ROWS/KEYS LOADED INTO PARTITION 7
 BMC50476I DDNAME = BMCCPY07, I/OS = 2241, I/O WAITS = 661, RDB LOCK WAITS = 0
 BMC50376I 262192 PAGES COPIED TO DATASET = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY07'
 BMC50476I DDNAME = SYSREC07, I/OS = 26, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A008'
 BMC50482I 0: RELOAD COMPLETE.  ELAPSED TIME = 00:00:25  DSN = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A008'
 BMC50477I 0: PARTITION =    8, ROWS/KEYS = 131008, I/O WAITS = 1525 ,DDNAME = SYS00040
 BMC51274I RELOAD STATISTICS:  131008 ROWS/KEYS LOADED INTO PARTITION 8
 BMC50476I DDNAME = BMCCPY08, I/OS = 2241, I/O WAITS = 739, RDB LOCK WAITS = 0
 BMC50376I 262192 PAGES COPIED TO DATASET = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY08'
 BMC50476I DDNAME = SYSREC08, I/OS = 26, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A002'
 BMC50482I 0: RELOAD COMPLETE.  ELAPSED TIME = 00:00:28  DSN = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A002'
 BMC50477I 0: PARTITION =    2, ROWS/KEYS = 131008, I/O WAITS = 1565 ,DDNAME = SYS00042
 BMC51274I RELOAD STATISTICS:  131008 ROWS/KEYS LOADED INTO PARTITION 2
 BMC50476I DDNAME = BMCCPY02, I/OS = 2241, I/O WAITS = 786, RDB LOCK WAITS = 0
 BMC50376I 262192 PAGES COPIED TO DATASET = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY02'
 BMC50476I DDNAME = SYSREC02, I/OS = 26, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A004'
 BMC50482I 0: RELOAD COMPLETE.  ELAPSED TIME = 00:00:31  DSN = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A004'
 BMC50477I 0: PARTITION =    4, ROWS/KEYS = 131008, I/O WAITS = 1562 ,DDNAME = SYS00044
 BMC51274I RELOAD STATISTICS:  131008 ROWS/KEYS LOADED INTO PARTITION 4
 BMC50476I DDNAME = BMCCPY04, I/OS = 2241, I/O WAITS = 782, RDB LOCK WAITS = 0
 BMC50376I 262192 PAGES COPIED TO DATASET = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY04'
 BMC50476I DDNAME = SYSREC04, I/OS = 26, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A001'
 BMC50482I 0: RELOAD COMPLETE.  ELAPSED TIME = 00:00:34  DSN = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A001'
 BMC50477I 0: PARTITION =    1, ROWS/KEYS = 131008, I/O WAITS = 1541 ,DDNAME = SYS00046
 BMC51274I RELOAD STATISTICS:  131008 ROWS/KEYS LOADED INTO PARTITION 1
 BMC50476I DDNAME = BMCCPY01, I/OS = 2241, I/O WAITS = 692, RDB LOCK WAITS = 0
 BMC50376I 262192 PAGES COPIED TO DATASET = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY01'
 BMC50476I DDNAME = SYSREC01, I/OS = 26, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A009'
 BMC50482I 0: RELOAD COMPLETE.  ELAPSED TIME = 00:00:33  DSN = 'DEMOCAT.DSNDBD.EXAMPLD3.EXAMPABA.I0001.A009'
 BMC50477I 0: PARTITION =    9, ROWS/KEYS = 33280, I/O WAITS = 400 ,DDNAME = SYS00048
 BMC51274I RELOAD STATISTICS:  33280 ROWS/KEYS LOADED INTO PARTITION 9
 BMC50476I DDNAME = BMCCPY09, I/OS = 570, I/O WAITS = 166, RDB LOCK WAITS = 0
 BMC50376I 66654 PAGES COPIED TO DATASET = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY09'
 BMC50476I DDNAME = SYSREC09, I/OS = 6, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51275I RELOAD STATISTICS:  1081344 ROWS LOADED INTO SPACE 'EXAMPLD3.EXAMPABA'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC10', DSNAME = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC10'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC09', DSNAME = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC09'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC01', DSNAME = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC01'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC04', DSNAME = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC04'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC02', DSNAME = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC02'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC08', DSNAME = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC08'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC07', DSNAME = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC07'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC06', DSNAME = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC06'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC03', DSNAME = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC03'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC05', DSNAME = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSREC05'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT1  ', DSNAME = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.SYSUT1'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I RELOAD PHASE COMPLETE.  ELAPSED TIME = 00:00:50
 
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'BMCCPY10', DSNAME = 'ARU.EXMPL09.EXAMPLD3.EXAMPABA.BMCCPY10'
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-20-03.10.47.743718                                          1
0
    
   INDEX --------------- EXAMPLD3.LARX003A
     ASSOCIATIONS
       TABLESPACE ------ EXAMPLD3.EXAMPABA
       TABLE ----------- EXAMPLD3.LART003
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------Y  UTILCODE---------------------R  LOCATION------------------DEMO
       SAMPLING---------------------N      
     ATTRIBUTES
       PIECESIZE--------------4194304  TYPE TS----------------------G  UNIQUERULE-------------------D  KEYLENGTH-------------------10
       SPARSE-----------------------N  INDEXTYPE--------------------2  CLUSTERING-------------------Y  COLCOUNT---------------------1
       INDEXSPACE------------LARX003A  PGSIZE-----------------------4  EXTTYPE----------------(BLANK)  COMPRESS---------------------N
       PAGENUM----------------------A  DSSIZE-----------------------0  COLNAME---------C006_TIMESTAMP  
     STATISTICS
       FIRSTKEYCARD-----------1081344  FULLKEYCARD------------1081344  NACTIVE------------------10620  TBCARDF----------------1081344
       NUMNONLEAF------------------20  NLEVELS----------------------3  CLUSTERRATIO---------------100  NLEAF---------------------5407
       AVGKEYLEN-------------------10  REORGSPACE-----------------465  REORGSPACE_KB------------22320  REORGNLEVELS-----------------3
       HIGH2K-----X'4460062522000000'  HIGH2K (CHAR)---------.-......  LOW2K------X'1910010101000000'  LOW2K (CHAR)----------........
       DATAREPEAT-------------1081344      
     ALLOCATION
       SPACE----------------------885  SPACE_KB-----------------42480  NUMDATASETS------------------1  
    
   INDEXPART ----------- EXAMPLD3.LARX003A
     ASSOCIATIONS
       TABLESPACE ------ EXAMPLD3.EXAMPABA
       TABLE ----------- EXAMPLD3.LART003
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------Y  UTILCODE---------------------R  LOCATION----------------(NULL)
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY------------------------59  SQTY------------------------59  PCTFREE----------------------0  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  NLAVGKEYLEN------------------5  RBA_FORMAT------------EXTENDED
       PAGENUM----------------------A  DSSIZE-----------------------0  VCATNAME---------------DEMOCAT  STORNAME--------------DEMOCAT
     STATISTICS
       FIRSTKEYCARD-----------1081344  FULLKEYCARD------------1081344  CARD-------------------1081344  NACTIVE------------------10620
       CLUSTERRATIO---------------100  NUMNONLEAF------------------20  NLEVELS----------------------3  FAROFFPOS--------------------8
       NEAROFFPOS-------------1081335  LEAFDIST---------------------0  NLEAF---------------------5407  FREE------------------------79
       FULL----------------------5424  AVGKEYLEN-------------------10    
       LEAFNEAR--------------------19  LEAFFAR----------------------0  PSEUDO_DEL_RIDS--------------0  REORGSPACE-----------------465
       REORGSPACE_KB------------22320  REORGNLEVELS-----------------3  PCTUSED--------------------100  PQTYROWS---------------2126317
       DATAREPEAT-------------1081344      
     ALLOCATION
       IPREFIX----------------------I  SPACE----------------------885  SPACE_KB-----------------42480  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------NGT018
     
   COLUMN -------------- C006_TIMESTAMP
     ASSOCIATIONS
       TABLESPACE ------ EXAMPLD3.EXAMPABA
       TABLE ----------- EXAMPLD3.LART003
     ATTRIBUTES
       COLNO------------------------6  COLTYPE---------------TIMESTMP  LENGTH----------------------10  NULLS------------------------N
     STATISTICS
       COLCARD----------------1081344  COLNULLS---------------------0  COLAVG----------------------10  COLMIN----------------------10
       COLMAX----------------------10      
       HIGH2K-----X'4460062522000000'  HIGH2K (CHAR)---------.-......  LOW2K------X'1910010101000000'  LOW2K (CHAR)----------........

       MOST FREQUENT VALUES
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-20-03.10.47.743718                                          2
0
        FREQUENCY---------9.247751E-07     COLVAL-X'19100101190000000000'
                                           (CHAR)--------------..........
        FREQUENCY---------9.247751E-07     COLVAL-X'19100101180000000000'
                                           (CHAR)--------------..........
        FREQUENCY---------9.247751E-07     COLVAL-X'19100101170000000000'
                                           (CHAR)--------------..........
        FREQUENCY---------9.247751E-07     COLVAL-X'19100101160000000000'
                                           (CHAR)--------------..........
        FREQUENCY---------9.247751E-07     COLVAL-X'19100101150000000000'
                                           (CHAR)--------------..........
        FREQUENCY---------9.247751E-07     COLVAL-X'19100101140000000000'
                                           (CHAR)--------------..........
        FREQUENCY---------9.247751E-07     COLVAL-X'19100101130000000000'
                                           (CHAR)--------------..........
        FREQUENCY---------9.247751E-07     COLVAL-X'19100101120000000000'
                                           (CHAR)--------------..........
        FREQUENCY---------9.247751E-07     COLVAL-X'19100101110000000000'
                                           (CHAR)--------------..........
        FREQUENCY---------9.247751E-07     COLVAL-X'19100101100000000000'
                                           (CHAR)--------------..........
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-20-03.10.47.743718                                          1
0
    
 TABLESPACE ------------ EXAMPLD3.EXAMPABA
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------Y  UTILCODE---------------------R  LOCATION------------------DEMO
       SAMPLING---------------------N      
     ATTRIBUTES
       PARTITIONS-------------------9  NTABLES----------------------1  PGSIZE-----------------------4  SEGSIZE---------------------32
       DSSIZE-----------------1048576  PAGENUM----------------------A    
       MAXROWS----------------------1  TYPE-------------------------G  ENCODING---------------------E  MAXPARTITIONS---------------10
       LOB--------------------------N  XML--------------------------N  MEMBER_CLUSTER---------(BLANK)  
     STATISTICS
       NACTIVE----------------2169088  REORGSPACE--------------180405  REORGSPACE_KB----------8659440  ROWMAXFOUND-----------------58
       ROWMINFOUND-----------------33  ROWAVG----------------------47  COMPRESSRATIO-------------(-1)  REORGSPACE_PARTS-------------9
     ALLOCATION
       SPACE-------------------180840  SPACE_KB---------------8680320    
    
   TABLEPART ----------- EXAMPLD3.EXAMPABA PART 001
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------R
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-----------------------100  SQTY-----------------------100  PCTFREE---------------------50  FREEPAGE---------------------1
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------G  PAGENUM----------------------A
       DSSIZE-----------------1048576  PGSIZE-----------------------4  BPOOL----------------------BP0  MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT  STORNAME--------------ARULARSG
     STATISTICS
       CARD--------------------131008  NACTIVE-----------------262136  NPAGES------------------131008  ROWAVG----------------------46
       ROWMAXFOUND-----------------57  ROWMINFOUND-----------------33  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL----------------------2304  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE-------------------0
       PCTPAGES--------------------49  PERCDROP---------------------0  REORGSPACE---------------21855  REORGSPACE_KB----------1049040
       PCTUSED--------------------100  PQTYROWS------------------8976  NDICTIONARY-----------------16  PCTROWCOMP-----------------100
       PAGESAVE---------------------0  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE--------------------21855  SPACE_KB---------------1049040  NUMDATASETS------------------1
       EXTENTS----------------------2  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------NGT095
    
   TABLEPART ----------- EXAMPLD3.EXAMPABA PART 002
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------R
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-----------------------100  SQTY-----------------------100  PCTFREE---------------------50  FREEPAGE---------------------1
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------G  PAGENUM----------------------A
       DSSIZE-----------------------0  PGSIZE-----------------------0  BPOOL-------------------(NULL)  MEMBER_CLUSTER----------(NULL)
       VCATNAME---------------DEMOCAT  STORNAME--------------ARULARSG
     STATISTICS
       CARD--------------------131008  NACTIVE-----------------262136  NPAGES------------------131008  ROWAVG----------------------46
       ROWMAXFOUND-----------------57  ROWMINFOUND-----------------35  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL----------------------2304  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE-------------------0
       PCTPAGES--------------------49  PERCDROP---------------------0  REORGSPACE---------------21855  REORGSPACE_KB----------1049040
       PCTUSED--------------------100  PQTYROWS------------------8976  NDICTIONARY-----------------16  PCTROWCOMP-----------------100
       PAGESAVE---------------------0  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE--------------------21855  SPACE_KB---------------1049040  NUMDATASETS------------------1
       EXTENTS----------------------6  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------NGT136
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-20-03.10.47.743718                                          2
0
    
   TABLEPART ----------- EXAMPLD3.EXAMPABA PART 003
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------R
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-----------------------100  SQTY-----------------------100  PCTFREE---------------------50  FREEPAGE---------------------1
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------G  PAGENUM----------------------A
       DSSIZE-----------------------0  PGSIZE-----------------------0  BPOOL-------------------(NULL)  MEMBER_CLUSTER----------(NULL)
       VCATNAME---------------DEMOCAT  STORNAME--------------ARULARSG
     STATISTICS
       CARD--------------------131008  NACTIVE-----------------262136  NPAGES------------------131008  ROWAVG----------------------47
       ROWMAXFOUND-----------------57  ROWMINFOUND-----------------35  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL----------------------2304  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE-------------------0
       PCTPAGES--------------------49  PERCDROP---------------------0  REORGSPACE---------------21855  REORGSPACE_KB----------1049040
       PCTUSED--------------------100  PQTYROWS------------------8976  NDICTIONARY-----------------16  PCTROWCOMP-----------------100
       PAGESAVE---------------------0  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE--------------------21855  SPACE_KB---------------1049040  NUMDATASETS------------------1
       EXTENTS----------------------4  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------NGT083
    
   TABLEPART ----------- EXAMPLD3.EXAMPABA PART 004
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------R
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-----------------------100  SQTY-----------------------100  PCTFREE---------------------50  FREEPAGE---------------------1
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------G  PAGENUM----------------------A
       DSSIZE-----------------------0  PGSIZE-----------------------0  BPOOL-------------------(NULL)  MEMBER_CLUSTER----------(NULL)
       VCATNAME---------------DEMOCAT  STORNAME--------------ARULARSG
STATISTICS
       CARD--------------------131008  NACTIVE-----------------262136  NPAGES------------------131008  ROWAVG----------------------47
       ROWMAXFOUND-----------------58  ROWMINFOUND-----------------35  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL----------------------2304  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE-------------------0
       PCTPAGES--------------------49  PERCDROP---------------------0  REORGSPACE---------------21855  REORGSPACE_KB----------1049040
       PCTUSED--------------------100  PQTYROWS------------------8976  NDICTIONARY-----------------16  PCTROWCOMP------------------99
       PAGESAVE---------------------0  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE--------------------21855  SPACE_KB---------------1049040  NUMDATASETS------------------1
       EXTENTS----------------------2  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------NGT056
    
   TABLEPART ----------- EXAMPLD3.EXAMPABA PART 005
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------R
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-----------------------100  SQTY-----------------------100  PCTFREE---------------------50  FREEPAGE---------------------1
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------G  PAGENUM----------------------A
       DSSIZE-----------------------0  PGSIZE-----------------------0  BPOOL-------------------(NULL)  MEMBER_CLUSTER----------(NULL)
       VCATNAME---------------DEMOCAT  STORNAME--------------ARULARSG
     STATISTICS
       CARD--------------------131008  NACTIVE-----------------262136  NPAGES------------------131008  ROWAVG----------------------47
       ROWMAXFOUND-----------------57  ROWMINFOUND-----------------35  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL----------------------2304  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE-------------------0
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-20-03.10.47.743718                                          3
0
       PCTPAGES--------------------49  PERCDROP---------------------0  REORGSPACE---------------21855  REORGSPACE_KB----------1049040
       PCTUSED--------------------100  PQTYROWS------------------8976  NDICTIONARY-----------------16  PCTROWCOMP-----------------100
       PAGESAVE---------------------0  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE--------------------21855  SPACE_KB---------------1049040  NUMDATASETS------------------1
       EXTENTS----------------------2  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------NGT022
    
   TABLEPART ----------- EXAMPLD3.EXAMPABA PART 006
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------R
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-----------------------100  SQTY-----------------------100  PCTFREE---------------------50  FREEPAGE---------------------1
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------G  PAGENUM----------------------A
       DSSIZE-----------------------0  PGSIZE-----------------------0  BPOOL-------------------(NULL)  MEMBER_CLUSTER----------(NULL)
       VCATNAME---------------DEMOCAT  STORNAME--------------ARULARSG
     STATISTICS
       CARD--------------------131008  NACTIVE-----------------262136  NPAGES------------------131008  ROWAVG----------------------47
       ROWMAXFOUND-----------------57  ROWMINFOUND-----------------35  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL----------------------2304  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE-------------------0
       PCTPAGES--------------------49  PERCDROP---------------------0  REORGSPACE---------------21855  REORGSPACE_KB----------1049040
       PCTUSED--------------------100  PQTYROWS------------------8976  NDICTIONARY-----------------16  PCTROWCOMP-----------------100
       PAGESAVE---------------------0  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE--------------------21855  SPACE_KB---------------1049040  NUMDATASETS------------------1
       EXTENTS----------------------5  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------NGT068
    
   TABLEPART ----------- EXAMPLD3.EXAMPABA PART 007
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------R
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-----------------------100  SQTY-----------------------100  PCTFREE---------------------50  FREEPAGE---------------------1
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------G  PAGENUM----------------------A
       DSSIZE-----------------------0  PGSIZE-----------------------0  BPOOL-------------------(NULL)  MEMBER_CLUSTER----------(NULL)
       VCATNAME---------------DEMOCAT  STORNAME--------------ARULARSG
     STATISTICS
       CARD--------------------131008  NACTIVE-----------------262136  NPAGES------------------131008  ROWAVG----------------------47
       ROWMAXFOUND-----------------57  ROWMINFOUND-----------------35  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL----------------------2304  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE-------------------0
       PCTPAGES--------------------49  PERCDROP---------------------0  REORGSPACE---------------21855  REORGSPACE_KB----------1049040
       PCTUSED--------------------100  PQTYROWS------------------8976  NDICTIONARY-----------------16  PCTROWCOMP-----------------100
       PAGESAVE---------------------0  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE--------------------21855  SPACE_KB---------------1049040  NUMDATASETS------------------1
       EXTENTS----------------------3  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------NGT068
    
   TABLEPART ----------- EXAMPLD3.EXAMPABA PART 008
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------R
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-----------------------100  SQTY-----------------------100  PCTFREE---------------------50  FREEPAGE---------------------1
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------G  PAGENUM----------------------A
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-20-03.10.47.743718                                          4
0
       DSSIZE-----------------------0  PGSIZE-----------------------0  BPOOL-------------------(NULL)  MEMBER_CLUSTER----------(NULL)
       VCATNAME---------------DEMOCAT  STORNAME--------------ARULARSG
     STATISTICS
       CARD--------------------131008  NACTIVE-----------------262136  NPAGES------------------131008  ROWAVG----------------------47
       ROWMAXFOUND-----------------57  ROWMINFOUND-----------------35  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL----------------------2304  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE-------------------0
       PCTPAGES--------------------49  PERCDROP---------------------0  REORGSPACE---------------21855  REORGSPACE_KB----------1049040
       PCTUSED--------------------100  PQTYROWS------------------8976  NDICTIONARY-----------------16  PCTROWCOMP-----------------100
       PAGESAVE---------------------0  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE--------------------21855  SPACE_KB---------------1049040  NUMDATASETS------------------1
       EXTENTS----------------------5  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------NGT027
    
   TABLEPART ----------- EXAMPLD3.EXAMPABA PART 009
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------R
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-----------------------100  SQTY-----------------------100  PCTFREE---------------------50  FREEPAGE---------------------1
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------G  PAGENUM----------------------A
       DSSIZE-----------------------0  PGSIZE-----------------------0  BPOOL-------------------(NULL)  MEMBER_CLUSTER----------(NULL)
       VCATNAME---------------DEMOCAT  STORNAME--------------ARULARSG
     STATISTICS
       CARD---------------------33280  NACTIVE------------------72000  NPAGES-------------------33280  ROWAVG----------------------47
       ROWMAXFOUND-----------------57  ROWMINFOUND-----------------36  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL-------------------------0  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE-------------------0
       PCTPAGES--------------------46  PERCDROP---------------------0  REORGSPACE----------------5565  REORGSPACE_KB-----------267120
       PCTUSED--------------------100  PQTYROWS------------------8976  NDICTIONARY-----------------16  PCTROWCOMP-----------------100
       PAGESAVE---------------------0  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE---------------------6000  SPACE_KB----------------288000  NUMDATASETS------------------1
       EXTENTS----------------------3  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------NGT082
    
   TABLE --------------- EXAMPLD3.LART003
     ASSOCIATIONS
       TABLESPACE ------ EXAMPLD3.EXAMPABA
     HISTORY
       SAVESTATS--------------------Y  UPDATEDB2--------------------Y  UTILCODE---------------------R  LOCATION----------------(NULL)
     STATISTICS
       CARD-------------------1081344  NPAGES-----------------1081344  SPACE_KB---------------8680320  AVGNONCOMPROWLEN----------(-1)
       ROWAVG----------------------48  ROWMAXFOUND-----------------58  ROWMINFOUND-----------------33  INDREF-----------------------0
       PCTPAGES--------------------49  PCTROWCOMP------------------99    
 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*