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 10: SHRLEVEL CHANGE with DDLIN and online repartitioning

In this example, REORG PLUS reorganizes a partitioned table space with three partitions.

The table has one clustering index and one nonpartitioned secondary index. This example uses SHRLEVEL CHANGE to keep the objects in RW status during most of the reorganization.

In the LOGAPPLY phase, REORG PLUS determines the rate at which it is applying log records. If REORG PLUS estimates that it can finish applying the log records (LOGFINAL phase) by the time specified by the DEADLINE option, and without exceeding the maximum time specified by MAXRO, REORG PLUS moves from the LOGAPPLY phase into the LOGFINAL phase and completes the reorganization.

Related topics

Examples-of-REORG-PLUS-jobs

Running-a-SHRLEVEL-CHANGE-reorganization

The DDLIN data set supplies the ALTER INDEX commands. REORG PLUS performs online partition rebalancing in the staging data sets and performs the limit-key updates in the UTILTERM phase.

Message 50041I indicates the status of zIIP processing. For this example, an XBM subsystem ID was specified for SHRLEVEL CHANGE processing. REORG PLUS uses the same XBM subsystem ID for zIIP processing.

The following table describes the key command options, installation options, and DD statements for this job:

Command options and DD statements used in JCL; installation options

Description

REORG TABLESPACE

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

SHRLEVEL CHANGE

Specifies the reorganization type

REORG PLUS will keep the original data sets in their original status (which can be RW) as long as possible.

UNLOAD CONTINUE

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

XBMID XV2B

Specifies to use the XBM subsystem with the SSID of XBMA

COPY YES

Creates full and incremental Db2 image copies of the table space

SHRLEVEL CHANGE sets REGISTER ALL, so all copies are registered in SYSIBM.SYSCOPY.

ORDER YES

Sorts the rows by table and by each table’s clustering key

If no clustering key exists, x'00's are used.

DEADLINE

Continues the reorganization only if REORG PLUS estimates that it can finish LOGFINAL processing by the time and date specified in the timestamp

The UTILTERM phase can continue past the deadline.

MAXRO 600

Starts the LOGFINAL phase when REORG PLUS estimates that it can apply the remaining log records within 10 minutes (600 seconds)

This estimate does not include the time needed to produce the incremental image copies and complete the UTILTERM phase processing.

LONGLOG CONTINUE (installation option)

Tells REORG PLUS to continue the reorganization if the longlog condition still exists after the DELAY time expires

DELAY 300

Specifies the number of seconds that are to elapse from the time REORG PLUS detects a longlog condition until the time it performs the action specified on the LONGLOG option

If the longlog condition no longer exists at the end of the time period specified by DELAY, the timer, is reset. When REORG PLUS detects the next longlog condition, it restarts the timer using the original DELAY value.

RIDMAPMEM 0 (installation option)

REORG PLUS automatically calculates the RIDMAPMEM value to be used to store the RID translation maps.

LOGMEM 0 (installation option)

REORG PLUS automatically calculates the amount of data space memory (in kilobytes) needed to hold the internal structures that REORG PLUS uses to store the log records

LOGSPILL (1024, 1024)

Determines the primary and secondary space allocation (in kilobytes) for the spill data sets that hold the log records

Each number can be a nonzero positive integer.

SPILLDSNPAT

Tells REORG PLUS to use a particular pattern of variables and text to create a prefix for the spill data set name

The spill data sets hold the log records and RID maps when they overflow memory. REORG PLUS dynamically allocates spill data sets as they are needed. The spill data sets are VSAM objects.

SPILLUNIT

Specifies the DASD unit where REORG PLUS can allocate spill data sets

The spill data sets hold the log records and RID maps when they overflow memory. REORG PLUS dynamically allocates spill data sets as they are needed. The spill data sets are VSAM objects.

SPILLSTORCLAS

Specifies the SMS storage class that REORG PLUS uses to allocate spill data sets

The spill data sets hold the log records and RID maps when they overflow memory. REORG PLUS dynamically allocates spill data sets as they are needed. The spill data sets are VSAM objects.

ANALYZE

Gathers information about the objects that you are reorganizing and provides estimated sizes for SYSREC, SYSUT1, SORTWK, and copy data sets

SIZEPCT (150,150)

Tells REORG PLUS to allocate 150% of the data set size that it calculated for the UNLOAD, WORK, and SORTWORK files

The increase allows room for the unknown number of updates that are being applied to the data sets.

DSNPAT

Specifies a pattern of variables and text that REORG PLUS uses to create data set names for dynamic data set allocation, overriding the default pattern

DDLIN

DDLIN data set contains the SQL ALTER INDEX and ALTER TABLESPACE statements with the new limit key values to use to rebalance partitions

//BMCCPY

//BMCCPZ

//BMCRCY

//BMCRCZ

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

The existence of the copy ddnames determines the number of copies made.

COPY YES is set for SHRLEVEL CHANGE.

//BMCICY

//BMCICZ

//BMCIRY

//BMCIRZ

Default ddnames that are used for the data sets that receive an incremental image copy of the table space that you are reorganizing

The existence of the copy ddnames determines the number of copies made.

COPY YES is set for SHRLEVEL CHANGE.

The following figure shows the JCL for example 10: 

