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 18 — LOAD REPLACE enforcing referential constraints

This example illustrates the use of the ENFORCE keyword to check referential constraints on a single-table, segmented table space.

The table space has one unique clustering index, one unique nonclustering index, and two non-unique, nonclustering indexes.

This example performs a LOAD REPLACE, and uses the ENFORCE CONSTRAINTS command option to override the ENFORCE=CHECK installation option. Although ENFORCE CONSTRAINTS checks both referential constraints and check constraints, this table is defined with only referential constraints.

The XBMID command option specifies the XBM subsystem ID to use when enforcing referential constraints. The SYSPRINT shows the messages that display when using XBM or SUF during referential constraint checking. This SYSPRINT also shows the following messages related to enforcing constraints:

  • Messages BMC51525I and BMC51526I display the referential constraint violations.
  • Message BMC50270I shows that CHKP status is reset because all constraints were checked.

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

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

Message 50041I indicates the status of zIIP processing. For this example, the ZIIP installation option is ENABLED and an XBM subsystem ID was specified (for referential constraint checking). LOADPLUS uses the same XBM subsystem ID for zIIP processing.

No COPY option is included on the LOAD command, so 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 following figure shows the DDL to create the objects for this example, illustrating the referential relationship between those objects:

  CREATE     DATABASE  DBEXMRI
     BUFFERPOOL  BP0;
  COMMIT;

 CREATE TABLESPACE TSEXMRI IN DBEXMRI
             BUFFERPOOL  BP0
             CLOSE NO
             SEGSIZE 32
             USING STOGROUP AMUQASTO
             PRIQTY 10000  
             SECQTY 1000  
             COMPRESS YES
             FREEPAGE 001
             PCTFREE 10;

 COMMIT;
 CREATE TABLE AMU.EXMTBLA (  
                 COL1_A         INTEGER NOT NULL WITH DEFAULT
                 CHECK (COL1_A > 10)
                ,COL2_A         INTEGER NOT NULL
                ,COL3_A         CHAR(10) NOT NULL
                ,COL4_A         CHAR(10) NOT NULL
                ,COL5_A         VARCHAR(300) NOT NULL
                ,COL6_A         VARCHAR(300) NOT NULL
              ,PRIMARY KEY (COL1_A,COL5_A,COL3_A))
              IN DBEXMRI.TSEXMRI;

 COMMIT;
 CREATE UNIQUE INDEX AMU.IXEXMA1
             ON AMU.EXMTBLA (COL1_A ASC,COL5_A DESC,COL3_A ASC)
             NOT PADDED
             CLUSTER
                 USING STOGROUP AMUQASTO
                      PRIQTY 10000
                      SECQTY 1000
                 FREEPAGE 1 PCTFREE 010;

  COMMIT;
 CREATE UNIQUE INDEX AMU.IXEXMA2
             ON AMU.EXMTBLA (COL3_A)
                 USING STOGROUP AMUQASTO
                                    PRIQTY 10000
                                    SECQTY 1000
                 FREEPAGE 4 PCTFREE 010;

  COMMIT;  
 CREATE INDEX AMU.IXEXMA3
             ON AMU.EXMTBLA (COL2_A)
                 USING STOGROUP AMUQASTO
                                    PRIQTY 10000
                                    SECQTY 1000
                 FREEPAGE 4 PCTFREE 010;

  COMMIT;  
 CREATE INDEX AMU.IXEXMA4
             ON AMU.EXMTBLA (COL5_A)
                 USING STOGROUP AMUQASTO
                                    PRIQTY 10000
                                    SECQTY 1000
                 FREEPAGE 4 PCTFREE 010;  

  COMMIT;

  CREATE     DATABASE  DBEXMRI2
     BUFFERPOOL  BP0;
  COMMIT;

 CREATE TABLESPACE TSEXMRI2 IN DBEXMRI2
             BUFFERPOOL  BP0  
             CLOSE NO
             SEGSIZE 32  
             USING STOGROUP AMUQASTO
             PRIQTY 10000
             SECQTY 1000
             COMPRESS YES
             FREEPAGE 001
             PCTFREE 10;

 COMMIT;
 CREATE TABLE AMU.EXMTBLB (
                 COL1_B              INTEGER NOT NULL WITH DEFAULT
                ,COL2_B              INTEGER NOT NULL
                ,COL2_BB             INTEGER NOT NULL
                ,COL3_B              CHAR(10) NOT NULL
                ,COL4_B              CHAR(10) NOT NULL
                ,COL5_B              VARCHAR(300) NOT NULL
                ,COL6_B              VARCHAR(300) NOT NULL
             ,PRIMARY KEY (COL5_B,COL1_B,COL6_B)
             ,FOREIGN KEY (COL1_B,COL5_B,COL3_B)
             REFERENCES AMU.EXMTBLA (COL1_A,COL5_A,COL3_A)
             ON DELETE RESTRICT)
              IN DBEXMRI2.TSEXMRI2;

 COMMIT;
 CREATE UNIQUE INDEX AMU.IXEXMB1
             ON AMU.EXMTBLB (COL5_B DESC,COL1_B ASC,COL6_B DESC)
             NOT PADDED
             CLUSTER
                 USING STOGROUP AMUQASTO
                      PRIQTY 10000
                      SECQTY 1000
                 FREEPAGE 2 PCTFREE 010;

  COMMIT;  
 CREATE UNIQUE INDEX AMU.IXEXMB2
             ON AMU.EXMTBLB (COL1_B DESC,COL5_B ASC,COL3_B DESC)
             NOT PADDED
                 USING STOGROUP AMUQASTO
                      PRIQTY 10000  
                      SECQTY 1000
                 FREEPAGE 2 PCTFREE 010;  

  COMMIT;  
 CREATE INDEX AMU.IXEXMB3  
             ON AMU.EXMTBLB (COL2_B)
                 USING STOGROUP AMUQASTO
                                    PRIQTY 10000
                                    SECQTY 1000
                 FREEPAGE 2 PCTFREE 075;

  COMMIT;
 CREATE INDEX AMU.IXEXMB4
             ON AMU.EXMTBLB (COL5_B)  
                 USING STOGROUP AMUQASTO  
                                    PRIQTY 10000
                                    SECQTY 1000
                 FREEPAGE 2 PCTFREE 075;

