Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see LOADPLUS for DB2 13.1.

Example 5 — LOAD REPLACE with data conversion

This example illustrates a LOAD REPLACE of a partitioned table space with four partitions, a clustering index, and a nonpartitioned index. LOADPLUS replaces all existing rows.

The ORDER YES option tells LOADPLUS to sort the input data in clustering index order. Although LOADPLUS makes four copies of the table space, only two of the copies are registered as specified by the REGISTER option. INLINE NO tells LOADPLUS to make standard image copies instead of inline copies, overriding the value in the installation options module.

Options on the WHEN statement direct LOADPLUS to trim excess space on VARCHAR columns, and convert dates in MM/DD/YY format to the Db2 date format.

This example shows use of a conversion exit that converts a four-byte alphanumeric DEPT_NO to a four-byte numeric field. The STEPLIB DD statement includes the exit library. Member AMUXDEPT of the HLQ.LLQSAMP data set contains this sample exit.

This job also illustrates how you can use LOADPLUS to handle problems with invalid input data. It shows use of the NULLIF clause to bypass the format check in the case of a date input field and a character field. If the HIRE_DATE field contains data that is not in valid date format (***** or 00/00/00), the record is not discarded, but the invalid data is translated to nulls. Likewise, using the NOT IN operand with the PART_401K field tells LOADPLUS to convert invalid data in that field to nulls. The DEFAULTIF clause tells LOADPLUS to convert input values in the PART_401K field to user-assigned default values.

RULES=BMC is specified in the options module so that you 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.

This example provides an image of the DDL that was used to create the Db2 objects being loaded, the JCL that was used to run the job, an image of the SYSREC data set, SYSPRINT output from the execution of the LOADPLUS utility, and output showing the loaded table.

The following figure shows the DDL used to create the Db2 objects being loaded in example 5:

           CREATE TABLESPACE EX5TS IN AMUEX5DB
             CCSID EBCDIC
             BUFFERPOOL  BP0
             CLOSE NO
             NUMPARTS 4
             USING STOGROUP AMUQASTO
                                    PRIQTY 12
                                    SECQTY 12
                                    ERASE NO
             FREEPAGE 005
             PCTFREE 25;
             COMMIT              ;
           CREATE TABLE EXAMPLE5.EMPLS
                (EMP_ID                DECIMAL(5) NOT NULL
                ,SSN                   CHAR(9)    NOT NULL
                ,HIRE_DATE             DATE
                ,DEPT_NO               CHAR(4)    NOT NULL
                ,JOB_CODE              SMALLINT
                ,SALARY                DECIMAL(9,2)
                ,PART_401K             CHAR(1)
                ,EMP_LNAME             VARCHAR(20) NOT NULL
                ,EMP_FNAME             VARCHAR(15) NOT NULL
                ,EMP_MNAME             VARCHAR(15)
                )
             IN AMUEX5DB.EX5TS
             PARTITION   BY (DEPT_NO)
               (PART 1 VALUES ('3999')
               ,PART 2 VALUES ('5999')
               ,PART 3 VALUES ('7999')
               ,PART 4 VALUES ('9999')) ;
             COMMIT              ;
           CREATE        INDEX EXAMPLE5.EMPLS_CLUST_IX
             ON EXAMPLE5.EMPLS (DEPT_NO)
                 USING STOGROUP AMUQASTO
                 CLUSTER ;
             COMMIT              ;
           CREATE        INDEX EXAMPLE5.EMPLS_NC_IX
             ON EXAMPLE5.EMPLS (EMP_ID)
             PARTITIONED
                 USING STOGROUP AMUQASTO ;

The following figure shows the JCL for example 5:

