Example 16 — LOAD RESUME YES replacing individual tables

This example illustrates replacing data in only two out of three tables in a segmented table space by specifying LOAD RESUME YES with INTO TABLE tableName REPLACE.

The table space has one non-unique clustering index and one unique nonclustering index per table.

The PRELOAD=LOAD default value in the installation options module tells LOADPLUS to use single-phase processing.

Because the LOAD command includes the ORDER YES option, LOADPLUS sorts the data rows and clustering index keys.

COPY YES INLINE NO REGISTER ALL tells LOADPLUS to create a standard image copy of the loaded table space and register it with Db2.

Related topics

Initial object status

Examples-of-LOADPLUS-jobs

Dynamic data set allocation is enabled for most data sets in the installation options module. Additionally, the JCL activates dynamic allocation for sort work data sets by specifying ACTIVE YES for DDTYPE SORTWORK. Because the installation options module includes AUTOENUMROWS=YES, the command statement does not need to include the ENUMROWS option for dynamic allocation. Message BMC51561I shows the number of input records that the utility calculated using automated file size estimation. The LOAD command also includes the DELETEFILES YES SYSDISC YES option to delete the work files, including SYSDISC if it is empty after the load completes.

RULES=BMC is specified in the options module so that the job can use extended operators, such as greater than (>) and less than (<), on the LOAD command.

Message 50041I indicates the status of zIIP processing. For this example, the ZIIP installation option is ENABLED, but an XBM subsystem was not specified. LOADPLUS automatically located an available XBM subsystem to provide zIIP processing.

In addition to the JCL and the SYSPRINT output, this example provides the results of a SELECT COUNT on the table space before and after running the load job. The second SELECT output shows that only tables TBREDE2 and TBREDE3 were replaced, leaving table TBREDE1 intact.

The following figure shows the JCL for example 16:

//  JOBCARD
//********************** AMUEX16 ************************************
//*******************************************************************
//*  LOAD RESUME YES replacing individual tables
//*******************************************************************
//*  Replace "DB2SYS" by your DB2 subsystem name.                     *
//*  Use your DB2 product install libraries for STEPLIBS :            *
//*     PRODUCT.LIBRARIES                                             *
//*     DB2.DSNEXIT                                                   *
//*     DB2.DSNLOAD                                                   *
//*******************************************************************
//EXAMPL16 EXEC PGM=AMUUMAIN,
//             PARM='DB2SYS,AMUEX16,NEW    ,,MSGLEVEL(1)'
//STEPLIB  DD DISP=SHR,DSN=PRODUCT.LIBRARIES
//         DD DSN=DB2.DSNEXIT,DISP=SHR
//         DD DSN=DB2.DSNLOAD,DISP=SHR
//*
//SYSPRINT DD DSN=AMU.EXAMPL16.SYSPRINT,
//            UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//SYSUT101 DD DSN=AMU.EXAMPL16.SYSUT1,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SORTWK01 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK02 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK03 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK04 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK05 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK06 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK07 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK08 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK09 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK10 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK11 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK12 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//*
//SORTOUT  DD DSN=AMU.EXAMPL16.SORTOUT,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SYSOUT   DD   SYSOUT=*
//UTPRINT  DD   SYSOUT=*
//X37IGN   DD   SYSOUT=*
//SYSERR   DD DSN=AMU.EXAMPL16.SYSERR,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SYSREC    DD DSN=AMU.INPUT.EXAMPL16.SYSREC,DISP=SHR
//BMCCPY   DD  DSN=AMU.EXAMPL16.BMCCPY,DISP=(NEW,CATLG,CATLG),
//             SPACE=(CYL,(5,1)),UNIT=SYSDA
//SYSIN    DD   *
 LOAD DATA RESUME YES
      ORDER YES
      COPY YES INLINE NO REGISTER ALL
      DELETEFILES YES SYSDISC YES
  INTO TABLE AMU.TBREDE2 REPLACE WHEN EMPHIREDATE2 > '1470-01-01'
                                 AND  EMPHIREDATE2 < '1480-01-01'
  (IDNO2         POSITION (01:09) CHAR,
   EMPNO2        POSITION (01:09) CHAR,
   EMPNAME2      POSITION (11:19) CHAR,
   EMPHIREDATE2  POSITION (60:69) DATE EXTERNAL)
  INTO TABLE AMU.TBREDE3 REPLACE WHEN EMPHIREDATE3 > '1479-12-31'
                                 AND  EMPHIREDATE3 < '1999-12-31'
  (SSSNO3        POSITION (01:09) CHAR,
   DEPTNAME3     POSITION (21:24) CHAR,
   EMPDEPT3      POSITION (01:04) CHAR,
   EMPHIREDATE3  POSITION (60:69) DATE EXTERNAL)
   DDTYPE SORTWORK ACTIVE YES
