Example 2: Partial reorganization with SHRLEVEL REFERENCE and a single copy of a subset of partitions

This example illustrates a partial reorganization of a 16-partition storage-group-defined table space.

The table has three indexes: the clustering index, a unique nonpartitioned secondary index (NPSI), and a non-unique nonpartitioned secondary index.

Command options used in JCL	Description
REORG TABLESPACE	Specifies that the table space named in the statement is to be reorganized
PART 1:5,8,16 (case 1) PART 1:5 (case 2)	Reorganizes partitions 1 through 5, 8, and 16 (case 1) Reorganizes contiguous partitions 1-5 to enable a single copy of a subset of partitions (case 2) For case 2, COPYSUBSET=YES is also set in the installation options for these copies.
COPYLVL FULL	Requests a full image copy for a partitioned table space This option is required to create a copy of the subset of partitions in case 2.
COPY YES	Creates Db2 image copies of table space partitions 1 through 5, 8, and 16 (case 1) Creates a single image copy of table space partitions 1 through 5 (case 2) Because REGISTER is not specified, this statement defaults to REGISTER ALL. REORG PLUS makes four copies of the table space after reorganizing it registering all four copies in SYSIBM.SYSCOPY.
REDEFINE NO (case 1) REDEFINE YES (default) (case 2)	In case 1, REDEFINE NO tells REORG PLUS not to delete and redefine the VSAM data sets containing the Db2 objects. Instead, REORG PLUS will reset the high-used RBA (HURBA). In case 2, the default of REDEFINE YES tells REORG PLUS to delete and redefine the VSAM data sets containing the Db2 objects.
BMCSTATS YES	Tells REORG PLUS to save the BMC statistics in the DASD MANAGER PLUS database statistics tables The JCL for this example also includes a DD statement for the ASUSRPRT data set. This DD statement tells REORG PLUS not to print the statistics from the Common Statistics component to SYSPRINT, but to send them to a separate data set. This example shows a portion of this ASUSRPRT data set for case 2.
SHRLEVEL NONE (case 1) SHRLEVEL REFERENCE (case 2)	In case 1, the default SHRLEVEL NONE is used. The objects that you are reorganizing are stopped and unavailable during the job. In case 2, SHRLEVEL REFERENCE is specified. The objects that you are reorganizing are available in read-only status during the job.
DDTYPE LOCBFCPY ACTIVE YES DDTYPE REMPFCPY ACTIVE YES DDTYPE REMBFCPY ACTIVE YES	Activates dynamic allocation for the local backup copy and the remote copies, overriding the installation defaults

SYSPRINT for example 2, case 1