//  JOBCARD
//**********************ARUEX010***************************************
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//*  PARTITIONED TABLESPACE, CLUSTERING INDEX AND NONPARTITIONED      *
//*  SECONDARY INDEX.                                                 *
//*  REORG TABLESPACE WITH SHRLEVEL CHANGE OPTION.                    *
//*  ALTER TABLE USING DDLIN OPTION.                                  *
//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//*====================================================================
//*  Replace "DB2SYS" by your DB2 subsystem name.                     *
//*  Use your DB2 product install libraries for STEPLIBS :            *
//*     PRODUCT.LIBRARIES                                             *
//*     DB2.DSNEXIT                                                   *
//*     DB2.DSNLOAD                                                   *
//*====================================================================
//EXAMPL10  EXEC PGM=ARUUMAIN,
//          PARM='DB2SYS,ARUEX10,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=*                                                
//*
//BMCCPY    DD DSN=ARU.EXAMPL10.BMCCPY,                                  
//  DISP=(,CATLG),
//  SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCCPZ    DD DSN=ARU.EXAMPL10.BMCCPZ,                                  
//  DISP=(,CATLG),
//  SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCRCY    DD DSN=ARU.EXAMPL10.BMCRCY,                                  
//  DISP=(,CATLG),
//  SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCRCZ    DD DSN=ARU.EXAMPL10.BMCRCZ,                                  
//  DISP=(,CATLG),
//  SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCICY    DD DSN=ARU.EXAMPL10.BMCICY,                                  
//  DISP=(,CATLG),
//  SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCICZ    DD DSN=ARU.EXAMPL10.BMCICZ,                                  
//  DISP=(,CATLG),
//  SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCIRY    DD DSN=ARU.EXAMPL10.BMCIRY,                                  
//  DISP=(,CATLG),
//  SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//BMCIRZ    DD DSN=ARU.EXAMPL10.BMCIRZ,                                  
//  DISP=(,CATLG),
//  SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//ARUARC    DD DSN=ARU.EXAMPL10.ARUARC,                                  
//  DISP=(,CATLG),
//  SPACE=(CYL,(50,20),RLSE),UNIT=WORK
//*                                                                     
//SYSIN     DD *                                                        
REORG TABLESPACE LARDBXAB.LARSXABA                                      
  SHRLEVEL CHANGE
  UNLOAD CONTINUE
  XBMID XV2B
  FASTSWITCH YES
  COPY YES
  ORDER YES                                                             
  DEADLINE 2025-12-31-19.30.00.00
  MAXRO 600
  DELAY 300
  LOGSPILL (1024,1024)
  SPILLDSNPAT 'ARU.LARWORK.DEMO'
  SPILLUNIT NONE
  SPILLSTORCLAS COPYCLAS
  ANALYZE
  DDTYPE UNLOAD ACTIVE YES UNIT (WORK) SIZEPCT (150,150)
  DSNPAT 'ARU.EXAMPL10.&DB.&TSIX.&DDNAME'
  DDTYPE WORK   ACTIVE YES UNIT (WORK) SIZEPCT (150,150)
  DSNPAT 'ARU.EXAMPL10.&DB.&TSIX.&DDNAME'
  ARCHDDN (ARUARC)
  DDTYPE LOCPFCPY ACTIVE NO
//DDLIN DD *
ALTER TABLE LARDBXAB.LART001
   ALTER PARTITION  02 ENDING AT ('2002-12-31')
   ;