/*

The following figure shows the number of rows in each table in the table space before running this job:

 1
1PAGE    1
 ***INPUT STATEMENT:
    SELECT COUNT(*)
      FROM AMU.TBREDE1;
                                                            +----------------+
                                                            |                |
                                                            +----------------+
                                                          1_|          12800 |
                                                            +----------------+
0SUCCESSFUL RETRIEVAL OF          1 ROW(S)
1PAGE    1
 ***INPUT STATEMENT:
    SELECT COUNT(*)
      FROM AMU.TBREDE2;
                                                            +----------------+
                                                            |                |
                                                            +----------------+
                                                          1_|          12800 |
                                                            +----------------+
0SUCCESSFUL RETRIEVAL OF          1 ROW(S)
1PAGE    1
 ***INPUT STATEMENT:
    SELECT COUNT(*)
      FROM AMU.TBREDE3;
                                                            +----------------+
                                                            |                |
                                                            +----------------+
                                                          1_|          12800 |
                                                            +----------------+
0SUCCESSFUL RETRIEVAL OF          1 ROW(S)

SYSPRINT for example 16 and SELECT on the table space after the load

The following figure shows the SYSPRINT output for example 16:

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   16:54:43 ...
 BMC50002I UTILITY ID = 'AMUEX16'.  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.6M,ABOVE 16M=1,004.9M,IEFUSI=NO,CPUs=9,GPs=5,zIIPs=4
 BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
 BMC50471I SMFID=DB2B,JOBID=J0202310,JOB=AMUEX16,STEP=EXAMP16A,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'
0
0
 BMC50102I  LOAD DATA RESUME YES
 BMC50102I       ORDER YES
 BMC50102I       COPY YES INLINE NO REGISTER ALL
 BMC50102I       DELETEFILES YES SYSDISC YES
 BMC50102I   INTO TABLE AMU.TBREDE2 REPLACE WHEN EMPHIREDATE2 > '1470-01-01'
 BMC50102I                                  AND  EMPHIREDATE2 < '1480-01-01'
 BMC50102I   (IDNO2         POSITION (01:09) CHAR,
 BMC50102I    EMPNO2        POSITION (01:09) CHAR,
 BMC50102I    EMPNAME2      POSITION (11:19) CHAR,
 BMC50102I    EMPHIREDATE2  POSITION (60:69) DATE EXTERNAL)
 BMC50102I   INTO TABLE AMU.TBREDE3 REPLACE WHEN EMPHIREDATE3 > '1479-12-31'
 BMC50102I                                  AND  EMPHIREDATE3 < '1999-12-31'
 BMC50102I   (SSSNO3        POSITION (01:09) CHAR,
 BMC50102I    DEPTNAME3     POSITION (21:24) CHAR,
 BMC50102I    EMPDEPT3      POSITION (01:04) CHAR,
 BMC50102I    EMPHIREDATE3  POSITION (60:69) DATE EXTERNAL)
 BMC50102I    DDTYPE SORTWORK ACTIVE YES
 
 BMC51424I ANALYZE PHASE WILL BE PERFORMED DUE TO DYNAMIC WORK FILE ALLOCATION
 BMC51421I NO FIELD SPECIFICATION FOR COLUMN 'EMPCOL3                       '.  VALUE IS DEFAULTED
 BMC51561I CALCULATED NUMBER OF INPUT RECORDS = 26 USING A SCALING FACTOR OF 100%
 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 IS ACTIVATED, BUT NO RULE APPLIES. PLUS UTILITY WILL BE USED   
 
 BMC50004I NGTUTIL PHASE COMPLETE.  ELAPSED TIME = 00:00:00
 
 BMC50199I LOAD PLUS PROCESSING CONTINUES
 
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I ANALYZE PHASE COMPLETE.  ELAPSED TIME = 00:00:00
 
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50425I &JOBNAME  = AMUEX16   &STEPNAME = EXAMP16A  &DB       = AMUDREDE  &TS       = TSREDE1   &UID      = MVSRXO3
 BMC50425I &RESUME   = Y         &REPLACE  = N         &DATE     = 091322    &TIME     = 165443    &SSID     = DEMO    
 BMC50425I &UTIL     = AMUEX16   &UTILPFX  = AMUEX16   &UTILSFX  =           &DATE8    = 09132022  &GRPNM    = DEMO    
 BMC50425I &VCAT     = DEMOCAT   &TIME4    = 1654      &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 SORTWK01 AMU.AMUEX16.SORTWK01                         SYSALLDA                          1        1        1         1  TRK
 BMC50448I SORTWK02 AMU.AMUEX16.SORTWK02                         SYSALLDA                          1        1        1         1  TRK
 BMC50448I SORTWK03 AMU.AMUEX16.SORTWK03                         SYSALLDA                          1        1        1         1  TRK
 BMC50448I SORTWK04 AMU.AMUEX16.SORTWK04                         SYSALLDA                          1        1        1         1  TRK
 BMC50448I SORTWK05 AMU.AMUEX16.SORTWK05                         SYSALLDA                          1        1        1         1  TRK
 BMC50448I SORTWK06 AMU.AMUEX16.SORTWK06                         SYSALLDA                          1        1        1         1  TRK
 BMC50448I SORTWK07 AMU.AMUEX16.SORTWK07                         SYSALLDA                          1        1        1         1  TRK
 BMC50448I SORTWK08 AMU.AMUEX16.SORTWK08                         SYSALLDA                          1        1        1         1  TRK
 BMC50448I SORTWK09 AMU.AMUEX16.SORTWK09                         SYSALLDA                          1        1        1         1  TRK
 BMC50448I SORTWK10 AMU.AMUEX16.SORTWK10                         SYSALLDA                          1        1        1         1  TRK
 BMC50448I SORTWK11 AMU.AMUEX16.SORTWK11                         SYSALLDA                          1        1        1         1  TRK
 BMC50448I SORTWK12 AMU.AMUEX16.SORTWK12                         SYSALLDA                          1        1        1         1  TRK
 BMC50448I SYSDISC  AMU.AMUEX16.SYSDISC                          SYSALLDA                          2        1        1         1  TRK
 BMC50448I SYSERR   AMU.AMUEX16.SYSERR                           SYSALLDA                          1        1        1         1  TRK
 
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8424K, ABOVE 16M = 1017532K, CPUS = 5
 BMC50479I TOTAL PAGES: 11361489, ALLOWED: 3408447; AVAILABLE PAGES: 5080762, ALLOWED: 0
 BMC51499I COMBINED OPTIMIZATION, RC=0, #SORTS=1, #READERS=1, #INDEX TASKS=2, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=25856
 BMC51499I COMBINED OPTIMIZATION, RC=20, #SORTS=1, #READERS=1, #INDEX TASKS=1, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=31232
 BMC51500I COMBINED ANALYZE, #SORTS=1, #READERS=1, #INDEX TASKS=2, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0
 BMC50477I 5: PARTITION =    0, ROWS/KEYS = 0, I/O WAITS = 2 ,DDNAME = SYS00055
 BMC50486I 3: BMCSORT STARTED, 332K BELOW 16M, 1356K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 4: BMCSORT STARTED, 328K BELOW 16M, 1352K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC51453I EXISTING ROWS IN TABLE 'AMU.TBREDE2' DELETED
 BMC51453I EXISTING ROWS IN TABLE 'AMU.TBREDE3' DELETED
 BMC50486I 2: BMCSORT STARTED, 492K BELOW 16M, 1516K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50481I 1: READ TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 1: READ TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51478I PRELOAD STATISTICS:  20 PHYSICAL (20 LOGICAL) RECORDS READ FROM SYSREC
 BMC50481I 2: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50482I 2: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.AMUDREDE.I22REDE2.I0001.A001'
 BMC50477I 2: PARTITION =    0, ROWS/KEYS = 5, I/O WAITS = 7 ,DDNAME = SYS00063
 BMC50482I 2: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.AMUDREDE.TSREDE1.I0001.A001'
 BMC50477I 2: PARTITION =    0, ROWS/KEYS = 20, I/O WAITS = 32 ,DDNAME = SYS00060
 BMC50482I 2: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.AMUDREDE.I32REDE3.I0001.A001'
 BMC50477I 2: PARTITION =    0, ROWS/KEYS = 15, I/O WAITS = 7 ,DDNAME = SYS00067
 BMC50481I 2: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 2: SORT TASK, XBLK XFERS = 3, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50481I 3: INDEX SORT COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50481I 4: INDEX SORT COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50482I 3: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.AMUDREDE.I21REDE2.I0001.A001'
 BMC50477I 3: PARTITION =    0, ROWS/KEYS = 5, I/O WAITS = 7 ,DDNAME = SYS00073
 BMC50482I 4: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.AMUDREDE.I31REDE3.I0001.A001'
 BMC50477I 4: PARTITION =    0, ROWS/KEYS = 15, I/O WAITS = 6 ,DDNAME = SYS00074
 BMC51476I BUILD STATISTICS:  5 KEYS LOADED INTO INDEX 'AMU.I21REDE2'
 BMC50481I 3: INDEX TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 3: INDEX TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 2
 BMC51476I BUILD STATISTICS:  15 KEYS LOADED INTO INDEX 'AMU.I31REDE3'
 BMC50481I 4: INDEX TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 4: INDEX TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 2
 BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 1
 BMC50476I DDNAME = SYSREC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51507I XBLKS = 12, XFERS = 3, EMPTY WAITS = 0, FULL WAITS =4
 BMC50476I DDNAME = SYSDISC, I/OS = 0, I/O WAITS = 0, RDB LOCK WAITS = 0
 BMC51472I COMBINED PHASE STATISTICS:  20 ROWS SELECTED FOR SPACE 'AMUDREDE.TSREDE1', 0 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
 BMC51479I COMBINED PHASE STATISTICS:  0 PHYSICAL (0 LOGICAL) RECORDS DISCARDED TO SYSDISC
 BMC51473I LOAD STATISTICS:  5 ROWS LOADED INTO TABLE 'AMU.TBREDE2'
 BMC51476I BUILD STATISTICS:  5 KEYS LOADED INTO INDEX 'AMU.I22REDE2'
 BMC51473I LOAD STATISTICS:  15 ROWS LOADED INTO TABLE 'AMU.TBREDE3'
 BMC51476I BUILD STATISTICS:  15 KEYS LOADED INTO INDEX 'AMU.I32REDE3'
 BMC51475I LOAD STATISTICS:  20 ROWS LOADED INTO TABLE SPACE 'AMUDREDE.TSREDE1'
 BMC50370I STARTING 1 IMAGE COPY TASKS
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEMOCAT.DSNDBD.AMUDREDE.TSREDE1.I0001.A001'
 BMC50476I DDNAME = BMCCPY, I/OS = 5, I/O WAITS = 3, RDB LOCK WAITS = 0
 BMC50376I 519 PAGES COPIED TO DATASET = 'AMU.EXAMP016.BMCCPYA'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT ', DSNAME = 'SYS22256.T165435.RA000.AMUEX16.R0844398'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK01', DSNAME = 'AMU.AMUEX16.SORTWK01'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR  ', DSNAME = 'AMU.AMUEX16.SYSERR'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK02', DSNAME = 'AMU.AMUEX16.SORTWK02'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK03', DSNAME = 'AMU.AMUEX16.SORTWK03'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK04', DSNAME = 'AMU.AMUEX16.SORTWK04'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK05', DSNAME = 'AMU.AMUEX16.SORTWK05'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK06', DSNAME = 'AMU.AMUEX16.SORTWK06'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK07', DSNAME = 'AMU.AMUEX16.SORTWK07'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK08', DSNAME = 'AMU.AMUEX16.SORTWK08'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK09', DSNAME = 'AMU.AMUEX16.SORTWK09'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK10', DSNAME = 'AMU.AMUEX16.SORTWK10'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK11', DSNAME = 'AMU.AMUEX16.SORTWK11'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK12', DSNAME = 'AMU.AMUEX16.SORTWK12'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSDISC ', DSNAME = 'AMU.AMUEX16.SYSDISC'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I COMBINED PHASE COMPLETE.  ELAPSED TIME = 00:00:02
 
 BMC50501I DB2 OBJECT STATISTICS
0BMC50503I STATISTICS FOR TABLESPACE 'AMUDREDE.TSREDE1' NOT AVAILABLE
0BMC50503I STATISTICS FOR TABLE      'AMU.TBREDE2' NOT AVAILABLE
0BMC50503I STATISTICS FOR INDEX      'AMU.I22REDE2' NOT AVAILABLE
0BMC50503I STATISTICS FOR INDEX      'AMU.I21REDE2' NOT AVAILABLE
0BMC50503I STATISTICS FOR TABLE      'AMU.TBREDE1' NOT AVAILABLE
0BMC50503I STATISTICS FOR INDEX      'AMU.I12REDE' NOT AVAILABLE
0BMC50503I STATISTICS FOR INDEX      'AMU.I11REDE' NOT AVAILABLE
0BMC50503I STATISTICS FOR TABLE      'AMU.TBREDE3' NOT AVAILABLE
0BMC50503I STATISTICS FOR INDEX      'AMU.I32REDE3' NOT AVAILABLE
0BMC50503I STATISTICS FOR INDEX      'AMU.I31REDE3' NOT AVAILABLE
 BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR LOAD UTILITY SUCCESSFUL FOR ALL OBJECTS
 BMC50004I UTILTERM PHASE COMPLETE.  ELAPSED TIME = 00:00:00
 
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0

The following figure shows the number of rows in each table in the table space after running this job:

 1
1PAGE    1
 ***INPUT STATEMENT:
    SELECT COUNT(*)
      FROM AMU.TBREDE1;
                                                            +----------------+
                                                            |                |
                                                            +----------------+
                                                          1_|          12800 |
                                                            +----------------+
0SUCCESSFUL RETRIEVAL OF          1 ROW(S)
1PAGE    1
 ***INPUT STATEMENT:
    SELECT COUNT(*)
      FROM AMU.TBREDE2;
                                                            +----------------+
                                                            |                |
                                                            +----------------+
                                                          1_|              5 |
                                                            +----------------+
0SUCCESSFUL RETRIEVAL OF          1 ROW(S)
1PAGE    1
 ***INPUT STATEMENT:
    SELECT COUNT(*)
      FROM AMU.TBREDE3;
                                                            +----------------+
                                                            |                |
                                                            +----------------+
                                                          1_|             15 |
                                                            +----------------+
0SUCCESSFUL RETRIEVAL OF          1 ROW(S)


 

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