Example 8 — LOAD REPLACE with ANALYZE PAUSE

//  JOBCARD
//********************** AMUEX08 *************************************
//********************************************************************
//*  LOAD REPLACE with ANALYZE PAUSE
//*====================================================================
//*  Replace "DB2SYS" by your DB2 subsystem name.                     *
//*  Use your DB2 product install libraries for STEPLIBS :            *
//*     PRODUCT.LIBRARIES                                             *
//*     DB2.DSNEXIT                                                   *
//*     DB2.DSNLOAD                                                   *
//*====================================================================
//EXAMPLE8 EXEC PGM=AMUUMAIN,
//             PARM='DB2SYS,AMUEX08,NEW,,MSGLEVEL(1),AMU$OPTO'
//*                  SSID,UTILID ,RSTART,NOTIFY,MSGLEVEL
//STEPLIB  DD DISP=SHR,DSN=PRODUCT.LIBRARIES
//         DD DSN=DB2.DSNEXIT,DISP=SHR
//         DD DSN=DB2.DSNLOAD,DISP=SHR
//*
//SYSPRINT  DD  DSN=AMU.EXAMPL08.SYSPRINTA,
//            UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG)
//SYSOUT   DD SYSOUT=*
//UTPRINT  DD SYSOUT=*
//*
//SYSREC1  DD DISP=SHR,DSN=AMU.INPUT.EXAMPL08.SYSREC.DTA112
//SYSREC2  DD DISP=SHR,DSN=AMU.INPUT.EXAMPL08.SYSREC.DTA113
//SYSREC3  DD DISP=SHR,DSN=AMU.INPUT.EXAMPL08.SYSREC.DTA114
//SYSREC4  DD DISP=SHR,DSN=AMU.INPUT.EXAMPL08.SYSREC.DTA115
//*
//SORTOUT1 DD DSN=AMU.EXAMPL08.SORTOUT1,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SORTOUT2 DD DSN=AMU.EXAMPL08.SORTOUT2,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SORTOUT3 DD DSN=AMU.EXAMPL08.SORTOUT3,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SORTOUT4 DD DSN=AMU.EXAMPL08.SORTOUT4,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SORTOUT5 DD DSN=AMU.EXAMPL08.SORTOUT5,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//*
//SYSERR   DD DSN=AMU.EXAMPL08.SYSERR,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SYSDISC  DD DSN=AMU.EXAMPL08.SYSDISC,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//*
//SYSUT101 DD DSN=AMU.EXAMPL08.SYSUT1,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//*
//SORTWK01 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK02 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK03 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK04 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK05 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK06 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK07 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK08 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK09 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK10 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK11 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK12 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//*
//BMCCPY01 DD DSN=AMU.EXAMPL08.COPY01,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY02 DD DSN=AMU.EXAMPL08.COPY02,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY03 DD DSN=AMU.EXAMPL08.COPY03,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY04 DD DSN=AMU.EXAMPL08.COPY04,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY05 DD DSN=AMU.EXAMPL08.COPY05,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY06 DD DSN=AMU.EXAMPL08.COPY06,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY07 DD DSN=AMU.EXAMPL08.COPY07,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY08 DD DSN=AMU.EXAMPL08.COPY08,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY09 DD DSN=AMU.EXAMPL08.COPY09,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY10 DD DSN=AMU.EXAMPL08.COPY10,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//*
//SYSIN    DD *
  LOAD REPLACE ORDER YES
    PRELOAD CONTINUE
    UPDATEDB2STATS YES
    CENTURY(1900,1999)
    REDEFINE NO
  INTO TABLE EXAMPLE8.TBL1
      (DATE_OF_SALE        POSITION(72:77) DATE-2 EXTERNAL
      ,SALES_TRANS_ID      POSITION(52:61) INTEGER EXTERNAL
      ,SALES_ITEM_ID       POSITION(1:10)  CHARACTER
      ,SALES_QTY           POSITION(11:21) INTEGER EXTERNAL
      ,SALES_PR_PER_ITEM   POSITION(22:30) DECIMAL EXTERNAL(9,2)
      ,SALES_TOTAL_TX      POSITION(31:39) DECIMAL EXTERNAL(9,2)
      ,SALES_TOTAL         POSITION(42:50) DECIMAL EXTERNAL(9,2)
      ,SELLER_ID           POSITION(62:71) CHARACTER
      )
  LOG NO
  COPY YES INLINE NO REGISTER NONE
  ANALYZE PAUSE
  DDTYPE   LOCPFCPY  ACTIVE NO