The following figure shows the JCL for example 18:

//LODPLUS2 EXEC PGM=AMUUMAIN,  
//             PARM='&SSID,AMUEXMPL,NEW    ,,MSGLEVEL(1),AMU$OPTS'
//*                  SSID,UTILID ,RSTART,NOTIFY,MSGLEVEL
//STEPLIB  DD DISP=SHR,DSN=product.libraries
//         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.V23182.TSTDATA1.VAR300,DISP=SHR
//SORTWK01 DD   DISP=(NEW,DELETE,DELETE),DSN=&&SORTWK1,
//         UNIT=WORK,SPACE=(CYL,(5,3),RLSE)
//SORTWK02 DD   DISP=(NEW,DELETE,DELETE),DSN=&&SORTWK2,
//         UNIT=WORK,SPACE=(CYL,(5,3),RLSE)
//SORTWK03 DD   DISP=(NEW,DELETE,DELETE),DSN=&&SORTWK3,
//         UNIT=WORK,SPACE=(CYL,(5,3),RLSE)
//SORTWK04 DD   DISP=(NEW,DELETE,DELETE),DSN=&&SORTWK4,
//         UNIT=WORK,SPACE=(CYL,(5,3),RLSE)
//SORTWK05 DD   DISP=(NEW,DELETE,DELETE),DSN=&&SORTWK5,
//         UNIT=WORK,SPACE=(CYL,(5,3),RLSE)  
//SORTWK06 DD   DISP=(NEW,DELETE,DELETE),DSN=&&SORTWK6,
//         UNIT=WORK,SPACE=(CYL,(5,3),RLSE)
//SORTWK07 DD   DISP=(NEW,DELETE,DELETE),DSN=&&SORTWK7,
//         UNIT=WORK,SPACE=(CYL,(5,3),RLSE)
//SORTWK08 DD   DISP=(NEW,DELETE,DELETE),DSN=&&SORTWK8,
//         UNIT=WORK,SPACE=(CYL,(5,3),RLSE)
//SYSERR   DD   DISP=(MOD,CATLG),
//         DSN=AMU.DEHJ.EXAMP18B.SYSERR,
//         UNIT=WORK,SPACE=(CYL,(10,10),RLSE)
//SYSDISC  DD   DISP=(NEW,CATLG),
//         DSN=AMU.DEHJ.EXAMP18B.SYSDISC,
//         UNIT=WORK,SPACE=(CYL,(10,00),RLSE)
//SORTOUT  DD   DISP=(NEW,PASS),
//         DSN=AMU.DEHJ.EXAMP18B.SORTOUT,
//         UNIT=WORK,SPACE=(CYL,(10,05),RLSE)
//SYSUT101 DD   DISP=(NEW,PASS),
//         DSN=AMU.DEHJ.EXAMP18B.SYSUT1,
//         UNIT=WORK,SPACE=(CYL,(10,00),RLSE)
//SYSUT102 DD   DISP=(NEW,PASS),
//         DSN=AMU.DEHJ.EXAMP18B.SYSUT2,  
//         UNIT=WORK,SPACE=(CYL,(10,00),RLSE)
//SYSUT103 DD   DISP=(NEW,PASS),
//         DSN=AMU.DEHJ.EXAMP18B.SYSUT3,
//         UNIT=WORK,SPACE=(CYL,(10,00),RLSE)  
//SYSUT104 DD   DISP=(NEW,PASS),  
//         DSN=AMU.DEHJ.EXAMP18B.SYSUT4,
//         UNIT=WORK,SPACE=(CYL,(10,00),RLSE)
//SYSUT105 DD   DISP=(NEW,PASS),
//         DSN=AMU.DEHJ.EXAMP18B.SYSUT5,
//         UNIT=WORK,SPACE=(CYL,(10,00),RLSE)
//SYSUT106 DD   DISP=(NEW,PASS),
//         DSN=AMU.DEHJ.EXAMP18B.SYSUT6,
//         UNIT=WORK,SPACE=(CYL,(10,00),RLSE)
//SYSIN    DD   *  
*
*  LODPLUS2 OF AMUEXMPL
*
    LOAD DATA
      REPLACE    ENFORCE CONSTRAINTS XBMID XBMB
      ORDER YES
      INTO TABLE AMU.EXMTBLB
      ( COL1_B             POSITION(9:12)  INTEGER
      , COL2_B             POSITION(13:16) INTEGER
      , COL2_BB            POSITION(13:16) INTEGER
      , COL3_B             POSITION(17:21) CHAR
      , COL4_B             POSITION(22:26) CHAR
      , COL5_B             POSITION(27:*)  VARCHAR
      , COL6_B             POSITION(27:*)  VARCHAR )

