Example 1 — LOAD REPLACE of a partitioned by growth table space

This example illustrates three runs of a LOAD REPLACE of a partitioned by growth table space with no indexes and shows the use of data conversions.

This example runs the following three jobs. Except for the changes to the LOAD command statement, the JCL is the same for all jobs.

  • SYSPRINT A (Output from a two-phase load (example 1A)) shows the output when the job is run as a two-phase load. PRELOAD CONTINUE is specified in the JCL to override the PRELOAD=LOAD default from the installation options module.
  • In the second case, the PRELOAD CONTINUE option is removed from the LOAD command statement. The PRELOAD=LOAD default value tells LOADPLUS to use single-phase processing. SYSPRINT B (Output from a single-phase load (example 1B)) shows the single-phase load output.
  • In the third version of this job, the SHRLEVEL REFERENCE option is added to the command statement, overriding the SHRLEVEL=(NONE, NONE) installation option value, to improve the accessibility of the data. SYSPRINT C (Output from a LOAD REPLACE SHRLEVEL REFERENCE load (example 1C)) shows the SHRLEVEL REFERENCE load output.

Related topic

Examples-of-LOADPLUS-jobs

In this example, LOADPLUS loads the data into a partitioned by growth, STOGROUP-defined table space that contains only one table with no indexes. LOADPLUS replaces all existing rows and deletes and redefines the VSAM data set for the space.

No sort work data sets are allocated because there are no indexes and LOADPLUS is not sorting the data.

The following data conversions take place:

  • Character data to small integer format
  • Timestamp in character format to DB2 timestamp format
  • Date in character format to DB2 date format

Because no COPY option is included on the LOAD command, LOADPLUS does not make a copy. Because the COPYPEND installation option is set to YES, LOADPLUS places the table space in COPY pending status and the job completes with return code 4.

The SYSPRINT output indicates that conversion errors occurred. Because the EXEC statement designates MSGLEVEL(1), LOADPLUS issues message BMC51501E to identify the erroneous input fields.

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.

Note that the JCL defines the SORTOUT and SYSERR data sets as DISP=(MOD,CATLG,CATLG) and the SYSDISC data set as DISP=(NEW,CATLG,CATLG). The EXEC statement includes the NEW/RESTART restart parameter.

The following figure shows the JCL for example 1A:

//  JOBCARD
//********************** AMUEX01 **************************************
//*====================================================================
//*========LOAD REPLACE of a partitioned by growth table space ========
//*====================================================================
//*  Replace "DB2SYS" by your DB2 subsystem name.                     *
//*  Use your DB2 product install libraries for STEPLIBS :            *
//*     PRODUCT.LIBRARIES                                             *
//*     DB2.DSNEXIT                                                   *
//*     DB2.DSNLOAD                                                   *
//*====================================================================
//*==   EXAMPL1A   LOAD REPLACE OF A PARTITIONED BY GROWTH TABLESPACE
//*==   EXAMPL1B   LOAD REPLACE (SINGLE PHASE)
//*==   EXAMPL1C   LOAD REPLACE W/SHRLEVEL REFERENCE
//*====================================================================
//EXAMPL1A EXEC PGM=AMUUMAIN,
//         PARM='DB2SYS,AMUEX01,NEW/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.EXAMP01A.SYSPRINT,
//            UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG)
//SYSOUT   DD SYSOUT=*
//UTPRINT  DD SYSOUT=*
//*
//SYSREC   DD DISP=SHR,DSN=AMU.INPUT.EXAMPL01.SYSREC
//SORTOUT  DD DSN=AMU.EXAMP01A.SORTOUT,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SYSERR   DD DSN=AMU.EXAMP01A.SYSERR,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SYSDISC  DD DSN=AMU.EXAMP01A.SYSDISC,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//*
//SYSIN     DD *
  LOAD REPLACE
    PRELOAD CONTINUE
    INTO TABLE EXAMPLE1.TBL1
                (SMINT_COL1      POSITION(1)      CHARACTER(3)
                ,TIMESTAMP_COL2  POSITION(4)     TIMESTAMP EXTERNAL(19)
                ,DATE_COL3       POSITION(23)     DATE EXTERNAL
                ,VARCHAR_COL4    POSITION(33)     CHARACTER(40) TRIM
                ,CHAR_COL5       POSITION(73)     CHARACTER(7)
                )