//EXAMPLE5 EXEC PGM=AMUUMAIN,
//             PARM='&SSID,EXAMPLE5,NEW/RESTART,,MSGLEVEL(1),AMU$OPTS'
//*                  SSID,UTILID ,RSTART,NOTIFY,MSGLEVEL
//STEPLIB  DD DISP=SHR,DSN=product.libraries
//         DD DISP=SHR,DSN=AUS.EDITPR.LOADLIB
//         DD DISP=SHR,DSN=DB2.DSNEXIT
//         DD DISP=SHR,DSN=DB2.DSNLOAD
//*
/*
//SYSPRINT  DD SYSOUT=*
//SYSOUT    DD SYSOUT=*
//UTPRINT   DD SYSOUT=*
//SYSUDUMP  DD SYSOUT=*
//*
//SYSREC    DD DSN=AMU.QA.RGRTESTS.DTA163,DISP=SHR
//SORTOUT   DD DSN=AMU.EXAMP005.SORTOUT,
//             UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SYSERR    DD DSN=AMU.EXAMP005.SYSERR,
//             UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SYSDISC   DD DSN=AMU.EXAMP005.SYSDISC,
//             UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//*
//SYSUT101  DD DSN=AMU.EXAMP005.SYSUT1,
//             UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SYSUT102  DD DSN=AMU.EXAMP005.SYSUT2,
//             UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//*
//SORTWK01  DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK02  DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK03  DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK04  DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK05  DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK06  DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK07  DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK08  DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK09  DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK10  DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK11  DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK12  DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//*
//BMCCPY    DD DSN=AMU.EXAMP005.BMCCPY,
//             UNIT=WORK,SPACE=(TRK,(3,1)),DISP=(NEW,CATLG)
//BMCCPZ    DD DSN=AMU.EXAMP005.BMCCPZ,
//             UNIT=WORK,SPACE=(TRK,(3,1)),DISP=(NEW,CATLG)
//BMCRCY    DD DSN=AMU.EXAMP005.BMCRCY,
//             UNIT=WORK,SPACE=(TRK,(3,1)),DISP=(NEW,CATLG)
//BMCRCZ    DD DSN=AMU.EXAMP005.BMCRCZ,
//             UNIT=WORK,SPACE=(TRK,(3,1)),DISP=(NEW,CATLG)
//*
//SYSIN     DD  *
    LOAD DATA REPLACE
      PRELOAD CONTINUE
      ORDER YES
      COPY YES INLINE NO REGISTER BMCCPY,BMCRCY
        INTO TABLE EXAMPLE5.EMPLS
          WHEN DEPT_NO > '1000'
                (PART_401K  POSITION(34)  CHAR(1)
                    NULLIF    PART_401K NOT IN ('Y','N','1','0')
                    DEFAULTIF PART_401K = 'Y' VALUE('1')
                    DEFAULTIF PART_401K = 'N' VALUE('0')
                ,EMP_ID     POSITION(1)    CHAR(5)
                ,SSN        POSITION(7)  CHAR(9)
                ,JOB_CODE   POSITION(22)  INTEGER EXTERNAL(3)
                    NULLIF  ERROR
                ,SALARY     POSITION(26)  DEC EXTERNAL(7,0)
                ,DEPT_NO    POSITION(17)  EXIT AMUXDEPT(4)
                ,EMP_LNAME  POSITION(36) CHAR(20) TRIM
                ,EMP_FNAME  POSITION(57) CHAR(15) TRIM
                ,EMP_MNAME  POSITION(73) CHAR(15) TRIM
                ,HIRE_DATE  POSITION(89) DATE-D1 EXTERNAL
                    NULLIF (89:93) = '*****'
                    NULLIF (89:96) = '00/00/00'
                )
/*

SYSREC for example 5

The following figure shows an image of the SYSREC data set for example 5:

00101.451846211.A00 .066.0052750.Y.HAAS                .CHRISTINE      .I          .01/01/65
00120.326759081.B01 .061.0041250.Y.THOMPSON            .MICHAEL        .L            .*****
00138.238755558.C01 .060.0038250.Y.KWAN                .SALLY          .A            .*****
00240.456679040.E01 .058.0040175.Y.GEYER               .JOHN           .B          .08/17/49
00258.873402211.D11 .055.0032250.Y.STERN               .IRVING         .F          .09/14/73
00266.433358923.D21 .056.0036170. .PULASKI             .EVA            .D          .00/00/00
00307.345270812.E11 .055.0029750.N.HENDERSON           .EILEEN         .W          .08/15/70
00380.453809376.E21 .054.0026150.N.SPENSER             .THEODORE       .Q          .06/19/80
00390.176834690.A00 .058.0046500.N.LUCCHESI            .VINCENZO       .G          .05/16/58
00400.611800345.A00 .058.0029250.N.O'CONNELL           .SEAN           .           .00/00/00
00419.112377650.C01 .055.0023800.N.QUINTANA            .DOLORES        .M          .07/28/71
00428.231544001.C01 .056.0028420.N.NICHOLLS            .HEATHER        .A          .12/15/76
00433.157919155.D11 .055.0025280.N.ADAMSON             .BRUCE          .           .02/12/72
00540.268025274.D11 .056.0022250.N.PIANKA              .ELIZABETH      .R          .10/11/77
00559.379136386.D11 .055.0024680.N.YOSHIMURA           .MASATOSHI      .J          .09/15/76
00567.480247497.D11 .054.0021340.0.SCOUTEN             .MARILYN        .S          .07/07/78
00672.591358508.D11 .054.0020450.N.WALKER              .JAMES          .H          .07/26/73
00682.602469819.D11 .053.0027740.Y.BROWN               .DAVID          .           .03/03/74
00690.713571723.D11 .053.0018270.N.JONES               .WILLIAM        .T          .04/11/66
00701.824682632.D11 .055.0029840. .LUTZ                .JENNIFER       .K          .08/29/79
00718.935793541.D11 .052.0022180. .JEFFERSON           .JAMES          .J          .11/21/69
00724.146824450.D11 .055.0028760. .MARINO              .SALVATORE      .M          .12/05/75
00830.257935361.D21 .053.0019180.N.SMITH               .DANIEL         .S          .10/13/80
00844.368046272.D21 .055.0017250.0.JOHNSON             .SYBIL          .V          .09/11/67
00852.479157183.D21 .052.0027380.N.PEREZ               .MARIA          .L          .09/29/80
00862.580268294.D21 .052.0026250.N.SCHNEIDER           .ETHEL          .R          .03/21/72
00876.691379385.D21 .055.0015340. .PARKER              .JOHN           .R          .05/05/64
00888.702480479.E11 .054.0017750. .SMITH               .PHILLIP        .X          .06/30/65
00898.813593568.E11 .042.0015900.N.SETRIGHT            .MAUDE          .F          .09/24/76
00909.924644657.E11 .048.0019950.N.MEHTA               .RAMLAL         .V          .07/30/77
00918.135755746.E11 .043.0025370.Y.LEE                 .WING           .           .02/19/88
00923.246866835.E21 .052.0023840.1.GROUNOT             .JASON          .R          .05/12/86

SYSPRINT for example 5

The following figure shows the SYSPRINT output for example 5:

1                          *************  B M C   L O A D P L U S   F O R   D B 2    V11R2.00 ************
                                             (C) COPYRIGHT 1990 - 2015 BMC SOFTWARE, INC.
                           LOADPLUS TECHNOLOGY IS PROTECTED BY U.S. PATENT NUMBERS 7,664,790 AND 7,930,291
-BMC50001I UTILITY EXECUTION STARTING    3/09/2015   14:39:45 ...
 BMC50002I UTILITY ID = 'EXAMPLE5'.  DB2 SUBSYSTEM ID = 'DEHJ'.  OPTION MODULE = 'AMU$OPTS'.
 BMC50471I z/OS 2.1.0,PID=HBB7790,DFSMS FOR Z/OS=2.1.0,DB2=11.1.0
 BMC50471I REGION=0M,BELOW 16M=8776K,ABOVE 16M=1298248K,IEFUSI=NO,CPUS=3
 BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040300M,MEMLIMIT SET BY:REGION=0
0
 BMC50471I LOADPLUS FOR DB2--V11.02.00
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I DB2 UTILITIES COMMON CODE--V11.02.00
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I SOLUTION COMMON CODE--V11.01.00
 BMC50471I   MAINT: BPJ0661  BPJ0667  BPJ0671  BPJ0674  BPJ0675  BPJ0676  BPJ0682  BPJ0686  BPJ0689  BPJ0697  BPJ0700  BPJ0702
 BMC50471I          BPJ0703  BPJ0706  BPJ0712  BPJ0715  BPJ0729  BPJ0773  BPJ0786  BPJ0794  BPJ0806  BPJ0830  BPJ0833  BPJ0839
 BMC50471I          BPJ0845  BPJ0866  BPJ0892  BPJ0913  BPJ0914  BPJ0916  BPJ0930  BPJ0944  BPJ0946
 BMC50471I BMCSORT ENGINE--V02.04.01
 BMC50471I   MAINT: BPJ0691  BPJ0718  BPJ0881  BPJ0922
 BMC50471I BMC STATS API--V11.02.00
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I EXTENDED BUFFER MANAGER--V06.01.00
 BMC50471I   MAINT: BPE0401  BPE0403  BPE0405  BPE0407  BPE0410  BPE0412  BPE0416  BPE0420  BPE0422  BPE0423  BPE0426  BPE0428
 BMC50471I          BPE0430  BPE0433  BPE0435  BPE0438  BPE0439
 BMC50471I HIGH-SPEED APPLY ENGINE--V11.02.00
 BMC50471I   NO MAINTENANCE TO REPORT
0
 BMC50471I APCOMMIT=2500                           FORCE_AT=(START,3)                      RCVYDDN=(BMCRCY,BMCRCZ)
 BMC50471I APDOPTS=                                FORCE_RPT=NO                            REDEFINE=YES
 BMC50471I APMULTIROW=100                          FORCE=NONE                              RENMMAX=30
 BMC50471I APMXAGNT=10                             IBUFFS=20                               RULES=BMC
 BMC50471I APRETLIM=COUNT                          IDCACHE=1000                            SDUMP=YES
 BMC50471I APRETVAL=5                              IDCDDN=SYSIDCIN                         SHORTMEMORY=CONTINUE
 BMC50471I AUTOENUMROWS=YES                        IDERROR=DISCARD                         SHRLEVEL=(NONE,NONE)
 BMC50471I AVAILPAGEPCT=0                          INDDN=SYSREC                            SMAX=16
 BMC50471I CBUFFS=30                               INFORI=NO                               SMCORE=(0K,0K)
 BMC50471I CENTURY=(1950,2049)                     INLINECP=YES                            SORTDEVT=(,SYSALLDA)
 BMC50471I CHEKPEND=YES                            KEEPDICTIONARY=NO                       SORTNUM=32
 BMC50471I COPYDDN=(BMCCPY,BMCCPZ)                 LBUFFS=20                               SQLDELAY=3
 BMC50471I COPYLVL=FULL                            LOADDN=SORTOUT                          SQLRETRY=100
 BMC50471I COPYPEND=YES                            LOBAVGPCT=50                            STOP@CMT=YES
 BMC50471I COPYSUBSET=NO                           LOCKROW=YES                             STOPDELAY=1
 BMC50471I DELFILES=(YES,NO)                       LONGNAMETRUNC=MIDDLE                    STOPRETRY=300
 BMC50471I DISCARDLIMRC=8                          MAPDDN=SYSMAP                           TAPEDISP=DELETE
 BMC50471I DISCARDRC=0                             MAXP=5                                  TOTALPAGEPCT=30
 BMC50471I DISCDDN=SYSDISC                         MAXSORTMEMORY=0                         TSSAMPLEPCT=100
 BMC50471I DRNDELAY=1                              MAXTAPE=3                               UPDMAXA_AUTHID=USER
 BMC50471I DRNRETRY=255                            MGEXTENT=CONTINUE                       UPDMAXA=NO
 BMC50471I DRNWAIT=NONE                            MINSORTMEMORY=0                         UXSTATE=SUP
 BMC50471I DSNUEXIT=(NONE,ASM)                     MSGLEVEL=1                              WBUFFS=(20,10)
 BMC50471I DSNUTILB=YES                            OPNDB2ID=YES                            WORKDDN=SYSUT1
 BMC50471I ENFORCE=CHECK                           ORIGDISP=DELETE                         WORKUNIT=SYSALLDA
 BMC50471I ERRDDN=SYSERR                           PAUSEDISCARDRC=4                        XBLKS=3
 BMC50471I EXCLDUMP=(X37,X22,X06)                  PLAN=AMUQA                              XMLAVGSIZE=10240
 BMC50471I FASTSWITCH=NO                           PREFORMAT=NO                            ZEROROWRC=0
 BMC50471I FILECHK=WARN                            PRELOAD=LOAD                            ZIIP=ENABLED
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=&UID..BMC.&TS.&DDNAME
 BMC50483I WORK       DSNPAT=&UID..BMC.&TS.&DDNAME
 BMC50483I SORTWORK   DSNPAT=NONE
 BMC50483I ERROR      DSNPAT=&UID..BMC.&TS.&DDNAME
 BMC50483I DISCARD    DSNPAT=&UID..BMC.&TS.&DDNAME
 BMC50483I SYSMAP     DSNPAT=&UID..BMC.&TS.&DDNAME
0
 BMC50483I LOCPFCPY   DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
 BMC50483I LOCBFCPY   DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
 BMC50483I REMPFCPY   DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
 BMC50483I REMBFCPY   DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
 BMC50483I LOCPLCPY   DSNPAT=&UID.&DDNAME.&TS..T&TIME
 BMC50483I LOCBLCPY   DSNPAT=&UID.&DDNAME.&TS..T&TIME
 BMC50483I REMPLCPY   DSNPAT=&UID.&DDNAME.&TS..T&TIME
 BMC50483I REMBLCPY   DSNPAT=&UID.&DDNAME.&TS..T&TIME
0
 BMC50483I LOCPXCPY   DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
 BMC50483I LOCBXCPY   DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
 BMC50483I REMPXCPY   DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
 BMC50483I REMBXCPY   DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0

 BMC50471I DB2 DSNHDECP MODULE SETTINGS:
 BMC50471I VERSION                 = 1110
 BMC50471I SUBSYSTEM DEFAULT       = DEHJ
 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)

 BMC50028I DB2 MODE = NFM
 BMC50471I BMC_BMCUTIL       ='BMCUTIL.CMN_BMCUTIL'
 BMC50471I BMC_BMCSYNC       ='BMCUTIL.CMN_BMCSYNC'
 BMC50471I BMC_BMCHIST       ='BMCUTIL.CMN_BMCHIST'
 BMC50471I BMC_BMCDICT       ='BMCUTIL.CMN_BMCDICT'
0
0
 BMC50102I     LOAD DATA REPLACE
 BMC50102I       PRELOAD CONTINUE
 BMC50102I       ORDER YES
 BMC50102I       COPY YES INLINE NO REGISTER BMCCPY,BMCRCY
 BMC50102I         INTO TABLE EXAMPLE5.EMPLS
 BMC50102I           WHEN DEPT_NO > '1000'
 BMC50102I                 (PART_401K  POSITION(34)  CHAR(1)
 BMC50102I                     NULLIF    PART_401K NOT IN ('Y','N','1','0')
 BMC50102I                     DEFAULTIF PART_401K = 'Y' VALUE('1')
 BMC50102I                     DEFAULTIF PART_401K = 'N' VALUE('0')
 BMC50102I                 ,EMP_ID     POSITION(1)    CHAR(5)
 BMC50102I                 ,SSN        POSITION(7)  CHAR(9)
 BMC50102I                 ,JOB_CODE   POSITION(22)  INTEGER EXTERNAL(3)
 BMC50102I                     NULLIF  ERROR
 BMC50102I                 ,SALARY     POSITION(26)  DEC EXTERNAL(7,0)
 BMC50102I                 ,DEPT_NO    POSITION(17)  EXIT AMUXDEPT(4)
 BMC50102I                 ,EMP_LNAME  POSITION(36) CHAR(20) TRIM
 BMC50102I                 ,EMP_FNAME  POSITION(57) CHAR(15) TRIM
 BMC50102I                 ,EMP_MNAME  POSITION(73) CHAR(15) TRIM
 BMC50102I                 ,HIRE_DATE  POSITION(89) DATE-D1 EXTERNAL
 BMC50102I                     NULLIF (89:93) = '*****'
 BMC50102I                     NULLIF (89:96) = '00/00/00'
 BMC50102I                 )

 BMC51424I ANALYZE PHASE WILL BE PERFORMED DUE TO DYNAMIC WORK FILE ALLOCATION
 BMC51422I FOR TABLE 'EXAMPLE5.EMPLS', THE FOLLOWING INPUT FIELDS HAVE KNOWN START:END POSITIONS THAT WERE NOT SPECIFIED
 BMC51423I FIELD 'PART_401K                     ' HAS POSITION(34:34)
 BMC51423I FIELD 'EMP_ID                        ' HAS POSITION(1:5)
 BMC51423I FIELD 'SSN                           ' HAS POSITION(7:15)
 BMC51423I FIELD 'JOB_CODE                      ' HAS POSITION(22:24)
 BMC51423I FIELD 'SALARY                        ' HAS POSITION(26:32)
 BMC51423I FIELD 'DEPT_NO                       ' HAS POSITION(17:20)
 BMC51423I FIELD 'EMP_LNAME                     ' HAS POSITION(36:55)
 BMC51423I FIELD 'EMP_FNAME                     ' HAS POSITION(57:71)
 BMC51423I FIELD 'EMP_MNAME                     ' HAS POSITION(73:87)
 BMC51423I FIELD 'HIRE_DATE                     ' HAS POSITION(89:96)
 BMC51561I CALCULATED NUMBER OF INPUT RECORDS = 41 USING A SCALING FACTOR OF 100%
 BMC50004I UTILINIT PHASE COMPLETE.  ELAPSED TIME = 00:00:00

 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  = AMUEX05   &STEPNAME = EXAMPLE5  &DB       = AMUEX5DB  &TS       = EX5TS     &UID      = RDAMZL
 BMC50425I &RESUME   = N         &REPLACE  = Y         &DATE     = 030915    &TIME     = 143945    &SSID     = DEHJ
 BMC50425I &UTIL     = EXAMPLE5  &UTILPFX  = EXAMPLE5  &UTILSFX  =           &DATE8    = 03092015  &GRPNM    = DEHJ
 BMC50425I &VCAT     = DEHJCAT   &TIME4    = 1439      &DATEJ    = 2015068   &JDATE    = 15068

 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 SORTOUT2 RDAMZL.BMC.EX5TS.SORTOUT2                    SYSALLDA                          3        2        1         1  TRK
 BMC50448I SORTOUT3 RDAMZL.BMC.EX5TS.SORTOUT3                    SYSALLDA                          3        2        1         1  TRK
 BMC50448I SORTOUT4 RDAMZL.BMC.EX5TS.SORTOUT4                    SYSALLDA                          3        2        1         1  TRK

 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8432K, ABOVE 16M = 1264740K, CPUS = 3
 BMC50479I TOTAL PAGES: 3849231, ALLOWED: 1154770; AVAILABLE PAGES: 331493, ALLOWED: 0
 BMC51495I PRELOAD OPTIMIZATION, RC = 0, #SORTS = 4, #READERS = 1, INDEX TASKS = 1, TIME = 77824
 BMC51495I PRELOAD OPTIMIZATION, RC = 14, #SORTS = 3, #READERS = 1, INDEX TASKS = 1, TIME = 95164
 BMC51496I PRELOAD ANALYZE, #SORTS = 4, #READERS = 1, INDEX TASKS = 1
 BMC50486I 5: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 2: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 4: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 3: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50481I 1: READ TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 1: READ TASK, XBLK XFERS = 4, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51478I PRELOAD STATISTICS:  32 PHYSICAL (32 LOGICAL) RECORDS READ FROM SYSREC
 BMC50481I 5: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 2: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 4: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 3: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 5: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 2: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 3: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 5: SORT TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51510I 2: SORT TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50481I 4: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 3: SORT TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51510I 4: SORT TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50476I DDNAME = SYSREC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT2, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT3, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT4, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSUT102, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSUT101, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSERR, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC51507I XBLKS = 14, XFERS = 4, EMPTY WAITS = 0, FULL WAITS =0
 BMC50486I 1002: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 1001: 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 DISCARDS NOT SPECIFIC TO A TABLE
 BMC51522I    INPUT        DISCARD  DISCARD               RELATED
 BMC51523I  ID: RECORD #    RECORD#  TYPE                 ID: RECORD #  FIELD, INDEX, OR CONSTRAINT NAME

 BMC51524E   1:         1          1 WHEN                  0:         0
 BMC51524E   1:         9          2 WHEN                  0:         0
 BMC51524E   1:        10          3 WHEN                  0:         0

 BMC51510I 1001: DISCARD TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 0

 BMC51510I 1002: DISCARD TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 1
 BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51471I PRELOAD STATISTICS:  4 ROWS SELECTED FOR PARTITION 1
 BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX5DB.EX5TS.I0001.A001' WILL REQUIRE 3 PAGES
 BMC51488I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX5DB.EMPLSRNC.I0001.A001' MAY REQUIRE 4 PAGES
 BMC51471I PRELOAD STATISTICS:  12 ROWS SELECTED FOR PARTITION 2
 BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX5DB.EX5TS.I0001.A002' WILL REQUIRE 3 PAGES
 BMC51488I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX5DB.EMPLSRNC.I0001.A002' MAY REQUIRE 4 PAGES
 BMC51471I PRELOAD STATISTICS:  11 ROWS SELECTED FOR PARTITION 3
 BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX5DB.EX5TS.I0001.A003' WILL REQUIRE 3 PAGES
 BMC51488I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX5DB.EMPLSRNC.I0001.A003' MAY REQUIRE 4 PAGES
 BMC51471I PRELOAD STATISTICS:  2 ROWS SELECTED FOR PARTITION 4
 BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX5DB.EX5TS.I0001.A004' WILL REQUIRE 3 PAGES
 BMC51488I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX5DB.EMPLSRNC.I0001.A004' MAY REQUIRE 4 PAGES
 BMC51488I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX5DB.EMPLSRCL.I0001.A001' MAY REQUIRE 4 PAGES
 BMC51472I PRELOAD PHASE STATISTICS:  29 ROWS SELECTED FOR SPACE 'AMUEX5DB.EX5TS', 0 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
 BMC51479I PRELOAD PHASE STATISTICS:  3 PHYSICAL (3 LOGICAL) RECORDS DISCARDED TO SYSDISC
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I PRELOAD PHASE COMPLETE.  ELAPSED TIME = 00:00:01

 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8508K, ABOVE 16M = 1290804K, CPUS = 3
 BMC50479I TOTAL PAGES: 3851431, ALLOWED: 1155430; AVAILABLE PAGES: 331832, ALLOWED: 0
 BMC51498I LOAD OPTIMIZATION, RC = 0, #LOAD TASKS = 4, #COPY TASKS = 1, #INDEX TASKS = 2
 BMC50370I STARTING 1 IMAGE COPY TASKS
 BMC51508I MAX DATA TASKS = 4, MAX PARTS PER TASK = 1, SORTWKS PER TASK = 0, MAX OPEN PARTITIONS PER TASK = 1
 BMC51453I EXISTING ROWS IN TABLESPACE 'AMUEX5DB.EX5TS' DELETED
 BMC51508I MAX INDEX TASKS = 2, INDEXES PER TASK = 1, SORTWKS PER TASK = 6, MAX OPEN PARTITIONS PER TASK = 1
 BMC50486I 2: BMCSORT STARTED, 384K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50482I 0: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX5DB.EX5TS.I0001.A003'
 BMC50477I 0: PARTITION =    3, ROWS/KEYS = 11, I/O WAITS = 7 ,DDNAME = SYS00015
 BMC50482I 1: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX5DB.EX5TS.I0001.A002'
 BMC50477I 1: PARTITION =    2, ROWS/KEYS = 12, I/O WAITS = 7 ,DDNAME = SYS00018
 BMC50482I 2: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX5DB.EX5TS.I0001.A004'
 BMC50477I 2: PARTITION =    4, ROWS/KEYS = 2, I/O WAITS = 7 ,DDNAME = SYS00017
 BMC51474I LOAD STATISTICS:  11 ROWS LOADED INTO TABLE SPACE 'AMUEX5DB.EX5TS' PARTITION 3
 BMC50482I 3: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX5DB.EX5TS.I0001.A001'
 BMC50477I 3: PARTITION =    1, ROWS/KEYS = 4, I/O WAITS = 7 ,DDNAME = SYS00016
 BMC51474I LOAD STATISTICS:  12 ROWS LOADED INTO TABLE SPACE 'AMUEX5DB.EX5TS' PARTITION 2
 BMC50476I DDNAME = SORTOUT, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51474I LOAD STATISTICS:  2 ROWS LOADED INTO TABLE SPACE 'AMUEX5DB.EX5TS' PARTITION 4
 BMC51474I LOAD STATISTICS:  4 ROWS LOADED INTO TABLE SPACE 'AMUEX5DB.EX5TS' PARTITION 1
 BMC50476I DDNAME = SORTOUT2, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50486I 1: BMCSORT STARTED, 384K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50476I DDNAME = SORTOUT3, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSUT101, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50481I 2: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50476I DDNAME = SORTOUT4, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51475I LOAD STATISTICS:  29 ROWS LOADED INTO TABLE SPACE 'AMUEX5DB.EX5TS'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX5DB.EX5TS.I0001.A001'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX5DB.EX5TS.I0001.A002'
 BMC50476I DDNAME = SYSUT102, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50481I 1: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX5DB.EX5TS.I0001.A003'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX5DB.EX5TS.I0001.A004'
 BMC50476I DDNAME = BMCCPY, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPZ, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCY, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCRCZ, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
 BMC50376I 12 PAGES COPIED TO DATASET = 'AMU.EXAMP005.BMCCPY'
 BMC50376I 12 PAGES COPIED TO DATASET = 'AMU.EXAMP005.BMCCPZ'
 BMC50376I 12 PAGES COPIED TO DATASET = 'AMU.EXAMP005.BMCRCY'
 BMC50376I 12 PAGES COPIED TO DATASET = 'AMU.EXAMP005.BMCRCZ'
 BMC50482I 2: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX5DB.EMPLSRCL.I0001.A001'
 BMC50477I 2: PARTITION =    0, ROWS/KEYS = 29, I/O WAITS = 7 ,DDNAME = SYS00025
 BMC51476I BUILD STATISTICS:  29 KEYS LOADED INTO INDEX 'EXAMPLE5.EMPLS_CLUST_IX'
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX5DB.EMPLSRNC.I0001.A001'
 BMC50477I 1: PARTITION =    1, ROWS/KEYS = 4, I/O WAITS = 7 ,DDNAME = SYS00027
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX5DB.EMPLSRNC.I0001.A002'
 BMC50477I 1: PARTITION =    2, ROWS/KEYS = 12, I/O WAITS = 7 ,DDNAME = SYS00029
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX5DB.EMPLSRNC.I0001.A003'
 BMC50477I 1: PARTITION =    3, ROWS/KEYS = 11, I/O WAITS = 7 ,DDNAME = SYS00031
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX5DB.EMPLSRNC.I0001.A004'
 BMC50477I 1: PARTITION =    4, ROWS/KEYS = 2, I/O WAITS = 7 ,DDNAME = SYS00033
 BMC51476I BUILD STATISTICS:  29 KEYS LOADED INTO INDEX 'EXAMPLE5.EMPLS_NC_IX'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK01', DSNAME = 'SYS15068.T143939.RA000.AMUEX05.R0329557'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK02', DSNAME = 'SYS15068.T143939.RA000.AMUEX05.R0329558'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK03', DSNAME = 'SYS15068.T143939.RA000.AMUEX05.R0329559'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK04', DSNAME = 'SYS15068.T143939.RA000.AMUEX05.R0329560'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK05', DSNAME = 'SYS15068.T143939.RA000.AMUEX05.R0329561'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK06', DSNAME = 'SYS15068.T143939.RA000.AMUEX05.R0329562'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK07', DSNAME = 'SYS15068.T143939.RA000.AMUEX05.R0329563'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK08', DSNAME = 'SYS15068.T143939.RA000.AMUEX05.R0329564'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK09', DSNAME = 'SYS15068.T143939.RA000.AMUEX05.R0329565'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK10', DSNAME = 'SYS15068.T143939.RA000.AMUEX05.R0329566'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK11', DSNAME = 'SYS15068.T143939.RA000.AMUEX05.R0329567'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK12', DSNAME = 'SYS15068.T143939.RA000.AMUEX05.R0329568'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR  ', DSNAME = 'AMU.EXAMP005.SYSERR'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT102', DSNAME = 'AMU.EXAMP005.SYSUT2'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT4', DSNAME = 'RDAMZL.BMC.EX5TS.SORTOUT4'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT101', DSNAME = 'AMU.EXAMP005.SYSUT1'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT3', DSNAME = 'RDAMZL.BMC.EX5TS.SORTOUT3'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT2', DSNAME = 'RDAMZL.BMC.EX5TS.SORTOUT2'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT ', DSNAME = 'AMU.EXAMP005.SORTOUT'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I LOAD PHASE COMPLETE.  ELAPSED TIME = 00:00:04

 BMC50501I DB2 OBJECT STATISTICS
0BMC50515I TABLESPACE  AMUEX5DB.EX5TS  PARTS   = 4         TABLES  = 1     SEGSIZE = 32    DSSIZE =    4G    PAGESIZE = 4K
 BMC50516I             PART  NACTIVE       CARD   EXTENTS   DBCARD PCOMP   KSAVED  PSAVED
 BMC50517I                1        3          4         1        0     0        0       0
 BMC50517I                2        3         12         1        0     0        0       0
 BMC50517I                3        3         11         1        0     0        0       0
 BMC50517I                4        3          2         1        0     0        0       0
 BMC50518I   TABLE     EXAMPLE5.EMPLS
 BMC50519I             ROWAVG    NPAGES       CARD   PCTPAGES
 BMC50520I                 52         8         29         66
0BMC50525I     INDEX   EXAMPLE5.EMPLS_NC_IX
0BMC50526I             FIRST KEY COLUMN = EMP_ID
0BMC50527I             CLUSTER = N   UNIQUE = D   COMPRESS = N   PAGESIZE = 4K   KEYLEN =    3   COLCOUNT = 1
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                1         5          4         1        2
 BMC50529I                2         5         12         1        2
 BMC50529I                3         5         11         1        2
 BMC50529I                4         5          2         1        2
0BMC50525I     INDEX   EXAMPLE5.EMPLS_CLUST_IX
0BMC50526I             FIRST KEY COLUMN = DEPT_NO
0BMC50527I             CLUSTER = Y   UNIQUE = D   COMPRESS = N   PAGESIZE = 4K   KEYLEN =    4   COLCOUNT = 1
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0         5         29         1        2
 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

SELECT on example 5 table

The following figure shows the output of a SELECT on the loaded table for example 5:

    SELECT EMP_ID,SSN,HIRE_DATE,DEPT_NO,JOB_CODE,SALARY,PART_401K,
      EMP_LNAME FROM EXAMPLE5.EMPLS ;
               +-----------------------------------------------------------------------------------------------------------+
               |  EMP_ID  |    SSN    | HIRE_DATE  | DEPT_NO | JOB_CODE  |    SALARY    | PART_401K |      EMP_LNAME       |
               +-----------------------------------------------------------------------------------------------------------+
             1_|    120   | 326759081 | ?          | 2000    |        61 |    41250.00  | 1         | THOMPSON             |
             2_|    138   | 238755558 | ?          | 3000    |        60 |    38250.00  | 1         | KWAN                 |
             3_|    419   | 112377650 | 07/28/1971 | 3000    |        55 |    23800.00  | 0         | QUINTANA             |
             4_|    428   | 231544001 | 12/15/1976 | 3000    |        56 |    28420.00  | 0         | NICHOLLS             |
             5_|    240   | 456679040 | 08/17/2049 | 4000    |        58 |    40175.00  | 1         | GEYER                |
             6_|    258   | 873402211 | 09/14/1973 | 5000    |        55 |    32250.00  | 1         | STERN                |
             7_|    433   | 157919155 | 02/12/1972 | 5000    |        55 |    25280.00  | 0         | ADAMSON              |
             8_|    540   | 268025274 | 10/11/1977 | 5000    |        56 |    22250.00  | 0         | PIANKA               |
             9_|    559   | 379136386 | 09/15/1976 | 5000    |        55 |    24680.00  | 0         | YOSHIMURA            |
            10_|    567   | 480247497 | 07/07/1978 | 5000    |        54 |    21340.00  | 0         | SCOUTEN              |
            11_|    672   | 591358508 | 07/26/1973 | 5000    |        54 |    20450.00  | 0         | WALKER               |
            12_|    682   | 602469819 | 03/03/1974 | 5000    |        53 |    27740.00  | 1         | BROWN                |
            13_|    690   | 713571723 | 04/11/1966 | 5000    |        53 |    18270.00  | 0         | JONES                |
            14_|    701   | 824682632 | 08/29/1979 | 5000    |        55 |    29840.00  | ?         | LUTZ                 |
            15_|    718   | 935793541 | 11/21/1969 | 5000    |        52 |    22180.00  | ?         | JEFFERSON            |
            16_|    724   | 146824450 | 12/05/1975 | 5000    |        55 |    28760.00  | ?         | MARINO               |
            17_|    266   | 433358923 | ?          | 6000    |        56 |    36170.00  | ?         | PULASKI              |
            18_|    830   | 257935361 | 10/13/1980 | 6000    |        53 |    19180.00  | 0         | SMITH                |
            19_|    844   | 368046272 | 09/11/1967 | 6000    |        55 |    17250.00  | 0         | JOHNSON              |
            20_|    852   | 479157183 | 09/29/1980 | 6000    |        52 |    27380.00  | 0         | PEREZ                |
            21_|    862   | 580268294 | 03/21/1972 | 6000    |        52 |    26250.00  | 0         | SCHNEIDER            |
            22_|    876   | 691379385 | 05/05/1964 | 6000    |        55 |    15340.00  | ?         | PARKER               |
            23_|    307   | 345270812 | 08/15/1970 | 7000    |        55 |    29750.00  | 0         | HENDERSON            |
            24_|    888   | 702480479 | 06/30/1965 | 7000    |        54 |    17750.00  | ?         | SMITH                |
            25_|    898   | 813593568 | 09/24/1976 | 7000    |        42 |    15900.00  | 0         | SETRIGHT             |
            26_|    909   | 924644657 | 07/30/1977 | 7000    |        48 |    19950.00  | 0         | MEHTA                |
            27_|    918   | 135755746 | 02/19/1988 | 7000    |        43 |    25370.00  | 1         | LEE                  |
            28_|    380   | 453809376 | 06/19/1980 | 9000    |        54 |    26150.00  | 0         | SPENSER              |
            29_|    923   | 246866835 | 05/12/1986 | 9000    |        52 |    23840.00  | 1         | GROUNOT              |
               +-----------------------------------------------------------------------------------------------------------+
 SUCCESSFUL RETRIEVAL OF         29 ROW(S)

Related topic

Examples-of-LOADPLUS-jobs


 

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