SYSPRINT for example 18

The following figure shows the SYSPRINT output for example 18:

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   15:28:53 ...
 BMC50002I UTILITY ID = 'AMUEXMPL'.  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=8792K,ABOVE 16M=1312228K,IEFUSI=NO,CPUS=3
 BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040312M,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 *
 BMC50102I *  LODPLUS2 OF AMUEXMPL
 BMC50102I *
 BMC50102I     LOAD DATA
 BMC50102I       REPLACE    ENFORCE CONSTRAINTS XBMID XBMB
 BMC50102I       ORDER YES
 BMC50102I       INTO TABLE AMU.EXMTBLB
 BMC50102I       ( COL1_B             POSITION(9:12)  INTEGER
 BMC50102I       , COL2_B             POSITION(13:16) INTEGER
 BMC50102I       , COL2_BB            POSITION(13:16) INTEGER
 BMC50102I       , COL3_B             POSITION(17:21) CHAR
 BMC50102I       , COL4_B             POSITION(22:26) CHAR
 BMC50102I       , COL5_B             POSITION(27:*)  VARCHAR
 BMC50102I       , COL6_B             POSITION(27:*)  VARCHAR )

 BMC51424I ANALYZE PHASE WILL BE PERFORMED DUE TO DYNAMIC WORK FILE ALLOCATION
 BMC51561I CALCULATED NUMBER OF INPUT RECORDS = 9305 USING A SCALING FACTOR OF 100%
 BMC50004I UTILINIT PHASE COMPLETE.  ELAPSED TIME = 00:00:01

 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  = AMUEX18   &STEPNAME = LODPLUS2  &DB       = DBEXMRI2  &TS       = TSEXMRI2  &UID      = RDAMZL
 BMC50425I &RESUME   = N         &REPLACE  = Y         &DATE     = 030915    &TIME     = 152853    &SSID     = DEHJ
 BMC50425I &UTIL     = AMUEXMPL  &UTILPFX  = AMUEXMPL  &UTILSFX  =           &DATE8    = 03092015  &GRPNM    = DEHJ
 BMC50425I &VCAT     = DEHJCAT   &TIME4    = 1528      &DATEJ    = 2015068   &JDATE    = 15068

 BMC50445I LOAD PLUS DYNAMIC FILE ALLOCATION REPORT
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8420K, ABOVE 16M = 1299504K, CPUS = 3
 BMC50479I TOTAL PAGES: 3929541, ALLOWED: 1178863; AVAILABLE PAGES: 538518, ALLOWED: 0
 BMC51499I COMBINED OPTIMIZATION, RC=0, #SORTS=1, #READERS=1, #INDEX TASKS=3, #PROBE TASKS=1, #LOB TASKS=0, #XML TASKS=0,
           TIME=8635904
 BMC51499I COMBINED OPTIMIZATION, RC=20, #SORTS=1, #READERS=1, #INDEX TASKS=2, #PROBE TASKS=1, #LOB TASKS=0, #XML TASKS=0,
           TIME=8677760
 BMC51500I COMBINED ANALYZE, #SORTS=1, #READERS=1, #INDEX TASKS=3, #PROBE TASKS=1, #LOB TASKS=0, #XML TASKS=0

 BMC50894I RELATED INDEX SUF REGISTRATION PROCESS STARTING AT   3/09/2015  15:28:56

 BMC50650I ESTABLISHING A POINT OF CONSISTENCY FOR:
 BMC50651I SPACE DBEXMRI.IXEXMA1 PART(0) PSID(E)

 BMC50895I RELATED INDEX SUF REGISTRATION PROCESS COMPLETE.  ELAPSED TIME =  00:00:00

 BMC50486I 4: BMCSORT STARTED, 272K BELOW 16M, 1296K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 6: BMCSORT STARTED, 360K BELOW 16M, 1384K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 5: BMCSORT STARTED, 356K BELOW 16M, 1380K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 3: BMCSORT STARTED, 360K BELOW 16M, 1384K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC51453I EXISTING ROWS IN TABLESPACE 'DBEXMRI2.TSEXMRI2' DELETED
 BMC50486I 2: BMCSORT STARTED, 572K BELOW 16M, 1596K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50481I 1: READ TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 1: READ TASK, XBLK XFERS = 74, EMPTY WAITS = 22, FULL WAITS = 0
 BMC51478I PRELOAD STATISTICS:  5000 PHYSICAL (5000 LOGICAL) RECORDS READ FROM SYSREC
 BMC50481I 2: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE DBEXMRI2.TSEXMRI2
 BMC50482I 2: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.DBEXMRI2.TSEXMRI2.I0001.A001'
 BMC50477I 2: PARTITION =    0, ROWS/KEYS = 5000, I/O WAITS = 8 ,DDNAME = SYS00035
 BMC50482I 2: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.DBEXMRI2.IXEXMB1.I0001.A001'
 BMC50477I 2: PARTITION =    0, ROWS/KEYS = 5000, I/O WAITS = 7 ,DDNAME = SYS00038
 BMC50481I 2: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 2: SORT TASK, XBLK XFERS = 153, EMPTY WAITS = 11, FULL WAITS = 0
 BMC50481I 3: PROBE SORT COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50481I 4: INDEX SORT COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50481I 5: INDEX SORT COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50481I 6: INDEX SORT COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51525I RI FAILURE FOR CONSTRAINT 'AMU.EXMTBLB.COL1$B', RECORD NO. = 1 IN SYSREC
 BMC51526I     KEY VALUE = '1,'GBH0RBBNEPF1Q9                                           ', RID = X'00028609'
 BMC51525I RI FAILURE FOR CONSTRAINT 'AMU.EXMTBLB.COL1$B', RECORD NO. = 2 IN SYSREC
 BMC51526I     KEY VALUE = '2,'8LWXXTHAY931L32WQC8AGTCGFEQ2ITC1609ATUE                  ', RID = X'00004A0E'
 BMC51525I RI FAILURE FOR CONSTRAINT 'AMU.EXMTBLB.COL1$B', RECORD NO. = 3 IN SYSREC
 BMC51526I     KEY VALUE = '3,'2NJRX2OERAN5ARE952KB3XNNDKPFE3QXN8SI8EW2P24WRGHIMSPQM6Y69', RID = X'0000BC0D'
 BMC51525I RI FAILURE FOR CONSTRAINT 'AMU.EXMTBLB.COL1$B', RECORD NO. = 4 IN SYSREC
 BMC51526I     KEY VALUE = '4,'UIQRABGODME39CGLE0ELJD48O6ZI3QE4QONWY1QDKBRQKP7U7CXXET9O4', RID = X'00016002'
 BMC51525I RI FAILURE FOR CONSTRAINT 'AMU.EXMTBLB.COL1$B', RECORD NO. = 5 IN SYSREC
 BMC51526I     KEY VALUE = '5,'J9CN4W07P90CMCJ77FDXB08KD3FPC6T24SVNIU0HXUPLEPJ6O7VYSV0H3', RID = X'00023605'
 BMC51525I RI FAILURE FOR CONSTRAINT 'AMU.EXMTBLB.COL1$B', RECORD NO. = 6 IN SYSREC
 BMC51526I     KEY VALUE = '6,'LBGP8EYZB44BZEZ3R1VJC4ARUNVHIT82HZRLVQK1CU3GOHMPI6LYDNRED', RID = X'00022008'
 BMC51525I RI FAILURE FOR CONSTRAINT 'AMU.EXMTBLB.COL1$B', RECORD NO. = 7 IN SYSREC
 BMC51526I     KEY VALUE = '7,'HZ3CDTIMLJFBLFYQG0NELX0WLDZR32IZMDJBNPCFHJ6PW','CIOV1'', RID = X'00026408'
 BMC51525I RI FAILURE FOR CONSTRAINT 'AMU.EXMTBLB.COL1$B', RECORD NO. = 8 IN SYSREC
 BMC51526I     KEY VALUE = '8,'XKLAC18RMAKY','ELT07'', RID = X'00012608'
 BMC51525I RI FAILURE FOR CONSTRAINT 'AMU.EXMTBLB.COL1$B', RECORD NO. = 9 IN SYSREC
 BMC51526I     KEY VALUE = '9,'REMRM6YYXNL7BFYKOXTEAMI66M69LCHJ4XTY60CFHJ6PW','CIOV1'RED', RID = X'0001A00A'
 BMC51525I RI FAILURE FOR CONSTRAINT 'AMU.EXMTBLB.COL1$B', RECORD NO. = 10 IN SYSREC
 BMC51526I     KEY VALUE = '10,'FLLHZI2W9WVBFYKOXTEAMI66M69LCHJ4XTY60CFHJ6PW','CIOV1'RED', RID = X'00029803'
 BMC51568I AMUBMGT TOTAL GETS = 5001
 BMC51569I AMUBMGT FOR INDEX = DEHJCAT.DSNDBD.DBEXMRI.IXEXMA1.I0001.A001, GETS = 250, PUTS = 0, DPUTS = N/A
 BMC50482I 3: PROBE COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.DBEXMRI.IXEXMA1.I0001.A001'
 BMC50477I 3: PARTITION =    0, ROWS/KEYS = 5000, I/O WAITS = 4 ,DDNAME = SYS00040
 BMC50482I 4: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.DBEXMRI2.IXEXMB3.I0001.A001'
 BMC50477I 4: PARTITION =    0, ROWS/KEYS = 5000, I/O WAITS = 7 ,DDNAME = SYS00046
 BMC50482I 6: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.DBEXMRI2.IXEXMB2.I0001.A001'
 BMC50482I 5: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.DBEXMRI2.IXEXMB4.I0001.A001'
 BMC50477I 5: PARTITION =    0, ROWS/KEYS = 5000, I/O WAITS = 12 ,DDNAME = SYS00044
 BMC50477I 6: PARTITION =    0, ROWS/KEYS = 5000, I/O WAITS = 9 ,DDNAME = SYS00045
 BMC50481I 4: INDEX TASK COMPLETE.  ELAPSED TIME = 00:00:02
 BMC51510I 4: INDEX TASK, XBLK XFERS = 2, EMPTY WAITS = 0, FULL WAITS = 3
 BMC50481I 3: PROBE TASK COMPLETE.  ELAPSED TIME = 00:00:02
 BMC51510I 3: PROBE TASK, XBLK XFERS = 26, EMPTY WAITS = 0, FULL WAITS = 16
 BMC50481I 5: INDEX TASK COMPLETE.  ELAPSED TIME = 00:00:02
 BMC50481I 6: INDEX TASK COMPLETE.  ELAPSED TIME = 00:00:02
 BMC51510I 5: INDEX TASK, XBLK XFERS = 25, EMPTY WAITS = 0, FULL WAITS = 20
 BMC51510I 6: INDEX TASK, XBLK XFERS = 26, EMPTY WAITS = 0, FULL WAITS = 7
 BMC50476I DDNAME = SYSERR, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50486I 2: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 1: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50482I 1: EXTRACT DUP KEYS COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.DBEXMRI2.TSEXMRI2.I0001.A001'
 BMC50477I 1: PARTITION =    0, ROWS/KEYS = 10, I/O WAITS = 28 ,DDNAME = SYS00052
 BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50481I 1: DISCARD TASK 1 COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 2: DISCARD SORT 2 COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51568I AMUBMGT TOTAL GETS = 11
 BMC51569I AMUBMGT FOR INDEX = DEHJCAT.DSNDBD.DBEXMRI2.IXEXMB1.I0001.A001, GETS = 11, PUTS = 10, DPUTS = N/A
 BMC50482I 2: DISCARD INDEX KEYS COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.DBEXMRI2.IXEXMB1.I0001.A001'
 BMC50477I 2: PARTITION =    0, ROWS/KEYS = 10, I/O WAITS = 9 ,DDNAME = SYS00053
 BMC51568I AMUBMGT TOTAL GETS = 10
 BMC51569I AMUBMGT FOR INDEX = DEHJCAT.DSNDBD.DBEXMRI2.IXEXMB2.I0001.A001, GETS = 1, PUTS = 1, DPUTS = N/A
 BMC50482I 2: DISCARD INDEX KEYS COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.DBEXMRI2.IXEXMB2.I0001.A001'
 BMC50477I 2: PARTITION =    0, ROWS/KEYS = 10, I/O WAITS = 9 ,DDNAME = SYS00054
 BMC51568I AMUBMGT TOTAL GETS = 10
 BMC51569I AMUBMGT FOR INDEX = DEHJCAT.DSNDBD.DBEXMRI2.IXEXMB3.I0001.A001, GETS = 1, PUTS = 1, DPUTS = N/A
 BMC50482I 2: DISCARD INDEX KEYS COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.DBEXMRI2.IXEXMB3.I0001.A001'
 BMC50477I 2: PARTITION =    0, ROWS/KEYS = 10, I/O WAITS = 7 ,DDNAME = SYS00055
 BMC51568I AMUBMGT TOTAL GETS = 13
 BMC51569I AMUBMGT FOR INDEX = DEHJCAT.DSNDBD.DBEXMRI2.IXEXMB4.I0001.A001, GETS = 13, PUTS = 10, DPUTS = N/A
 BMC50482I 2: DISCARD INDEX KEYS COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.DBEXMRI2.IXEXMB4.I0001.A001'
 BMC50477I 2: PARTITION =    0, ROWS/KEYS = 10, I/O WAITS = 9 ,DDNAME = SYS00056
 BMC50481I 2: DISCARD TASK 2 COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 2: DISCARD TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 2
 BMC50486I 3: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50481I 3: DISCARD SORT 3 COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50482I 3: DISCARD DATA ROWS COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.DBEXMRI2.TSEXMRI2.I0001.A001'
 BMC50477I 3: PARTITION =    0, ROWS/KEYS = 10, I/O WAITS = 23 ,DDNAME = SYS00058
 BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50481I 3: DISCARD TASK 3 COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50277I XBM STATISTICS: DSN='DEHJCAT.DSNDBD.DBEXMRI.IXEXMA1.I0001.A001    ', READS 630, HITS 0, WRITES 0, CACHE 0
 BMC50476I DDNAME = SYSREC, I/OS = 5, I/O WAITS = 1, RDB LOCK 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 TABLE AMU.EXMTBLB
 BMC51522I    INPUT        DISCARD  DISCARD               RELATED
 BMC51523I  ID: RECORD #    RECORD#  TYPE                 ID: RECORD #  FIELD, INDEX, OR CONSTRAINT NAME

 BMC51524E   1:         1          1 FOREIGN KEY           0:         0 COL1$B
 BMC51524E   1:         2          2 FOREIGN KEY           0:         0 COL1$B
 BMC51524E   1:         3          3 FOREIGN KEY           0:         0 COL1$B
 BMC51524E   1:         4          4 FOREIGN KEY           0:         0 COL1$B
 BMC51524E   1:         5          5 FOREIGN KEY           0:         0 COL1$B
 BMC51524E   1:         6          6 FOREIGN KEY           0:         0 COL1$B
 BMC51524E   1:         7          7 FOREIGN KEY           0:         0 COL1$B
 BMC51524E   1:         8          8 FOREIGN KEY           0:         0 COL1$B
 BMC51524E   1:         9          9 FOREIGN KEY           0:         0 COL1$B
 BMC51524E   1:        10         10 FOREIGN KEY           0:         0 COL1$B
 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:  4990 ROWS SELECTED FOR SPACE 'DBEXMRI2.TSEXMRI2', 10 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
 BMC51479I COMBINED PHASE STATISTICS:  10 PHYSICAL (10 LOGICAL) RECORDS DISCARDED TO SYSDISC
 BMC51473I LOAD STATISTICS:  4990 ROWS LOADED INTO TABLE 'AMU.EXMTBLB'
 BMC51476I BUILD STATISTICS:  4990 KEYS LOADED INTO INDEX 'AMU.IXEXMB1'
 BMC51476I BUILD STATISTICS:  4990 KEYS LOADED INTO INDEX 'AMU.IXEXMB2'
 BMC51476I BUILD STATISTICS:  4990 KEYS LOADED INTO INDEX 'AMU.IXEXMB3'
 BMC51476I BUILD STATISTICS:  4990 KEYS LOADED INTO INDEX 'AMU.IXEXMB4'
 BMC51475I LOAD STATISTICS:  4990 ROWS LOADED INTO TABLE SPACE 'DBEXMRI2.TSEXMRI2'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK01', DSNAME = 'SYS15068.T152808.RA000.AMUEX18.SORTWK1.H03'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK02', DSNAME = 'SYS15068.T152808.RA000.AMUEX18.SORTWK2.H03'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK03', DSNAME = 'SYS15068.T152808.RA000.AMUEX18.SORTWK3.H03'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK04', DSNAME = 'SYS15068.T152808.RA000.AMUEX18.SORTWK4.H03'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK05', DSNAME = 'SYS15068.T152808.RA000.AMUEX18.SORTWK5.H03'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK06', DSNAME = 'SYS15068.T152808.RA000.AMUEX18.SORTWK6.H03'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK07', DSNAME = 'SYS15068.T152808.RA000.AMUEX18.SORTWK7.H03'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK08', DSNAME = 'SYS15068.T152808.RA000.AMUEX18.SORTWK8.H03'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR  ', DSNAME = 'AMU.DEHJ.EXAMP18B.SYSERR'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I COMBINED PHASE COMPLETE.  ELAPSED TIME = 00:00:06

 BMC50270I CHECK PENDING STATUS HAS BEEN RESET (OFF) FOR DBEXMRI2.TSEXMRI2
 BMC50501I DB2 OBJECT STATISTICS