The following figure shows the SYSPRINT output for case 1 of example 2:

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/29/2022    2:05:36 ...
BMC50002I UTILITY ID = 'EXMPLE2A'. DB2 SUBSYSTEM ID = 'DEMO'. OPTION MODULE = 'ARU$OPT2'.
BMC50471I z/OS 2.4.0,PID=HBB77C0,DFSMS FOR Z/OS=2.4.0,DB2=13.1.501
BMC50471I REGION=0M,BELOW 16M=8804K,ABOVE 16M=1024908K,IEFUSI=NO,CPUs=7,GPs=5,zIIPs=2
BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040247M,MEMLIMIT SET BY:REGION=0
BMC50471I SMFID=DB2B,JOBID=J0709278,JOB=EXMPLE2A,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%                           ICDDN=(BMCICY,BMCICZ)                   SCPYMAX=8
BMC50471I ARC=NO                                  ICTYPE=AUTO                             SDUMP=YES
BMC50471I ARCHDDN=SYSARC                          IDCACHE=10000                           SHORTMEMORY=CONTINUE
BMC50471I ARCHFORMAT=BMC                          INDREFLM=10                             SIXSNAP=NO
BMC50471I AVAILPAGEPCT=100                        INLINECP=YES                            SMAX=0
BMC50471I BILDMAX=300%                            INVALIDATECACHE=YES                     SMCORE=(0K,0K)
BMC50471I BMCHIST=YES                             KEEPDICTIONARY=NO                       SORTDEVT=(,SYSALLDA)
BMC50471I CBUFFS=30                               LEAFDSLM=200                            SORTNUM=32
BMC50471I CONDEXEC=NO                             LOCKROW=YES                             SPILDCLS=NONE
BMC50471I COPYDDN=(BMCCPY,BMCCPZ)                 LOGFINAL=NONE                           SPILDSNP=&UID
BMC50471I COPYLVL=PART                            LOGMEM=0                                SPILSCLS=NONE
BMC50471I COPYMAX=1000%                           LOGSPIL=(20000,10000)                   SPILUNIT=WORK
BMC50471I COPYSUBSET=YES                          LOGTHRSH=0                              SQLDELAY=3
BMC50471I CPYRFAIL=TERM                           LONGLOG=CONTINUE                        SQLRETRY=100
BMC50471I DATACAP=NO                              LONGNAMETRUNC=MIDDLE                    SSREPORT=REPORT_SWITCH
BMC50471I DDLDDN=DDLIN                            MAPTEXIT=(NONE,REXX)                    STAGEDSN=BMC
BMC50471I DEADLINE=NONE                           MAXNEWPARTS=2                           STOP@CMT=YES
BMC50471I DELAY=1200                              MAXRO=300                               STOPDELAY=1
BMC50471I DELFILES=YES                            MAXSORTMEMORY=0                         STOPRETRY=300
BMC50471I DESCCDE=(3,7)                           MAXTAPE=3                               TAPEDISP=DELETE
BMC50471I DRAINTYP=ALL                            MGEXTENT=CONTINUE                       TASKMAX=1000%
BMC50471I DRNDELAY=1                              MINSORTMEMORY=0                         TERMEXIT=(NONE,REXX)
BMC50471I DRNRETRY=255                            MSGLEVEL=1                              TIMEOUT=TERM
BMC50471I DRNWAIT=NONE                            OFFPOSLM=10                             TOTALPAGEPCT=0
BMC50471I DSNUEXIT=(NONE,ASM)                     OPNDB2ID=YES                            TSSAMPLEPCT=100
BMC50471I DSNUTILB=YES                            ORIGDISP=DELETE                         UBUFFS=20
BMC50471I DSPLOCKS=DRNFAIL                        PREFORMAT=NO                            UNLDDN=SYSREC
BMC50471I DSRSEXIT=(NONE,REXX)                    RCVICDDN=(BMCIRY,BMCIRZ)                UNLDMAX=300%
BMC50471I EXCLDUMP=(X37,X22,X06)                  RCVYDDN=(BMCRCY,BMCRCZ)                 UNLOAD=RELOAD
BMC50471I FASTSWITCH=NO                           REDEFINE=YES                            UXSTATE=SUP
BMC50471I FILECHK=WARN                            RENMMAX=30                              WBUFFS=(20,10)
BMC50471I FORCE_AT=(START,3)                      RIDMDSSZ=2097152                        WORKDDN=SYSUT1
BMC50471I FORCE_RPT=NO                            RIDMMAXD=1                              WORKUNIT=SYSALLDA
BMC50471I FORCE=NONE                              RMAPMEM=0                               WRLOG=NO
BMC50471I FSFALLBACK=NO                           RORGMAX=300%                            XBMID=
BMC50471I FSTHRESHOLD=0                           ROUTCDE=(11,1)                          ZIIP=ENABLED
0
BMC50471I PLAN=ARU1310D
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)                            (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   = 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..F&PART..T&TIME
BMC50483I LOCBLCPY   DSNPAT=&UID.&DDNAME.&TSIX..F&PART..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..F&PART..T&TIME
BMC50483I REMBLCPY   DSNPAT=&UID.&DDNAME.&TSIX..F&PART..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 ARUDB007.TS007 PART 1:5, 8, 16
BMC50102I       COPY YES
BMC50102I       REDEFINE NO
BMC50102I       BMCSTATS YES
BMC50102I       DDTYPE UNLOAD
BMC50102I         DSNPAT 'ARU.EXMPL03A.&DDNAME'
BMC50102I       ACTIVE YES
BMC50102I       DDTYPE WORK
BMC50102I         DSNPAT 'ARU.EXMPL03A.&DDNAME'
BMC50102I       DDTYPE LOCPFCPY
BMC50102I         DSNPAT 'ARU.EXMPL03A.&DDNAME'
BMC50102I       DDTYPE LOCBFCPY ACTIVE YES
BMC50102I         DSNPAT 'ARU.EXMPL03A.&DDNAME'
BMC50102I       DDTYPE REMPFCPY ACTIVE YES
BMC50102I         DSNPAT 'ARU.EXMPL03A.&DDNAME'
BMC50102I       DDTYPE REMBFCPY ACTIVE YES
BMC50102I         DSNPAT 'ARU.EXMPL03A.&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(1945) PSID(2) PART(1) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00000000 FOR DBID(1945) PSID(2)
BMC50244I PROCESSING PAGESET DBID(1945) PSID(2) PART(2) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00100000 FOR DBID(1945) PSID(2)
BMC50244I PROCESSING PAGESET DBID(1945) PSID(2) PART(3) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00200000 FOR DBID(1945) PSID(2)
BMC50244I PROCESSING PAGESET DBID(1945) PSID(2) PART(4) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00300000 FOR DBID(1945) PSID(2)
BMC50244I PROCESSING PAGESET DBID(1945) PSID(2) PART(5) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00400000 FOR DBID(1945) PSID(2)
BMC50244I PROCESSING PAGESET DBID(1945) PSID(2) PART(8) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00700000 FOR DBID(1945) PSID(2)
BMC50244I PROCESSING PAGESET DBID(1945) PSID(2) PART(16) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00F00000 FOR DBID(1945) PSID(2)
BMC51265I ESTIMATED CARDINALITY OF SPACE = 0 AVG SORTWK ROW LENGTH = 0 AVG UNLOAD ROW LENGTH = 0
BMC50484I ESTIMATED CARDINALITY OF PART 0001 = 0 AVG SORTWK ROW LENGTH = 0 AVG UNLOAD ROW LENGTH = 0
BMC50484I ESTIMATED CARDINALITY OF PART 0002 = 0 AVG SORTWK ROW LENGTH = 0 AVG UNLOAD ROW LENGTH = 0
BMC50484I ESTIMATED CARDINALITY OF PART 0003 = 0 AVG SORTWK ROW LENGTH = 0 AVG UNLOAD ROW LENGTH = 0
BMC50484I ESTIMATED CARDINALITY OF PART 0004 = 0 AVG SORTWK ROW LENGTH = 0 AVG UNLOAD ROW LENGTH = 0
BMC50484I ESTIMATED CARDINALITY OF PART 0005 = 0 AVG SORTWK ROW LENGTH = 0 AVG UNLOAD ROW LENGTH = 0
BMC50484I ESTIMATED CARDINALITY OF PART 0008 = 0 AVG SORTWK ROW LENGTH = 0 AVG UNLOAD ROW LENGTH = 0
BMC50484I ESTIMATED CARDINALITY OF PART 0016 = 0 AVG SORTWK ROW LENGTH = 0 AVG UNLOAD ROW LENGTH = 0
BMC51264I UNLOAD WILL READ 0 DATA PAGES FROM SPACE 'ARUDB007.TS007'
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 = EXMPLE2A &STEPNAME = BMCREORG &DB       = ARUDB007 &TSIX     = TS007     &RTYPE    = TS
BMC50425I &UID      = BMCPMN    &DATE     = 122921    &TIME     = 020536    &SSID     = DEMO      &UTIL     = EXMPLE2A
BMC50425I &UTILPFX = EXMPLE2A &UTILSFX =           &DATE8    = 1292022 &GRPNM    = DEMO      &VCAT     = DEMOCAT
BMC50425I &TIME4    = 0205      &DATEJ    = 2021363   &JDATE    = 21363

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.EXMPL03A.BMCCPY01                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCCPY02 ARU.EXMPL03A.BMCCPY02                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCCPY03 ARU.EXMPL03A.BMCCPY03                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCCPY04 ARU.EXMPL03A.BMCCPY04                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCCPY05 ARU.EXMPL03A.BMCCPY05                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCCPY08 ARU.EXMPL03A.BMCCPY08                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCCPY16 ARU.EXMPL03A.BMCCPY16                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCCPZ01 ARU.EXMPL03A.BMCCPZ01                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCCPZ02 ARU.EXMPL03A.BMCCPZ02                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCCPZ03 ARU.EXMPL03A.BMCCPZ03                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCCPZ04 ARU.EXMPL03A.BMCCPZ04                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCCPZ05 ARU.EXMPL03A.BMCCPZ05                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCCPZ08 ARU.EXMPL03A.BMCCPZ08                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCCPZ16 ARU.EXMPL03A.BMCCPZ16                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCRCY01 ARU.EXMPL03A.BMCRCY01                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCRCY02 ARU.EXMPL03A.BMCRCY02                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCRCY03 ARU.EXMPL03A.BMCRCY03                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCRCY04 ARU.EXMPL03A.BMCRCY04                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCRCY05 ARU.EXMPL03A.BMCRCY05                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCRCY08 ARU.EXMPL03A.BMCRCY08                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCRCY16 ARU.EXMPL03A.BMCRCY16                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCRCZ01 ARU.EXMPL03A.BMCRCZ01                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCRCZ02 ARU.EXMPL03A.BMCRCZ02                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCRCZ03 ARU.EXMPL03A.BMCRCZ03                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCRCZ04 ARU.EXMPL03A.BMCRCZ04                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCRCZ05 ARU.EXMPL03A.BMCRCZ05                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCRCZ08 ARU.EXMPL03A.BMCRCZ08                        SYSALLDA                        144       14        3         1 TRK
BMC50448I BMCRCZ16 ARU.EXMPL03A.BMCRCZ16                        SYSALLDA                        144       14        3         1 TRK
BMC50448I SYSREC01 ARU.EXMPL03A.SYSREC01                        SYSALLDA                          1        1        1         1 TRK
BMC50448I SYSREC02 ARU.EXMPL03A.SYSREC02                        SYSALLDA                          1        1        1         1 TRK
BMC50448I SYSREC03 ARU.EXMPL03A.SYSREC03                        SYSALLDA                          1        1        1         1 TRK
BMC50448I SYSREC04 ARU.EXMPL03A.SYSREC04                        SYSALLDA                          1        1        1         1 TRK
BMC50448I SYSREC05 ARU.EXMPL03A.SYSREC05                        SYSALLDA                          1        1        1         1 TRK
BMC50448I SYSREC08 ARU.EXMPL03A.SYSREC08                        SYSALLDA                          1        1        1         1 TRK
BMC50448I SYSREC16 ARU.EXMPL03A.SYSREC16                        SYSALLDA                          1        1        1         1 TRK
BMC50448I SYSUT101 ARU.EXMPL03A.SYSUT101                        SYSALLDA                          1        1        1         1 TRK
BMC50448I SYSUT102 ARU.EXMPL03A.SYSUT102                        SYSALLDA 1        1        1         1 TRK
BMC50448I SYSREC05 ARU.EXMPL03A.SYSREC05                        SYSALLDA                          1        1        1         1 TRK
BMC50448I SYSREC08 ARU.EXMPL03A.SYSREC08                        SYSALLDA                          1        1        1         1 TRK
BMC50448I SYSREC16 ARU.EXMPL03A.SYSREC16                        SYSALLDA                          1        1        1         1 TRK
BMC50448I SYSUT101 ARU.EXMPL03A.SYSUT101                        SYSALLDA                          1        1        1         1 TRK
BMC50448I SYSUT102 ARU.EXMPL03A.SYSUT102                        SYSALLDA                          1        1        1         1 TRK

BMC50394I UNABLE TO LOCATE SORT WORK DATASETS, DDNAME = 'SORTWKNN'
BMC50509I STATISTICS COLLECTION FOR INDEX SPACE ARU.TS00712 BYPASSED DUE TO PARTIAL TABLE SPACE REORG
BMC50509I STATISTICS COLLECTION FOR INDEX SPACE ARU.TS00713 BYPASSED DUE TO PARTIAL TABLE SPACE REORG
BMC50474I BELOW 16M = 8068K, ABOVE 16M = 1009060K, CPUS = 5
BMC50479I TOTAL PAGES: 11315484, ALLOWED: 0; AVAILABLE PAGES: 2907501, ALLOWED: 2907501
BMC51302I MAX TASKS = 7, MAX PARTITIONS PER TASK = 1, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 1
BMC50486I 2: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 3: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50477I 2: PARTITION =    2, ROWS/KEYS = 10, I/O WAITS = 1 ,DDNAME = SYS00066
BMC51271I UNLOAD STATISTICS: 10 ROWS/KEYS UNLOADED FROM PARTITION 2
BMC51281I UNLOAD STATISTICS: X'0000000002B59238CC41' IS THE HIGHEST LOGRBA FOR PARTITION 2
BMC50481I 2: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50486I 4: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50477I 3: PARTITION =    3, ROWS/KEYS = 10, I/O WAITS = 1 ,DDNAME = SYS00069
BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50477I 4: PARTITION =    4, ROWS/KEYS = 10, I/O WAITS = 1 ,DDNAME = SYS00070
BMC51271I UNLOAD STATISTICS: 10 ROWS/KEYS UNLOADED FROM PARTITION 3
BMC51281I UNLOAD STATISTICS: X'0000000002B59238FD91' IS THE HIGHEST LOGRBA FOR PARTITION 3
BMC51271I UNLOAD STATISTICS: 10 ROWS/KEYS UNLOADED FROM PARTITION 4
BMC51281I UNLOAD STATISTICS: X'0000000002B592392D4B' IS THE HIGHEST LOGRBA FOR PARTITION 4
BMC50481I 3: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50481I 4: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50486I 7: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50477I 1: PARTITION =    1, ROWS/KEYS = 10, I/O WAITS = 1 ,DDNAME = SYS00074
BMC51271I UNLOAD STATISTICS: 10 ROWS/KEYS UNLOADED FROM PARTITION 1
BMC51281I UNLOAD STATISTICS: X'0000000002B592389DB0' IS THE HIGHEST LOGRBA FOR PARTITION 1
BMC50481I 1: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50486I 6: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50477I 7: PARTITION =   16, ROWS/KEYS = 10, I/O WAITS = 1 ,DDNAME = SYS00076
BMC51271I UNLOAD STATISTICS: 10 ROWS/KEYS UNLOADED FROM PARTITION 16
BMC51281I UNLOAD STATISTICS: X'0000000002B5923B696F' IS THE HIGHEST LOGRBA FOR PARTITION 16
BMC50481I 7: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50486I 5: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50477I 6: PARTITION =    8, ROWS/KEYS = 0, I/O WAITS = 1 ,DDNAME = SYS00078
BMC51271I UNLOAD STATISTICS: 0 ROWS/KEYS UNLOADED FROM PARTITION 8
BMC51281I UNLOAD STATISTICS: X'0000000002B592336DE5' IS THE HIGHEST LOGRBA FOR PARTITION 8
BMC50477I 5: PARTITION =    5, ROWS/KEYS = 0, I/O WAITS = 1 ,DDNAME = SYS00080
BMC51271I UNLOAD STATISTICS: 0 ROWS/KEYS UNLOADED FROM PARTITION 5
BMC51281I UNLOAD STATISTICS: X'0000000002B5923354B1' IS THE HIGHEST LOGRBA FOR PARTITION 5
BMC51272I UNLOAD STATISTICS: 50 ROWS UNLOADED FROM SPACE 'ARUDB007.TS007', 0 ROWS DISCARDED, 0 ROWS UPDATED
BMC51282I UNLOAD STATISTICS: X'0000000002B5923B696F' IS THE HIGHEST LOGRBA FOR SPACE 'ARUDB007.TS007'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A002'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A002'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A004'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A004'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A003'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A003'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A001'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A001'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A016'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A016'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A002'
BMC50482I 6: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.ARUDB007.TS00711.I0001.A008'
BMC50477I 6: PARTITION =    8, ROWS/KEYS = 0, I/O WAITS = 5 ,DDNAME = SYS00079
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A004'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A003'
BMC50482I 2: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.ARUDB007.TS00711.I0001.A002'
BMC50477I 2: PARTITION =    2, ROWS/KEYS = 10, I/O WAITS = 5 ,DDNAME = SYS00081
BMC50482I 2: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A002'
BMC50477I 2: PARTITION =    2, ROWS/KEYS = 10, I/O WAITS = 8 ,DDNAME = SYS00071
BMC51274I RELOAD STATISTICS: 10 ROWS/KEYS LOADED INTO PARTITION 2
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A001'
BMC50482I 5: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.ARUDB007.TS00711.I0001.A005'
BMC50477I 5: PARTITION =    5, ROWS/KEYS = 0, I/O WAITS = 5 ,DDNAME = SYS00082
BMC50476I DDNAME = BMCCPY02, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCCPZ02, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCY02, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCZ02, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPY02'
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPZ02'
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCY02'
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCZ02'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A016'
BMC50482I 4: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.ARUDB007.TS00711.I0001.A004'
BMC50477I 4: PARTITION =    4, ROWS/KEYS = 10, I/O WAITS = 5 ,DDNAME = SYS00083
BMC50482I 3: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.ARUDB007.TS00711.I0001.A003'
BMC50477I 3: PARTITION =    3, ROWS/KEYS = 10, I/O WAITS = 5 ,DDNAME = SYS00084
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.ARUDB007.TS00711.I0001.A001'
BMC50477I 1: PARTITION =    1, ROWS/KEYS = 10, I/O WAITS = 5 ,DDNAME = SYS00085
BMC50482I 3: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A003'
BMC50477I 3: PARTITION =    3, ROWS/KEYS = 10, I/O WAITS = 8 ,DDNAME = SYS00072
BMC50482I 4: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A004'
BMC50477I 4: PARTITION =    4, ROWS/KEYS = 10, I/O WAITS = 8 ,DDNAME = SYS00073
BMC51274I RELOAD STATISTICS: 10 ROWS/KEYS LOADED INTO PARTITION 3
BMC51274I RELOAD STATISTICS: 10 ROWS/KEYS LOADED INTO PARTITION 4
BMC50482I 1: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A001'
BMC50477I 1: PARTITION =    1, ROWS/KEYS = 10, I/O WAITS = 8 ,DDNAME = SYS00075
BMC51274I RELOAD STATISTICS: 10 ROWS/KEYS LOADED INTO PARTITION 1
BMC50481I 2: REORG TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC50476I DDNAME = BMCCPY03, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCCPZ03, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCY03, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCZ03, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPY03'
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPZ03'
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCY03'
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCZ03'
BMC50482I 7: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.ARUDB007.TS00711.I0001.A016'
BMC50477I 7: PARTITION =   16, ROWS/KEYS = 10, I/O WAITS = 5 ,DDNAME = SYS00086
BMC50482I 7: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A016'
BMC50477I 7: PARTITION =   16, ROWS/KEYS = 10, I/O WAITS = 8 ,DDNAME = SYS00077
BMC51274I RELOAD STATISTICS: 10 ROWS/KEYS LOADED INTO PARTITION 16
BMC50481I 3: REORG TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC50476I DDNAME = BMCCPY04, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCCPZ04, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCY04, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCZ04, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPY04'
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPZ04'
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCY04'
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCZ04'
BMC50481I 4: REORG TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A008'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A008'
BMC50482I 6: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A008'
BMC50477I 6: PARTITION =    8, ROWS/KEYS = 0, I/O WAITS = 5 ,DDNAME = SYS00087
BMC51274I RELOAD STATISTICS: 0 ROWS/KEYS LOADED INTO PARTITION 8
BMC50476I DDNAME = BMCCPY01, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCCPZ01, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCY01, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCZ01, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPY01'
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPZ01'
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCY01'
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCZ01'
BMC50481I 1: REORG TASK COMPLETE. ELAPSED TIME = 00:00:01
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A005'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A005'
BMC50476I DDNAME = BMCCPY16, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCCPZ16, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCY16, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCZ16, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPY16'
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPZ16'
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCY16'
BMC50376I 14 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCZ16'
BMC50482I 5: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A005'
BMC50477I 5: PARTITION =    5, ROWS/KEYS = 0, I/O WAITS = 5 ,DDNAME = SYS00088
BMC51274I RELOAD STATISTICS: 0 ROWS/KEYS LOADED INTO PARTITION 5
BMC50476I DDNAME = BMCCPY08, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCCPZ08, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCY08, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCZ08, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50376I 12 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPY08'
BMC50376I 12 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPZ08'
BMC50376I 12 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCY08'
BMC50376I 12 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCZ08'
BMC50481I 7: REORG TASK COMPLETE. ELAPSED TIME = 00:00:01
BMC50481I 6: REORG TASK COMPLETE. ELAPSED TIME = 00:00:01
BMC50476I DDNAME = BMCCPY05, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCCPZ05, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCY05, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCZ05, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50376I 12 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPY05'
BMC50376I 12 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCCPZ05'
BMC50376I 12 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCY05'
BMC50376I 12 PAGES COPIED TO DATASET = 'ARU.EXMPL03A.BMCRCZ05'
BMC50481I 5: REORG TASK COMPLETE. ELAPSED TIME = 00:00:01
BMC50476I DDNAME = SYSREC01, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC02, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC03, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC04, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC05, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC08, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC16, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSUT101, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSUT102, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC51276I BUILD STATISTICS: 50 KEYS LOADED INTO INDEX 'ARU.TS00711'
BMC51275I RELOAD STATISTICS: 50 ROWS LOADED INTO SPACE 'ARUDB007.TS007'
BMC50474I BELOW 16M = 7732K, ABOVE 16M = 1000620K, CPUS = 5
BMC50479I TOTAL PAGES: 11316541, ALLOWED: 0; AVAILABLE PAGES: 2910667, ALLOWED: 2910667
BMC51303I MAX TASKS = 2, INDEXES PER TASK = 1, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 2
BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 2: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50476I DDNAME = SYSUT101, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50481I 1: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50476I DDNAME = SYSUT102, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50481I 2: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50482I 1: UPDATE COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.ARUDB007.TS00712.I0001.A001'
BMC50477I 1: PARTITION =    0, ROWS/KEYS = 50, I/O WAITS = 4 ,DDNAME = SYS00091
BMC51277I BUILD STATISTICS: 50 KEY-RID PAIRS UPDATED IN INDEX 'ARU.TS00712'
BMC50482I 2: UPDATE COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.ARUDB007.TS00713.I0001.A001'
BMC50477I 2: PARTITION =    0, ROWS/KEYS = 50, I/O WAITS = 4 ,DDNAME = SYS00092
BMC51277I BUILD STATISTICS: 50 KEY-RID PAIRS UPDATED IN INDEX 'ARU.TS00713'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT102', DSNAME = 'ARU.EXMPL03A.SYSUT102'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT101', DSNAME = 'ARU.EXMPL03A.SYSUT101'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC16', DSNAME = 'ARU.EXMPL03A.SYSREC16'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC08', DSNAME = 'ARU.EXMPL03A.SYSREC08'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC05', DSNAME = 'ARU.EXMPL03A.SYSREC05'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC04', DSNAME = 'ARU.EXMPL03A.SYSREC04'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC03', DSNAME = 'ARU.EXMPL03A.SYSREC03'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC02', DSNAME = 'ARU.EXMPL03A.SYSREC02'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSREC01', DSNAME = 'ARU.EXMPL03A.SYSREC01'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I REORG PHASE COMPLETE. ELAPSED TIME = 00:00:05

BMC278098I AGGREGATE STATISTICS NOT PRODUCED FOR INDEX ARU.TS00711
BMC278098I AGGREGATE STATISTICS NOT PRODUCED FOR TABLESPACE ARUDB007.TS007
BMC278098I AGGREGATE STATISTICS NOT PRODUCED FOR TABLE ARU.TS0071
BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR REORG UTILITY SUCCESSFUL FOR ALL OBJECTS
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0

ASUSRPT for example 2, case 1

The following figure shows the ASUSRPT output for case 1 of example 2:

1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-1-29-02.05.39.275899                                          1
0

   INDEXPART ----------- ARU.TS00711 PART 001
     ASSOCIATIONS
       TABLESPACE ------ ARUDB007.TS007
       TABLE ----------- ARU.TS0071
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N UTILCODE---------------------R LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------1 SQTY------------------------15 PCTFREE---------------------15 FREEPAGE---------------------9
       ALLOCUNIT--------------------T STORTYPE---------------------I NLAVGKEYLEN-----------------34 RBA_FORMAT------------EXTENDED
       PAGENUM----------------------A DSSIZE-----------------------0 VCATNAME---------------DEMOCAT STORNAME--------------DEMOCAT
     STATISTICS
       FIRSTKEYCARD----------------10 FULLKEYCARD-----------------10 CARD------------------------10 NACTIVE----------------------5
       CLUSTERRATIO---------------100 NUMNONLEAF-------------------1 NLEVELS----------------------2 FAROFFPOS--------------------0
       NEAROFFPOS-------------------0 LEAFDIST---------------------0 NLEAF------------------------1 FREE-------------------------7
       FULL-------------------------0 AVGKEYLEN-------------------25
       LEAFNEAR---------------------0 LEAFFAR----------------------0 PSEUDO_DEL_RIDS--------------0 REORGSPACE-------------------1
       REORGSPACE_KB---------------48 REORGNLEVELS-----------------2 PCTUSED--------------------100 PQTYROWS-------------------832
       DATAREPEAT-------------------1
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------1 SPACE_KB--------------------48 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT054

   INDEXPART ----------- ARU.TS00711 PART 002
     ASSOCIATIONS
       TABLESPACE ------ ARUDB007.TS007
       TABLE ----------- ARU.TS0071
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N UTILCODE---------------------R LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------1 SQTY------------------------15 PCTFREE---------------------15 FREEPAGE---------------------9
       ALLOCUNIT--------------------T STORTYPE---------------------I NLAVGKEYLEN-----------------34 RBA_FORMAT------------EXTENDED
       PAGENUM----------------------A DSSIZE-----------------------0 VCATNAME---------------DEMOCAT STORNAME--------------DEMOCAT
     STATISTICS
       FIRSTKEYCARD----------------10 FULLKEYCARD-----------------10 CARD------------------------10 NACTIVE----------------------5
       CLUSTERRATIO---------------100 NUMNONLEAF-------------------1 NLEVELS----------------------2 FAROFFPOS--------------------0
       NEAROFFPOS-------------------0 LEAFDIST---------------------0 NLEAF------------------------1 FREE-------------------------7
       FULL-------------------------0 AVGKEYLEN-------------------36
       LEAFNEAR---------------------0 LEAFFAR----------------------0 PSEUDO_DEL_RIDS--------------0 REORGSPACE-------------------1
       REORGSPACE_KB---------------48 REORGNLEVELS-----------------2 PCTUSED--------------------100 PQTYROWS-------------------624
       DATAREPEAT-------------------1
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------1 SPACE_KB--------------------48 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT049

   INDEXPART ----------- ARU.TS00711 PART 003
     ASSOCIATIONS
       TABLESPACE ------ ARUDB007.TS007
       TABLE ----------- ARU.TS0071
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N UTILCODE---------------------R LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------1 SQTY------------------------15 PCTFREE---------------------15 FREEPAGE---------------------9
       ALLOCUNIT--------------------T STORTYPE---------------------I NLAVGKEYLEN-----------------34 RBA_FORMAT------------EXTENDED
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-29-02.05.39.275899                                          2
0
       PAGENUM----------------------A DSSIZE-----------------------0 VCATNAME---------------DEMOCAT STORNAME--------------DEMOCAT
     STATISTICS
       FIRSTKEYCARD----------------10 FULLKEYCARD-----------------10 CARD------------------------10 NACTIVE----------------------5
       CLUSTERRATIO---------------100 NUMNONLEAF-------------------1 NLEVELS----------------------2 FAROFFPOS--------------------0
       NEAROFFPOS-------------------0 LEAFDIST---------------------0 NLEAF------------------------1 FREE-------------------------7
       FULL-------------------------0 AVGKEYLEN-------------------36
       LEAFNEAR---------------------0 LEAFFAR----------------------0 PSEUDO_DEL_RIDS--------------0 REORGSPACE-------------------1
       REORGSPACE_KB---------------48 REORGNLEVELS-----------------2 PCTUSED--------------------100 PQTYROWS-------------------624
       DATAREPEAT-------------------1
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------1 SPACE_KB--------------------48 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT024

   INDEXPART ----------- ARU.TS00711 PART 004
     ASSOCIATIONS
       TABLESPACE ------ ARUDB007.TS007
       TABLE ----------- ARU.TS0071
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N UTILCODE---------------------R LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------1 SQTY------------------------15 PCTFREE---------------------15 FREEPAGE---------------------9
       ALLOCUNIT--------------------T STORTYPE---------------------I NLAVGKEYLEN-----------------34 RBA_FORMAT------------EXTENDED
       PAGENUM----------------------A DSSIZE-----------------------0 VCATNAME---------------DEMOCAT STORNAME--------------DEMOCAT
     STATISTICS
       FIRSTKEYCARD----------------10 FULLKEYCARD-----------------10 CARD------------------------10 NACTIVE----------------------5
       CLUSTERRATIO---------------100 NUMNONLEAF-------------------1 NLEVELS----------------------2 FAROFFPOS--------------------0
       NEAROFFPOS-------------------0 LEAFDIST---------------------0 NLEAF------------------------1 FREE-------------------------7
       FULL-------------------------0 AVGKEYLEN-------------------25
       LEAFNEAR---------------------0 LEAFFAR----------------------0 PSEUDO_DEL_RIDS--------------0 REORGSPACE-------------------1
       REORGSPACE_KB---------------48 REORGNLEVELS-----------------2 PCTUSED--------------------100 PQTYROWS-------------------832
       DATAREPEAT-------------------1
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------1 SPACE_KB--------------------48 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT097

   INDEXPART ----------- ARU.TS00711 PART 005
     ASSOCIATIONS
   TABLESPACE ------ ARUDB007.TS007
       TABLE ----------- ARU.TS0071
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N UTILCODE---------------------R LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------1 SQTY------------------------15 PCTFREE---------------------15 FREEPAGE---------------------9
       ALLOCUNIT--------------------T STORTYPE---------------------I NLAVGKEYLEN------------------0 RBA_FORMAT------------EXTENDED
       PAGENUM----------------------A DSSIZE-----------------------0 VCATNAME---------------DEMOCAT STORNAME--------------DEMOCAT
     STATISTICS
       FIRSTKEYCARD-----------------0 FULLKEYCARD------------------0 CARD-------------------------0 NACTIVE----------------------5
       CLUSTERRATIO-----------------0 NUMNONLEAF-------------------1 NLEVELS----------------------2 FAROFFPOS--------------------0
       NEAROFFPOS-------------------0 LEAFDIST---------------------0 NLEAF------------------------0 FREE-------------------------3
       FULL-------------------------0 AVGKEYLEN--------------------0
       LEAFNEAR---------------------0 LEAFFAR----------------------0 PSEUDO_DEL_RIDS--------------0 REORGSPACE-------------------1
       REORGSPACE_KB---------------48 REORGNLEVELS-----------------2 PCTUSED--------------------100 PQTYROWS-------------------654
       DATAREPEAT-------------------0
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------1 SPACE_KB--------------------48 NUMDATASETS------------------1
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-29-02.05.39.275899                                          3
0
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT130

   INDEXPART ----------- ARU.TS00711 PART 008
     ASSOCIATIONS
       TABLESPACE ------ ARUDB007.TS007
       TABLE ----------- ARU.TS0071
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N UTILCODE---------------------R LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------1 SQTY------------------------15 PCTFREE---------------------15 FREEPAGE---------------------9
       ALLOCUNIT--------------------T STORTYPE---------------------I NLAVGKEYLEN------------------0 RBA_FORMAT------------EXTENDED
       PAGENUM----------------------A DSSIZE-----------------------0 VCATNAME---------------DEMOCAT STORNAME--------------DEMOCAT
     STATISTICS
       FIRSTKEYCARD-----------------0 FULLKEYCARD------------------0 CARD-------------------------0 NACTIVE----------------------5
       CLUSTERRATIO-----------------0 NUMNONLEAF-------------------1 NLEVELS----------------------2 FAROFFPOS--------------------0
       NEAROFFPOS-------------------0 LEAFDIST---------------------0 NLEAF------------------------0 FREE-------------------------3
       FULL-------------------------0 AVGKEYLEN--------------------0
       LEAFNEAR---------------------0 LEAFFAR----------------------0 PSEUDO_DEL_RIDS--------------0 REORGSPACE-------------------1
       REORGSPACE_KB---------------48 REORGNLEVELS-----------------2 PCTUSED--------------------100 PQTYROWS-------------------654
       DATAREPEAT-------------------0
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------1 SPACE_KB--------------------48 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT007

   INDEXPART ----------- ARU.TS00711 PART 016
     ASSOCIATIONS
       TABLESPACE ------ ARUDB007.TS007
       TABLE ----------- ARU.TS0071
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N UTILCODE---------------------R LOCATION----------------(NULL)
       SAMPLING---------------------N
ATTRIBUTES
       PQTY-------------------------1 SQTY------------------------15 PCTFREE---------------------15 FREEPAGE---------------------9
       ALLOCUNIT--------------------T STORTYPE---------------------I NLAVGKEYLEN-----------------34 RBA_FORMAT------------EXTENDED
       PAGENUM----------------------A DSSIZE-----------------------0 VCATNAME---------------DEMOCAT STORNAME--------------DEMOCAT
     STATISTICS
       FIRSTKEYCARD----------------10 FULLKEYCARD-----------------10 CARD------------------------10 NACTIVE----------------------5
       CLUSTERRATIO---------------100 NUMNONLEAF-------------------1 NLEVELS----------------------2 FAROFFPOS--------------------0
       NEAROFFPOS-------------------0 LEAFDIST---------------------0 NLEAF------------------------1 FREE-------------------------7
       FULL-------------------------0 AVGKEYLEN-------------------25
       LEAFNEAR---------------------0 LEAFFAR----------------------0 PSEUDO_DEL_RIDS--------------0 REORGSPACE-------------------1
       REORGSPACE_KB---------------48 REORGNLEVELS-----------------2 PCTUSED--------------------100 PQTYROWS-------------------832
       DATAREPEAT-------------------1
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------1 SPACE_KB--------------------48 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT052

   COLUMN -------------- EMPHIREDATE PART 001
     ATTRIBUTES
       COLNO------------------------6 COLTYPE-------------------DATE LENGTH-----------------------4 NULLS------------------------Y
       SCALE------------------------0
     STATISTICS
       COLCARD---------------------10 COLNULLS---------------------0 COLAVG-----------------------5 COLMIN-----------------------5
       COLMAX-----------------------5
       HIGH2K-----------X'0019890129' HIGH2K (CHAR)------------..i.. LOW2K------------X'0019890122' LOW2K (CHAR)-------------..i..
       HIGHK------------X'0019890130' HIGHK (CHAR)-------------..i.. LOWK-------------X'0019890121' LOWK (CHAR)--------------..i..
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-29-02.05.39.275899                                          4
0

       MOST FREQUENT VALUES
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890130'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890129'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890128'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890127'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890126'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890125'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890124'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890123'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890122'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890121'
                                       (CHAR)-------------------..i..

   KEYCARD ------------- EMPHIREDATE PART 001
       ATTRIBUTES AND STATISTICS
       COLUMN-------------EMPHIREDATE COLCARD---------------------10 COLTYPE-------------------DATE LENGTH-----------------------4
       COLUMN-------------------EMPNO COLCARD---------------------10 COLTYPE-------------------CHAR LENGTH-----------------------9
       COLUMN-------------EMPDEPTNAME COLCARD---------------------10 COLTYPE----------------VARCHAR LENGTH----------------------18

   COLUMN -------------- EMPHIREDATE PART 002
     ATTRIBUTES
       COLNO------------------------6 COLTYPE-------------------DATE LENGTH-----------------------4 NULLS------------------------Y
       SCALE------------------------0
     STATISTICS
       COLCARD---------------------10 COLNULLS---------------------0 COLAVG-----------------------5 COLMIN-----------------------5
       COLMAX-----------------------5
       HIGH2K-----------X'0019890227' HIGH2K (CHAR)------------..i.. LOW2K------------X'0019890220' LOW2K (CHAR)-------------..i..
       HIGHK------------X'0019890228' HIGHK (CHAR)-------------..i.. LOWK-------------X'0019890219' LOWK (CHAR)--------------..i..

       MOST FREQUENT VALUES
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890228'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890227'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890226'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890225'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890224'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890223'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890222'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890221'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890220'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890219'
                                       (CHAR)-------------------..i..
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-29-02.05.39.275899                                          5
0

   KEYCARD ------------- EMPHIREDATE PART 002
     ATTRIBUTES AND STATISTICS
       COLUMN-------------EMPHIREDATE COLCARD---------------------10 COLTYPE-------------------DATE LENGTH-----------------------4
       COLUMN-------------------EMPNO COLCARD---------------------10 COLTYPE-------------------CHAR LENGTH-----------------------9
       COLUMN-------------EMPDEPTNAME COLCARD---------------------10 COLTYPE----------------VARCHAR LENGTH----------------------18

   COLUMN -------------- EMPHIREDATE PART 003
     ATTRIBUTES
       COLNO------------------------6 COLTYPE-------------------DATE LENGTH-----------------------4 NULLS------------------------Y
       SCALE------------------------0
     STATISTICS
       COLCARD---------------------10 COLNULLS---------------------0 COLAVG-----------------------5 COLMIN-----------------------5
       COLMAX-----------------------5
       HIGH2K-----------X'0019890330' HIGH2K (CHAR)------------..i.. LOW2K------------X'0019890323' LOW2K (CHAR)-------------..i..
       HIGHK------------X'0019890331' HIGHK (CHAR)-------------..i.. LOWK-------------X'0019890322' LOWK (CHAR)--------------..i..
       MOST FREQUENT VALUES
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890331'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890330'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890329'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890328'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890327'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890326'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890325'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890324'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890323'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890322'
                                       (CHAR)-------------------..i..

   KEYCARD ------------- EMPHIREDATE PART 003
     ATTRIBUTES AND STATISTICS
       COLUMN-------------EMPHIREDATE COLCARD---------------------10 COLTYPE-------------------DATE LENGTH-----------------------4
       COLUMN-------------------EMPNO COLCARD---------------------10 COLTYPE-------------------CHAR LENGTH-----------------------9
       COLUMN-------------EMPDEPTNAME COLCARD---------------------10 COLTYPE----------------VARCHAR LENGTH----------------------18

   COLUMN -------------- EMPHIREDATE PART 004
     ATTRIBUTES
       COLNO------------------------6 COLTYPE-------------------DATE LENGTH-----------------------4 NULLS------------------------Y
       SCALE------------------------0
     STATISTICS
       COLCARD---------------------10 COLNULLS---------------------0 COLAVG-----------------------5 COLMIN-----------------------5
       COLMAX-----------------------5
       HIGH2K-----------X'0019890429' HIGH2K (CHAR)------------..i.. LOW2K------------X'0019890422' LOW2K (CHAR)-------------..i..
       HIGHK------------X'0019890430' HIGHK (CHAR)-------------..i.. LOWK-------------X'0019890421' LOWK (CHAR)--------------..i..
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-29-02.05.39.275899                                          6
0

       MOST FREQUENT VALUES
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890430'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890429'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890428'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890427'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890426'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890425'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890424'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890423'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890422'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890421'
                                       (CHAR)-------------------..i..

   KEYCARD ------------- EMPHIREDATE PART 004
     ATTRIBUTES AND STATISTICS
       COLUMN-------------EMPHIREDATE COLCARD---------------------10 COLTYPE-------------------DATE LENGTH-----------------------4
       COLUMN-------------------EMPNO COLCARD---------------------10 COLTYPE-------------------CHAR LENGTH-----------------------9
       COLUMN-------------EMPDEPTNAME COLCARD---------------------10 COLTYPE----------------VARCHAR LENGTH----------------------18

   COLUMN -------------- EMPHIREDATE PART 005
     ATTRIBUTES
       COLNO------------------------6 COLTYPE-------------------DATE LENGTH-----------------------4 NULLS------------------------Y
       SCALE------------------------0
     STATISTICS
       COLCARD----------------------0 COLNULLS---------------------0 COLAVG-----------------------5 COLMIN-----------------------5
       COLMAX-----------------------5
       HIGH2K---------------------X'' HIGH2K (CHAR)-----------(NULL) LOW2K----------------------X'' LOW2K (CHAR)------------(NULL)
       HIGHK----------------------X'' HIGHK (CHAR)------------(NULL) LOWK-----------------------X'' LOWK (CHAR)-------------(NULL)


   KEYCARD ------------- EMPHIREDATE PART 005
     ATTRIBUTES AND STATISTICS
       COLUMN-------------EMPHIREDATE COLCARD----------------------0 COLTYPE-------------------DATE LENGTH-----------------------4
       COLUMN-------------------EMPNO COLCARD----------------------0 COLTYPE-------------------CHAR LENGTH-----------------------9
       COLUMN-------------EMPDEPTNAME COLCARD----------------------0 COLTYPE----------------VARCHAR LENGTH----------------------18

   COLUMN -------------- EMPHIREDATE PART 008
     ATTRIBUTES
       COLNO------------------------6 COLTYPE-------------------DATE LENGTH-----------------------4 NULLS------------------------Y
       SCALE------------------------0
     STATISTICS
       COLCARD----------------------0 COLNULLS---------------------0 COLAVG-----------------------5 COLMIN-----------------------5
       COLMAX-----------------------5
       HIGH2K---------------------X'' HIGH2K (CHAR)-----------(NULL) LOW2K----------------------X'' LOW2K (CHAR)------------(NULL)
       HIGHK----------------------X'' HIGHK (CHAR)------------(NULL) LOWK-----------------------X'' LOWK (CHAR)-------------(NULL)


1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-1-29-02.05.39.275899                                          7
0
   KEYCARD ------------- EMPHIREDATE PART 008
     ATTRIBUTES AND STATISTICS
       COLUMN-------------EMPHIREDATE COLCARD----------------------0 COLTYPE-------------------DATE LENGTH-----------------------4
       COLUMN-------------------EMPNO COLCARD----------------------0 COLTYPE-------------------CHAR LENGTH-----------------------9
       COLUMN-------------EMPDEPTNAME COLCARD----------------------0 COLTYPE----------------VARCHAR LENGTH----------------------18

   COLUMN -------------- EMPHIREDATE PART 016
     ATTRIBUTES
       COLNO------------------------6 COLTYPE-------------------DATE LENGTH-----------------------4 NULLS------------------------Y
       SCALE------------------------0
     STATISTICS
       COLCARD---------------------10 COLNULLS---------------------0 COLAVG-----------------------5 COLMIN-----------------------5
       COLMAX-----------------------5
       HIGH2K-----------X'0019900429' HIGH2K (CHAR)------------..... LOW2K------------X'0019900422' LOW2K (CHAR)-------------.....
       HIGHK------------X'0019900430' HIGHK (CHAR)-------------..... LOWK-------------X'0019900421' LOWK (CHAR)--------------.....

       MOST FREQUENT VALUES
       FREQUENCY-------------0.100000 COLVAL-----------X'0019900430'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.100000 COLVAL-----------X'0019900429'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.100000 COLVAL-----------X'0019900428'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.100000 COLVAL-----------X'0019900427'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.100000 COLVAL-----------X'0019900426'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.100000 COLVAL-----------X'0019900425'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.100000 COLVAL-----------X'0019900424'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.100000 COLVAL-----------X'0019900423'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.100000 COLVAL-----------X'0019900422'
                                       (CHAR)-------------------.....
       FREQUENCY-------------0.100000 COLVAL-----------X'0019900421'
                                       (CHAR)-------------------.....

   KEYCARD ------------- EMPHIREDATE PART 016
     ATTRIBUTES AND STATISTICS
       COLUMN-------------EMPHIREDATE COLCARD---------------------10 COLTYPE-------------------DATE LENGTH-----------------------4
       COLUMN-------------------EMPNO COLCARD---------------------10 COLTYPE-------------------CHAR LENGTH-----------------------9
       COLUMN-------------EMPDEPTNAME COLCARD---------------------10 COLTYPE----------------VARCHAR LENGTH----------------------18
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-29-02.05.39.275899                                          1
0

   TABLEPART ----------- ARUDB007.TS007    PART 001
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N LOCATION----------------(NULL) UTILCODE---------------------R
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------3 SQTY------------------------15 PCTFREE----------------------0 FREEPAGE---------------------0
       ALLOCUNIT--------------------T STORTYPE---------------------I COMPRESS---------------(BLANK) TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF RBA_FORMAT------------EXTENDED TYPE-------------------------R PAGENUM----------------------A
       DSSIZE-----------------4194304 PGSIZE-----------------------4 BPOOL----------------------BP0 MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT STORNAME--------------ARULARSG
     STATISTICS
       CARD------------------------10 NACTIVE---------------------11 NPAGES-----------------------1 ROWAVG---------------------118
       ROWMAXFOUND----------------118 ROWMINFOUND----------------118 AVGNONCOMPROWLEN----------(-1) DIRTY------------------------0
       FULL-------------------------0 FARINDREF--------------------0 NEARINDREF-------------------0 PERCACTIVE-------------------2
       PCTPAGES---------------------9 PERCDROP---------------------0 REORGSPACE-------------------1 REORGSPACE_KB---------------48
       PCTUSED---------------------33 PQTYROWS------------------1056
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------3 SPACE_KB-------------------144 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT022

   TABLEPART ----------- ARUDB007.TS007    PART 002
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N LOCATION----------------(NULL) UTILCODE---------------------R
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------3 SQTY------------------------15 PCTFREE----------------------0 FREEPAGE---------------------0
       ALLOCUNIT--------------------T STORTYPE---------------------I COMPRESS---------------(BLANK) TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF RBA_FORMAT------------EXTENDED TYPE-------------------------R PAGENUM----------------------A
       DSSIZE-----------------4194304 PGSIZE-----------------------4 BPOOL----------------------BP0 MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT STORNAME--------------ARULARSG
     STATISTICS
       CARD------------------------10 NACTIVE---------------------11 NPAGES-----------------------1 ROWAVG---------------------139
       ROWMAXFOUND----------------139 ROWMINFOUND----------------139 AVGNONCOMPROWLEN----------(-1) DIRTY------------------------0
       FULL-------------------------0 FARINDREF--------------------0 NEARINDREF-------------------0 PERCACTIVE-------------------3
       PCTPAGES---------------------9 PERCDROP---------------------0 REORGSPACE-------------------1 REORGSPACE_KB---------------48
       PCTUSED---------------------33 PQTYROWS-------------------896
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------3 SPACE_KB-------------------144 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT007

   TABLEPART ----------- ARUDB007.TS007    PART 003
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N LOCATION----------------(NULL) UTILCODE---------------------R
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------3 SQTY------------------------15 PCTFREE----------------------0 FREEPAGE---------------------0
       ALLOCUNIT--------------------T STORTYPE---------------------I COMPRESS---------------(BLANK) TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF RBA_FORMAT------------EXTENDED TYPE-------------------------R PAGENUM----------------------A
       DSSIZE-----------------4194304 PGSIZE-----------------------4 BPOOL----------------------BP0 MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT STORNAME--------------ARULARSG
     STATISTICS
       CARD------------------------10 NACTIVE---------------------11 NPAGES-----------------------1 ROWAVG---------------------165
       ROWMAXFOUND----------------165 ROWMINFOUND----------------165 AVGNONCOMPROWLEN----------(-1) DIRTY------------------------0
       FULL-------------------------0 FARINDREF--------------------0 NEARINDREF-------------------0 PERCACTIVE-------------------3
       PCTPAGES---------------------9 PERCDROP---------------------0 REORGSPACE-------------------1 REORGSPACE_KB---------------48
       PCTUSED---------------------33 PQTYROWS-------------------768
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-29-02.05.39.275899                                          2
0
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------3 SPACE_KB-------------------144 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT027

   TABLEPART ----------- ARUDB007.TS007    PART 004
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N LOCATION----------------(NULL) UTILCODE---------------------R
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------3 SQTY------------------------15 PCTFREE----------------------0 FREEPAGE---------------------0
       ALLOCUNIT--------------------T STORTYPE---------------------I COMPRESS---------------(BLANK) TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF RBA_FORMAT------------EXTENDED TYPE-------------------------R PAGENUM----------------------A
       DSSIZE-----------------4194304 PGSIZE-----------------------4 BPOOL----------------------BP0 MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT STORNAME--------------ARULARSG
     STATISTICS
       CARD------------------------10 NACTIVE---------------------11 NPAGES-----------------------1 ROWAVG---------------------118
       ROWMAXFOUND----------------118 ROWMINFOUND----------------118 AVGNONCOMPROWLEN----------(-1) DIRTY------------------------0
       FULL-------------------------0 FARINDREF--------------------0 NEARINDREF-------------------0 PERCACTIVE-------------------2
       PCTPAGES---------------------9 PERCDROP---------------------0 REORGSPACE-------------------1 REORGSPACE_KB---------------48
       PCTUSED---------------------33 PQTYROWS------------------1056
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------3 SPACE_KB-------------------144 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT009

   TABLEPART ----------- ARUDB007.TS007    PART 005
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N LOCATION----------------(NULL) UTILCODE---------------------R
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------3 SQTY------------------------15 PCTFREE----------------------0 FREEPAGE---------------------0
       ALLOCUNIT--------------------T STORTYPE---------------------I COMPRESS---------------(BLANK) TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF RBA_FORMAT------------EXTENDED TYPE-------------------------R PAGENUM----------------------A
       DSSIZE-----------------4194304 PGSIZE-----------------------4 BPOOL----------------------BP0 MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT STORNAME--------------ARULARSG
     STATISTICS
       CARD-------------------------0 NACTIVE---------------------10 NPAGES-----------------------0 ROWAVG-----------------------0
       ROWMAXFOUND------------------0 ROWMINFOUND------------------0 AVGNONCOMPROWLEN----------(-1) DIRTY------------------------0
       FULL-------------------------0 FARINDREF--------------------0 NEARINDREF-------------------0 PERCACTIVE-------------------0
       PCTPAGES---------------------0 PERCDROP---------------------0 REORGSPACE-------------------1 REORGSPACE_KB---------------48
       PCTUSED---------------------33 PQTYROWS---------------------0
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------3 SPACE_KB-------------------144 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT001

   TABLEPART ----------- ARUDB007.TS007    PART 008
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N LOCATION----------------(NULL) UTILCODE---------------------R
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------3 SQTY------------------------15 PCTFREE----------------------0 FREEPAGE---------------------0
       ALLOCUNIT--------------------T STORTYPE---------------------I COMPRESS---------------(BLANK) TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF RBA_FORMAT------------EXTENDED TYPE-------------------------R PAGENUM----------------------A
       DSSIZE-----------------4194304 PGSIZE-----------------------4 BPOOL----------------------BP0 MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT STORNAME--------------ARULARSG
     STATISTICS
       CARD-------------------------0 NACTIVE---------------------10 NPAGES-----------------------0 ROWAVG-----------------------0
       ROWMAXFOUND------------------0 ROWMINFOUND------------------0 AVGNONCOMPROWLEN----------(-1) DIRTY------------------------0
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-29-02.05.39.275899                                          3
0
       FULL-------------------------0 FARINDREF--------------------0 NEARINDREF-------------------0 PERCACTIVE-------------------0
       PCTPAGES---------------------0 PERCDROP---------------------0 REORGSPACE-------------------1 REORGSPACE_KB---------------48
       PCTUSED---------------------33 PQTYROWS---------------------0
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------3 SPACE_KB-------------------144 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT035

   TABLEPART ----------- ARUDB007.TS007    PART 016
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N LOCATION----------------(NULL) UTILCODE---------------------R
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------3 SQTY------------------------15 PCTFREE----------------------0 FREEPAGE---------------------0
       ALLOCUNIT--------------------T STORTYPE---------------------I COMPRESS---------------(BLANK) TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF RBA_FORMAT------------EXTENDED TYPE-------------------------R PAGENUM----------------------A
       DSSIZE-----------------4194304 PGSIZE-----------------------4 BPOOL----------------------BP0 MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT STORNAME--------------ARULARSG
     STATISTICS
       CARD------------------------10 NACTIVE---------------------11 NPAGES-----------------------1 ROWAVG---------------------118
       ROWMAXFOUND----------------118 ROWMINFOUND----------------118 AVGNONCOMPROWLEN----------(-1) DIRTY------------------------0
       FULL-------------------------0 FARINDREF--------------------0 NEARINDREF-------------------0 PERCACTIVE-------------------2
       PCTPAGES---------------------9 PERCDROP---------------------0 REORGSPACE-------------------1 REORGSPACE_KB---------------48
       PCTUSED---------------------33 PQTYROWS------------------1056
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------3 SPACE_KB-------------------144 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT117

SYSPRINT for example 2, case 2

The following figure shows the SYSPRINT output for case 2 of example 2:

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/29/2022    2:12:33 ...
BMC50002I UTILITY ID = 'EXMPL02B'. DB2 SUBSYSTEM ID = 'DEMO'. OPTION MODULE = 'ARU$OPT2'.
BMC50471I z/OS 2.4.0,PID=HBB77C0,DFSMS FOR Z/OS=2.4.0,DB2=13.1.501
BMC50471I REGION=0M,BELOW 16M=8800K,ABOVE 16M=1025760K,IEFUSI=NO,CPUs=7,GPs=5,zIIPs=2
BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040247M,MEMLIMIT SET BY:REGION=0
BMC50471I SMFID=DB2B,JOBID=J0709301,JOB=EXMPL02B,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%                           ICDDN=(BMCICY,BMCICZ)                   SCPYMAX=8
BMC50471I ARC=NO                                  ICTYPE=AUTO                             SDUMP=YES
BMC50471I ARCHDDN=SYSARC                          IDCACHE=10000                           SHORTMEMORY=CONTINUE
BMC50471I ARCHFORMAT=BMC                          INDREFLM=10                             SIXSNAP=NO
BMC50471I AVAILPAGEPCT=100                        INLINECP=YES                            SMAX=0
BMC50471I BILDMAX=300%                            INVALIDATECACHE=YES                     SMCORE=(0K,0K)
BMC50471I BMCHIST=YES                             KEEPDICTIONARY=NO                       SORTDEVT=(,SYSALLDA)
BMC50471I CBUFFS=30                               LEAFDSLM=200                            SORTNUM=32
BMC50471I CONDEXEC=NO                             LOCKROW=YES                             SPILDCLS=NONE
BMC50471I COPYDDN=(BMCCPY,BMCCPZ)                 LOGFINAL=NONE                           SPILDSNP=&UID
BMC50471I COPYLVL=PART                            LOGMEM=0                                SPILSCLS=NONE
BMC50471I COPYMAX=1000%                           LOGSPIL=(20000,10000)                   SPILUNIT=WORK
BMC50471I COPYSUBSET=YES                          LOGTHRSH=0                              SQLDELAY=3
BMC50471I CPYRFAIL=TERM                           LONGLOG=CONTINUE                        SQLRETRY=100
BMC50471I DATACAP=NO                              LONGNAMETRUNC=MIDDLE                    SSREPORT=REPORT_SWITCH
BMC50471I DDLDDN=DDLIN                            MAPTEXIT=(NONE,REXX)                    STAGEDSN=BMC
BMC50471I DEADLINE=NONE                           MAXNEWPARTS=2                           STOP@CMT=YES
BMC50471I DELAY=1200                              MAXRO=300                               STOPDELAY=1
BMC50471I DELFILES=YES                            MAXSORTMEMORY=0                         STOPRETRY=300
BMC50471I DESCCDE=(3,7)                           MAXTAPE=3                               TAPEDISP=DELETE
BMC50471I DRAINTYP=ALL                            MGEXTENT=CONTINUE                       TASKMAX=1000%
BMC50471I DRNDELAY=1                              MINSORTMEMORY=0                         TERMEXIT=(NONE,REXX)
BMC50471I DRNRETRY=255                            MSGLEVEL=1                              TIMEOUT=TERM
BMC50471I DRNWAIT=NONE                            OFFPOSLM=10                             TOTALPAGEPCT=0
BMC50471I DSNUEXIT=(NONE,ASM)                     OPNDB2ID=YES                            TSSAMPLEPCT=100
BMC50471I DSNUTILB=YES                            ORIGDISP=DELETE                         UBUFFS=20
BMC50471I DSPLOCKS=DRNFAIL                        PREFORMAT=NO                            UNLDDN=SYSREC
BMC50471I DSRSEXIT=(NONE,REXX)                    RCVICDDN=(BMCIRY,BMCIRZ)                UNLDMAX=300%
BMC50471I EXCLDUMP=(X37,X22,X06)                  RCVYDDN=(BMCRCY,BMCRCZ)                 UNLOAD=RELOAD
BMC50471I FASTSWITCH=NO                           REDEFINE=YES                            UXSTATE=SUP
BMC50471I FILECHK=WARN                            RENMMAX=30                              WBUFFS=(20,10)
BMC50471I FORCE_AT=(START,3)                      RIDMDSSZ=2097152                        WORKDDN=SYSUT1
BMC50471I FORCE_RPT=NO                            RIDMMAXD=1                              WORKUNIT=SYSALLDA
BMC50471I FORCE=NONE                              RMAPMEM=0                               WRLOG=NO
BMC50471I FSFALLBACK=NO                           RORGMAX=300%                            XBMID=
BMC50471I FSTHRESHOLD=0                           ROUTCDE=(11,1)                          ZIIP=ENABLED
0
BMC50471I PLAN=ARU1310D
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)                            (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   = 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..F&PART..T&TIME
BMC50483I LOCBLCPY   DSNPAT=&UID.&DDNAME.&TSIX..F&PART..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..F&PART..T&TIME
BMC50483I REMBLCPY   DSNPAT=&UID.&DDNAME.&TSIX..F&PART..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 ARUDB007.TS007 PART 1:5
BMC50102I       SHRLEVEL REFERENCE
BMC50102I       COPY YES
BMC50102I       COPYLVL FULL
BMC50102I       BMCSTATS YES
BMC50102I       DDTYPE WORK
BMC50102I         DSNPAT 'ARU.EXMPL02B.&DDNAME'
BMC50102I       DDTYPE LOCPFCPY
BMC50102I         DSNPAT 'ARU.EXMPL02B.&DDNAME'
BMC50102I       DDTYPE LOCBFCPY ACTIVE YES
BMC50102I         DSNPAT 'ARU.EXMPL02B.&DDNAME'
BMC50102I       DDTYPE REMPFCPY ACTIVE YES
BMC50102I         DSNPAT 'ARU.EXMPL02B.&DDNAME'
BMC50102I       DDTYPE REMBFCPY ACTIVE YES
BMC50102I         DSNPAT 'ARU.EXMPL02B.&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(1945) PSID(2) PART(1) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00000000 FOR DBID(1945) PSID(2)
BMC50245I REGISTERING SYSTEM PAGE - 00000002 FOR DBID(1945) PSID(2)
BMC51301I 5: SAMPLING STATISTICS: PART=1,TP=11,SP=9,SR=10,AVGR=112,SD=64,SE=0,AVGF=111,SD=64,SE=104,EP=8
BMC50244I PROCESSING PAGESET DBID(1945) PSID(2) PART(2) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00100000 FOR DBID(1945) PSID(2)
BMC50245I REGISTERING SYSTEM PAGE - 00100002 FOR DBID(1945) PSID(2)
BMC51301I 4: SAMPLING STATISTICS: PART=2,TP=11,SP=9,SR=10,AVGR=133,SD=64,SE=0,AVGF=111,SD=64,SE=104,EP=8
BMC50244I PROCESSING PAGESET DBID(1945) PSID(2) PART(3) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00200000 FOR DBID(1945) PSID(2)
BMC50245I REGISTERING SYSTEM PAGE - 00200002 FOR DBID(1945) PSID(2)
BMC51301I 3: SAMPLING STATISTICS: PART=3,TP=11,SP=9,SR=10,AVGR=159,SD=64,SE=0,AVGF=111,SD=64,SE=104,EP=8
BMC50244I PROCESSING PAGESET DBID(1945) PSID(2) PART(4) THAT MIGHT CONTAIN VERSIONED DATA
BMC50244I PROCESSING PAGESET DBID(1945) PSID(2) PART(5) THAT MIGHT CONTAIN VERSIONED DATA
BMC50245I REGISTERING HEADER PAGE - 00300000 FOR DBID(1945) PSID(2)
BMC50245I REGISTERING SYSTEM PAGE - 00300002 FOR DBID(1945) PSID(2)
BMC50245I REGISTERING HEADER PAGE - 00400000 FOR DBID(1945) PSID(2)
BMC50245I REGISTERING SYSTEM PAGE - 00400002 FOR DBID(1945) PSID(2)
BMC51301I 5: SAMPLING STATISTICS: PART=4,TP=11,SP=9,SR=10,AVGR=112,SD=64,SE=0,AVGF=111,SD=64,SE=104,EP=8
BMC51301I 2: SAMPLING STATISTICS: PART=5,TP=10,SP=8,SR=0,AVGR=0,SD=0,SE=0,AVGF=0,SD=0,SE=0,EP=8
BMC51265I ESTIMATED CARDINALITY OF SPACE = 40 AVG SORTWK ROW LENGTH = 129 AVG UNLOAD ROW LENGTH = 129
BMC50484I ESTIMATED CARDINALITY OF PART 0001 = 10 AVG SORTWK ROW LENGTH = 112 AVG UNLOAD ROW LENGTH = 112
BMC50484I ESTIMATED CARDINALITY OF PART 0002 = 10 AVG SORTWK ROW LENGTH = 133 AVG UNLOAD ROW LENGTH = 133
BMC50484I ESTIMATED CARDINALITY OF PART 0003 = 10 AVG SORTWK ROW LENGTH = 159 AVG UNLOAD ROW LENGTH = 159
BMC50484I ESTIMATED CARDINALITY OF PART 0004 = 10 AVG SORTWK ROW LENGTH = 112 AVG UNLOAD ROW LENGTH = 112
BMC50484I ESTIMATED CARDINALITY OF PART 0005 = 0 AVG SORTWK ROW LENGTH = 0 AVG UNLOAD ROW LENGTH = 0
BMC51264I UNLOAD WILL READ 44 DATA PAGES FROM SPACE 'ARUDB007.TS007'
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 = EXMPL02B &STEPNAME = BMCREORG &DB       = ARUDB007 &TSIX     = TS007     &RTYPE    = TS
BMC50425I &UID      = BMCPMN    &DATE     = 122921    &TIME     = 021233    &SSID     = DEMO      &UTIL     = EXMPL02B
BMC50425I &UTILPFX = EXMPL02B &UTILSFX =           &DATE8    = 1292022 &GRPNM    = DEMO      &VCAT     = DEMOCAT
BMC50425I &TIME4    = 0212      &DATEJ    = 2021363   &JDATE    = 21363

BMC50877I POINT OF CONSISTENCY ESTABLISHED AT RBA/LRSN = 0000000002B5950BEF87
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 BMCCPZ   ARU.EXMPL02B.BMCCPZ                          SYSALLDA                        216       22        5         1 TRK
BMC50448I BMCRCY   ARU.EXMPL02B.BMCRCY                          SYSALLDA                        216       22        5         1 TRK
BMC50448I BMCRCZ   ARU.EXMPL02B.BMCRCZ                          SYSALLDA                        216       22        5         1 TRK
BMC50448I SYSUT101 ARU.EXMPL02B.SYSUT101                        SYSALLDA                          2        1        1         1 TRK
BMC50448I SYSUT102 ARU.EXMPL02B.SYSUT102                        SYSALLDA                          1        1        1         1 TRK

BMC50394I UNABLE TO LOCATE SORT WORK DATASETS, DDNAME = 'SORTWKNN'
BMC50509I STATISTICS COLLECTION FOR INDEX SPACE ARU.TS00712 BYPASSED DUE TO PARTIAL TABLE SPACE REORG
BMC50509I STATISTICS COLLECTION FOR INDEX SPACE ARU.TS00713 BYPASSED DUE TO PARTIAL TABLE SPACE REORG
BMC50474I BELOW 16M = 8100K, ABOVE 16M = 1014284K, CPUS = 5
BMC50388I 17: COPY OF SECONDARY INDEX: 'DEMOCAT.DSNDBD.ARUDB007.TS00712.I0001.A001' STARTED
BMC50388I 18: COPY OF SECONDARY INDEX: 'DEMOCAT.DSNDBD.ARUDB007.TS00713.I0001.A001' STARTED
BMC50389I 17: COPY        12 PAGES OF SECONDARY INDEX: 'DEMOCAT.DSNDBD.ARUDB007.TS00712.I0001.A001' COMPLETE
BMC50389I 18: COPY        12 PAGES OF SECONDARY INDEX: 'DEMOCAT.DSNDBD.ARUDB007.TS00713.I0001.A001' COMPLETE
BMC50479I TOTAL PAGES: 11489916, ALLOWED: 0; AVAILABLE PAGES: 3077685, ALLOWED: 3077685
BMC51302I MAX TASKS = 5, MAX PARTITIONS PER TASK = 1, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 1
BMC50486I 2: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50477I 2: PARTITION =    2, ROWS/KEYS = 10, I/O WAITS = 1 ,DDNAME = SYS00034
BMC51271I UNLOAD STATISTICS: 10 ROWS/KEYS UNLOADED FROM PARTITION 2
BMC51281I UNLOAD STATISTICS: X'0000000002B592445242' IS THE HIGHEST LOGRBA FOR PARTITION 2
BMC50481I 2: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50486I 3: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50477I 1: PARTITION =    1, ROWS/KEYS = 10, I/O WAITS = 1 ,DDNAME = SYS00035
BMC51271I UNLOAD STATISTICS: 10 ROWS/KEYS UNLOADED FROM PARTITION 1
BMC51281I UNLOAD STATISTICS: X'0000000002B592445242' IS THE HIGHEST LOGRBA FOR PARTITION 1
BMC50481I 1: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50486I 5: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50477I 3: PARTITION =    3, ROWS/KEYS = 10, I/O WAITS = 1 ,DDNAME = SYS00037
BMC51271I UNLOAD STATISTICS: 10 ROWS/KEYS UNLOADED FROM PARTITION 3
BMC51281I UNLOAD STATISTICS: X'0000000002B592445242' IS THE HIGHEST LOGRBA FOR PARTITION 3
BMC50481I 3: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50486I 4: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50477I 5: PARTITION =    5, ROWS/KEYS = 0, I/O WAITS = 1 ,DDNAME = SYS00039
BMC51271I UNLOAD STATISTICS: 0 ROWS/KEYS UNLOADED FROM PARTITION 5
BMC51281I UNLOAD STATISTICS: X'0000000002B592445242' IS THE HIGHEST LOGRBA FOR PARTITION 5
BMC50466W TEMPORARY DATASET NOT RECOMMENDED FOR DDNAME = 'BMCCPY'
BMC50477I 4: PARTITION =    4, ROWS/KEYS = 10, I/O WAITS = 1 ,DDNAME = SYS00042
BMC51271I UNLOAD STATISTICS: 10 ROWS/KEYS UNLOADED FROM PARTITION 4
BMC51281I UNLOAD STATISTICS: X'0000000002B592445242' IS THE HIGHEST LOGRBA FOR PARTITION 4
BMC51272I UNLOAD STATISTICS: 40 ROWS UNLOADED FROM SPACE 'ARUDB007.TS007', 0 ROWS DISCARDED, 0 ROWS UPDATED
BMC51282I UNLOAD STATISTICS: X'0000000002B592445242' IS THE HIGHEST LOGRBA FOR SPACE 'ARUDB007.TS007'
BMC50481I 4: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A002'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A001'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A002'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A001'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A003'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A003'
BMC50482I 5: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.BMCDBD.ARUDB007.TS00711.I0001.A005'
BMC50477I 5: PARTITION =    5, ROWS/KEYS = 0, I/O WAITS = 5 ,DDNAME = SYS00041
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A004'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A004'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A002'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A001'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A003'
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.BMCDBD.ARUDB007.TS00711.I0001.A001'
BMC50477I 1: PARTITION =    1, ROWS/KEYS = 10, I/O WAITS = 5 ,DDNAME = SYS00045
BMC50482I 2: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.BMCDBD.ARUDB007.TS00711.I0001.A002'
BMC50477I 2: PARTITION =    2, ROWS/KEYS = 10, I/O WAITS = 5 ,DDNAME = SYS00044
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A005'
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A005'
BMC50482I 1: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A001'
BMC50477I 1: PARTITION =    1, ROWS/KEYS = 10, I/O WAITS = 8 ,DDNAME = SYS00038
BMC51274I RELOAD STATISTICS: 10 ROWS/KEYS LOADED INTO PARTITION 1
BMC50482I 2: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A002'
BMC50477I 2: PARTITION =    2, ROWS/KEYS = 10, I/O WAITS = 8 ,DDNAME = SYS00036
BMC51274I RELOAD STATISTICS: 10 ROWS/KEYS LOADED INTO PARTITION 2
BMC50482I 5: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A005'
BMC50477I 5: PARTITION =    5, ROWS/KEYS = 0, I/O WAITS = 5 ,DDNAME = SYS00047
BMC50482I 3: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.BMCDBD.ARUDB007.TS00711.I0001.A003'
BMC50477I 3: PARTITION =    3, ROWS/KEYS = 10, I/O WAITS = 5 ,DDNAME = SYS00046
BMC51274I RELOAD STATISTICS: 0 ROWS/KEYS LOADED INTO PARTITION 5
BMC50481I 5: REORG TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC50481I 1: REORG TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC50481I 2: REORG TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC50482I 3: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A003'
BMC50477I 3: PARTITION =    3, ROWS/KEYS = 10, I/O WAITS = 8 ,DDNAME = SYS00040
BMC51274I RELOAD STATISTICS: 10 ROWS/KEYS LOADED INTO PARTITION 3
BMC50481I 3: REORG TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC50375I INLINE COPY STARTED FOR DATASET = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A004'
BMC50482I 4: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.BMCDBD.ARUDB007.TS00711.I0001.A004'
BMC50477I 4: PARTITION =    4, ROWS/KEYS = 10, I/O WAITS = 5 ,DDNAME = SYS00048
BMC50482I 4: RELOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A004'
BMC50477I 4: PARTITION =    4, ROWS/KEYS = 10, I/O WAITS = 8 ,DDNAME = SYS00043
BMC51274I RELOAD STATISTICS: 10 ROWS/KEYS LOADED INTO PARTITION 4
BMC50481I 4: REORG TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC50476I DDNAME = SYSUT101, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSUT102, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC51276I BUILD STATISTICS: 40 KEYS LOADED INTO INDEX 'ARU.TS00711'
BMC51275I RELOAD STATISTICS: 40 ROWS LOADED INTO SPACE 'ARUDB007.TS007'
BMC50474I BELOW 16M = 8028K, ABOVE 16M = 1013140K, CPUS = 5
BMC50479I TOTAL PAGES: 11486799, ALLOWED: 0; AVAILABLE PAGES: 3076757, ALLOWED: 3076757
BMC51303I MAX TASKS = 2, INDEXES PER TASK = 1, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 2
BMC50486I 2: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50476I DDNAME = SYSUT102, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50481I 2: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50476I DDNAME = SYSUT101, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50481I 1: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50482I 2: UPDATE COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.BMCDBD.ARUDB007.TS00713.I0001.A001'
BMC50477I 2: PARTITION =    0, ROWS/KEYS = 40, I/O WAITS = 4 ,DDNAME = SYS00051
BMC51277I BUILD STATISTICS: 40 KEY-RID PAIRS UPDATED IN INDEX 'ARU.TS00713'
BMC50482I 1: UPDATE COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.BMCDBD.ARUDB007.TS00712.I0001.A001'
BMC50477I 1: PARTITION =    0, ROWS/KEYS = 40, I/O WAITS = 4 ,DDNAME = SYS00052
BMC51277I BUILD STATISTICS: 40 KEY-RID PAIRS UPDATED IN INDEX 'ARU.TS00712'
BMC50476I DDNAME = BMCCPY, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCCPZ, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCY, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCZ, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50376I 68 PAGES COPIED TO DATASET = 'ARU.EXMPL02B.FULLCPY'
BMC50376I 68 PAGES COPIED TO DATASET = 'ARU.EXMPL02B.BMCCPZ'
BMC50376I 68 PAGES COPIED TO DATASET = 'ARU.EXMPL02B.BMCRCY'
BMC50376I 68 PAGES COPIED TO DATASET = 'ARU.EXMPL02B.BMCRCZ'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT101', DSNAME = 'ARU.EXMPL02B.SYSUT101'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT102', DSNAME = 'ARU.EXMPL02B.SYSUT102'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I REORG PHASE COMPLETE. ELAPSED TIME = 00:00:03

BMC50705I SQL PREPARE LOCK STARTED AT 00DAD54C8F24AC9A7400
BMC50894I RENAME PROCESS STARTING AT 1/29/2022   2:12:37
BMC50890I 1: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS007.I0001.A001'...
BMC50890I 2: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS007.I0001.A002'...
BMC50890I 3: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS007.I0001.A003'...
BMC50890I 4: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS007.I0001.A004'...
BMC50890I 6: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS00711.I0001.A001'...
BMC50890I 5: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS007.I0001.A005'...
BMC50890I 11: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS00712.I0001.A001'...
BMC50890I 10: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS00711.I0001.A005'...
BMC50890I 8: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS00711.I0001.A003'...
BMC50890I 7: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS00711.I0001.A002'...
BMC50890I 12: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS00713.I0001.A001'...
BMC50890I 9: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS00711.I0001.A004'...
BMC50891I 1: DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS007.I0001.A001' IS RENAMED
BMC50891I 2: DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS007.I0001.A002' IS RENAMED
BMC50890I 1: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A001'...
BMC50890I 2: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A002'...
BMC50891I 4: DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS007.I0001.A004' IS RENAMED
BMC50891I 3: DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS007.I0001.A003' IS RENAMED
BMC50890I 4: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A004'...
BMC50890I 3: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A003'...
BMC50891I 6: DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS00711.I0001.A001' IS RENAMED
BMC50891I 10: DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS00711.I0001.A005' IS RENAMED
BMC50891I 11: DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS00712.I0001.A001' IS RENAMED
BMC50891I 9: DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS00711.I0001.A004' IS RENAMED
BMC50891I 8: DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS00711.I0001.A003' IS RENAMED
BMC50891I 12: DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS00713.I0001.A001' IS RENAMED
BMC50891I 7: DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS00711.I0001.A002' IS RENAMED
BMC50891I 5: DATASET 'DEMOCAT.DSNDBC.ARUDB007.TS007.I0001.A005' IS RENAMED
BMC50890I 6: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS00711.I0001.A001'...
BMC50890I 11: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS00712.I0001.A001'...
BMC50890I 10: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS00711.I0001.A005'...
BMC50890I 12: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS00713.I0001.A001'...
BMC50890I 7: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS00711.I0001.A002'...
BMC50890I 8: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS00711.I0001.A003'...
BMC50890I 9: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS00711.I0001.A004'...
BMC50891I 1: DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A001' IS RENAMED
BMC50890I 1: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS007.I0001.A001'...
BMC50890I 5: ATTEMPTING TO RENAME DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A005'...
BMC50891I 1: DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS007.I0001.A001' IS RENAMED
BMC50890I 1: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A001'...
BMC50891I 2: DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A002' IS RENAMED
BMC50890I 2: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS007.I0001.A002'...
BMC50891I 4: DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A004' IS RENAMED
BMC50890I 4: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS007.I0001.A004'...
BMC50891I 3: DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A003' IS RENAMED
BMC50890I 3: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS007.I0001.A003'...
BMC50891I 2: DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS007.I0001.A002' IS RENAMED
BMC50890I 2: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A002'...
BMC50891I 10: DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS00711.I0001.A005' IS RENAMED
BMC50890I 10: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS00711.I0001.A005'...
BMC50891I 4: DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS007.I0001.A004' IS RENAMED
BMC50890I 4: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A004'...
BMC50891I 12: DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS00713.I0001.A001' IS RENAMED
BMC50890I 12: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS00713.I0001.A001'...
BMC50891I 11: DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS00712.I0001.A001' IS RENAMED
BMC50890I 11: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS00712.I0001.A001'...
BMC50891I 6: DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS00711.I0001.A001' IS RENAMED
BMC50890I 6: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS00711.I0001.A001'...
BMC50891I 3: DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS007.I0001.A003' IS RENAMED
BMC50890I 3: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A003'...
BMC50891I 7: DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS00711.I0001.A002' IS RENAMED
BMC50890I 7: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS00711.I0001.A002'...
BMC50891I 10: DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS00711.I0001.A005' IS RENAMED
BMC50890I 10: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS00711.I0001.A005'...
BMC50891I 9: DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS00711.I0001.A004' IS RENAMED
BMC50890I 9: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS00711.I0001.A004'...
BMC50891I 8: DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS00711.I0001.A003' IS RENAMED
BMC50890I 8: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS00711.I0001.A003'...
BMC50891I 5: DATASET 'DEMOCAT.DSNDBD.ARUDB007.TS007.I0001.A005' IS RENAMED
BMC50890I 5: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS007.I0001.A005'...
BMC50891I 1: DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A001' IS RENAMED
BMC50891I 12: DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS00713.I0001.A001' IS RENAMED
BMC50890I 12: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS00713.I0001.A001'...
BMC50891I 11: DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS00712.I0001.A001' IS RENAMED
BMC50890I 11: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS00712.I0001.A001'...
BMC50891I 2: DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A002' IS RENAMED
BMC50891I 4: DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A004' IS RENAMED
BMC50891I 6: DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS00711.I0001.A001' IS RENAMED
BMC50890I 6: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS00711.I0001.A001'...
BMC50891I 3: DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A003' IS RENAMED
BMC50891I 7: DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS00711.I0001.A002' IS RENAMED
BMC50890I 7: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS00711.I0001.A002'...
BMC50891I 9: DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS00711.I0001.A004' IS RENAMED
BMC50890I 9: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS00711.I0001.A004'...
BMC50891I 10: DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS00711.I0001.A005' IS RENAMED
BMC50891I 8: DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS00711.I0001.A003' IS RENAMED
BMC50890I 8: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS00711.I0001.A003'...
BMC50891I 5: DATASET 'DEMOCAT.BMCDBC.ARUDB007.TS007.I0001.A005' IS RENAMED
BMC50890I 5: ATTEMPTING TO RENAME DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A005'...
BMC50891I 11: DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS00712.I0001.A001' IS RENAMED
BMC50891I 12: DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS00713.I0001.A001' IS RENAMED
BMC50891I 6: DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS00711.I0001.A001' IS RENAMED
BMC50891I 7: DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS00711.I0001.A002' IS RENAMED
BMC50891I 9: DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS00711.I0001.A004' IS RENAMED
BMC50891I 8: DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS00711.I0001.A003' IS RENAMED
BMC50891I 5: DATASET 'DEMOCAT.BMCDBD.ARUDB007.TS007.I0001.A005' IS RENAMED
BMC50895I RENAME PROCESS COMPLETE. ELAPSED TIME = 00:00:00

BMC50705I SQL PREPARE LOCK TERMINATED AT 00DAD54C8FA45B074A00
BMC50890I 4: ATTEMPTING TO DELETE DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS007.I0001.A004'...
BMC50890I 10: ATTEMPTING TO DELETE DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS00711.I0001.A005'...
BMC50890I 2: ATTEMPTING TO DELETE DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS007.I0001.A002'...
BMC50890I 5: ATTEMPTING TO DELETE DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS007.I0001.A005'...
BMC50890I 8: ATTEMPTING TO DELETE DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS00711.I0001.A003'...
BMC50890I 6: ATTEMPTING TO DELETE DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS00711.I0001.A001'...
BMC50890I 3: ATTEMPTING TO DELETE DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS007.I0001.A003'...
BMC50890I 7: ATTEMPTING TO DELETE DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS00711.I0001.A002'...
BMC50890I 1: ATTEMPTING TO DELETE DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS007.I0001.A001'...
BMC50890I 9: ATTEMPTING TO DELETE DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS00711.I0001.A004'...
BMC50890I 11: ATTEMPTING TO DELETE DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS00712.I0001.A001'...
BMC50890I 12: ATTEMPTING TO DELETE DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS00713.I0001.A001'...
BMC50891I 4: DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS007.I0001.A004' IS DELETED
BMC50891I 10: DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS00711.I0001.A005' IS DELETED
BMC50891I 8: DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS00711.I0001.A003' IS DELETED
BMC50891I 2: DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS007.I0001.A002' IS DELETED
BMC50891I 6: DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS00711.I0001.A001' IS DELETED
BMC50891I 5: DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS007.I0001.A005' IS DELETED
BMC50891I 3: DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS007.I0001.A003' IS DELETED
BMC50891I 1: DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS007.I0001.A001' IS DELETED
BMC50891I 9: DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS00711.I0001.A004' IS DELETED
BMC50891I 12: DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS00713.I0001.A001' IS DELETED
BMC50891I 11: DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS00712.I0001.A001' IS DELETED
BMC50891I 7: DATASET 'DEMOCAT.OLDDBC.ARUDB007.TS00711.I0001.A002' IS DELETED

BMC278098I AGGREGATE STATISTICS NOT PRODUCED FOR INDEX ARU.TS00711
BMC278098I AGGREGATE STATISTICS NOT PRODUCED FOR TABLESPACE ARUDB007.TS007
BMC278098I AGGREGATE STATISTICS NOT PRODUCED FOR TABLE ARU.TS0071
BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR REORG UTILITY SUCCESSFUL FOR ALL OBJECTS
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0

ASUSRPRT for example 2, case 2

The following figure shows a portion of the statistics reports sent to ASUSRPRT for case 2 of example 2. This figure shows one set of statistics for each object type. Ellipses (...) at the beginning of a line indicate the omitted statistics sections.

1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-1-29-02.12.33.928671                                          1
0

   INDEXPART ----------- ARU.TS00711 PART 001
     ASSOCIATIONS
       TABLESPACE ------ ARUDB007.TS007
       TABLE ----------- ARU.TS0071
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N UTILCODE---------------------R LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------1 SQTY------------------------15 PCTFREE---------------------15 FREEPAGE---------------------9
       ALLOCUNIT--------------------T STORTYPE---------------------I NLAVGKEYLEN-----------------34 RBA_FORMAT------------EXTENDED
       PAGENUM----------------------A DSSIZE-----------------------0 VCATNAME---------------DEMOCAT STORNAME--------------DEMOCAT
     STATISTICS
       FIRSTKEYCARD----------------10 FULLKEYCARD-----------------10 CARD------------------------10 NACTIVE----------------------5
       CLUSTERRATIO---------------100 NUMNONLEAF-------------------1 NLEVELS----------------------2 FAROFFPOS--------------------0
       NEAROFFPOS-------------------0 LEAFDIST---------------------0 NLEAF------------------------1 FREE-------------------------7
       FULL-------------------------0 AVGKEYLEN-------------------25
       LEAFNEAR---------------------0 LEAFFAR----------------------0 PSEUDO_DEL_RIDS--------------0 REORGSPACE-------------------1
       REORGSPACE_KB---------------48 REORGNLEVELS-----------------2 PCTUSED--------------------100 PQTYROWS-------------------832
       DATAREPEAT-------------------1
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------1 SPACE_KB--------------------48 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT038

   INDEXPART ----------- ARU.TS00711 PART 002
     ASSOCIATIONS
       TABLESPACE ------ ARUDB007.TS007
       TABLE ----------- ARU.TS0071
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N UTILCODE---------------------R LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------1 SQTY------------------------15 PCTFREE---------------------15 FREEPAGE---------------------9
       ALLOCUNIT--------------------T STORTYPE---------------------I NLAVGKEYLEN-----------------34 RBA_FORMAT------------EXTENDED
       PAGENUM----------------------A DSSIZE-----------------------0 VCATNAME---------------DEMOCAT STORNAME--------------DEMOCAT
     STATISTICS
       FIRSTKEYCARD----------------10 FULLKEYCARD-----------------10 CARD------------------------10 NACTIVE----------------------5
       CLUSTERRATIO---------------100 NUMNONLEAF-------------------1 NLEVELS----------------------2 FAROFFPOS--------------------0
       NEAROFFPOS-------------------0 LEAFDIST---------------------0 NLEAF------------------------1 FREE-------------------------7
       FULL-------------------------0 AVGKEYLEN-------------------36
       LEAFNEAR---------------------0 LEAFFAR----------------------0 PSEUDO_DEL_RIDS--------------0 REORGSPACE-------------------1
       REORGSPACE_KB---------------48 REORGNLEVELS-----------------2 PCTUSED--------------------100 PQTYROWS-------------------624
       DATAREPEAT-------------------1
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------1 SPACE_KB--------------------48 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT002

   INDEXPART ----------- ARU.TS00711 PART 003
     ASSOCIATIONS
       TABLESPACE ------ ARUDB007.TS007
       TABLE ----------- ARU.TS0071
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N UTILCODE---------------------R LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------1 SQTY------------------------15 PCTFREE---------------------15 FREEPAGE---------------------9
       ALLOCUNIT--------------------T STORTYPE---------------------I NLAVGKEYLEN-----------------34 RBA_FORMAT------------EXTENDED
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-29-02.12.33.928671                                          2
0
       PAGENUM----------------------A DSSIZE-----------------------0 VCATNAME---------------DEMOCAT STORNAME--------------DEMOCAT
     STATISTICS
       FIRSTKEYCARD----------------10 FULLKEYCARD-----------------10 CARD------------------------10 NACTIVE----------------------5
       CLUSTERRATIO---------------100 NUMNONLEAF-------------------1 NLEVELS----------------------2 FAROFFPOS--------------------0
       NEAROFFPOS-------------------0 LEAFDIST---------------------0 NLEAF------------------------1 FREE-------------------------7
       FULL-------------------------0 AVGKEYLEN-------------------36
       LEAFNEAR---------------------0 LEAFFAR----------------------0 PSEUDO_DEL_RIDS--------------0 REORGSPACE-------------------1
       REORGSPACE_KB---------------48 REORGNLEVELS-----------------2 PCTUSED--------------------100 PQTYROWS-------------------624
       DATAREPEAT-------------------1
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------1 SPACE_KB--------------------48 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT046

   INDEXPART ----------- ARU.TS00711 PART 004
     ASSOCIATIONS
       TABLESPACE ------ ARUDB007.TS007
       TABLE ----------- ARU.TS0071
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N UTILCODE---------------------R LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------1 SQTY------------------------15 PCTFREE---------------------15 FREEPAGE---------------------9
       ALLOCUNIT--------------------T STORTYPE---------------------I NLAVGKEYLEN-----------------34 RBA_FORMAT------------EXTENDED
       PAGENUM----------------------A DSSIZE-----------------------0 VCATNAME---------------DEMOCAT STORNAME--------------DEMOCAT
     STATISTICS
       FIRSTKEYCARD----------------10 FULLKEYCARD-----------------10 CARD------------------------10 NACTIVE----------------------5
       CLUSTERRATIO---------------100 NUMNONLEAF-------------------1 NLEVELS----------------------2 FAROFFPOS--------------------0
       NEAROFFPOS-------------------0 LEAFDIST---------------------0 NLEAF------------------------1 FREE-------------------------7
       FULL-------------------------0 AVGKEYLEN-------------------25
       LEAFNEAR---------------------0 LEAFFAR----------------------0 PSEUDO_DEL_RIDS--------------0 REORGSPACE-------------------1
       REORGSPACE_KB---------------48 REORGNLEVELS-----------------2 PCTUSED--------------------100 PQTYROWS-------------------832
       DATAREPEAT-------------------1
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------1 SPACE_KB--------------------48 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT131

   INDEXPART ----------- ARU.TS00711 PART 005
     ASSOCIATIONS
       TABLESPACE ------ ARUDB007.TS007
       TABLE ----------- ARU.TS0071
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N UTILCODE---------------------R LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------1 SQTY------------------------15 PCTFREE---------------------15 FREEPAGE---------------------9
       ALLOCUNIT--------------------T STORTYPE---------------------I NLAVGKEYLEN------------------0 RBA_FORMAT------------EXTENDED
       PAGENUM----------------------A DSSIZE-----------------------0 VCATNAME---------------DEMOCAT STORNAME--------------DEMOCAT
     STATISTICS
       FIRSTKEYCARD-----------------0 FULLKEYCARD------------------0 CARD-------------------------0 NACTIVE----------------------5
       CLUSTERRATIO-----------------0 NUMNONLEAF-------------------1 NLEVELS----------------------2 FAROFFPOS--------------------0
       NEAROFFPOS-------------------0 LEAFDIST---------------------0 NLEAF------------------------0 FREE-------------------------3
       FULL-------------------------0 AVGKEYLEN--------------------0
       LEAFNEAR---------------------0 LEAFFAR----------------------0 PSEUDO_DEL_RIDS--------------0 REORGSPACE-------------------1
       REORGSPACE_KB---------------48 REORGNLEVELS-----------------2 PCTUSED--------------------100 PQTYROWS-------------------654
       DATAREPEAT-------------------0
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------1 SPACE_KB--------------------48 NUMDATASETS------------------1
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-29-02.12.33.928671                                          3
0
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT037

   COLUMN -------------- EMPHIREDATE PART 001
     ATTRIBUTES
       COLNO------------------------6 COLTYPE-------------------DATE LENGTH-----------------------4 NULLS------------------------Y
       SCALE------------------------0
     STATISTICS
       COLCARD---------------------10 COLNULLS---------------------0 COLAVG-----------------------5 COLMIN-----------------------5
       COLMAX-----------------------5
       HIGH2K-----------X'0019890129' HIGH2K (CHAR)------------..i.. LOW2K------------X'0019890122' LOW2K (CHAR)-------------..i..
       HIGHK------------X'0019890130' HIGHK (CHAR)-------------..i.. LOWK-------------X'0019890121' LOWK (CHAR)--------------..i..

       MOST FREQUENT VALUES
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890130'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890129'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890128'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890127'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890126'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890125'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890124'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890123'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890122'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890121'
                                       (CHAR)-------------------..i..

   KEYCARD ------------- EMPHIREDATE PART 001
     ATTRIBUTES AND STATISTICS
       COLUMN-------------EMPHIREDATE COLCARD---------------------10 COLTYPE-------------------DATE LENGTH-----------------------4
       COLUMN-------------------EMPNO COLCARD---------------------10 COLTYPE-------------------CHAR LENGTH-----------------------9
       COLUMN-------------EMPDEPTNAME COLCARD---------------------10 COLTYPE----------------VARCHAR LENGTH----------------------18

   COLUMN -------------- EMPHIREDATE PART 002
     ATTRIBUTES
       COLNO------------------------6 COLTYPE-------------------DATE LENGTH-----------------------4 NULLS------------------------Y
       SCALE------------------------0
     STATISTICS
       COLCARD---------------------10 COLNULLS---------------------0 COLAVG-----------------------5 COLMIN-----------------------5
       COLMAX-----------------------5
       HIGH2K-----------X'0019890227' HIGH2K (CHAR)------------..i.. LOW2K------------X'0019890220' LOW2K (CHAR)-------------..i..
       HIGHK------------X'0019890228' HIGHK (CHAR)-------------..i.. LOWK-------------X'0019890219' LOWK (CHAR)--------------..i..

       MOST FREQUENT VALUES
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890228'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890227'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890226'
                                       (CHAR)-------------------..i..
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-29-02.12.33.928671                                          4
0
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890225'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890224'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890223'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890222'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890221'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890220'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890219'
                                       (CHAR)-------------------..i..

   KEYCARD ------------- EMPHIREDATE PART 002
     ATTRIBUTES AND STATISTICS
       COLUMN-------------EMPHIREDATE COLCARD---------------------10 COLTYPE-------------------DATE LENGTH-----------------------4
       COLUMN-------------------EMPNO COLCARD---------------------10 COLTYPE-------------------CHAR LENGTH-----------------------9
       COLUMN-------------EMPDEPTNAME COLCARD---------------------10 COLTYPE----------------VARCHAR LENGTH----------------------18

   COLUMN -------------- EMPHIREDATE PART 003
     ATTRIBUTES
       COLNO------------------------6 COLTYPE-------------------DATE LENGTH-----------------------4 NULLS------------------------Y
       SCALE------------------------0
     STATISTICS
       COLCARD---------------------10 COLNULLS---------------------0 COLAVG-----------------------5 COLMIN-----------------------5
       COLMAX-----------------------5
       HIGH2K-----------X'0019890330' HIGH2K (CHAR)------------..i.. LOW2K------------X'0019890323' LOW2K (CHAR)-------------..i..
       HIGHK------------X'0019890331' HIGHK (CHAR)-------------..i.. LOWK-------------X'0019890322' LOWK (CHAR)--------------..i..

       MOST FREQUENT VALUES
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890331'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890330'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890329'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890328'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890327'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890326'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890325'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890324'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890323'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890322'
                                       (CHAR)-------------------..i..

   KEYCARD ------------- EMPHIREDATE PART 003
     ATTRIBUTES AND STATISTICS
       COLUMN-------------EMPHIREDATE COLCARD---------------------10 COLTYPE-------------------DATE LENGTH-----------------------4
       COLUMN-------------------EMPNO COLCARD---------------------10 COLTYPE-------------------CHAR LENGTH-----------------------9
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-29-02.12.33.928671                                          5
0
       COLUMN-------------EMPDEPTNAME COLCARD---------------------10 COLTYPE----------------VARCHAR LENGTH----------------------18

   COLUMN -------------- EMPHIREDATE PART 004
     ATTRIBUTES
       COLNO------------------------6 COLTYPE-------------------DATE LENGTH-----------------------4 NULLS------------------------Y
       SCALE------------------------0
     STATISTICS
       COLCARD---------------------10 COLNULLS---------------------0 COLAVG-----------------------5 COLMIN-----------------------5
       COLMAX-----------------------5
       HIGH2K-----------X'0019890429' HIGH2K (CHAR)------------..i.. LOW2K------------X'0019890422' LOW2K (CHAR)-------------..i..
       HIGHK------------X'0019890430' HIGHK (CHAR)-------------..i.. LOWK-------------X'0019890421' LOWK (CHAR)--------------..i..
       MOST FREQUENT VALUES
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890430'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890429'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890428'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890427'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890426'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890425'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890424'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890423'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890422'
                                       (CHAR)-------------------..i..
       FREQUENCY-------------0.100000 COLVAL-----------X'0019890421'
                                       (CHAR)-------------------..i..

   KEYCARD ------------- EMPHIREDATE PART 004
     ATTRIBUTES AND STATISTICS
       COLUMN-------------EMPHIREDATE COLCARD---------------------10 COLTYPE-------------------DATE LENGTH-----------------------4
       COLUMN-------------------EMPNO COLCARD---------------------10 COLTYPE-------------------CHAR LENGTH-----------------------9
       COLUMN-------------EMPDEPTNAME COLCARD---------------------10 COLTYPE----------------VARCHAR LENGTH----------------------18

   COLUMN -------------- EMPHIREDATE PART 005
     ATTRIBUTES
       COLNO------------------------6 COLTYPE-------------------DATE LENGTH-----------------------4 NULLS------------------------Y
       SCALE------------------------0
     STATISTICS
       COLCARD----------------------0 COLNULLS---------------------0 COLAVG-----------------------5 COLMIN-----------------------5
       COLMAX-----------------------5
       HIGH2K---------------------X'' HIGH2K (CHAR)-----------(NULL) LOW2K----------------------X'' LOW2K (CHAR)------------(NULL)
       HIGHK----------------------X'' HIGHK (CHAR)------------(NULL) LOWK-----------------------X'' LOWK (CHAR)-------------(NULL)


   KEYCARD ------------- EMPHIREDATE PART 005
     ATTRIBUTES AND STATISTICS
       COLUMN-------------EMPHIREDATE COLCARD----------------------0 COLTYPE-------------------DATE LENGTH-----------------------4
       COLUMN-------------------EMPNO COLCARD----------------------0 COLTYPE-------------------CHAR LENGTH-----------------------9
       COLUMN-------------EMPDEPTNAME COLCARD----------------------0 COLTYPE----------------VARCHAR LENGTH----------------------18
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-29-02.12.33.928671                                          1
0

   TABLEPART ----------- ARUDB007.TS007    PART 001
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N LOCATION----------------(NULL) UTILCODE---------------------R
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------3 SQTY------------------------15 PCTFREE----------------------0 FREEPAGE---------------------0
       ALLOCUNIT--------------------T STORTYPE---------------------I COMPRESS---------------(BLANK) TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF RBA_FORMAT------------EXTENDED TYPE-------------------------R PAGENUM----------------------A
       DSSIZE-----------------4194304 PGSIZE-----------------------4 BPOOL----------------------BP0 MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT STORNAME--------------ARULARSG
     STATISTICS
       CARD------------------------10 NACTIVE---------------------11 NPAGES-----------------------1 ROWAVG---------------------118
       ROWMAXFOUND----------------118 ROWMINFOUND----------------118 AVGNONCOMPROWLEN----------(-1) DIRTY------------------------0
       FULL-------------------------0 FARINDREF--------------------0 NEARINDREF-------------------0 PERCACTIVE-------------------2
       PCTPAGES---------------------9 PERCDROP---------------------0 REORGSPACE-------------------1 REORGSPACE_KB---------------48
       PCTUSED---------------------33 PQTYROWS------------------1056
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------3 SPACE_KB-------------------144 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT018

   TABLEPART ----------- ARUDB007.TS007    PART 002
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N LOCATION----------------(NULL) UTILCODE---------------------R
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------3 SQTY------------------------15 PCTFREE----------------------0 FREEPAGE---------------------0
       ALLOCUNIT--------------------T STORTYPE---------------------I COMPRESS---------------(BLANK) TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF RBA_FORMAT------------EXTENDED TYPE-------------------------R PAGENUM----------------------A
       DSSIZE-----------------4194304 PGSIZE-----------------------4 BPOOL----------------------BP0 MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT STORNAME--------------ARULARSG
     STATISTICS
       CARD------------------------10 NACTIVE---------------------11 NPAGES-----------------------1 ROWAVG---------------------139
       ROWMAXFOUND----------------139 ROWMINFOUND----------------139 AVGNONCOMPROWLEN----------(-1) DIRTY------------------------0
       FULL-------------------------0 FARINDREF--------------------0 NEARINDREF-------------------0 PERCACTIVE-------------------3
       PCTPAGES---------------------9 PERCDROP---------------------0 REORGSPACE-------------------1 REORGSPACE_KB---------------48
       PCTUSED---------------------33 PQTYROWS-------------------896
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------3 SPACE_KB-------------------144 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT134

   TABLEPART ----------- ARUDB007.TS007    PART 003
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N LOCATION----------------(NULL) UTILCODE---------------------R
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------3 SQTY------------------------15 PCTFREE----------------------0 FREEPAGE---------------------0
       ALLOCUNIT--------------------T STORTYPE---------------------I COMPRESS---------------(BLANK) TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF RBA_FORMAT------------EXTENDED TYPE-------------------------R PAGENUM----------------------A
       DSSIZE-----------------4194304 PGSIZE-----------------------4 BPOOL----------------------BP0 MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT STORNAME--------------ARULARSG
     STATISTICS
       CARD------------------------10 NACTIVE---------------------11 NPAGES-----------------------1 ROWAVG---------------------165
       ROWMAXFOUND----------------165 ROWMINFOUND----------------165 AVGNONCOMPROWLEN----------(-1) DIRTY------------------------0
       FULL-------------------------0 FARINDREF--------------------0 NEARINDREF-------------------0 PERCACTIVE-------------------3
       PCTPAGES---------------------9 PERCDROP---------------------0 REORGSPACE-------------------1 REORGSPACE_KB---------------48
       PCTUSED---------------------33 PQTYROWS-------------------768
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-01-29-02.12.33.928671                                          2
0
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------3 SPACE_KB-------------------144 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT002

   TABLEPART ----------- ARUDB007.TS007    PART 004
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N LOCATION----------------(NULL) UTILCODE---------------------R
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------3 SQTY------------------------15 PCTFREE----------------------0 FREEPAGE---------------------0
       ALLOCUNIT--------------------T STORTYPE---------------------I COMPRESS---------------(BLANK) TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF RBA_FORMAT------------EXTENDED TYPE-------------------------R PAGENUM----------------------A
       DSSIZE-----------------4194304 PGSIZE-----------------------4 BPOOL----------------------BP0 MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT STORNAME--------------ARULARSG
     STATISTICS
       CARD------------------------10 NACTIVE---------------------11 NPAGES-----------------------1 ROWAVG---------------------118
       ROWMAXFOUND----------------118 ROWMINFOUND----------------118 AVGNONCOMPROWLEN----------(-1) DIRTY------------------------0
       FULL-------------------------0 FARINDREF--------------------0 NEARINDREF-------------------0 PERCACTIVE-------------------2
       PCTPAGES---------------------9 PERCDROP---------------------0 REORGSPACE-------------------1 REORGSPACE_KB---------------48
       PCTUSED---------------------33 PQTYROWS------------------1056
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------3 SPACE_KB-------------------144 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT091

   TABLEPART ----------- ARUDB007.TS007    PART 005
     HISTORY
       SAVESTATS--------------------Y UPDATEDB2--------------------N LOCATION----------------(NULL) UTILCODE---------------------R
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------3 SQTY------------------------15 PCTFREE----------------------0 FREEPAGE---------------------0
       ALLOCUNIT--------------------T STORTYPE---------------------I COMPRESS---------------(BLANK) TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF RBA_FORMAT------------EXTENDED TYPE-------------------------R PAGENUM----------------------A
       DSSIZE-----------------4194304 PGSIZE-----------------------4 BPOOL----------------------BP0 MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT STORNAME--------------ARULARSG
     STATISTICS
       CARD-------------------------0 NACTIVE---------------------10 NPAGES-----------------------0 ROWAVG-----------------------0
       ROWMAXFOUND------------------0 ROWMINFOUND------------------0 AVGNONCOMPROWLEN----------(-1) DIRTY------------------------0
       FULL-------------------------0 FARINDREF--------------------0 NEARINDREF-------------------0 PERCACTIVE-------------------0
       PCTPAGES---------------------0 PERCDROP---------------------0 REORGSPACE-------------------1 REORGSPACE_KB---------------48
       PCTUSED---------------------33 PQTYROWS---------------------0
     ALLOCATION
       IPREFIX----------------------I SPACE------------------------3 SPACE_KB-------------------144 NUMDATASETS------------------1
       EXTENTS----------------------1 VOLCOUNT---------------------1 DEVTYPE-------------------3390 VOLUME------------------NGT072