/*
//*====================================================================
//RESTART8 EXEC PGM=AMUUMAIN,
//             PARM='DB2SYS,AMUEX08,RESTART,,MSGLEVEL(1),AMU$OPTO'
//*                  SSID,UTILID ,RSTART,NOTIFY,MSGLEVEL
//STEPLIB  DD DISP=SHR,DSN=PRODUCT.LIBRARIES
//         DD DSN=DB2.DSNEXIT,DISP=SHR
//         DD DSN=DB2.DSNLOAD,DISP=SHR
//*
//SYSPRINT  DD  DSN=AMU.EXAMPL08.SYSPRINTB,
//            UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG)
//SYSOUT   DD SYSOUT=*
//UTPRINT  DD SYSOUT=*
//ASUSRPRT  DD  DSN=AMU.EXAMPL08.ASUSRPRTB,
//            UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG)
//*
//SYSREC1  DD DISP=SHR,DSN=AMU.INPUT.EXAMPL08.SYSREC.DTA112
//SYSREC2  DD DISP=SHR,DSN=AMU.INPUT.EXAMPL08.SYSREC.DTA113
//SYSREC3  DD DISP=SHR,DSN=AMU.INPUT.EXAMPL08.SYSREC.DTA114
//SYSREC4  DD DISP=SHR,DSN=AMU.INPUT.EXAMPL08.SYSREC.DTA115
//*
//SORTOUT1 DD DSN=AMU.EXAMPL08.SORTOUT1,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SORTOUT2 DD DSN=AMU.EXAMPL08.SORTOUT2,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SORTOUT3 DD DSN=AMU.EXAMPL08.SORTOUT3,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SORTOUT4 DD DSN=AMU.EXAMPL08.SORTOUT4,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SORTOUT5 DD DSN=AMU.EXAMPL08.SORTOUT5,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//*
//SYSERR   DD DSN=AMU.EXAMPL08.SYSERR,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SYSDISC  DD DSN=AMU.EXAMPL08.SYSDISC,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//*
//SYSUT101 DD DSN=AMU.EXAMPL08.SYSUT1,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//*
//SORTWK01 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK02 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK03 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK04 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK05 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK06 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK07 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK08 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK09 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK10 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK11 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK12 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//*
//BMCCPY01 DD DSN=AMU.EXAMPL08.COPY01,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//BMCCPY02 DD DSN=AMU.EXAMPL08.COPY02,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//BMCCPY03 DD DSN=AMU.EXAMPL08.COPY03,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//BMCCPY04 DD DSN=AMU.EXAMPL08.COPY04,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//BMCCPY05 DD DSN=AMU.EXAMPL08.COPY05,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//BMCCPY06 DD DSN=AMU.EXAMPL08.COPY06,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//BMCCPY07 DD DSN=AMU.EXAMPL08.COPY07,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//BMCCPY08 DD DSN=AMU.EXAMPL08.COPY08,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//BMCCPY09 DD DSN=AMU.EXAMPL08.COPY09,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//BMCCPY10 DD DSN=AMU.EXAMPL08.COPY10,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//*
//SYSIN    DD *
  LOAD REPLACE ORDER YES
    PRELOAD CONTINUE
    UPDATEDB2STATS YES
    CENTURY(1900,1999)
    REDEFINE NO
  INTO TABLE EXAMPLE8.TBL1
      (DATE_OF_SALE        POSITION(72:77) DATE-2 EXTERNAL
      ,SALES_TRANS_ID      POSITION(52:61) INTEGER EXTERNAL
      ,SALES_ITEM_ID       POSITION(1:10)  CHARACTER
      ,SALES_QTY           POSITION(11:21) INTEGER EXTERNAL
      ,SALES_PR_PER_ITEM   POSITION(22:30) DECIMAL EXTERNAL(9,2)
      ,SALES_TOTAL_TX      POSITION(31:39) DECIMAL EXTERNAL(9,2)
      ,SALES_TOTAL         POSITION(42:50) DECIMAL EXTERNAL(9,2)
      ,SELLER_ID           POSITION(62:71) CHARACTER
      )
  LOG NO
  COPY YES INLINE NO REGISTER NONE
  ANALYZE PAUSE
  DDTYPE   LOCPFCPY  ACTIVE NO

1                          *************  B M C   L O A D P L U S   F O R   D B 2    V13R1.00 ************
                                             (C) COPYRIGHT 1990 - 2022 BMC SOFTWARE, INC.
                           LOADPLUS TECHNOLOGY IS PROTECTED BY U.S. PATENT NUMBERS 7,664,790 AND 7,930,291
-BMC50001I UTILITY EXECUTION STARTING    9/13/2022   17:10:51 ...
 BMC50002I UTILITY ID = 'AMUEX08'.  DB2 SUBSYSTEM ID = 'DEMO'.  OPTION MODULE = 'AMU$OPTS'.
 BMC50471I z/OS 2.4.0,PID=HBB77C0,DFSMS FOR Z/OS=2.4.0,DB2=13.1.501
 BMC50471I REGION=0M,BELOW 16M=8.5M,ABOVE 16M=1,004.7M,IEFUSI=NO,CPUs=9,GPs=5,zIIPs=4
 BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
 BMC50471I SMFID=DB2B,JOBID=J0202478,JOB=AMUEX08,STEP=RESTART8,CPU=3931-612 (z16)/1.47,76.0G
0
 BMC50471I LOADPLUS FOR DB2--V13.01.00 SPE2207
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I DB2 UTILITIES COMMON CODE--V13.01.00 SPE2207
 BMC50471I   MAINT: BQU4035
 BMC50471I SOLUTION COMMON CODE--V13.01.00 SPE2210
 BMC50471I   MAINT: BPJ2315  BPJ2337  BPJ2341
 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 SPE2210
 BMC50471I   MAINT: BQU4213
 BMC50471I EXTENDED BUFFER MANAGER--V06.02.01
 BMC50471I   MAINT: BPE0443  BPE0445  BPE0447  BPE0449  BPE0450  BPE0451  BPE0452  BPE0455  BPE0456  BPE0457  BPE0460  BPE0463
 BMC50471I          BPE0467  BPE0468  BPE0469  BPE0473  BPE0474  BPE0475  BPE0479  BPE0480  BPE0482  BPE0487  BPE0488  BPE0489
 BMC50471I          BPE0493  BPE0497  BPE0498  BPE0501  BPE0503  BPE0507  BPE0512  BPE0513  BPE0517  BPE0518  BPE0519  BPE0523
 BMC50471I          BPE0524  BPE0527  BPE0528  BPE0530  BPE0531  BPE0534  BPE0535  BPE0540  BPE0541  BPE0542  BPE0545  BPE0549
 BMC50471I          BPE0551  BPE0552  BPE0555  BPE0556  BPE0557  BPE0560  BPE0561
 BMC50471I High-speed Apply Engine--V13.01.00 SPE2210
 BMC50471I   MAINT: BQU4146
0
 BMC50471I APCOMMIT=2500                           FORCE=NONE                              RULES=BMC                          
 BMC50471I APDOPTS=                                IBUFFS=20                               SDUMP=YES                          
 BMC50471I APMULTIROW=100                          IDCACHE=1000                            SHORTMEMORY=CONTINUE               
 BMC50471I APMXAGNT=10                             IDCDDN=SYSIDCIN                         SHRLEVEL=(NONE,NONE)               
 BMC50471I APRETLIM=COUNT                          IDERROR=DISCARD                         SMAX=16                            
 BMC50471I APRETVAL=5                              INDDN=SYSREC                            SMCORE=(0K,0K)                     
 BMC50471I AUTOENUMROWS=YES                        INFORI=NO                               SORTDEVT=(,SYSALLDA)               
 BMC50471I AVAILPAGEPCT=0                          INLINECP=YES                            SORTNUM=32                         
 BMC50471I CBUFFS=30                               INVALIDATECACHE=YES                     SQLDELAY=3                         
 BMC50471I CENTURY=(1950,2049)                     KEEPDICTIONARY=NO                       SQLRETRY=100                       
 BMC50471I CHEKPEND=YES                            LBUFFS=20                               SSIGNRPAUSE=NO                     
 BMC50471I COPYDDN=(BMCCPY,BMCCPZ)                 LOADDN=SORTOUT                          SSREPORT=REPORT_SWITCH             
 BMC50471I COPYLVL=FULL                            LOBAVGPCT=50                            STOP@CMT=YES                       
 BMC50471I COPYPEND=YES                            LOCKROW=YES                             STOPDELAY=1                        
 BMC50471I COPYSUBSET=NO                           LONGNAMETRUNC=MIDDLE                    STOPRETRY=300                      
 BMC50471I DELFILES=(YES,NO)                       MAPDDN=SYSMAP                           TAPEDISP=DELETE                    
 BMC50471I DISCARDLIMRC=8                          MAXP=5                                  TOTALPAGEPCT=30                    
 BMC50471I DISCARDRC=0                             MAXSORTMEMORY=0                         TSSAMPLEPCT=100                    
 BMC50471I DISCDDN=SYSDISC                         MAXTAPE=3                               UPDMAXA_AUTHID=USER                
 BMC50471I DRNDELAY=1                              MGEXTENT=CONTINUE                       UPDMAXA=NO                         
 BMC50471I DRNRETRY=255                            MINSORTMEMORY=0                         UXSTATE=SUP                        
 BMC50471I DRNWAIT=NONE                            MSGLEVEL=1                              WBUFFS=(20,10)                     
 BMC50471I DSNUEXIT=(NONE,ASM)                     OPNDB2ID=YES                            WORKDDN=SYSUT1                     
 BMC50471I DSNUTILB=YES                            ORIGDISP=DELETE                         WORKUNIT=SYSALLDA                  
 BMC50471I ENFORCE=CHECK                           PAUSEDISCARDRC=4                        WRLOG=NO                           
 BMC50471I ERRDDN=SYSERR                           PLAN=AMU1310I                           XBLKS=3                            
 BMC50471I EXCLDUMP=(X37,X22,X06)                  PREFORMAT=NO                            XMLAVGSIZE=10240                   
 BMC50471I FASTSWITCH=NO                           PRELOAD=LOAD                            ZEROROWRC=0                        
 BMC50471I FILECHK=WARN                            RCVYDDN=(BMCRCY,BMCRCZ)                 ZIIP=ENABLED                       
 BMC50471I FORCE_AT=(START,3)                      REDEFINE=YES                                                               
 BMC50471I FORCE_RPT=NO                            RENMMAX=30                                                                 
0
 BMC50471I APCOLLECTION=
 BMC50471I APOWNER=
0
 BMC50470I DDTYPE   = LOAD                               WORK                                 SORTWORK                           
 BMC50470I ACTIVE   = YES                                YES                                  NO                                 
 BMC50470I IFALLOC  = USE                                USE                                  USE                                
 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   = ERROR                              DISCARD                              LOCPFCPY                           
 BMC50470I ACTIVE   = YES                                YES                                  YES                                
 BMC50470I IFALLOC  = USE                                USE                                  USE                                
 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 = N/A                                N/A                                  5                                  
 BMC50470I GDGEMPTY = N/A                                N/A                                  NO                                 
 BMC50470I GDGSCRAT = N/A                                N/A                                  NO                                 
0
 BMC50470I DDTYPE   = LOCBFCPY                           REMPFCPY                             REMBFCPY                           
 BMC50470I ACTIVE   = NO                                 NO                                   NO                                 
 BMC50470I IFALLOC  = USE                                USE                                  USE                                
 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   = SYSMAP                             LOCPLCPY                             LOCBLCPY                           
 BMC50470I ACTIVE   = YES                                YES                                  NO                                 
 BMC50470I IFALLOC  = USE                                USE                                  USE                                
 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    = N/A                                                                                                        
 BMC50470I RETPD    = N/A                                                                                                        
 BMC50470I GDGLIMIT = N/A                                5                                    5                                  
 BMC50470I GDGEMPTY = N/A                                NO                                   NO                                 
 BMC50470I GDGSCRAT = N/A                                NO                                   NO                                 
0
 BMC50470I DDTYPE   = REMPLCPY                           REMBLCPY                             LOCPXCPY                           
 BMC50470I ACTIVE   = NO                                 NO                                   YES                                
 BMC50470I IFALLOC  = USE                                USE                                  USE                                
 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   = LOCBXCPY                           REMPXCPY                             REMBXCPY                           
 BMC50470I ACTIVE   = NO                                 NO                                   NO                                 
 BMC50470I IFALLOC  = USE                                USE                                  USE                                
 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
 BMC50483I LOAD       DSNPAT=AMU.&UTILPFX.&DDNAME
 BMC50483I WORK       DSNPAT=AMU.&UTILPFX.&DDNAME
 BMC50483I SORTWORK   DSNPAT=AMU.&UTILPFX.&DDNAME
 BMC50483I ERROR      DSNPAT=AMU.&UTILPFX.&DDNAME
 BMC50483I DISCARD    DSNPAT=AMU.&UTILPFX.&DDNAME
 BMC50483I SYSMAP     DSNPAT=AMU.&UTILPFX.&DDNAME
0
 BMC50483I LOCPFCPY   DSNPAT=AMU.&UTILPFX.&DDNAME
 BMC50483I LOCBFCPY   DSNPAT=AMU.&UTILPFX.&DDNAME
 BMC50483I REMPFCPY   DSNPAT=AMU.&UTILPFX.&DDNAME
 BMC50483I REMBFCPY   DSNPAT=AMU.&UTILPFX.&DDNAME
0
 BMC50483I LOCPLCPY   DSNPAT=AMU.&UTILPFX.&DDNAME
 BMC50483I LOCBLCPY   DSNPAT=AMU.&UTILPFX.&DDNAME
 BMC50483I REMPLCPY   DSNPAT=AMU.&UTILPFX.&DDNAME
 BMC50483I REMBLCPY   DSNPAT=AMU.&UTILPFX.&DDNAME
0
 BMC50483I LOCPXCPY   DSNPAT=AMU.&UTILPFX.&DDNAME
 BMC50483I LOCBXCPY   DSNPAT=AMU.&UTILPFX.&DDNAME
 BMC50483I REMPXCPY   DSNPAT=AMU.&UTILPFX.&DDNAME
 BMC50483I REMBXCPY   DSNPAT=AMU.&UTILPFX.&DDNAME
0
 
 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 (-05: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_BMCSMARTSWITCH='BMCUTIL.CMN_BMCSWITCH'
 BMC50471I BMC_BMCSSTRACKING ='BMCUTIL.CMN_BMCSSTRACK'
 BMC50003I RESTARTING UTILITY: COMMAND = 'LOAD', PHASE = 'PRELOAD'
0
0
 BMC50102I   LOAD REPLACE ORDER YES
 BMC50102I     PRELOAD CONTINUE
 BMC50102I     UPDATEDB2STATS YES
 BMC50102I     CENTURY(1900,1999)
 BMC50102I     REDEFINE NO
 BMC50102I   INTO TABLE EXAMPLE8.TBL1
 BMC50102I       (DATE_OF_SALE        POSITION(72:77) DATE-2 EXTERNAL
 BMC50102I       ,SALES_TRANS_ID      POSITION(52:61) INTEGER EXTERNAL
 BMC50102I       ,SALES_ITEM_ID       POSITION(1:10)  CHARACTER
 BMC50102I       ,SALES_QTY           POSITION(11:21) INTEGER EXTERNAL
 BMC50102I       ,SALES_PR_PER_ITEM   POSITION(22:30) DECIMAL EXTERNAL(9,2)
 BMC50102I       ,SALES_TOTAL_TX      POSITION(31:39) DECIMAL EXTERNAL(9,2)
 BMC50102I       ,SALES_TOTAL         POSITION(42:50) DECIMAL EXTERNAL(9,2)
 BMC50102I       ,SELLER_ID           POSITION(62:71) CHARACTER
 BMC50102I       )
 BMC50102I   LOG NO
 BMC50102I   COPY YES INLINE NO REGISTER NONE
 BMC50102I   ANALYZE PAUSE
 BMC50102I   DDTYPE   LOCPFCPY  ACTIVE NO
 
 BMC51421I NO FIELD SPECIFICATION FOR COLUMN 'SALES_ITEM_DESC               '.  VALUE IS DEFAULTED
 BMC51421I NO FIELD SPECIFICATION FOR COLUMN 'ENTRY_TIMESTAMP               '.  VALUE IS DEFAULTED
 BMC51561I CALCULATED NUMBER OF INPUT RECORDS = 18945 USING A SCALING FACTOR OF 100%
 BMC50004I UTILINIT PHASE COMPLETE.  ELAPSED TIME = 00:00:00
 
 BMC50425I &JOBNAME  = AMUEX08   &STEPNAME = RESTART8  &DB       = AMUEX8DB  &TS       = EX8TS     &UID      = MVSRXO3
 BMC50425I &RESUME   = N         &REPLACE  = Y         &DATE     = 091322    &TIME     = 171051    &SSID     = DEMO    
 BMC50425I &UTIL     = AMUEX08   &UTILPFX  = AMUEX08   &UTILSFX  =           &DATE8    = 09132022  &GRPNM    = DEMO    
 BMC50425I &VCAT     = DEMOCAT   &TIME4    = 1710      &DATEJ    = 2022256   &JDATE    = 22256                         
 
 BMC50445I LOAD PLUS DYNAMIC FILE ALLOCATION REPORT
 
 BMC50446I                                                       UNIT OR                      KBYTES   KBYTES     ALOC      ALOC     
 BMC50447I DDNAME   DSNAME                                       DATACLAS MGMTCLAS STORCLAS      PRI      SEC      PRI       SEC     
 
 BMC50448I SORTOUT6 AMU.AMUEX08.SORTOUT6                         SYSALLDA                        236       59        5         2  TRK
 BMC50448I SORTOUT7 AMU.AMUEX08.SORTOUT7                         SYSALLDA                        236       59        5         2  TRK
 BMC50448I SORTOUT8 AMU.AMUEX08.SORTOUT8                         SYSALLDA                        236       59        5         2  TRK
 BMC50448I SORTOUT9 AMU.AMUEX08.SORTOUT9                         SYSALLDA                        236       59        5         2  TRK
 BMC50448I SYSUT102 AMU.AMUEX08.SYSUT102                         SYSALLDA                        408       41        8         1  TRK
 
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8436K, ABOVE 16M = 1002248K, CPUS = 5
 BMC50479I TOTAL PAGES: 12904687, ALLOWED: 3871406; AVAILABLE PAGES: 6618890, ALLOWED: 0
 BMC51495I PRELOAD OPTIMIZATION, RC = 0, #SORTS = 9, #READERS = 4, INDEX TASKS = 1, TIME = 85248
 BMC51495I PRELOAD OPTIMIZATION, RC = 14, #SORTS = 9, #READERS = 3, INDEX TASKS = 1, TIME = 92048
 BMC51495I PRELOAD OPTIMIZATION, RC = 14, #SORTS = 9, #READERS = 2, INDEX TASKS = 1, TIME = 105728
 BMC51495I PRELOAD OPTIMIZATION, RC = 14, #SORTS = 9, #READERS = 1, INDEX TASKS = 1, TIME = 146688
 BMC51495I PRELOAD OPTIMIZATION, RC = 14, #SORTS = 8, #READERS = 4, INDEX TASKS = 1, TIME = 92672
 BMC51495I PRELOAD OPTIMIZATION, RC = 14, #SORTS = 8, #READERS = 3, INDEX TASKS = 1, TIME = 99472
 BMC51495I PRELOAD OPTIMIZATION, RC = 14, #SORTS = 8, #READERS = 2, INDEX TASKS = 1, TIME = 113152
 BMC51495I PRELOAD OPTIMIZATION, RC = 14, #SORTS = 8, #READERS = 1, INDEX TASKS = 1, TIME = 154112
 BMC51496I PRELOAD ANALYZE, #SORTS = 9, #READERS = 4, INDEX TASKS = 1
 BMC50486I 14: BMCSORT STARTED, 468K BELOW 16M, 1492K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 12: BMCSORT STARTED, 372K BELOW 16M, 1396K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 8: BMCSORT STARTED, 372K BELOW 16M, 1396K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 9: BMCSORT STARTED, 372K BELOW 16M, 1396K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 11: BMCSORT STARTED, 372K BELOW 16M, 1396K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 5: BMCSORT STARTED, 396K BELOW 16M, 1420K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 7: BMCSORT STARTED, 372K BELOW 16M, 1396K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 10: BMCSORT STARTED, 372K BELOW 16M, 1396K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 6: BMCSORT STARTED, 372K BELOW 16M, 1396K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 13: BMCSORT STARTED, 372K BELOW 16M, 1396K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50481I 4: READ TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 3: READ TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 4: READ TASK, XBLK XFERS = 7, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51478I PRELOAD STATISTICS:  854 PHYSICAL (854 LOGICAL) RECORDS READ FROM SYSREC4
 BMC51510I 3: READ TASK, XBLK XFERS = 9, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51478I PRELOAD STATISTICS:  1735 PHYSICAL (1735 LOGICAL) RECORDS READ FROM SYSREC3
 BMC50481I 2: READ TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 1: READ TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 2: READ TASK, XBLK XFERS = 10, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51478I PRELOAD STATISTICS:  3442 PHYSICAL (3442 LOGICAL) RECORDS READ FROM SYSREC2
 BMC51510I 1: READ TASK, XBLK XFERS = 21, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51478I PRELOAD STATISTICS:  10000 PHYSICAL (10000 LOGICAL) RECORDS READ FROM SYSREC1
 BMC50481I 8: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 5: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 7: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 12: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 9: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 13: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 10: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 6: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 11: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 9
 BMC50481I 8: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 8: SORT TASK, XBLK XFERS = 5, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 8
 BMC50481I 5: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 5: SORT TASK, XBLK XFERS = 5, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 6
 BMC50481I 10: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 7
 BMC50481I 7: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 10: SORT TASK, XBLK XFERS = 4, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51510I 7: SORT TASK, XBLK XFERS = 5, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 3
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 2
 BMC50481I 12: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 12: SORT TASK, XBLK XFERS = 5, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 10
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 4
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 1
 BMC50481I 6: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50481I 9: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 6: SORT TASK, XBLK XFERS = 3, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51510I 9: SORT TASK, XBLK XFERS = 5, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 5
 BMC50481I 13: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 13: SORT TASK, XBLK XFERS = 5, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50481I 11: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 11: SORT TASK, XBLK XFERS = 26, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50481I 14: INDEX SORT COMPLETE.  ELAPSED TIME = 00:00:02
 BMC51505E DUPLICATE KEY FOUND FOR INDEX 'EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000000', RECORD NO. = 100 OF SYSREC4
 BMC51506E     KEY VALUE = ' 1/25/1990,100', RID-1 = X'0080001B32', RID-2 = X'0080001B32'
 BMC51505E DUPLICATE KEY FOUND FOR INDEX 'EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000000', RECORD NO. = 1 OF SYSREC3
 BMC51506E     KEY VALUE = ' 1/25/1990,100', RID-1 = X'0080001B32', RID-2 = X'0080001C01'
 BMC50481I 14: INDEX TASK COMPLETE.  ELAPSED TIME = 00:00:02
 BMC51510I 14: INDEX TASK, XBLK XFERS = 16, EMPTY WAITS = 0, FULL WAITS = 17
 BMC50476I DDNAME = SYSREC1, I/OS = 2, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC2, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC3, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC4, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT1, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT2, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT3, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT4, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT5, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT6, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT7, I/OS = 4, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT8, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT9, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSUT102, I/OS = 4, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSUT101, I/OS = 4, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSERR, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC51507I XBLKS = 91, XFERS = 63, EMPTY WAITS = 0, FULL WAITS =17
 BMC50486I 1001: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 1002: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50476I DDNAME = SYSREC3, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC4, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSDISC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
0
 BMC51521I LOADPLUS ERROR SUMMARY REPORT FOR TABLE EXAMPLE8.TBL1
 BMC51522I    INPUT        DISCARD  DISCARD               RELATED
 BMC51523I  ID: RECORD #    RECORD#  TYPE                 ID: RECORD #  FIELD, INDEX, OR CONSTRAINT NAME
 
 BMC51524E   3:         1          1 DUPLICATE KEY         4:       100 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000000
 
 BMC51524E   4:       100          2 DUPLICATE KEY         4:       100 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000000
 BMC51510I 1001: DISCARD TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 0
 
 BMC51510I 1002: DISCARD TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 1
 BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51471I PRELOAD STATISTICS:  11031 ROWS SELECTED FOR PARTITION 1
 BMC51486I LOADING OF DATASET 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A001' WILL REQUIRE 171 PAGES
 BMC51471I PRELOAD STATISTICS:  522 ROWS SELECTED FOR PARTITION 2
 BMC51486I LOADING OF DATASET 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A002' WILL REQUIRE 37 PAGES
 BMC51471I PRELOAD STATISTICS:  529 ROWS SELECTED FOR PARTITION 3
 BMC51486I LOADING OF DATASET 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A003' WILL REQUIRE 37 PAGES
 BMC51471I PRELOAD STATISTICS:  577 ROWS SELECTED FOR PARTITION 4
 BMC51486I LOADING OF DATASET 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A004' WILL REQUIRE 38 PAGES
 BMC51471I PRELOAD STATISTICS:  543 ROWS SELECTED FOR PARTITION 5
 BMC51486I LOADING OF DATASET 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A005' WILL REQUIRE 37 PAGES
 BMC51471I PRELOAD STATISTICS:  109 ROWS SELECTED FOR PARTITION 6
 BMC51486I LOADING OF DATASET 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A006' WILL REQUIRE 29 PAGES
 BMC51471I PRELOAD STATISTICS:  236 ROWS SELECTED FOR PARTITION 7
 BMC51486I LOADING OF DATASET 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A007' WILL REQUIRE 31 PAGES
 BMC51471I PRELOAD STATISTICS:  793 ROWS SELECTED FOR PARTITION 8
 BMC51486I LOADING OF DATASET 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A008' WILL REQUIRE 42 PAGES
 BMC51471I PRELOAD STATISTICS:  789 ROWS SELECTED FOR PARTITION 9
 BMC51486I LOADING OF DATASET 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A009' WILL REQUIRE 42 PAGES
 BMC51471I PRELOAD STATISTICS:  900 ROWS SELECTED FOR PARTITION 10
 BMC51486I LOADING OF DATASET 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A010' WILL REQUIRE 44 PAGES
 BMC51490I LOADING OF DATASET 'DEMOCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A001' WILL REQUIRE 79 PAGES (APPROX.)
 BMC51488I LOADING OF DATASET 'DEMOCAT.DSNDBD.AMUEX8DB.LONG11YX.I0001.A001' MAY REQUIRE 92 PAGES
 BMC51472I PRELOAD PHASE STATISTICS:  16029 ROWS SELECTED FOR SPACE 'AMUEX8DB.EX8TS', 2 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
 BMC51479I PRELOAD PHASE STATISTICS:  2 PHYSICAL (2 LOGICAL) RECORDS DISCARDED TO SYSDISC
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I PRELOAD PHASE COMPLETE.  ELAPSED TIME = 00:00:03
 
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8268K, ABOVE 16M = 1017440K, CPUS = 5
 BMC50479I TOTAL PAGES: 12898493, ALLOWED: 3869548; AVAILABLE PAGES: 6613750, ALLOWED: 0
 BMC51498I LOAD OPTIMIZATION, RC = 0, #LOAD TASKS = 9, #COPY TASKS = 9, #INDEX TASKS = 2
 BMC50486I 0: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50370I STARTING 9 IMAGE COPY TASKS
 BMC51508I MAX DATA TASKS = 9, MAX PARTS PER TASK = 2, SORTWKS PER TASK = 0, MAX OPEN PARTITIONS PER TASK = 1
 BMC51453I EXISTING ROWS IN TABLESPACE 'AMUEX8DB.EX8TS' DELETED
 BMC51508I MAX INDEX TASKS = 2, INDEXES PER TASK = 1, SORTWKS PER TASK = 12, MAX OPEN PARTITIONS PER TASK = 1
 BMC50486I 2: BMCSORT STARTED, 384K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50476I DDNAME = SYSUT101, I/OS = 2, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50481I 2: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50482I 0: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A008'
 BMC50477I 0: PARTITION =    8, ROWS/KEYS = 793, I/O WAITS = 10 ,DDNAME = SYS00036
 BMC51474I LOAD STATISTICS:  793 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 8
 BMC50476I DDNAME = SORTOUT1, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50482I 1: LOAD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A010'
 BMC50477I 1: PARTITION =   10, ROWS/KEYS = 900, I/O WAITS = 10 ,DDNAME = SYS00037
 BMC50482I 2: LOAD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A007'
 BMC50477I 2: PARTITION =    7, ROWS/KEYS = 236, I/O WAITS = 10 ,DDNAME = SYS00038
 BMC51474I LOAD STATISTICS:  900 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 10
 BMC51474I LOAD STATISTICS:  236 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 7
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A008'
 BMC50476I DDNAME = SORTOUT2, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT3, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPY08, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 42 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY08'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A007'
 BMC50476I DDNAME = BMCCPY07, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 31 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY07'
 BMC50482I 3: LOAD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A009'
 BMC50477I 3: PARTITION =    9, ROWS/KEYS = 789, I/O WAITS = 10 ,DDNAME = SYS00039
 BMC51474I LOAD STATISTICS:  789 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 9
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A010'
 BMC50476I DDNAME = SORTOUT4, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPY10, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 44 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY10'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A009'
 BMC50476I DDNAME = BMCCPY09, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 42 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY09'
 BMC50482I 4: LOAD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A002'
 BMC50477I 4: PARTITION =    2, ROWS/KEYS = 522, I/O WAITS = 8 ,DDNAME = SYS00041
 BMC51474I LOAD STATISTICS:  522 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 2
 BMC50476I DDNAME = SORTOUT5, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A002'
 BMC50476I DDNAME = BMCCPY02, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 37 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY02'
 BMC50482I 5: LOAD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A006'
 BMC50477I 5: PARTITION =    6, ROWS/KEYS = 109, I/O WAITS = 9 ,DDNAME = SYS00042
 BMC51474I LOAD STATISTICS:  109 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 6
 BMC50476I DDNAME = SORTOUT6, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A006'
 BMC50476I DDNAME = BMCCPY06, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 29 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY06'
 BMC50482I 6: LOAD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A001'
 BMC50477I 6: PARTITION =    1, ROWS/KEYS = 11031, I/O WAITS = 10 ,DDNAME = SYS00044
 BMC51474I LOAD STATISTICS:  11031 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 1
 BMC50476I DDNAME = SORTOUT7, I/OS = 2, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A001'
 BMC50476I DDNAME = BMCCPY01, I/OS = 2, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 171 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY01'
 BMC50482I 7: LOAD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A003'
 BMC50477I 7: PARTITION =    3, ROWS/KEYS = 529, I/O WAITS = 10 ,DDNAME = SYS00048
 BMC51474I LOAD STATISTICS:  529 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 3
 BMC50476I DDNAME = SORTOUT8, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A003'
 BMC50482I 8: LOAD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A004'
 BMC50477I 8: PARTITION =    4, ROWS/KEYS = 577, I/O WAITS = 9 ,DDNAME = SYS00049
 BMC51474I LOAD STATISTICS:  577 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 4
 BMC50482I 2: BUILD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEMOCAT.DSNDBD.AMUEX8DB.LONG11YX.I0001.A001'
 BMC50477I 2: PARTITION =    0, ROWS/KEYS = 16029, I/O WAITS = 6 ,DDNAME = SYS00046
 BMC50476I DDNAME = BMCCPY03, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 37 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY03'
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:02  DSN = 'DEMOCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A001'
 BMC50477I 1: PARTITION =    0, ROWS/KEYS = 16029, I/O WAITS = 7 ,DDNAME = SYS00040
 BMC50476I DDNAME = SYSUT102, I/OS = 2, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51476I BUILD STATISTICS:  16029 KEYS LOADED INTO INDEX 'EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000000'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A004'
 BMC50476I DDNAME = BMCCPY04, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 38 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY04'
 BMC51476I BUILD STATISTICS:  16029 KEYS LOADED INTO INDEX 'EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001'
 BMC50482I 8: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A005'
 BMC50477I 8: PARTITION =    5, ROWS/KEYS = 543, I/O WAITS = 9 ,DDNAME = SYS00058
 BMC51474I LOAD STATISTICS:  543 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 5
 BMC50476I DDNAME = SORTOUT9, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51475I LOAD STATISTICS:  16029 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A005'
 BMC50476I DDNAME = BMCCPY05, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 37 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY05'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR  ', DSNAME = 'AMU.EXAMP008.SYSERR'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK01', DSNAME = 'SYS22256.T170958.RA000.AMUEX08.R0845502'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK02', DSNAME = 'SYS22256.T170958.RA000.AMUEX08.R0845503'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK03', DSNAME = 'SYS22256.T170958.RA000.AMUEX08.R0845504'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK04', DSNAME = 'SYS22256.T170958.RA000.AMUEX08.R0845505'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK05', DSNAME = 'SYS22256.T170958.RA000.AMUEX08.R0845506'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK06', DSNAME = 'SYS22256.T170958.RA000.AMUEX08.R0845507'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK07', DSNAME = 'SYS22256.T170958.RA000.AMUEX08.R0845508'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK08', DSNAME = 'SYS22256.T170958.RA000.AMUEX08.R0845509'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK09', DSNAME = 'SYS22256.T170958.RA000.AMUEX08.R0845510'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK10', DSNAME = 'SYS22256.T170958.RA000.AMUEX08.R0845511'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK11', DSNAME = 'SYS22256.T170958.RA000.AMUEX08.R0845512'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK12', DSNAME = 'SYS22256.T170958.RA000.AMUEX08.R0845513'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT9', DSNAME = 'AMU.AMUEX08.SORTOUT9'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT102', DSNAME = 'AMU.AMUEX08.SYSUT102'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT8', DSNAME = 'AMU.AMUEX08.SORTOUT8'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT7', DSNAME = 'AMU.AMUEX08.SORTOUT7'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT6', DSNAME = 'AMU.AMUEX08.SORTOUT6'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT5', DSNAME = 'AMU.EXAMP008.SORTOUT5'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT4', DSNAME = 'AMU.EXAMP008.SORTOUT4'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT3', DSNAME = 'AMU.EXAMP008.SORTOUT3'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT2', DSNAME = 'AMU.EXAMP008.SORTOUT2'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT1', DSNAME = 'AMU.EXAMP008.SORTOUT1'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT101', DSNAME = 'AMU.EXAMP008.SYSUT1'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I LOAD PHASE COMPLETE.  ELAPSED TIME = 00:00:05
 
 BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR LOAD UTILITY SUCCESSFUL FOR ALL OBJECTS
 BMC50004I UTILTERM PHASE COMPLETE.  ELAPSED TIME = 00:00:01
 
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0

1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-09-13-17.10.58.258418                                          1
0
    
   INDEX --------------- EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000000
     ASSOCIATIONS
       TABLESPACE ------ AMUEX8DB.EX8TS   
       TABLE ----------- EXAMPLE8.TBL1
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------L  LOCATION------------------DEMO
       SAMPLING---------------------N      
     ATTRIBUTES
       PIECESIZE--------------4194304  TYPE TS----------------------R  UNIQUERULE-------------------U  KEYLENGTH--------------------9
       SPARSE-----------------------N  INDEXTYPE--------------------2  CLUSTERING-------------------Y  COLCOUNT---------------------2
       INDEXSPACE------------LONGNAME  PGSIZE-----------------------4  EXTTYPE----------------(BLANK)  COMPRESS---------------------N
       PAGENUM----------------------A  DSSIZE-----------------------0  COLNAME-----------DATE_OF_SALE  
     STATISTICS
       FIRSTKEYCARD---------------132  FULLKEYCARD--------------16029  NACTIVE---------------------80  TBCARDF------------------16029
       NUMNONLEAF-------------------1  NLEVELS----------------------2  CLUSTERRATIO----------------99  NLEAF-----------------------76
       AVGKEYLEN--------------------9  REORGSPACE------------------15  REORGSPACE_KB--------------720  REORGNLEVELS-----------------2
       HIGH2K-------------X'19980306'  HIGH2K (CHAR)-------------.q..  LOW2K--------------X'19010301'  LOW2K (CHAR)--------------....
       DATAREPEAT-----------------248      
     ALLOCATION
       SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1  
    
   INDEXPART ----------- EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000000
     ASSOCIATIONS
       TABLESPACE ------ AMUEX8DB.EX8TS   
       TABLE ----------- EXAMPLE8.TBL1
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------L  LOCATION----------------(NULL)
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-------------------------1  SQTY-------------------------1  PCTFREE---------------------10  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  NLAVGKEYLEN------------------9  RBA_FORMAT------------EXTENDED
       PAGENUM----------------------A  DSSIZE-----------------------0  VCATNAME---------------DEMOCAT  STORNAME--------------AMUQASTO
     STATISTICS
       FIRSTKEYCARD---------------132  FULLKEYCARD--------------16029  CARD---------------------16029  NACTIVE---------------------80
       CLUSTERRATIO----------------99  NUMNONLEAF-------------------1  NLEVELS----------------------2  FAROFFPOS--------------------9
       NEAROFFPOS-------------------0  LEAFDIST---------------------1  NLEAF-----------------------76  FREE------------------------34
       FULL-------------------------0  AVGKEYLEN--------------------9    
       LEAFNEAR---------------------1  LEAFFAR----------------------0  PSEUDO_DEL_RIDS--------------0  REORGSPACE------------------15
       REORGSPACE_KB--------------720  REORGNLEVELS-----------------2  PCTUSED--------------------100  PQTYROWS-----------------37832
       DATAREPEAT-----------------248      
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------DEVS0U
     
   COLUMN -------------- DATE_OF_SALE
     ASSOCIATIONS
       TABLESPACE ------ AMUEX8DB.EX8TS   
       TABLE ----------- EXAMPLE8.TBL1
     ATTRIBUTES
       COLNO------------------------9  COLTYPE-------------------DATE  LENGTH-----------------------4  NULLS------------------------N
       SCALE------------------------0      
     STATISTICS
       COLCARD--------------------132  COLNULLS---------------------0  COLAVG-----------------------4  COLMIN-----------------------4
       COLMAX-----------------------4      
       HIGH2K-------------X'19980306'  HIGH2K (CHAR)-------------.q..  LOW2K--------------X'19010301'  LOW2K (CHAR)--------------....

1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-09-13-17.10.58.258418                                          2
0
       MOST FREQUENT VALUES
       FREQUENCY-------------0.087342  COLVAL-------------X'19820617'    
                                       (CHAR)--------------------.b..    
       FREQUENCY-------------0.043234  COLVAL-------------X'19891025'    
                                       (CHAR)--------------------.i..    
       FREQUENCY-------------0.042985  COLVAL-------------X'19900125'    
                                       (CHAR)--------------------....    
       FREQUENCY-------------0.042673  COLVAL-------------X'19820705'    
                                       (CHAR)--------------------.b..    
       FREQUENCY-------------0.033627  COLVAL-------------X'19820810'    
                                       (CHAR)--------------------.b..    
       FREQUENCY-------------0.028823  COLVAL-------------X'19850224'    
                                       (CHAR)--------------------.e..    
       FREQUENCY-------------0.026203  COLVAL-------------X'19840321'    
                                       (CHAR)--------------------.d..    
       FREQUENCY-------------0.025766  COLVAL-------------X'19861012'    
                                       (CHAR)--------------------.f..    
       FREQUENCY-------------0.025766  COLVAL-------------X'19830101'    
                                       (CHAR)--------------------.c..    
       FREQUENCY-------------0.008297  COLVAL-------------X'19880514'    
                                       (CHAR)--------------------.h..    
     
   KEYCARD ------------- DATE_OF_SALE
     ASSOCIATIONS
       TABLESPACE ------ AMUEX8DB.EX8TS   
       TABLE ----------- EXAMPLE8.TBL1
     ATTRIBUTES AND STATISTICS
       COLUMN------------DATE_OF_SALE  COLCARD--------------------132  COLTYPE-------------------DATE  LENGTH-----------------------4
       COLUMN----------SALES_TRANS_ID  COLCARD------------------16029  COLTYPE----------------INTEGER  LENGTH-----------------------4
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-09-13-17.10.58.258418                                          1
0
    
   INDEX --------------- EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
     ASSOCIATIONS
       TABLESPACE ------ AMUEX8DB.EX8TS   
       TABLE ----------- EXAMPLE8.TBL1
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------L  LOCATION------------------DEMO
       SAMPLING---------------------N      
     ATTRIBUTES
       PIECESIZE--------------4194304  TYPE TS----------------------R  UNIQUERULE-------------------D  KEYLENGTH-------------------10
       SPARSE-----------------------N  INDEXTYPE--------------------2  CLUSTERING-------------------N  COLCOUNT---------------------1
       INDEXSPACE------------LONG11YX  PGSIZE-----------------------4  EXTTYPE----------------(BLANK)  COMPRESS---------------------N
       PAGENUM----------------------A  DSSIZE-----------------------0  COLNAME--------------SELLER_ID  
     STATISTICS
       FIRSTKEYCARD----------------66  FULLKEYCARD-----------------66  NACTIVE---------------------32  TBCARDF------------------16029
       NUMNONLEAF-------------------1  NLEVELS----------------------2  CLUSTERRATIO----------------95  NLEAF-----------------------28
       AVGKEYLEN-------------------10  REORGSPACE------------------15  REORGSPACE_KB--------------720  REORGNLEVELS-----------------2
       HIGH2K-----X'F8F9404A4BF8F940'  HIGH2K (CHAR)---------89 ..89   LOW2K------X'4A4B4C4D4E4A4B4C'  LOW2K (CHAR)----------..<(+..<
       DATAREPEAT----------------7670      
     ALLOCATION
       SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1  
    
   INDEXPART ----------- EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
     ASSOCIATIONS
       TABLESPACE ------ AMUEX8DB.EX8TS   
       TABLE ----------- EXAMPLE8.TBL1
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------L  LOCATION----------------(NULL)
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-------------------------1  SQTY-------------------------1  PCTFREE---------------------10  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  NLAVGKEYLEN-----------------10  RBA_FORMAT------------EXTENDED
       PAGENUM----------------------A  DSSIZE-----------------------0  VCATNAME---------------DEMOCAT  STORNAME--------------AMUQASTO
     STATISTICS
       FIRSTKEYCARD----------------66  FULLKEYCARD-----------------66  CARD---------------------16029  NACTIVE---------------------32
       CLUSTERRATIO----------------95  NUMNONLEAF-------------------1  NLEVELS----------------------2  FAROFFPOS------------------652
       NEAROFFPOS-----------------602  LEAFDIST---------------------3  NLEAF-----------------------28  FREE------------------------17
       FULL-------------------------0  AVGKEYLEN-------------------10    
       LEAFNEAR---------------------1  LEAFFAR----------------------0  PSEUDO_DEL_RIDS--------------0  REORGSPACE------------------15
       REORGSPACE_KB--------------720  REORGNLEVELS-----------------2  PCTUSED--------------------100  PQTYROWS----------------105785
       DATAREPEAT----------------7670      
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------DEVSIE
     
   COLUMN -------------- SELLER_ID
     ASSOCIATIONS
       TABLESPACE ------ AMUEX8DB.EX8TS   
       TABLE ----------- EXAMPLE8.TBL1
     ATTRIBUTES
       COLNO------------------------8  COLTYPE-------------------CHAR  LENGTH----------------------10  NULLS------------------------N
     STATISTICS
       COLCARD---------------------66  COLNULLS---------------------0  COLAVG----------------------10  COLMIN----------------------10
       COLMAX----------------------10      
       HIGH2K-----X'F8F9404A4BF8F940'  HIGH2K (CHAR)---------89 ..89   LOW2K------X'4A4B4C4D4E4A4B4C'  LOW2K (CHAR)----------..<(+..<

       MOST FREQUENT VALUES
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-09-13-17.10.58.258418                                          2
0
        FREQUENCY-------------0.235760     COLVAL-X'E2D4C9E3C8F540404040'
                                           (CHAR)--------------SMITH5    
        FREQUENCY-------------0.129453     COLVAL-X'E9C9C7C1C6D6D6E24040'
                                           (CHAR)--------------ZIGAFOOS  
        FREQUENCY-------------0.010918     COLVAL-X'E64BC14BD9C5C5C44040'
                                           (CHAR)--------------W.A.REED  
        FREQUENCY-------------0.009920     COLVAL-X'6B6C6D6E6F6B6C6D6E6F'
                                           (CHAR)--------------,%_>?,%_>?
        FREQUENCY-------------0.009920     COLVAL-X'616B6C6D6E616B6C6D6E'
                                           (CHAR)--------------/,%_>/,%_>
        FREQUENCY-------------0.009920     COLVAL-X'60616B6C6D60616B6C6D'
                                           (CHAR)---------------/,%_-/,%_
        FREQUENCY-------------0.009920     COLVAL-X'5F60616B6C5F60616B6C'
                                           (CHAR)--------------^-/,%^-/,%
        FREQUENCY-------------0.009920     COLVAL-X'5E5F60616B5E5F60616B'
                                           (CHAR)--------------;^-/,;^-/,
        FREQUENCY-------------0.009920     COLVAL-X'5D5E5F60615D5E5F6061'
                                           (CHAR)--------------);^-/);^-/
        FREQUENCY-------------0.009920     COLVAL-X'5C5D5E5F605C5D5E5F60'
                                           (CHAR)--------------*);^-*);^-
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-09-13-17.10.58.258418                                          1
0
    
 TABLESPACE ------------ AMUEX8DB.EX8TS   
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------L  LOCATION------------------DEMO
       SAMPLING---------------------N      
     ATTRIBUTES
       PARTITIONS------------------10  NTABLES----------------------1  PGSIZE-----------------------4  SEGSIZE----------------------8
       DSSIZE-----------------4194304  PAGENUM----------------------A    
       MAXROWS--------------------255  TYPE-------------------------R  ENCODING---------------------E  MAXPARTITIONS----------------0
       LOB--------------------------N  XML--------------------------N  MEMBER_CLUSTER---------(BLANK)  
     STATISTICS
       NACTIVE--------------------508  REORGSPACE-----------------150  REORGSPACE_KB-------------7200  ROWMAXFOUND-----------------74
       ROWMINFOUND-----------------27  ROWAVG----------------------56  COMPRESSRATIO-------------(-1)  
     ALLOCATION
       SPACE----------------------150  SPACE_KB------------------7200    
    
   TABLEPART ----------- AMUEX8DB.EX8TS    PART 001
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------L
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-------------------------1  SQTY-------------------------1  PCTFREE----------------------5  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------R  PAGENUM----------------------A
       DSSIZE-----------------4194304  PGSIZE-----------------------4  BPOOL----------------------BP0  MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT  STORNAME--------------AMUQASTO
     STATISTICS
       CARD---------------------11031  NACTIVE--------------------171  NPAGES---------------------145  ROWAVG----------------------48
       ROWMAXFOUND-----------------74  ROWMINFOUND-----------------27  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL-------------------------0  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE------------------76
       PCTPAGES--------------------84  PERCDROP---------------------0  REORGSPACE------------------15  REORGSPACE_KB--------------720
       PCTUSED--------------------100  PQTYROWS-----------------12315  NDICTIONARY-----------------16  PCTROWCOMP------------------82
       PAGESAVE---------------------0  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------DEVSIM
    
   TABLEPART ----------- AMUEX8DB.EX8TS    PART 002
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------L
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-------------------------1  SQTY-------------------------1  PCTFREE----------------------5  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------R  PAGENUM----------------------A
       DSSIZE-----------------4194304  PGSIZE-----------------------4  BPOOL----------------------BP0  MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT  STORNAME--------------AMUQASTO
     STATISTICS
       CARD-----------------------522  NACTIVE---------------------37  NPAGES----------------------11  ROWAVG----------------------74
       ROWMAXFOUND-----------------74  ROWMINFOUND-----------------74  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL-------------------------0  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE------------------25
       PCTPAGES--------------------29  PERCDROP---------------------0  REORGSPACE------------------15  REORGSPACE_KB--------------720
       PCTUSED--------------------100  PQTYROWS------------------7997  NDICTIONARY-----------------16  PCTROWCOMP-------------------0
       PAGESAVE----------------(-100)  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------DEVS9C
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-09-13-17.10.58.258418                                          2
0
    
   TABLEPART ----------- AMUEX8DB.EX8TS    PART 003
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------L
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-------------------------1  SQTY-------------------------1  PCTFREE----------------------5  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------R  PAGENUM----------------------A
       DSSIZE-----------------4194304  PGSIZE-----------------------4  BPOOL----------------------BP0  MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT  STORNAME--------------AMUQASTO
     STATISTICS
       CARD-----------------------529  NACTIVE---------------------37  NPAGES----------------------11  ROWAVG----------------------74
       ROWMAXFOUND-----------------74  ROWMINFOUND-----------------74  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL-------------------------0  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE------------------25
       PCTPAGES--------------------29  PERCDROP---------------------0  REORGSPACE------------------15  REORGSPACE_KB--------------720
       PCTUSED--------------------100  PQTYROWS------------------7997  NDICTIONARY-----------------16  PCTROWCOMP-------------------0
       PAGESAVE----------------(-100)  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------DEVS9H
    
   TABLEPART ----------- AMUEX8DB.EX8TS    PART 004
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------L
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-------------------------1  SQTY-------------------------1  PCTFREE----------------------5  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------R  PAGENUM----------------------A
       DSSIZE-----------------4194304  PGSIZE-----------------------4  BPOOL----------------------BP0  MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT  STORNAME--------------AMUQASTO
     STATISTICS
       CARD-----------------------577  NACTIVE---------------------38  NPAGES----------------------12  ROWAVG----------------------74
       ROWMAXFOUND-----------------74  ROWMINFOUND-----------------74  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL-------------------------0  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE------------------27
       PCTPAGES--------------------31  PERCDROP---------------------0  REORGSPACE------------------15  REORGSPACE_KB--------------720
       PCTUSED--------------------100  PQTYROWS------------------7997  NDICTIONARY-----------------16  PCTROWCOMP-------------------0
       PAGESAVE----------------(-100)  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------DEVS9A
    
   TABLEPART ----------- AMUEX8DB.EX8TS    PART 005
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------L
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-------------------------1  SQTY-------------------------1  PCTFREE----------------------5  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------R  PAGENUM----------------------A
       DSSIZE-----------------4194304  PGSIZE-----------------------4  BPOOL----------------------BP0  MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT  STORNAME--------------AMUQASTO
     STATISTICS
       CARD-----------------------543  NACTIVE---------------------37  NPAGES----------------------11  ROWAVG----------------------74
       ROWMAXFOUND-----------------74  ROWMINFOUND-----------------74  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL-------------------------0  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE------------------26
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-09-13-17.10.58.258418                                          3
0
       PCTPAGES--------------------29  PERCDROP---------------------0  REORGSPACE------------------15  REORGSPACE_KB--------------720
       PCTUSED--------------------100  PQTYROWS------------------7997  NDICTIONARY-----------------16  PCTROWCOMP-------------------0
       PAGESAVE----------------(-100)  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------DEVS32
    
   TABLEPART ----------- AMUEX8DB.EX8TS    PART 006
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------L
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-------------------------1  SQTY-------------------------1  PCTFREE----------------------5  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------R  PAGENUM----------------------A
       DSSIZE-----------------4194304  PGSIZE-----------------------4  BPOOL----------------------BP0  MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT  STORNAME--------------AMUQASTO
     STATISTICS
       CARD-----------------------109  NACTIVE---------------------29  NPAGES-----------------------3  ROWAVG----------------------74
       ROWMAXFOUND-----------------74  ROWMINFOUND-----------------74  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL-------------------------0  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE-------------------6
       PCTPAGES--------------------10  PERCDROP---------------------0  REORGSPACE------------------15  REORGSPACE_KB--------------720
       PCTUSED--------------------100  PQTYROWS------------------7997  NDICTIONARY------------------8  PCTROWCOMP-------------------0
       PAGESAVE----------------(-200)  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------DEVS9C
    
   TABLEPART ----------- AMUEX8DB.EX8TS    PART 007
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------L
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-------------------------1  SQTY-------------------------1  PCTFREE----------------------5  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------R  PAGENUM----------------------A
       DSSIZE-----------------4194304  PGSIZE-----------------------4  BPOOL----------------------BP0  MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT  STORNAME--------------AMUQASTO
     STATISTICS
       CARD-----------------------236  NACTIVE---------------------31  NPAGES-----------------------5  ROWAVG----------------------74
       ROWMAXFOUND-----------------74  ROWMINFOUND-----------------74  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL-------------------------0  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE------------------13
       PCTPAGES--------------------16  PERCDROP---------------------0  REORGSPACE------------------15  REORGSPACE_KB--------------720
       PCTUSED--------------------100  PQTYROWS------------------7997  NDICTIONARY------------------8  PCTROWCOMP-------------------0
       PAGESAVE----------------(-200)  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------DEVSIK
    
   TABLEPART ----------- AMUEX8DB.EX8TS    PART 008
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------L
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-------------------------1  SQTY-------------------------1  PCTFREE----------------------5  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------R  PAGENUM----------------------A
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-09-13-17.10.58.258418                                          4
0
       DSSIZE-----------------4194304  PGSIZE-----------------------4  BPOOL----------------------BP0  MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT  STORNAME--------------AMUQASTO
     STATISTICS
       CARD-----------------------793  NACTIVE---------------------42  NPAGES----------------------16  ROWAVG----------------------74
       ROWMAXFOUND-----------------74  ROWMINFOUND-----------------74  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL-------------------------0  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE------------------34
       PCTPAGES--------------------38  PERCDROP---------------------0  REORGSPACE------------------15  REORGSPACE_KB--------------720
       PCTUSED--------------------100  PQTYROWS------------------7997  NDICTIONARY-----------------16  PCTROWCOMP-------------------0
       PAGESAVE----------------(-100)  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------DEVSIU
    
   TABLEPART ----------- AMUEX8DB.EX8TS    PART 009
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------L
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-------------------------1  SQTY-------------------------1  PCTFREE----------------------5  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------R  PAGENUM----------------------A
       DSSIZE-----------------4194304  PGSIZE-----------------------4  BPOOL----------------------BP0  MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT  STORNAME--------------AMUQASTO
     STATISTICS
       CARD-----------------------789  NACTIVE---------------------42  NPAGES----------------------16  ROWAVG----------------------74
       ROWMAXFOUND-----------------74  ROWMINFOUND-----------------74  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL-------------------------0  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE------------------33
       PCTPAGES--------------------38  PERCDROP---------------------0  REORGSPACE------------------15  REORGSPACE_KB--------------720
       PCTUSED--------------------100  PQTYROWS------------------7997  NDICTIONARY-----------------16  PCTROWCOMP-------------------0
       PAGESAVE----------------(-100)  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------DEVSIH
    
   TABLEPART ----------- AMUEX8DB.EX8TS    PART 010
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------L
       SAMPLING---------------------N      
     ATTRIBUTES
       PQTY-------------------------1  SQTY-------------------------1  PCTFREE----------------------5  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  TYPE-------------------------R  PAGENUM----------------------A
       DSSIZE-----------------4194304  PGSIZE-----------------------4  BPOOL----------------------BP0  MEMBER_CLUSTER---------(BLANK)
       VCATNAME---------------DEMOCAT  STORNAME--------------AMUQASTO
     STATISTICS
       CARD-----------------------900  NACTIVE---------------------44  NPAGES----------------------18  ROWAVG----------------------74
       ROWMAXFOUND-----------------74  ROWMINFOUND-----------------74  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL-------------------------0  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE------------------36
       PCTPAGES--------------------40  PERCDROP---------------------0  REORGSPACE------------------15  REORGSPACE_KB--------------720
       PCTUSED--------------------100  PQTYROWS------------------7997  NDICTIONARY-----------------16  PCTROWCOMP-------------------0
       PAGESAVE-----------------(-67)  COMPRESSRATIO-------------(-1)    
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------DEVS9B
    
   TABLE --------------- EXAMPLE8.TBL1
     ASSOCIATIONS
1BMCSTATS V13.01.00 REPORT FOR DEMO V1315 (131)       TIME 2022-09-13-17.10.58.258418                                          5
0
       TABLESPACE ------ AMUEX8DB.EX8TS   
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------L  LOCATION----------------(NULL)
     STATISTICS
       CARD---------------------16029  NPAGES---------------------248  SPACE_KB------------------7200  AVGNONCOMPROWLEN----------(-1)
       ROWAVG----------------------57  ROWMAXFOUND-----------------74  ROWMINFOUND-----------------27  INDREF-----------------------0
       PCTPAGES--------------------48  PCTROWCOMP------------------56