/*

The following figure shows the JCL for example 1B (PRELOAD CONTINUE is removed):

//*
//EXAMPL1B EXEC PGM=AMUUMAIN,
//         PARM='DB2SYS,AMUEX01,NEW/RESTART,,MSGLEVEL(1)'
//*               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.EXAMP01B.SYSPRINT,
//             UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG)
//SYSOUT   DD SYSOUT=*
//UTPRINT  DD SYSOUT=*
//*
//SYSREC   DD DISP=SHR,DSN=AMU.INPUT.EXAMPL01.SYSREC
//SORTOUT  DD DSN=AMU.EXAMP01B.SORTOUT,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SYSERR   DD DSN=AMU.EXAMP01B.SYSERR,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SYSDISC  DD DSN=AMU.EXAMP01B.SYSDISC,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//*
//SYSIN     DD *
  LOAD REPLACE
    INTO TABLE EXAMPLE1.TBL1
                (SMINT_COL1      POSITION(1)      CHARACTER(3)
                ,TIMESTAMP_COL2  POSITION(4)     TIMESTAMP EXTERNAL(19)
                ,DATE_COL3       POSITION(23)     DATE EXTERNAL
                ,VARCHAR_COL4    POSITION(33)     CHARACTER(40) TRIM
                ,CHAR_COL5       POSITION(73)     CHARACTER(7)
                )

The following figure shows the JCL for example 1C:

//EXAMPL1C EXEC PGM=AMUUMAIN,
//         PARM='DB2SYS,AMUEX01,NEW/RESTART,,MSGLEVEL(1)'
//*               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.EXAMP01C.SYSPRINT,
//             UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG)
//SYSOUT   DD SYSOUT=*
//UTPRINT  DD SYSOUT=*
//*
//SYSREC   DD DISP=SHR,DSN=AMU.INPUT.EXAMPL01.SYSREC
//SORTOUT  DD DSN=AMU.EXAMP01C.SORTOUT,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SYSERR   DD DSN=AMU.EXAMP01C.SYSERR,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SYSDISC  DD DSN=AMU.EXAMP01C.SYSDISC,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//*
//SYSIN     DD *
  LOAD REPLACE SHRLEVEL REFERENCE
    INTO TABLE EXAMPLE1.TBL1
                (SMINT_COL1      POSITION(1)      CHARACTER(3)
                ,TIMESTAMP_COL2  POSITION(4)     TIMESTAMP EXTERNAL(19)
                ,DATE_COL3       POSITION(23)     DATE EXTERNAL
                ,VARCHAR_COL4    POSITION(33)     CHARACTER(40) TRIM
                ,CHAR_COL5       POSITION(73)     CHARACTER(7)
                )

Output from a two-phase load (example 1A)

The following figure shows the SYSPRINT output for example 1A:

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    8/30/2022    7:22:59 ...
 BMC50002I UTILITY ID = 'AMUEX01'.  DB2 SUBSYSTEM ID = 'DEND'.  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=990.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=J0002470,JOB=AMUEX01,STEP=EXAMPL1A,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 BASE
 BMC50471I   MAINT: BPJ2315
 BMC50471I BMCSORT ENGINE--V02.04.01
 BMC50471I   MAINT: BPJ0691  BPJ0718  BPJ0881  BPJ0922  BPJ0996  BPJ1164  BPJ1309  BPJ1386  BPJ1497  BPJ1594  BPJ1724  BPJ1809
 BMC50471I          BPJ1833  BPJ1891  BPJ1905  BPJ2109  BPJ2232  BPJ2297
 BMC50471I BMC STATS API--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I EXTENDED BUFFER MANAGER--V06.02.01
 BMC50471I   MAINT: BPE0443  BPE0445  BPE0447  BPE0449  BPE0450  BPE0451  BPE0452  BPE0455  BPE0456  BPE0457  BPE0460  BPE0463
 BMC50471I          BPE0467  BPE0468  BPE0469  BPE0473  BPE0474  BPE0475  BPE0479  BPE0480  BPE0482  BPE0487  BPE0488  BPE0489
 BMC50471I          BPE0493  BPE0497  BPE0498  BPE0501  BPE0503  BPE0507  BPE0512  BPE0513  BPE0517  BPE0518  BPE0519  BPE0523
 BMC50471I          BPE0524  BPE0527  BPE0528  BPE0530  BPE0531  BPE0534  BPE0535  BPE0540  BPE0541  BPE0542  BPE0545  BPE0549
 BMC50471I          BPE0551  BPE0552  BPE0555  BPE0556  BPE0557  BPE0560  BPE0561
 BMC50471I High-speed Apply Engine--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
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   = 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)                                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   = 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 = 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   = NO                                 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=&UID.&UTILPFX.&DDNAME
 BMC50483I WORK       DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I SORTWORK   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I ERROR      DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I DISCARD    DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I SYSMAP     DSNPAT=&UID.&UTILPFX.&DDNAME
0
 BMC50483I LOCPFCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I LOCBFCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMPFCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMBFCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
0
 BMC50483I LOCPLCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I LOCBLCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMPLCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMBLCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
0
 BMC50483I LOCPXCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I LOCBXCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMPXCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMBXCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
0

 BMC50471I DB2 DSNHDECP MODULE SETTINGS:
 BMC50471I VERSION                 = 1310
 BMC50471I SUBSYSTEM DEFAULT       = DEND
 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 REPLACE
 BMC50102I     INTO TABLE AMUEX01.TBL1
 BMC50102I                 (SMINT_COL1      POSITION(1)      CHARACTER(3)
 BMC50102I                 ,TIMESTAMP_COL2  POSITION(4)     TIMESTAMP EXTERNAL(19)
 BMC50102I                 ,DATE_COL3       POSITION(23)     DATE EXTERNAL
 BMC50102I                 ,VARCHAR_COL4    POSITION(33)     CHARACTER(40) TRIM
 BMC50102I                 ,CHAR_COL5       POSITION(73)     CHARACTER(7)
 BMC50102I                 )

 BMC51424I ANALYZE PHASE WILL BE PERFORMED DUE TO DYNAMIC WORK FILE ALLOCATION
 BMC51422I FOR TABLE 'AMUEX01.TBL1', THE FOLLOWING INPUT FIELDS HAVE KNOWN START:END POSITIONS THAT WERE NOT SPECIFIED
 BMC51423I FIELD 'SMINT_COL1                    ' HAS POSITION(1:3)
 BMC51423I FIELD 'TIMESTAMP_COL2                ' HAS POSITION(4:22)
 BMC51423I FIELD 'DATE_COL3                     ' HAS POSITION(23:32)
 BMC51423I FIELD 'VARCHAR_COL4                  ' HAS POSITION(33:72)
 BMC51423I FIELD 'CHAR_COL5                     ' HAS POSITION(73:79)
 BMC51561I CALCULATED NUMBER OF INPUT RECORDS = 39 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 NOT ACTIVATED, NO ROWS ON POLICY TABLE

 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  = AMUEX01   &STEPNAME = EXAMPL1A  &DB       = AMUEX1DB  &TS       = EX1TS     &UID      = BMCJXS
 BMC50425I &RESUME   = N         &REPLACE  = Y         &DATE     = 083022    &TIME     = 072259    &SSID     = DEND
 BMC50425I &UTIL     = AMUEX01  &UTILPFX  = AMUEX01  &UTILSFX  =           &DATE8    = 08302022  &GRPNM    = DEND
 BMC50425I &VCAT     = DENDCAT   &TIME4    = 0722      &DATEJ    = 2022242   &JDATE    = 22242

 BMC50445I LOAD PLUS DYNAMIC FILE ALLOCATION REPORT
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8280K, ABOVE 16M = 1004680K, CPUS = 5
 BMC50479I TOTAL PAGES: 12736662, ALLOWED: 3820999; AVAILABLE PAGES: 5364367, ALLOWED: 0
 BMC51499I COMBINED OPTIMIZATION, RC=0, #SORTS=1, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=37632
 BMC51500I COMBINED ANALYZE, #SORTS=1, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0
 BMC51453I EXISTING ROWS IN TABLESPACE 'AMUEX1DB.EX1TS' DELETED
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'DATE_COL3', RECORD NO. 1 OF SYSREC, DATA = C'1990-02-29'
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'DATE_COL3', RECORD NO. 2 OF SYSREC, DATA = C'1990-13-1 '
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'DATE_COL3', RECORD NO. 3 OF SYSREC, DATA = C'1990-9-31 '
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'TIMESTAMP_COL2', RECORD NO. 5 OF SYSREC, DATA = C'1990-02-31-12.32.00'
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'TIMESTAMP_COL2', RECORD NO. 7 OF SYSREC, DATA = C'1990-04-31-12.34.00'
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'TIMESTAMP_COL2', RECORD NO. 8 OF SYSREC, DATA = C'1990-11-31-12.35.00'
 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:  26 PHYSICAL (26 LOGICAL) RECORDS READ FROM SYSREC
 BMC50482I 2: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DENDCAT.DSNDBD.AMUEX1DB.EX1TS.I0001.A001'
 BMC50477I 2: PARTITION =    1, ROWS/KEYS = 20, I/O WAITS = 10 ,DDNAME = SYS00019
 BMC51474I LOAD STATISTICS:  20 ROWS LOADED INTO TABLE SPACE 'AMUEX1DB.EX1TS' PARTITION 1
 BMC50481I 2: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 2: SORT TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50476I DDNAME = SYSERR, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51507I XBLKS = 4, XFERS = 1, EMPTY WAITS = 0, FULL WAITS =0
 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 = SYSREC, 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 AMUEX01.TBL1
 BMC51522I    INPUT        DISCARD  DISCARD               RELATED
 BMC51523I  ID: RECORD #    RECORD#  TYPE                 ID: RECORD #  FIELD, INDEX, OR CONSTRAINT NAME

 BMC51524E   1:         1          1 CONVERSION            0:         7 DATE_COL3
 BMC51524E   1:         2          2 CONVERSION            0:         7 DATE_COL3
 BMC51524E   1:         3          3 CONVERSION            0:         7 DATE_COL3
 BMC51524E   1:         5          4 CONVERSION            0:         7 TIMESTAMP_COL2
 BMC51524E   1:         7          5 CONVERSION            0:         7 TIMESTAMP_COL2
 BMC51524E   1:         8          6 CONVERSION            0:         7 TIMESTAMP_COL2


 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
 BMC51472I COMBINED PHASE STATISTICS:  20 ROWS SELECTED FOR SPACE 'AMUEX1DB.EX1TS', 6 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
 BMC51479I COMBINED PHASE STATISTICS:  6 PHYSICAL (6 LOGICAL) RECORDS DISCARDED TO SYSDISC
 BMC51474I LOAD STATISTICS:  20 ROWS LOADED INTO TABLE SPACE 'AMUEX1DB.EX1TS' PARTITION 1
 BMC51473I LOAD STATISTICS:  20 ROWS LOADED INTO TABLE 'AMUEX01.TBL1'
 BMC51475I LOAD STATISTICS:  20 ROWS LOADED INTO TABLE SPACE 'AMUEX1DB.EX1TS'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR  ', DSNAME = 'AMU.EXAMP01A.SYSERR'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT ', DSNAME = 'AMU.EXAMP01A.SORTOUT'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I COMBINED PHASE COMPLETE.  ELAPSED TIME = 00:00:01

 BMC50501I DB2 OBJECT STATISTICS
0BMC50515I TABLESPACE  AMUEX1DB.EX1TS  PARTS   = 1         TABLES  = 1     SEGSIZE = 8     PAGESIZE = 4K
 BMC50516I             PART  NACTIVE       CARD   EXTENTS   DBCARD PCOMP   KSAVED  PSAVED
 BMC50517I                1       11         20         1        0     0        0       0
 BMC50518I   TABLE     AMUEX01.TBL1
 BMC50519I             ROWAVG    NPAGES       CARD   PCTPAGES
 BMC50520I                 58         4         20         36
 BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR LOAD UTILITY SUCCESSFUL FOR ALL OBJECTS
 BMC50387W IMAGE COPY REQUIRED.  TABLE SPACE AMUEX1DB.EX1TS STATE SET TO "COPY PENDING"
 BMC50004I UTILTERM PHASE COMPLETE.  ELAPSED TIME = 00:00:00

0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 4


Output from a single-phase load (example 1B)

The following figure shows the SYSPRINT output for example 1B:

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    8/30/2022    7:23:01 ...
 BMC50002I UTILITY ID = 'AMUEX01'.  DB2 SUBSYSTEM ID = 'DEND'.  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=990.8M,IEFUSI=NO,CPUs=9,GPs=5,zIIPs=4
 BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
 BMC50471I SMFID=DB2B,JOBID=J0002470,JOB=AMUEX01,STEP=EXAMPL1B,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 BASE
 BMC50471I   MAINT: BPJ2315
 BMC50471I BMCSORT ENGINE--V02.04.01
 BMC50471I   MAINT: BPJ0691  BPJ0718  BPJ0881  BPJ0922  BPJ0996  BPJ1164  BPJ1309  BPJ1386  BPJ1497  BPJ1594  BPJ1724  BPJ1809
 BMC50471I          BPJ1833  BPJ1891  BPJ1905  BPJ2109  BPJ2232  BPJ2297
 BMC50471I BMC STATS API--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I EXTENDED BUFFER MANAGER--V06.02.01
 BMC50471I   MAINT: BPE0443  BPE0445  BPE0447  BPE0449  BPE0450  BPE0451  BPE0452  BPE0455  BPE0456  BPE0457  BPE0460  BPE0463
 BMC50471I          BPE0467  BPE0468  BPE0469  BPE0473  BPE0474  BPE0475  BPE0479  BPE0480  BPE0482  BPE0487  BPE0488  BPE0489
 BMC50471I          BPE0493  BPE0497  BPE0498  BPE0501  BPE0503  BPE0507  BPE0512  BPE0513  BPE0517  BPE0518  BPE0519  BPE0523
 BMC50471I          BPE0524  BPE0527  BPE0528  BPE0530  BPE0531  BPE0534  BPE0535  BPE0540  BPE0541  BPE0542  BPE0545  BPE0549
 BMC50471I          BPE0551  BPE0552  BPE0555  BPE0556  BPE0557  BPE0560  BPE0561
 BMC50471I High-speed Apply Engine--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
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   = 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)                                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   = 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 = 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   = NO                                 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=&UID.&UTILPFX.&DDNAME
 BMC50483I WORK       DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I SORTWORK   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I ERROR      DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I DISCARD    DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I SYSMAP     DSNPAT=&UID.&UTILPFX.&DDNAME
0
 BMC50483I LOCPFCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I LOCBFCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMPFCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMBFCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
0
 BMC50483I LOCPLCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I LOCBLCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMPLCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMBLCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
0
 BMC50483I LOCPXCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I LOCBXCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMPXCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMBXCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
0

 BMC50471I DB2 DSNHDECP MODULE SETTINGS:
 BMC50471I VERSION                 = 1310
 BMC50471I SUBSYSTEM DEFAULT       = DEND
 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 REPLACE
 BMC50102I     INTO TABLE AMUEX01.TBL1
 BMC50102I                 (SMINT_COL1      POSITION(1)      CHARACTER(3)
 BMC50102I                 ,TIMESTAMP_COL2  POSITION(4)     TIMESTAMP EXTERNAL(19)
 BMC50102I                 ,DATE_COL3       POSITION(23)     DATE EXTERNAL
 BMC50102I                 ,VARCHAR_COL4    POSITION(33)     CHARACTER(40) TRIM
 BMC50102I                 ,CHAR_COL5       POSITION(73)     CHARACTER(7)
 BMC50102I                 )

 BMC51424I ANALYZE PHASE WILL BE PERFORMED DUE TO DYNAMIC WORK FILE ALLOCATION
 BMC51422I FOR TABLE 'AMUEX01.TBL1', THE FOLLOWING INPUT FIELDS HAVE KNOWN START:END POSITIONS THAT WERE NOT SPECIFIED
 BMC51423I FIELD 'SMINT_COL1                    ' HAS POSITION(1:3)
 BMC51423I FIELD 'TIMESTAMP_COL2                ' HAS POSITION(4:22)
 BMC51423I FIELD 'DATE_COL3                     ' HAS POSITION(23:32)
 BMC51423I FIELD 'VARCHAR_COL4                  ' HAS POSITION(33:72)
 BMC51423I FIELD 'CHAR_COL5                     ' HAS POSITION(73:79)
 BMC51561I CALCULATED NUMBER OF INPUT RECORDS = 39 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 NOT ACTIVATED, NO ROWS ON POLICY TABLE

 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  = AMUEX01   &STEPNAME = EXAMPL1B  &DB       = AMUEX1DB  &TS       = EX1TS     &UID      = BMCJXS
 BMC50425I &RESUME   = N         &REPLACE  = Y         &DATE     = 083022    &TIME     = 072301    &SSID     = DEND
 BMC50425I &UTIL     = AMUEX01  &UTILPFX  = AMUEX01  &UTILSFX  =           &DATE8    = 08302022  &GRPNM    = DEND
 BMC50425I &VCAT     = DENDCAT   &TIME4    = 0723      &DATEJ    = 2022242   &JDATE    = 22242

 BMC50445I LOAD PLUS DYNAMIC FILE ALLOCATION REPORT
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8280K, ABOVE 16M = 1004664K, CPUS = 5
 BMC50479I TOTAL PAGES: 12738763, ALLOWED: 3821629; AVAILABLE PAGES: 5364246, ALLOWED: 0
 BMC51499I COMBINED OPTIMIZATION, RC=0, #SORTS=1, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=37632
 BMC51500I COMBINED ANALYZE, #SORTS=1, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0
 BMC51453I EXISTING ROWS IN TABLESPACE 'AMUEX1DB.EX1TS' DELETED
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'DATE_COL3', RECORD NO. 1 OF SYSREC, DATA = C'1990-02-29'
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'DATE_COL3', RECORD NO. 2 OF SYSREC, DATA = C'1990-13-1 '
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'DATE_COL3', RECORD NO. 3 OF SYSREC, DATA = C'1990-9-31 '
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'TIMESTAMP_COL2', RECORD NO. 5 OF SYSREC, DATA = C'1990-02-31-12.32.00'
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'TIMESTAMP_COL2', RECORD NO. 7 OF SYSREC, DATA = C'1990-04-31-12.34.00'
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'TIMESTAMP_COL2', RECORD NO. 8 OF SYSREC, DATA = C'1990-11-31-12.35.00'
 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:  26 PHYSICAL (26 LOGICAL) RECORDS READ FROM SYSREC
 BMC50482I 2: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DENDCAT.DSNDBD.AMUEX1DB.EX1TS.I0001.A001'
 BMC50477I 2: PARTITION =    1, ROWS/KEYS = 20, I/O WAITS = 10 ,DDNAME = SYS00032
 BMC51474I LOAD STATISTICS:  20 ROWS LOADED INTO TABLE SPACE 'AMUEX1DB.EX1TS' PARTITION 1
 BMC50481I 2: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 2: SORT TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50476I DDNAME = SYSERR, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51507I XBLKS = 4, XFERS = 1, EMPTY WAITS = 0, FULL WAITS =0
 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 = SYSREC, 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 AMUEX01.TBL1
 BMC51522I    INPUT        DISCARD  DISCARD               RELATED
 BMC51523I  ID: RECORD #    RECORD#  TYPE                 ID: RECORD #  FIELD, INDEX, OR CONSTRAINT NAME

 BMC51524E   1:         1          1 CONVERSION            0:         7 DATE_COL3
 BMC51524E   1:         2          2 CONVERSION            0:         7 DATE_COL3
 BMC51524E   1:         3          3 CONVERSION            0:         7 DATE_COL3
 BMC51524E   1:         5          4 CONVERSION            0:         7 TIMESTAMP_COL2
 BMC51524E   1:         7          5 CONVERSION            0:         7 TIMESTAMP_COL2
 BMC51524E   1:         8          6 CONVERSION            0:         7 TIMESTAMP_COL2


 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
 BMC51472I COMBINED PHASE STATISTICS:  20 ROWS SELECTED FOR SPACE 'AMUEX1DB.EX1TS', 6 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
 BMC51479I COMBINED PHASE STATISTICS:  6 PHYSICAL (6 LOGICAL) RECORDS DISCARDED TO SYSDISC
 BMC51474I LOAD STATISTICS:  20 ROWS LOADED INTO TABLE SPACE 'AMUEX1DB.EX1TS' PARTITION 1
 BMC51473I LOAD STATISTICS:  20 ROWS LOADED INTO TABLE 'AMUEX01.TBL1'
 BMC51475I LOAD STATISTICS:  20 ROWS LOADED INTO TABLE SPACE 'AMUEX1DB.EX1TS'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR  ', DSNAME = 'AMU.EXAMP01B.SYSERR'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT ', DSNAME = 'AMU.EXAMP01B.SORTOUT'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I COMBINED PHASE COMPLETE.  ELAPSED TIME = 00:00:00

 BMC50501I DB2 OBJECT STATISTICS
0BMC50515I TABLESPACE  AMUEX1DB.EX1TS  PARTS   = 1         TABLES  = 1     SEGSIZE = 8     PAGESIZE = 4K
 BMC50516I             PART  NACTIVE       CARD   EXTENTS   DBCARD PCOMP   KSAVED  PSAVED
 BMC50517I                1       11         20         1        0     0        0       0
 BMC50518I   TABLE     AMUEX01.TBL1
 BMC50519I             ROWAVG    NPAGES       CARD   PCTPAGES
 BMC50520I                 58         4         20         36
 BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR LOAD UTILITY SUCCESSFUL FOR ALL OBJECTS
 BMC50386W IMAGE COPY REQUIRED.  TABLE SPACE AMUEX1DB.EX1TS REMAINS IN "COPY PENDING" STATE
 BMC50004I UTILTERM PHASE COMPLETE.  ELAPSED TIME = 00:00:00

0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 4


Output from a LOAD REPLACE SHRLEVEL REFERENCE load (example 1C)

The following figure shows the SYSPRINT output for example 1C:

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    8/30/2022    7:23:03 ...
 BMC50002I UTILITY ID = 'AMUEX01'.  DB2 SUBSYSTEM ID = 'DEND'.  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=990.8M,IEFUSI=NO,CPUs=9,GPs=5,zIIPs=4
 BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
 BMC50471I SMFID=DB2B,JOBID=J0002470,JOB=AMUEX01,STEP=EXAMPL1C,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 BASE
 BMC50471I   MAINT: BPJ2315
 BMC50471I BMCSORT ENGINE--V02.04.01
 BMC50471I   MAINT: BPJ0691  BPJ0718  BPJ0881  BPJ0922  BPJ0996  BPJ1164  BPJ1309  BPJ1386  BPJ1497  BPJ1594  BPJ1724  BPJ1809
 BMC50471I          BPJ1833  BPJ1891  BPJ1905  BPJ2109  BPJ2232  BPJ2297
 BMC50471I BMC STATS API--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I EXTENDED BUFFER MANAGER--V06.02.01
 BMC50471I   MAINT: BPE0443  BPE0445  BPE0447  BPE0449  BPE0450  BPE0451  BPE0452  BPE0455  BPE0456  BPE0457  BPE0460  BPE0463
 BMC50471I          BPE0467  BPE0468  BPE0469  BPE0473  BPE0474  BPE0475  BPE0479  BPE0480  BPE0482  BPE0487  BPE0488  BPE0489
 BMC50471I          BPE0493  BPE0497  BPE0498  BPE0501  BPE0503  BPE0507  BPE0512  BPE0513  BPE0517  BPE0518  BPE0519  BPE0523
 BMC50471I          BPE0524  BPE0527  BPE0528  BPE0530  BPE0531  BPE0534  BPE0535  BPE0540  BPE0541  BPE0542  BPE0545  BPE0549
 BMC50471I          BPE0551  BPE0552  BPE0555  BPE0556  BPE0557  BPE0560  BPE0561
 BMC50471I High-speed Apply Engine--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
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   = 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)                                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   = 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 = 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   = NO                                 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=&UID.&UTILPFX.&DDNAME
 BMC50483I WORK       DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I SORTWORK   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I ERROR      DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I DISCARD    DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I SYSMAP     DSNPAT=&UID.&UTILPFX.&DDNAME
0
 BMC50483I LOCPFCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I LOCBFCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMPFCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMBFCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
0
 BMC50483I LOCPLCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I LOCBLCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMPLCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMBLCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
0
 BMC50483I LOCPXCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I LOCBXCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMPXCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMBXCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
0

 BMC50471I DB2 DSNHDECP MODULE SETTINGS:
 BMC50471I VERSION                 = 1310
 BMC50471I SUBSYSTEM DEFAULT       = DEND
 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 REPLACE SHRLEVEL REFERENCE
 BMC50102I     INTO TABLE AMUEX01.TBL1
 BMC50102I                 (SMINT_COL1      POSITION(1)      CHARACTER(3)
 BMC50102I                 ,TIMESTAMP_COL2  POSITION(4)     TIMESTAMP EXTERNAL(19)
 BMC50102I                 ,DATE_COL3       POSITION(23)     DATE EXTERNAL
 BMC50102I                 ,VARCHAR_COL4    POSITION(33)     CHARACTER(40) TRIM
 BMC50102I                 ,CHAR_COL5       POSITION(73)     CHARACTER(7)
 BMC50102I                 )

 BMC51424I ANALYZE PHASE WILL BE PERFORMED DUE TO DYNAMIC WORK FILE ALLOCATION
 BMC51422I FOR TABLE 'AMUEX01.TBL1', THE FOLLOWING INPUT FIELDS HAVE KNOWN START:END POSITIONS THAT WERE NOT SPECIFIED
 BMC51423I FIELD 'SMINT_COL1                    ' HAS POSITION(1:3)
 BMC51423I FIELD 'TIMESTAMP_COL2                ' HAS POSITION(4:22)
 BMC51423I FIELD 'DATE_COL3                     ' HAS POSITION(23:32)
 BMC51423I FIELD 'VARCHAR_COL4                  ' HAS POSITION(33:72)
 BMC51423I FIELD 'CHAR_COL5                     ' HAS POSITION(73:79)
 BMC51561I CALCULATED NUMBER OF INPUT RECORDS = 39 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 NOT ACTIVATED, NO ROWS ON POLICY TABLE

 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  = AMUEX01   &STEPNAME = EXAMPL1C  &DB       = AMUEX1DB  &TS       = EX1TS     &UID      = BMCJXS
 BMC50425I &RESUME   = N         &REPLACE  = Y         &DATE     = 083022    &TIME     = 072303    &SSID     = DEND
 BMC50425I &UTIL     = AMUEX01  &UTILPFX  = AMUEX01  &UTILSFX  =           &DATE8    = 08302022  &GRPNM    = DEND
 BMC50425I &VCAT     = DENDCAT   &TIME4    = 0723      &DATEJ    = 2022242   &JDATE    = 22242

 BMC50445I LOAD PLUS DYNAMIC FILE ALLOCATION REPORT
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8444K, ABOVE 16M = 1007988K, CPUS = 5
 BMC50479I TOTAL PAGES: 12738031, ALLOWED: 3821410; AVAILABLE PAGES: 5364387, ALLOWED: 0
 BMC51499I COMBINED OPTIMIZATION, RC=0, #SORTS=1, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=37632
 BMC51500I COMBINED ANALYZE, #SORTS=1, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0
 BMC51453I EXISTING ROWS IN TABLESPACE 'AMUEX1DB.EX1TS' DELETED
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'DATE_COL3', RECORD NO. 1 OF SYSREC, DATA = C'1990-02-29'
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'DATE_COL3', RECORD NO. 2 OF SYSREC, DATA = C'1990-13-1 '
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'DATE_COL3', RECORD NO. 3 OF SYSREC, DATA = C'1990-9-31 '
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'TIMESTAMP_COL2', RECORD NO. 5 OF SYSREC, DATA = C'1990-02-31-12.32.00'
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'TIMESTAMP_COL2', RECORD NO. 7 OF SYSREC, DATA = C'1990-04-31-12.34.00'
 BMC51501E DATE/TIME VALUE OUT-OF-RANGE, COLUMN = 'TIMESTAMP_COL2', RECORD NO. 8 OF SYSREC, DATA = C'1990-11-31-12.35.00'
 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:  26 PHYSICAL (26 LOGICAL) RECORDS READ FROM SYSREC
 BMC50482I 2: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DENDCAT.BMCDBD.AMUEX1DB.EX1TS.I0001.A001'
 BMC50477I 2: PARTITION =    1, ROWS/KEYS = 20, I/O WAITS = 10 ,DDNAME = SYS00038
 BMC51474I LOAD STATISTICS:  20 ROWS LOADED INTO TABLE SPACE 'AMUEX1DB.EX1TS' PARTITION 1
 BMC50481I 2: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 2: SORT TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50476I DDNAME = SYSERR, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51507I XBLKS = 4, XFERS = 1, EMPTY WAITS = 0, FULL WAITS =0
 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 = SYSREC, 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 AMUEX01.TBL1
 BMC51522I    INPUT        DISCARD  DISCARD               RELATED
 BMC51523I  ID: RECORD #    RECORD#  TYPE                 ID: RECORD #  FIELD, INDEX, OR CONSTRAINT NAME

 BMC51524E   1:         1          1 CONVERSION            0:         7 DATE_COL3
 BMC51524E   1:         2          2 CONVERSION            0:         7 DATE_COL3
 BMC51524E   1:         3          3 CONVERSION            0:         7 DATE_COL3
 BMC51524E   1:         5          4 CONVERSION            0:         7 TIMESTAMP_COL2
 BMC51524E   1:         7          5 CONVERSION            0:         7 TIMESTAMP_COL2
 BMC51524E   1:         8          6 CONVERSION            0:         7 TIMESTAMP_COL2


 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
 BMC51472I COMBINED PHASE STATISTICS:  20 ROWS SELECTED FOR SPACE 'AMUEX1DB.EX1TS', 6 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
 BMC51479I COMBINED PHASE STATISTICS:  6 PHYSICAL (6 LOGICAL) RECORDS DISCARDED TO SYSDISC
 BMC51474I LOAD STATISTICS:  20 ROWS LOADED INTO TABLE SPACE 'AMUEX1DB.EX1TS' PARTITION 1
 BMC51473I LOAD STATISTICS:  20 ROWS LOADED INTO TABLE 'AMUEX01.TBL1'
 BMC51475I LOAD STATISTICS:  20 ROWS LOADED INTO TABLE SPACE 'AMUEX1DB.EX1TS'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR  ', DSNAME = 'AMU.EXAMP01C.SYSERR'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT ', DSNAME = 'AMU.EXAMP01C.SORTOUT'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I COMBINED PHASE COMPLETE.  ELAPSED TIME = 00:00:00

 BMC50705I SQL PREPARE LOCK STARTED
 BMC50894I RENAME PROCESS STARTING AT   8/30/2022   7:23:05
 BMC50890I 1: ATTEMPTING TO RENAME DATASET 'DENDCAT.DSNDBC.AMUEX1DB.EX1TS.I0001.A001'...
 BMC50891I 1: DATASET 'DENDCAT.DSNDBC.AMUEX1DB.EX1TS.I0001.A001' IS RENAMED
 BMC50890I 1: ATTEMPTING TO RENAME DATASET 'DENDCAT.DSNDBD.AMUEX1DB.EX1TS.I0001.A001'...
 BMC50891I 1: DATASET 'DENDCAT.DSNDBD.AMUEX1DB.EX1TS.I0001.A001' IS RENAMED
 BMC50890I 1: ATTEMPTING TO RENAME DATASET 'DENDCAT.BMCDBC.AMUEX1DB.EX1TS.I0001.A001'...
 BMC50891I 1: DATASET 'DENDCAT.BMCDBC.AMUEX1DB.EX1TS.I0001.A001' IS RENAMED
 BMC50890I 1: ATTEMPTING TO RENAME DATASET 'DENDCAT.BMCDBD.AMUEX1DB.EX1TS.I0001.A001'...
 BMC50891I 1: DATASET 'DENDCAT.BMCDBD.AMUEX1DB.EX1TS.I0001.A001' IS RENAMED
 BMC50895I RENAME PROCESS COMPLETE.  ELAPSED TIME =  00:00:00

 BMC50705I SQL PREPARE LOCK TERMINATED
 BMC50890I 1: ATTEMPTING TO DELETE DATASET 'DENDCAT.OLDDBC.AMUEX1DB.EX1TS.I0001.A001'...
 BMC50891I 1: DATASET 'DENDCAT.OLDDBC.AMUEX1DB.EX1TS.I0001.A001' IS DELETED

 BMC50501I DB2 OBJECT STATISTICS
0BMC50515I TABLESPACE  AMUEX1DB.EX1TS  PARTS   = 1         TABLES  = 1     SEGSIZE = 8     PAGESIZE = 4K
 BMC50516I             PART  NACTIVE       CARD   EXTENTS   DBCARD PCOMP   KSAVED  PSAVED
 BMC50517I                1       11         20         1        0     0        0       0
 BMC50518I   TABLE     AMUEX01.TBL1
 BMC50519I             ROWAVG    NPAGES       CARD   PCTPAGES
 BMC50520I                 58         4         20         36
 BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR LOAD UTILITY SUCCESSFUL FOR ALL OBJECTS
 BMC50386W IMAGE COPY REQUIRED.  TABLE SPACE AMUEX1DB.EX1TS REMAINS IN "COPY PENDING" STATE
 BMC50004I UTILTERM PHASE COMPLETE.  ELAPSED TIME = 00:00:01

0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 4

 

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