/*

SYSPRINT for example 10

The following figure shows the SYSPRINT output for example 10:

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   11:16:49 ...
 BMC50002I UTILITY ID = 'EXMPL10R'.  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=8.6M,ABOVE 16M=1,000.6M,IEFUSI=NO,CPUs=7,GPs=5,zIIPs=2
 BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
 BMC50471I SMFID=DB2B,JOBID=J0894531,JOB=EXMPL10R,STEP=BMCREORG,CPU=8561-615 (z15)/1.71,72.0G
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  BPE0556  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=XBMDB2V                      
 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 BMC_BMCSSTRACKING ='BMCUTIL.CMN_BMCSSTRACK'
 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 LARDBXAB.LARSXABA
 BMC50102I   SHRLEVEL CHANGE
 BMC50102I   UNLOAD CONTINUE
 BMC50102I   XBMID XV2B
 BMC50102I   FASTSWITCH YES
 BMC50102I   COPY YES
 BMC50102I   ORDER YES
 BMC50102I   DEADLINE 2025-12-31-19.30.00.00
 BMC50102I   MAXRO 600
 BMC50102I   DELAY 300
 BMC50102I   LOGSPILL (1024,1024)
 BMC50102I   SPILLDSNPAT 'ARU.LARWORK.DEMO'
 BMC50102I   SPILLUNIT NONE
 BMC50102I   SPILLSTORCLAS COPYCLAS
 BMC50102I   ANALYZE
 BMC50102I   DDTYPE UNLOAD ACTIVE YES UNIT (WORK) SIZEPCT (150,150)
 BMC50102I   DSNPAT 'ARU.EXMPL10.&DB.&TSIX.&DDNAME'
 BMC50102I   DDTYPE WORK   ACTIVE YES UNIT (WORK) SIZEPCT (150,150)
 BMC50102I   DSNPAT 'ARU.EXMPL10.&DB.&TSIX.&DDNAME'
 BMC50102I   ARCHDDN (ARUARC)
 BMC50102I   DDTYPE LOCPFCPY ACTIVE NO
 
 BMC50109I 'FASTSWITCH=YES' OPTION SPECIFIED.  OPTION 'STAGEDSN=BMC' IGNORED
 BMC51291I A DDLIN DATASET HAS BEEN FOUND AND CONTAINS THE FOLLOWING STATEMENTS:
0
0
 BMC50102I ALTER TABLE LARDBXAB.LART001
 BMC50102I    ALTER PARTITION  02 ENDING AT ('2002-12-31')
 BMC50102I    ;
 BMC51232I ALTER STATEMENT 1 WILL BE PROCESSED
 BMC51293I 1 ALTER STATEMENT(S) WILL BE PROCESSED FROM THE DDLIN FILE
 BMC50138I 'CPYRFAIL TERM' CHANGED TO 'CPYRFAIL COPYPEND' DUE TO ALTER TABLE/INDEX IN 'DDLIN' DATASET
 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, TABLE/ALIAS DOES NOT EXIST
 
 BMC50199I REORG PLUS PROCESSING CONTINUES
 
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XV2B
 BMC50244I PROCESSING PAGESET DBID(1953) PSID(2) PART(1) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00000000 FOR DBID(1953) PSID(2)
 BMC50245I REGISTERING SYSTEM PAGE - 00000002 FOR DBID(1953) PSID(2)
 BMC50244I PROCESSING PAGESET DBID(1953) PSID(2) PART(2) THAT MIGHT CONTAIN VERSIONED DATA
 BMC51301I 3: SAMPLING STATISTICS: PART=1,TP=18833,SP=136,SR=787,AVGR=440,SD=65,SE=0,AVGF=578,SD=65,SE=10,EP=5
 BMC50245I REGISTERING HEADER PAGE - 00100000 FOR DBID(1953) PSID(2)
 BMC50245I REGISTERING SYSTEM PAGE - 00100002 FOR DBID(1953) PSID(2)
 BMC51301I 2: SAMPLING STATISTICS: PART=2,TP=51,SP=49,SR=97,AVGR=442,SD=65,SE=2,AVGF=197,SD=65,SE=40,EP=32
 BMC50244I PROCESSING PAGESET DBID(1953) PSID(2) PART(3) THAT MIGHT CONTAIN VERSIONED DATA
 BMC50245I REGISTERING HEADER PAGE - 00200000 FOR DBID(1953) PSID(2)
 BMC50245I REGISTERING SYSTEM PAGE - 00200002 FOR DBID(1953) PSID(2)
 BMC51301I 1: SAMPLING STATISTICS: PART=3,TP=2358,SP=103,SR=594,AVGR=440,SD=65,SE=1,AVGF=576,SD=65,SE=11,EP=4
 BMC51265I ESTIMATED CARDINALITY OF SPACE = 122492  AVG SORTWK ROW LENGTH = 440  AVG UNLOAD ROW LENGTH = 440
 BMC50484I ESTIMATED CARDINALITY OF PART 0001 = 108825  AVG SORTWK ROW LENGTH = 440  AVG UNLOAD ROW LENGTH = 440
 BMC50484I ESTIMATED CARDINALITY OF PART 0002 = 97  AVG SORTWK ROW LENGTH = 442  AVG UNLOAD ROW LENGTH = 442
 BMC50484I ESTIMATED CARDINALITY OF PART 0003 = 13570  AVG SORTWK ROW LENGTH = 440  AVG UNLOAD ROW LENGTH = 440
 BMC51264I UNLOAD WILL READ 21233 DATA PAGES FROM SPACE 'LARDBXAB.LARSXABA'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XV2B
 BMC50004I ANALYZE PHASE COMPLETE.  ELAPSED TIME = 00:00:00
 
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XV2B
 BMC50425I &JOBNAME  = EXMPL10R  &STEPNAME = BMCREORG  &DB       = LARDBXAB  &TSIX     = LARSXABA  &RTYPE    = TS      
 BMC50425I &UID      = BMCPMN    &DATE     = 012022    &TIME     = 111649    &SSID     = DEMO      &UTIL     = EXMPL10R
 BMC50425I &UTILPFX  = EXMPL10R  &UTILSFX  =           &DATE8    = 01202022  &GRPNM    = DEMO      &VCAT     = DEMOCAT
 BMC50425I &TIME4    = 1116      &DATEJ    = 2022020   &JDATE    = 22020                                               
 
 BMC50702I LOG PROCESSING STARTED AT 01/20/2022 11:16:50
 BMC50773I 101: LOG SCAN TASK STARTED AT 01/20/2022 11:16:50
 BMC50706I MONITOR TRACE CLASS(1) STARTED, TRACE NUMBER = 06
 BMC50877I POINT OF CONSISTENCY ESTABLISHED AT RBA/LRSN = 0000000003A926DD92C2
 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.EXMPL10.LARDBXAB.LARSXABA.SYSREC01      *WORK                          71736    17934     1329       333  TRK
 BMC50448I SYSREC02 ARU.EXMPL10.LARDBXAB.LARSXABA.SYSREC02      *WORK                             65       17        2         1  TRK
 BMC50448I SYSREC03 ARU.EXMPL10.LARDBXAB.LARSXABA.SYSREC03      *WORK                           8946     2237      166        42  TRK
 BMC50448I SYSUT1   ARU.EXMPL10.LARDBXAB.LARSXABA.SYSUT1        *WORK                           2156      216       40         4  TRK
 
 BMC50394I UNABLE TO LOCATE SORT WORK DATASETS, DDNAME = 'SORTWKNN'
 BMC50474I BELOW 16M = 8300K, ABOVE 16M = 1012088K, CPUS = 5
 BMC50479I TOTAL PAGES: 11040228, ALLOWED: 0; AVAILABLE PAGES: 2876540, ALLOWED: 2876540
 BMC50719I 2 LOG APPLY TASKS, 4 INDEX APPLY TASKS, AVAILABLE MEMORY: 891597K
 BMC50887I RIDMAP: RIDMAPMEM CHANGED TO 2097152K
 BMC50864I LOGMEM OF 0K SPECIFIED, CHANGED TO 25600K
 BMC51302I MAX TASKS = 2, MAX PARTITIONS PER TASK = 2, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 2
 BMC50773I 108: LOG RECORD SORT TASK STARTED AT 01/20/2022 11:16:52
 BMC50773I 109: LOG RECORD SPILL TASK STARTED AT 01/20/2022 11:16:52
 BMC50773I 110: INLINE IMAGE COPY APPEND TASK STARTED AT 01/20/2022 11:16:52
 BMC50847I 110: BUFFER ALLOCATIONS: CHANGED PAGE BUFFERS = 0, I/O BUFFERS = 1400,LARGEST BLOCK SIZE = 4096
 BMC50486I 2: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1764K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50477I 2: PARTITION =    2, ROWS/KEYS = 97, I/O WAITS = 1 ,DDNAME = SYS00025
 BMC50477I 2: PARTITION =    3, ROWS/KEYS = 13289, I/O WAITS = 6 ,DDNAME = SYS00027
 BMC50481I 2: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50477I 1: PARTITION =    1, ROWS/KEYS = 107446, I/O WAITS = 54 ,DDNAME = SYS00026
 BMC50481I 1: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 1: UNLOAD TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50481I 2: UNLOAD TASK COMPLETE.  ELAPSED TIME = 00:00:02
 BMC50476I DDNAME = SYSREC01, I/OS = 153, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC02, I/OS = 20, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC03, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = ARUARC, I/OS = 0, I/O WAITS = 0, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSUT1, I/OS = 6, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC51271I UNLOAD STATISTICS:  107446 ROWS/KEYS UNLOADED FROM PARTITION 1
 BMC51281I UNLOAD STATISTICS:  X'0000000003A926D37D3D' IS THE HIGHEST LOGRBA FOR PARTITION 1
 BMC51286I RELOADING OF DATASET 'DEMOCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A001' WILL REQUIRE 18830 PAGES
 BMC51288I RELOADING OF DATASET 'DEMOCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A001' MAY REQUIRE 553 PAGES
 BMC51271I UNLOAD STATISTICS:  13386 ROWS/KEYS UNLOADED FROM PARTITION 2
 BMC51281I UNLOAD STATISTICS:  X'0000000003A926D392E4' IS THE HIGHEST LOGRBA FOR PARTITION 2
 BMC51286I RELOADING OF DATASET 'DEMOCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A002' WILL REQUIRE 2375 PAGES
 BMC51288I RELOADING OF DATASET 'DEMOCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A002' MAY REQUIRE 71 PAGES
 BMC51271I UNLOAD STATISTICS:  0 ROWS/KEYS UNLOADED FROM PARTITION 3
 BMC51281I UNLOAD STATISTICS:  X'0000000003A926D3A7F6' IS THE HIGHEST LOGRBA FOR PARTITION 3
 BMC51286I RELOADING OF DATASET 'DEMOCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A003' WILL REQUIRE 34 PAGES
 BMC51290I RELOADING OF DATASET 'DEMOCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A003' WILL REQUIRE 3 PAGES (APPROX.)
 BMC51288I RELOADING OF DATASET 'DEMOCAT.DSNDBD.LARDBXAB.LARX001B.J0001.A001' MAY REQUIRE 665 PAGES
 BMC51272I UNLOAD STATISTICS:  120832 ROWS UNLOADED FROM SPACE 'LARDBXAB.LARSXABA', 0 ROWS DISCARDED, 0 ROWS UPDATED
 BMC51282I UNLOAD STATISTICS:  X'0000000003A926D3A7F6' IS THE HIGHEST LOGRBA FOR SPACE 'LARDBXAB.LARSXABA'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XV2B
 BMC50004I UNLOAD PHASE COMPLETE.  ELAPSED TIME = 00:00:04
 
 BMC50277I XBM STATISTICS: DSN='DEMOCAT.DSNDBD.LARDBXAB.LARSXABA.I0001.A001  ', READS 18833, HITS 0, WRITES 0, CACHE 0
 BMC50277I XBM STATISTICS: DSN='DEMOCAT.DSNDBD.LARDBXAB.LARSXABA.I0001.A002  ', READS 66, HITS 0, WRITES 0, CACHE 0
 BMC50277I XBM STATISTICS: DSN='DEMOCAT.DSNDBD.LARDBXAB.LARSXABA.I0001.A003  ', READS 2358, HITS 0, WRITES 0, CACHE 0
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XV2B
 BMC50474I BELOW 16M = 8256K, ABOVE 16M = 993492K, CPUS = 5
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A001'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A001'
 BMC50479I TOTAL PAGES: 11040172, ALLOWED: 0; AVAILABLE PAGES: 2870821, ALLOWED: 2870821
 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
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A002'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A002'
 BMC50476I DDNAME = SYSUT1, I/OS = 4, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50481I 1: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.LARDBXAB.LARX001B.J0001.A001'
 BMC50477I 1: PARTITION =    0, ROWS/KEYS = 120832, I/O WAITS = 5 ,DDNAME = SYS00033
 BMC50773I 107: INDEX APPLY TASK STARTED AT 01/20/2022 11:16:56
 BMC51276I BUILD  STATISTICS:  120832 KEYS LOADED INTO INDEX 'LARDBXAB.LARX001B'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A001'
 BMC50482I 0: BUILD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEMOCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A001'
 BMC50477I 0: PARTITION =    1, ROWS/KEYS = 107446, I/O WAITS = 5 ,DDNAME = SYS00029
 BMC50482I 0: RELOAD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEMOCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A001'
 BMC50477I 0: PARTITION =    1, ROWS/KEYS = 107446, I/O WAITS = 105 ,DDNAME = SYS00028
 BMC51274I RELOAD STATISTICS:  107446 ROWS/KEYS LOADED INTO PARTITION 1
 BMC50773I 104: INDEX APPLY TASK STARTED AT 01/20/2022 11:16:57
 BMC50476I DDNAME = SYSREC01, I/OS = 145, I/O WAITS = 11, RDB LOCK WAITS = 0
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A002'
 BMC50482I 0: BUILD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEMOCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A002'
 BMC50477I 0: PARTITION =    2, ROWS/KEYS = 13386, I/O WAITS = 5 ,DDNAME = SYS00032
 BMC50773I 105: INDEX APPLY TASK STARTED AT 01/20/2022 11:16:57
 BMC50482I 0: RELOAD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEMOCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A002'
 BMC50477I 0: PARTITION =    2, ROWS/KEYS = 13386, I/O WAITS = 9 ,DDNAME = SYS00030
 BMC51274I RELOAD STATISTICS:  13386 ROWS/KEYS LOADED INTO PARTITION 2
 BMC50476I DDNAME = SYSREC02, I/OS = 18, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50482I 0: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.LARDBXAB.LARX001A.J0001.A003'
 BMC50477I 0: PARTITION =    3, ROWS/KEYS = 0, I/O WAITS = 5 ,DDNAME = SYS00034
 BMC50773I 106: INDEX APPLY TASK STARTED AT 01/20/2022 11:16:57
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A003'
 BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A003'
 BMC50482I 0: RELOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.LARDBXAB.LARSXABA.J0001.A003'
 BMC50477I 0: PARTITION =    3, ROWS/KEYS = 0, I/O WAITS = 5 ,DDNAME = SYS00035
 BMC51274I RELOAD STATISTICS:  0 ROWS/KEYS LOADED INTO PARTITION 3
 BMC51276I BUILD  STATISTICS:  120832 KEYS LOADED INTO INDEX 'LARDBXAB.LARX001A'
 BMC51275I RELOAD STATISTICS:  120832 ROWS LOADED INTO SPACE 'LARDBXAB.LARSXABA'
 BMC50773I 102: LOG APPLY TASK STARTED AT 01/20/2022 11:16:57
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC03', DSNAME = 'ARU.EXMPL10.LARDBXAB.LARSXABA.SYSREC03'
 BMC50773I 103: LOG APPLY TASK STARTED AT 01/20/2022 11:16:57
 BMC50829I LOGAPPLY PHASE STARTING AT 01/20/2022 11:16:57
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC02', DSNAME = 'ARU.EXMPL10.LARDBXAB.LARSXABA.SYSREC02'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC01', DSNAME = 'ARU.EXMPL10.LARDBXAB.LARSXABA.SYSREC01'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT1  ', DSNAME = 'ARU.EXMPL10.LARDBXAB.LARSXABA.SYSUT1'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XV2B
 BMC50004I RELOAD PHASE COMPLETE.  ELAPSED TIME = 00:00:02
 
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XV2B
 BMC50877I POINT OF CONSISTENCY ESTABLISHED AT RBA/LRSN = 0000000003A926E18B93
 BMC50778I LOG RECORD QUEUE SIZE AT OR BELOW THRESHOLD
 BMC50004I LOGAPPLY PHASE COMPLETE.  ELAPSED TIME = 00:00:10
 BMC50830I LOGFINAL PHASE STARTING AT 01/20/2022 11:17:08
 BMC50709I MONITOR TRACE CLASS(1) TRACE NUMBER = 06 STOPPED
 BMC50786I 101: LOG SCAN TASK ENDED AT 01/20/2022 11:17:08, ELAPSED TIME = 00:00:17
 BMC50720I 102: 0 NEW LOG APPLY BUFFERS, 0 REUSED, 5900 INITIAL MAXIMUM, 0 WAITS, BUFFER SIZE=8388
 BMC50741I 102: LOGAPPLY STATISTICS
 BMC50742I 102: PROCESSED TRANSACTIONS
 BMC50744I 102:    INSERTS:          0 INSERTS(COMPENSATION):          0
 BMC50745I 102:    UPDATES:          0 UPDATES(COMPENSATION):          0
 BMC50746I 102:    DELETES:          0 DELETES(COMPENSATION):          0
 BMC50743I 102: CONSOLIDATED TRANSACTIONS
 BMC50744I 102:    INSERTS:          0 INSERTS(COMPENSATION):          0
 BMC50745I 102:    UPDATES:          0 UPDATES(COMPENSATION):          0
 BMC50746I 102:    DELETES:          0 DELETES(COMPENSATION):          0
 BMC50747I 102: PAGES UPDATED COUNTERS FOR LARDBXAB.LARSXABA
 BMC50748I 102:     PART     TOTAL PAGES     DATA PAGES     SPACE MAPS     HEADER PAGES
 BMC50749I 102:        1              1              0               0               1
 BMC50716I 102: Buffer Manager Statistics
 BMC50717I 102:  DATASET=DEMOCAT.DSNDBC.LARDBXAB.LARSXABA.J0001.A001
 BMC50718I 102:        Page Requests          5 |            Page Hits          0
 BMC50718I 102:           Page Reads          5 |          Page Writes          1
 BMC50718I 102:   Write I/O Requests          1 |            New Pages          0
 BMC50716I 102:       Write I/O time    0:00:00 |        Read I/O time    0:00:00
 BMC50786I 102: LOG APPLY TASK ENDED AT 01/20/2022 11:17:12, ELAPSED TIME = 00:00:15
 BMC50720I 103: 0 NEW LOG APPLY BUFFERS, 0 REUSED, 5900 INITIAL MAXIMUM, 0 WAITS, BUFFER SIZE=8388
 BMC50741I 103: LOGAPPLY STATISTICS
 BMC50742I 103: PROCESSED TRANSACTIONS
 BMC50744I 103:    INSERTS:          0 INSERTS(COMPENSATION):          0
 BMC50745I 103:    UPDATES:          0 UPDATES(COMPENSATION):          0
 BMC50746I 103:    DELETES:          0 DELETES(COMPENSATION):          0
 BMC50743I 103: CONSOLIDATED TRANSACTIONS
 BMC50744I 103:    INSERTS:          0 INSERTS(COMPENSATION):          0
 BMC50745I 103:    UPDATES:          0 UPDATES(COMPENSATION):          0
 BMC50746I 103:    DELETES:          0 DELETES(COMPENSATION):          0
 BMC50747I 103: PAGES UPDATED COUNTERS FOR LARDBXAB.LARSXABA
 BMC50748I 103:     PART     TOTAL PAGES     DATA PAGES     SPACE MAPS     HEADER PAGES
 BMC50749I 103:        2              1              0               0               1
 BMC50749I 103:        3              1              0               0               1
 BMC50716I 103: Buffer Manager Statistics
 BMC50717I 103:  DATASET=DEMOCAT.DSNDBC.LARDBXAB.LARSXABA.J0001.A002
 BMC50717I 103:  DATASET=DEMOCAT.DSNDBC.LARDBXAB.LARSXABA.J0001.A003
 BMC50718I 103:        Page Requests          4 |            Page Hits          0
 BMC50718I 103:           Page Reads          4 |          Page Writes          1
 BMC50718I 103:   Write I/O Requests          2 |            New Pages          0
 BMC50716I 103:       Write I/O time    0:00:00 |        Read I/O time    0:00:00
 BMC50786I 103: LOG APPLY TASK ENDED AT 01/20/2022 11:17:12, ELAPSED TIME = 00:00:15
 BMC50794I 104: INDEX MAINTENANCE STATISTICS FOR INDEX LARDBXAB.LARX001A DSNUM 1
 BMC50791I 104:   PAGE READS  :         2  KEY INSERTS     :         0
 BMC50794I 106: INDEX MAINTENANCE STATISTICS FOR INDEX LARDBXAB.LARX001A DSNUM 3
 BMC50791I 106:   PAGE READS  :         2  KEY INSERTS     :         0
 BMC50794I 105: INDEX MAINTENANCE STATISTICS FOR INDEX LARDBXAB.LARX001A DSNUM 2
 BMC50791I 106:   RID INSERTS :         0  RID DELETES (PS):         0
 BMC50791I 106:   ROOT SPLITS :         0  NON-LEAF SPLITS :         0
 BMC50791I 105:   PAGE READS  :         2  KEY INSERTS     :         0
 BMC50791I 105:   RID INSERTS :         0  RID DELETES (PS):         0
 BMC50791I 105:   ROOT SPLITS :         0  NON-LEAF SPLITS :         0
 BMC50791I 105:   LEAF SPLITS :         0  PAGE FREES      :         0
 BMC50791I 105:   NEW PAGES   :         0  BUFF PAGE READS :         0
 BMC50794I 107: INDEX MAINTENANCE STATISTICS FOR INDEX LARDBXAB.LARX001B
 BMC50791I 107:   PAGE READS  :         2  KEY INSERTS     :         0
 BMC50791I 107:   RID INSERTS :         0  RID DELETES (PS):         0
 BMC50791I 107:   ROOT SPLITS :         0  NON-LEAF SPLITS :         0
 BMC50791I 106:   LEAF SPLITS :         0  PAGE FREES      :         0
 BMC50791I 106:   NEW PAGES   :         0  BUFF PAGE READS :         0
 BMC50791I 107:   LEAF SPLITS :         0  PAGE FREES      :         0
 BMC50791I 107:   NEW PAGES   :         0  BUFF PAGE READS :         0
 BMC50789W 106: THERE ARE NO KEY VALUES FOR INDEX LARDBXAB.LARX001A DSNUM 3
 BMC50786I 108: LOG RECORD SORT TASK ENDED AT 01/20/2022 11:17:12, ELAPSED TIME = 00:00:20
 BMC50791I 104:   RID INSERTS :         0  RID DELETES (PS):         0
 BMC50791I 104:   ROOT SPLITS :         0  NON-LEAF SPLITS :         0
 BMC50791I 104:   LEAF SPLITS :         0  PAGE FREES      :         0
 BMC50791I 104:   NEW PAGES   :         0  BUFF PAGE READS :         0
 BMC50716I 105: Buffer Manager Statistics
 BMC50717I 105:  DATASET=DEMOCAT.DSNDBC.LARDBXAB.LARX001A.J0001.A002
 BMC50718I 105:        Page Requests          5 |            Page Hits          1
 BMC50718I 105:           Page Reads          4 |          Page Writes          1
 BMC50718I 105:   Write I/O Requests          1 |            New Pages          0
 BMC50716I 105:       Write I/O time    0:00:00 |        Read I/O time    0:00:00
 BMC50716I 106: Buffer Manager Statistics
 BMC50717I 106:  DATASET=DEMOCAT.DSNDBC.LARDBXAB.LARX001A.J0001.A003
 BMC50718I 106:        Page Requests          5 |            Page Hits          1
 BMC50718I 106:           Page Reads          4 |          Page Writes          1
 BMC50718I 106:   Write I/O Requests          1 |            New Pages          0
 BMC50716I 106:       Write I/O time    0:00:00 |        Read I/O time    0:00:00
 BMC50716I 107: Buffer Manager Statistics
 BMC50717I 107:  DATASET=DEMOCAT.DSNDBC.LARDBXAB.LARX001B.J0001.A001
 BMC50718I 107:        Page Requests          6 |            Page Hits          1
 BMC50718I 107:           Page Reads          5 |          Page Writes          1
 BMC50718I 107:   Write I/O Requests          1 |            New Pages          0
 BMC50716I 107:       Write I/O time    0:00:00 |        Read I/O time    0:00:00
 BMC50716I 104: Buffer Manager Statistics
 BMC50717I 104:  DATASET=DEMOCAT.DSNDBC.LARDBXAB.LARX001A.J0001.A001
 BMC50718I 104:        Page Requests          6 |            Page Hits          1
 BMC50718I 104:           Page Reads          5 |          Page Writes          1
 BMC50718I 104:   Write I/O Requests          1 |            New Pages          0
 BMC50716I 104:       Write I/O time    0:00:00 |        Read I/O time    0:00:00
 BMC50786I 105: INDEX APPLY TASK ENDED AT 01/20/2022 11:17:12, ELAPSED TIME = 00:00:15
 BMC50786I 107: INDEX APPLY TASK ENDED AT 01/20/2022 11:17:12, ELAPSED TIME = 00:00:16
 BMC50786I 106: INDEX APPLY TASK ENDED AT 01/20/2022 11:17:12, ELAPSED TIME = 00:00:15
 BMC50786I 104: INDEX APPLY TASK ENDED AT 01/20/2022 11:17:13, ELAPSED TIME = 00:00:15
 BMC50867I LOG RECORD STORE SPILL REQUESTS = 0, HIGH SPILL PAGE = 0, SPILL DATASETS CREATED = 0
 BMC50868I LOG RECORD STORE WRITE REQUESTS = 0, WRITE WAIT TIME =   0.000, READ REQUESTS = 0 READ WAIT TIME =   0.000
 BMC50786I 109: LOG RECORD SPILL TASK ENDED AT 01/20/2022 11:17:13, ELAPSED TIME = 00:00:20
 BMC50786I 110: INLINE IMAGE COPY APPEND TASK ENDED AT 01/20/2022 11:17:13, ELAPSED TIME = 00:00:20
 BMC50476I DDNAME = BMCCPY, I/OS = 183, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPZ, I/OS = 183, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCY, I/OS = 183, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCZ, I/OS = 183, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50376I 21255 PAGES COPIED TO DATASET = 'ARU.EXMPL10.BMCCPY'
 BMC50376I 21255 PAGES COPIED TO DATASET = 'ARU.EXMPL10.BMCCPZ'
 BMC50376I 21255 PAGES COPIED TO DATASET = 'ARU.EXMPL10.BMCRCY'
 BMC50376I 21255 PAGES COPIED TO DATASET = 'ARU.EXMPL10.BMCRCZ'
 BMC50865I TOTAL RECORDS INSERTED INTO LOG RECORD STORE, DATA =0, INDEX = 0
 BMC50866I TOTAL TABLESPACE STRINGS PROCESSED = 0, WHEN NOT FULL = 0, FROM SPILL = 0
 BMC50866I TOTAL INDEXSPACE STRINGS PROCESSED = 0, WHEN NOT FULL = 0, FROM SPILL = 0
 BMC50866I TOTAL INDEXSPACE REQUE STRINGS PROCESSED = 0, WHEN NOT FULL = 0, FROM SPILL = 0
 BMC50859I LOG RECORD STORE STATISTICS:  MEMORY AVAILABLE = 25600K, MEMORY USED = 5120K
 BMC50860I TOTAL WAIT TIME FOR LOG RECORD STORE MEMORY =   0.000 DATA =   0.000 INDEX =   0.000
 BMC50880I RIDMAP: PART 0001: ROWS=107446, PAIRS=107443, STORAGE=896K, MEM WAITS=0, WAIT TIME=0
 BMC50881I RIDMAP: PART 0001: TRANS=0, ADDS=0, DELS=0, SPILL READS=0, WAIT TIME=0
 BMC50880I RIDMAP: PART 0002: ROWS=97, PAIRS=94, STORAGE=4K, MEM WAITS=0, WAIT TIME=0
 BMC50881I RIDMAP: PART 0002: TRANS=0, ADDS=0, DELS=0, SPILL READS=0, WAIT TIME=0
 BMC50880I RIDMAP: PART 0003: ROWS=13289, PAIRS=13287, STORAGE=112K, MEM WAITS=0, WAIT TIME=0
 BMC50881I RIDMAP: PART 0003: TRANS=0, ADDS=0, DELS=0, SPILL READS=0, WAIT TIME=0
 BMC50880I RIDMAP: SUMMARY: ROWS=120832, PAIRS=120824, STORAGE=1012K, MEM WAITS=0, WAIT TIME=0
 BMC50881I RIDMAP: SUMMARY: TRANS=0, ADDS=0, DELS=0, SPILL READS=0, WAIT TIME=0
 BMC50882I RIDMAP: SUMMARY: MAX DATASPACES=1, USED DATASPACES=1, RIDMAPMEM=0K, USED MEM=2044K
 BMC50883I RIDMAP: SUMMARY: MAX PIPES=10, PIPES USED=4, PIPE BUFFER SIZE=262144, PIPE WAITS=0, WAIT TIME=0
 BMC50868I RIDMAP WRITE REQUESTS = 0, WRITE WAIT TIME =   0.000, READ REQUESTS = 0 READ WAIT TIME =   0.000
 BMC50703I LOG PROCESSING COMPLETED, RC = 0, AT 01/20/2022 11:17:13, ELAPSED TIME = 00:00:22
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XV2B
 BMC50004I LOGFINAL PHASE COMPLETE.  ELAPSED TIME = 00:00:05
 
 BMC50705I SQL PREPARE LOCK STARTED AT 00DAF16F515EBECDC600
 
 BMC50894I SWITCH PROCESS STARTING AT   1/20/2022  11:17:13
 BMC51297I ALL SPECIFIED LIMIT KEYS HAVE BEEN SUCCESSFULLY ALTERED
 BMC50705I SQL PREPARE LOCK TERMINATED AT 00DAF16F517561D8A200
 BMC51362I LPART  PPART       CARD  ALTER TYPE   LIMITKEY
 BMC51363I     1      1     107446               X'19890131'
 BMC51363I     2      2      13386  DDLIN        X'20021231'
 BMC51363I     3      3          0               X'20210331'
 BMC50890I 1: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A001'...
 BMC50890I 6: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A003'...
 BMC50890I 2: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A002'...
 BMC50890I 3: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A003'...
 BMC50890I 5: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A002'...
 BMC50890I 4: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A001'...
 BMC50890I 7: ATTEMPTING TO DELETE DATASET 'DEMOCAT.DSNDBC.LARDBXAB.LARX001B.I0001.A001'...
 BMC50891I 1: DATASET 'DEMOCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A001' IS DELETED
 BMC50891I 2: DATASET 'DEMOCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A002' IS DELETED
 BMC50891I 6: DATASET 'DEMOCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A003' IS DELETED
 BMC50891I 3: DATASET 'DEMOCAT.DSNDBC.LARDBXAB.LARSXABA.I0001.A003' IS DELETED
 BMC50891I 4: DATASET 'DEMOCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A001' IS DELETED
 BMC50891I 7: DATASET 'DEMOCAT.DSNDBC.LARDBXAB.LARX001B.I0001.A001' IS DELETED
 BMC50891I 5: DATASET 'DEMOCAT.DSNDBC.LARDBXAB.LARX001A.I0001.A002' IS DELETED
 
 BMC50501I DB2 OBJECT STATISTICS
0BMC50515I TABLESPACE  LARDBXAB.LARSXABA  PARTS   = 3         TABLES  = 1     SEGSIZE = 32    DSSIZE =    4G    PAGESIZE = 4K
0BMC50516I             PART  NACTIVE       CARD   EXTENTS   DBCARD PCOMP   KSAVED  PSAVED
 BMC50517I                1    18831     107446         6        0     0        0       0
 BMC50517I                2     2376      13386         1        0     0        0       0
 BMC50517I                3       34          0         1        0     0        0       0
 BMC50518I   TABLE     LARDBXAB.LART001
 BMC50519I             ROWAVG    NPAGES       CARD   PCTPAGES
 BMC50520I                441     20227     120832         95
0BMC50525I     INDEX   LARDBXAB.LARX001A
 BMC50526I             FIRST KEY COLUMN = C007_DATE
 BMC50527I             CLUSTER = Y   UNIQUE = D   COMPRESS = N   PAGESIZE = 4K   KEYLEN =    4   COLCOUNT = 1
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                1       325     107446         1        3
 BMC50529I                2        44      13386         1        2
 BMC50529I                3         5          0         1        2
0BMC50525I     INDEX   LARDBXAB.LARX001B
 BMC50526I             FIRST KEY COLUMN = C001_INTEGER
 BMC50527I             CLUSTER = N   UNIQUE = D   COMPRESS = N   PAGESIZE = 4K   KEYLEN =    5   COLCOUNT = 1
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0       486     120832         1        3
 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*