0BMC50515I TABLESPACE  DBEXMRI2.TSEXMRI2  PARTS   = 0         TABLES  = 1     SEGSIZE = 32    DSSIZE =    0G    PAGESIZE = 4K
 BMC50516I             PART  NACTIVE       CARD   EXTENTS   DBCARD PCOMP   KSAVED  PSAVED
 BMC50517I                0      773       4990         1      150    97      435      26
 BMC50518I   TABLE     AMU.EXMTBLB
 BMC50519I             ROWAVG    NPAGES       CARD   PCTPAGES
 BMC50520I                249       370       4990         48
0BMC50525I     INDEX   AMU.IXEXMB1
0BMC50526I             FIRST KEY COLUMN = COL5_B
0BMC50527I             CLUSTER = Y   UNIQUE = P   COMPRESS = N   PAGESIZE = 4K   KEYLEN =  608   COLCOUNT = 3
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0       710       4990         1        3
0BMC50525I     INDEX   AMU.IXEXMB2
0BMC50526I             FIRST KEY COLUMN = COL1_B
0BMC50527I             CLUSTER = N   UNIQUE = U   COMPRESS = N   PAGESIZE = 4K   KEYLEN =  316   COLCOUNT = 3
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0       380       4990         1        3
0BMC50525I     INDEX   AMU.IXEXMB3
0BMC50526I             FIRST KEY COLUMN = COL2_B
0BMC50527I             CLUSTER = N   UNIQUE = D   COMPRESS = N   PAGESIZE = 4K   KEYLEN =    4   COLCOUNT = 1
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0        73       4990         1        2
0BMC50525I     INDEX   AMU.IXEXMB4
0BMC50526I             FIRST KEY COLUMN = COL5_B
0BMC50527I             CLUSTER = N   UNIQUE = D   COMPRESS = N   PAGESIZE = 4K   KEYLEN =  302   COLCOUNT = 1
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0      1366       4990         1        3
 BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR LOAD UTILITY SUCCESSFUL FOR ALL OBJECTS
 BMC50386W IMAGE COPY REQUIRED.  TABLE SPACE DBEXMRI2.TSEXMRI2 REMAINS IN 'COPY PENDING' STATE
 BMC50004I UTILTERM PHASE COMPLETE.  ELAPSED TIME = 00:00:00

0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 4

Related topics

Referential-and-check-constraints

Examples-of-LOADPLUS-jobs



 

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