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 3 — Single-phase LOAD RESUME YES of a partitioned table space

This example shows a single-phase LOAD RESUME YES job for the same table space that was loaded in example 2.

LOADPLUS adds new data to two of the ten partitions.

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

In this example, the SYSREC ddname, work file ddnames, and copy ddnames are all overridden by using the appropriate command options in addition to specifying the override ddnames in the JCL. Note the following override names:

  • INDATA overrides SYSREC
  • DATAWK overrides SORTOUT
  • ERRWK overrides SYSERR
  • IXWK overrides SYSUT1
  • DISCARDS overrides SYSDISC
  • CPY overrides BMCCPY
  • RCY overrides BMCRCY

Assuming that the data was sorted before this run, the LOAD command includes the ORDER NO option. Both indexes are built independently of the data, which allows LOADPLUS to use two SYSUT1 data sets to process the two indexes concurrently.

DDTYPE LOCPFCPY ACTIVE NO disables dynamic allocation for the primary copy data set, overriding the default in the installation options module. The DD statements in the JCL direct LOADPLUS to create two copies of each partition.

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.

The following figure shows the JCL for example 3:

//EXAMPLE3 EXEC PGM=AMUUMAIN,
//             PARM='&SSID,EXAMPLE3,NEW/RESTART,,MSGLEVEL(1),AMU$OPTO'
//*                  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=*
//*
//INDATA   DD DSN=AMU.VQA.EXAMPL03.SYSREC,DISP=SHR
//DATAWK   DD DSN=AMU.EXAMP003.SORTOUT,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//ERRWK    DD DSN=AMU.EXAMP003.SYSERR,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//DISCARDS DD DSN=AMU.EXAMP003.SYSDISC,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//*
//IXWK01   DD DSN=AMU.EXAMP003.SYSUT1,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//IXWK02   DD DSN=AMU.EXAMP003.SYSUT2,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//*
//SORTWK01 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK02 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK03 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK04 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK05 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK06 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK07 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK08 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK09 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK10 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK11 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//SORTWK12 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(1,1))
//*
//CPY00001 DD DSN=AMU.EXAMP003.COPY01,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//CPY00002 DD DSN=AMU.EXAMP003.COPY02,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//CPY00003 DD DSN=AMU.EXAMP003.COPY03,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//CPY00004 DD DSN=AMU.EXAMP003.COPY04,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//CPY00005 DD DSN=AMU.EXAMP003.COPY05,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//CPY00006 DD DSN=AMU.EXAMP003.COPY06,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//CPY00007 DD DSN=AMU.EXAMP003.COPY07,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//CPY00008 DD DSN=AMU.EXAMP003.COPY08,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//CPY00009 DD DSN=AMU.EXAMP003.COPY09,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//CPY00010 DD DSN=AMU.EXAMP003.COPY10,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//RCY00001 DD DSN=AMU.EXAMP003.RCOPY01,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//RCY00002 DD DSN=AMU.EXAMP003.RCOPY02,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//RCY00003 DD DSN=AMU.EXAMP003.RCOPY03,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//RCY00004 DD DSN=AMU.EXAMP003.RCOPY04,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//RCY00005 DD DSN=AMU.EXAMP003.RCOPY05,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//RCY00006 DD DSN=AMU.EXAMP003.RCOPY06,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//RCY00007 DD DSN=AMU.EXAMP003.RCOPY07,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//RCY00008 DD DSN=AMU.EXAMP003.RCOPY08,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//RCY00009 DD DSN=AMU.EXAMP003.RCOPY09,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//RCY00010 DD DSN=AMU.EXAMP003.RCOPY10,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//*
//SYSIN    DD *
  LOAD RESUME YES
    INDDN       INDATA
    LOADDN      DATAWK
    ERRDDN      ERRWK
    WORKDDN     IXWK
    DISCARDDN   DISCARDS
    COPYDDN     CPY
    RECOVERYDDN RCY
    ORDER NO
  INTO TABLE EXAMPLE2.TBL1
      (DATE_OF_SALE        POSITION(72:77) DATE-2 EXTERNAL
      ,SALES_TRANS_ID      POSITION(52:61) INTEGER EXTERNAL
      ,SALES_ITEM_ID       POSITION(1:10)  CHARACTER
      ,SALES_QTY           POSITION(11:21) INTEGER EXTERNAL
      ,SALES_PR_PER_ITEM   POSITION(22:30) DECIMAL EXTERNAL(9,2)
      ,SALES_TOTAL_TX      POSITION(31:39) DECIMAL EXTERNAL(9,2)
      ,SALES_TOTAL         POSITION(42:50) DECIMAL EXTERNAL(9,2)
      ,SELLER_ID           POSITION(62:71) CHARACTER
      )
  LOG NO
  COPY YES REGISTER NONE
  DDTYPE   LOCPFCPY  ACTIVE NO

SYSPRINT for example 3

The following figure shows the SYSPRINT output for example 3:

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:04:42 ...
 BMC50002I UTILITY ID = 'EXAMPLE3'.  DB2 SUBSYSTEM ID = 'DEHJ'.  OPTION MODULE = 'AMU$OPTO'.
 BMC50471I z/OS 2.1.0,PID=HBB7790,DFSMS FOR Z/OS=2.1.0,DB2=11.1.0
 BMC50471I REGION=0M,BELOW 16M=8764K,ABOVE 16M=1306152K,IEFUSI=NO,CPUS=3
 BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040308M,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=STANDARD
 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 RESUME YES
 BMC50102I     INDDN       INDATA
 BMC50102I     LOADDN      DATAWK
 BMC50102I     ERRDDN      ERRWK
 BMC50102I     WORKDDN     IXWK
 BMC50102I     DISCARDDN   DISCARDS
 BMC50102I     COPYDDN     CPY
 BMC50102I     RECOVERYDDN RCY
 BMC50102I     ORDER NO
 BMC50102I   INTO TABLE EXAMPLE2.TBL1
 BMC50102I       (DATE_OF_SALE        POSITION(72:77) DATE-2 EXTERNAL
 BMC50102I       ,SALES_TRANS_ID      POSITION(52:61) INTEGER EXTERNAL
 BMC50102I       ,SALES_ITEM_ID       POSITION(1:10)  CHARACTER
 BMC50102I       ,SALES_QTY           POSITION(11:21) INTEGER EXTERNAL
 BMC50102I       ,SALES_PR_PER_ITEM   POSITION(22:30) DECIMAL EXTERNAL(9,2)
 BMC50102I       ,SALES_TOTAL_TX      POSITION(31:39) DECIMAL EXTERNAL(9,2)
 BMC50102I       ,SALES_TOTAL         POSITION(42:50) DECIMAL EXTERNAL(9,2)
 BMC50102I       ,SELLER_ID           POSITION(62:71) CHARACTER
 BMC50102I       )
 BMC50102I   LOG NO
 BMC50102I   COPY YES REGISTER NONE
 BMC50102I   DDTYPE   LOCPFCPY  ACTIVE NO

 BMC51424I ANALYZE PHASE WILL BE PERFORMED DUE TO DYNAMIC WORK FILE ALLOCATION
 BMC51421I NO FIELD SPECIFICATION FOR COLUMN 'SALES_ITEM_DESC               '.  VALUE IS DEFAULTED
 BMC51421I NO FIELD SPECIFICATION FOR COLUMN 'ENTRY_TIMESTAMP               '.  VALUE IS DEFAULTED
 BMC51561I CALCULATED NUMBER OF INPUT RECORDS = 141 USING A SCALING FACTOR OF 100%
 BMC50109I 'RESUME YES' OPTION SPECIFIED.  OPTION 'INLINE YES' IGNORED
 BMC50004I UTILINIT PHASE COMPLETE.  ELAPSED TIME = 00:00:00

 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC51535I ESTIMATED CARDINALITY OF SPACE = 835    ESTIMATED AVG ROW LENGTH = 80
 BMC50485I ESTIMATED CARDINALITY OF PART 0001 = 454
 BMC50485I ESTIMATED CARDINALITY OF PART 0002 = 59
 BMC50485I ESTIMATED CARDINALITY OF PART 0003 = 60
 BMC50485I ESTIMATED CARDINALITY OF PART 0004 = 0
 BMC50485I ESTIMATED CARDINALITY OF PART 0005 = 62
 BMC50485I ESTIMATED CARDINALITY OF PART 0006 = 0
 BMC50485I ESTIMATED CARDINALITY OF PART 0007 = 0
 BMC50485I ESTIMATED CARDINALITY OF PART 0008 = 100
 BMC50485I ESTIMATED CARDINALITY OF PART 0009 = 100
 BMC50485I ESTIMATED CARDINALITY OF PART 0010 = 0
 BMC50004I ANALYZE PHASE COMPLETE.  ELAPSED TIME = 00:00:00

 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50425I &JOBNAME  = AMUEX03   &STEPNAME = EXAMPLE3  &DB       = AMUEX2DB  &TS       = EX2TS     &UID      = RDAMZL
 BMC50425I &RESUME   = Y         &REPLACE  = N         &DATE     = 030915    &TIME     = 140442    &SSID     = DEHJ
 BMC50425I &UTIL     = EXAMPLE3  &UTILPFX  = EXAMPLE3  &UTILSFX  =           &DATE8    = 03092015  &GRPNM    = DEHJ
 BMC50425I &VCAT     = DEHJCAT   &TIME4    = 1404      &DATEJ    = 2015068   &JDATE    = 15068

 BMC50445I LOAD PLUS DYNAMIC FILE ALLOCATION REPORT
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8396K, ABOVE 16M = 1298732K, CPUS = 3
 BMC50479I TOTAL PAGES: 3879702, ALLOWED: 1163911; AVAILABLE PAGES: 387043, ALLOWED: 0
 BMC51499I COMBINED OPTIMIZATION, RC=0, #SORTS=1, #READERS=1, #INDEX TASKS=2, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0,
           TIME=2170624
 BMC51499I COMBINED OPTIMIZATION, RC=20, #SORTS=1, #READERS=1, #INDEX TASKS=1, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0,
           TIME=4313600
 BMC51500I COMBINED ANALYZE, #SORTS=1, #READERS=1, #INDEX TASKS=2, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0
 BMC50486I 3: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 4: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50477I 3: PARTITION =    1, ROWS/KEYS = 454, I/O WAITS = 1 ,DDNAME = SYS00007
 BMC50477I 3: PARTITION =    2, ROWS/KEYS = 59, I/O WAITS = 1 ,DDNAME = SYS00008
 BMC50477I 3: PARTITION =    3, ROWS/KEYS = 60, I/O WAITS = 1 ,DDNAME = SYS00009
 BMC50477I 4: PARTITION =    0, ROWS/KEYS = 835, I/O WAITS = 1 ,DDNAME = SYS00010
 BMC50477I 3: PARTITION =    4, ROWS/KEYS = 0, I/O WAITS = 1 ,DDNAME = SYS00012
 BMC50477I 3: PARTITION =    5, ROWS/KEYS = 62, I/O WAITS = 1 ,DDNAME = SYS00014
 BMC50477I 3: PARTITION =    6, ROWS/KEYS = 0, I/O WAITS = 1 ,DDNAME = SYS00016
 BMC50477I 3: PARTITION =    7, ROWS/KEYS = 0, I/O WAITS = 1 ,DDNAME = SYS00018
 BMC50477I 3: PARTITION =    8, ROWS/KEYS = 100, I/O WAITS = 1 ,DDNAME = SYS00020
 BMC50477I 3: PARTITION =    9, ROWS/KEYS = 100, I/O WAITS = 1 ,DDNAME = SYS00022
 BMC50477I 3: PARTITION =   10, ROWS/KEYS = 0, I/O WAITS = 1 ,DDNAME = SYS00024
 BMC50481I 1: READ TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 1: READ TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51478I PRELOAD STATISTICS:  131 PHYSICAL (131 LOGICAL) RECORDS READ FROM INDATA
 BMC50482I 2: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX2DB.EX2TS.I0001.A009'
 BMC50477I 2: PARTITION =    9, ROWS/KEYS = 27, I/O WAITS = 8 ,DDNAME = SYS00028
 BMC51474I LOAD STATISTICS:  27 ROWS LOADED INTO TABLE SPACE 'AMUEX2DB.EX2TS' PARTITION 9
 BMC50482I 2: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX2DB.EX2TS.I0001.A010'
 BMC50477I 2: PARTITION =   10, ROWS/KEYS = 104, I/O WAITS = 8 ,DDNAME = SYS00029
 BMC51474I LOAD STATISTICS:  104 ROWS LOADED INTO TABLE SPACE 'AMUEX2DB.EX2TS' PARTITION 10
 BMC50481I 2: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 2: SORT TASK, XBLK XFERS = 3, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50476I DDNAME = IXWK02, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = IXWK01, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50481I 3: INDEX SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 4: INDEX SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50482I 3: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX2DB.IX0.I0001.A001'
 BMC50477I 3: PARTITION =    1, ROWS/KEYS = 454, I/O WAITS = 7 ,DDNAME = SYS00033
 BMC51474I BUILD STATISTICS:  454 KEYS LOADED INTO INDEX 'EXAMPLE2.IX0' PARTITION 1
 BMC50482I 4: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX2DB.IX1.I0001.A001'
 BMC50477I 4: PARTITION =    0, ROWS/KEYS = 966, I/O WAITS = 7 ,DDNAME = SYS00032
 BMC51476I BUILD STATISTICS:  966 KEYS LOADED INTO INDEX 'EXAMPLE2.IX1'
 BMC50481I 4: INDEX TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 4: INDEX TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 2
 BMC50482I 3: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX2DB.IX0.I0001.A002'
 BMC50477I 3: PARTITION =    2, ROWS/KEYS = 59, I/O WAITS = 7 ,DDNAME = SYS00036
 BMC51474I BUILD STATISTICS:  59 KEYS LOADED INTO INDEX 'EXAMPLE2.IX0' PARTITION 2
 BMC50482I 3: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX2DB.IX0.I0001.A003'
 BMC50477I 3: PARTITION =    3, ROWS/KEYS = 60, I/O WAITS = 7 ,DDNAME = SYS00038
 BMC51474I BUILD STATISTICS:  60 KEYS LOADED INTO INDEX 'EXAMPLE2.IX0' PARTITION 3
 BMC50482I 3: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX2DB.IX0.I0001.A005'
 BMC50477I 3: PARTITION =    5, ROWS/KEYS = 62, I/O WAITS = 7 ,DDNAME = SYS00040
 BMC51474I BUILD STATISTICS:  62 KEYS LOADED INTO INDEX 'EXAMPLE2.IX0' PARTITION 5
 BMC51505E DUPLICATE KEY FOUND FOR INDEX 'EXAMPLE2.IX0', RECORD NO. = 1 OF INDATA
 BMC51506E     KEY VALUE = ' 1/25/1990,1', RID-1 = X'80000201', RID-2 = X'80000401'
 BMC50482I 3: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX2DB.IX0.I0001.A008'
 BMC50477I 3: PARTITION =    8, ROWS/KEYS = 100, I/O WAITS = 7 ,DDNAME = SYS00042
 BMC51474I BUILD STATISTICS:  100 KEYS LOADED INTO INDEX 'EXAMPLE2.IX0' PARTITION 8
 BMC51505E DUPLICATE KEY FOUND FOR INDEX 'EXAMPLE2.IX0', RECORD NO. = 2 OF INDATA
 BMC51506E     KEY VALUE = ' 1/25/1990,2', RID-1 = X'80000202', RID-2 = X'80000402'
 BMC50482I 3: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX2DB.IX0.I0001.A009'
 BMC50477I 3: PARTITION =    9, ROWS/KEYS = 125, I/O WAITS = 7 ,DDNAME = SYS00044
 BMC51474I BUILD STATISTICS:  125 KEYS LOADED INTO INDEX 'EXAMPLE2.IX0' PARTITION 9
 BMC50482I 3: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX2DB.IX0.I0001.A010'
 BMC50477I 3: PARTITION =   10, ROWS/KEYS = 104, I/O WAITS = 7 ,DDNAME = SYS00046
 BMC51474I BUILD STATISTICS:  104 KEYS LOADED INTO INDEX 'EXAMPLE2.IX0' PARTITION 10
 BMC50481I 3: INDEX TASK COMPLETE.  ELAPSED TIME = 00:00:03
 BMC51510I 3: INDEX TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 2
 BMC50476I DDNAME = ERRWK, I/OS = 3, I/O WAITS = 3, RDB LOCK WAITS = 1
 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.AMUEX2DB.EX2TS.I0001.A009'
 BMC50477I 1: PARTITION =    9, ROWS/KEYS = 2, I/O WAITS = 3 ,DDNAME = SYS00049
 BMC50476I DDNAME = ERRWK, 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 = 4
 BMC51569I AMUBMGT FOR INDEX = DEHJCAT.DSNDBD.AMUEX2DB.IX0.I0001.A009, GETS = 1, PUTS = 1, DPUTS = N/A
 BMC50482I 2: DISCARD INDEX KEYS COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX2DB.IX0.I0001.A009'
 BMC50477I 2: PARTITION =    9, ROWS/KEYS = 0, I/O WAITS = 7 ,DDNAME = SYS00050
 BMC51568I AMUBMGT TOTAL GETS = 2
 BMC51569I AMUBMGT FOR INDEX = DEHJCAT.DSNDBD.AMUEX2DB.IX1.I0001.A001, GETS = 1, PUTS = 1, DPUTS = N/A
 BMC50482I 2: DISCARD INDEX KEYS COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX2DB.IX1.I0001.A001'
 BMC50477I 2: PARTITION =    0, ROWS/KEYS = 2, I/O WAITS = 7 ,DDNAME = SYS00051
 BMC50481I 2: DISCARD TASK 2 COMPLETE.  ELAPSED TIME = 00:00:00
 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.AMUEX2DB.EX2TS.I0001.A009'
 BMC50477I 3: PARTITION =    9, ROWS/KEYS = 2, I/O WAITS = 5 ,DDNAME = SYS00053
 BMC50476I DDNAME = ERRWK, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50481I 3: DISCARD TASK 3 COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50476I DDNAME = INDATA, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = DATAWK, I/OS = 2, I/O WAITS = 2, 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 = INDATA, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = DISCARDS, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0

0
 BMC51521I LOADPLUS ERROR SUMMARY REPORT FOR TABLE EXAMPLE2.TBL1
 BMC51522I    INPUT        DISCARD  DISCARD               RELATED
 BMC51523I  ID: RECORD #    RECORD#  TYPE                 ID: RECORD #  FIELD, INDEX, OR CONSTRAINT NAME

 BMC51524E   1:         1          1 DUPLICATE KEY         0:         0 EXAMPLE2.IX0
 BMC51510I 1001: DISCARD TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51524E   1:         2          2 DUPLICATE KEY         0:         0 EXAMPLE2.IX0

 BMC51510I 1002: DISCARD TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 1
 BMC50476I DDNAME = ERRWK, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51472I COMBINED PHASE STATISTICS:  129 ROWS SELECTED FOR SPACE 'AMUEX2DB.EX2TS', 2 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
 BMC51479I COMBINED PHASE STATISTICS:  2 PHYSICAL (2 LOGICAL) RECORDS DISCARDED TO SYSDISC
 BMC51474I LOAD STATISTICS:  0 ROWS LOADED INTO TABLE SPACE 'AMUEX2DB.EX2TS' PARTITION 1
 BMC51474I LOAD STATISTICS:  0 ROWS LOADED INTO TABLE SPACE 'AMUEX2DB.EX2TS' PARTITION 2
 BMC51474I LOAD STATISTICS:  0 ROWS LOADED INTO TABLE SPACE 'AMUEX2DB.EX2TS' PARTITION 3
 BMC51474I LOAD STATISTICS:  0 ROWS LOADED INTO TABLE SPACE 'AMUEX2DB.EX2TS' PARTITION 4
 BMC51474I LOAD STATISTICS:  0 ROWS LOADED INTO TABLE SPACE 'AMUEX2DB.EX2TS' PARTITION 5
 BMC51474I LOAD STATISTICS:  0 ROWS LOADED INTO TABLE SPACE 'AMUEX2DB.EX2TS' PARTITION 6
 BMC51474I LOAD STATISTICS:  0 ROWS LOADED INTO TABLE SPACE 'AMUEX2DB.EX2TS' PARTITION 7
 BMC51474I LOAD STATISTICS:  0 ROWS LOADED INTO TABLE SPACE 'AMUEX2DB.EX2TS' PARTITION 8
 BMC51474I LOAD STATISTICS:  25 ROWS LOADED INTO TABLE SPACE 'AMUEX2DB.EX2TS' PARTITION 9
 BMC51474I LOAD STATISTICS:  104 ROWS LOADED INTO TABLE SPACE 'AMUEX2DB.EX2TS' PARTITION 10
 BMC51473I LOAD STATISTICS:  129 ROWS LOADED INTO TABLE 'EXAMPLE2.TBL1'
 BMC51476I BUILD STATISTICS:  964 KEYS LOADED INTO INDEX 'EXAMPLE2.IX0'
 BMC51476I BUILD STATISTICS:  964 KEYS LOADED INTO INDEX 'EXAMPLE2.IX1'
 BMC51475I LOAD STATISTICS:  129 ROWS LOADED INTO TABLE SPACE 'AMUEX2DB.EX2TS'
 BMC50370I STARTING 10 IMAGE COPY TASKS
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX2DB.EX2TS.I0001.A007'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX2DB.EX2TS.I0001.A003'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX2DB.EX2TS.I0001.A010'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX2DB.EX2TS.I0001.A006'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX2DB.EX2TS.I0001.A004'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX2DB.EX2TS.I0001.A002'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX2DB.EX2TS.I0001.A008'
 BMC50476I DDNAME = CPY00007, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = CPY00003, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX2DB.EX2TS.I0001.A009'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX2DB.EX2TS.I0001.A005'
 BMC50476I DDNAME = CPY00006, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = CPY00010, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = CPY00004, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX2DB.EX2TS.I0001.A001'
 BMC50476I DDNAME = RCY00003, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
 BMC50476I DDNAME = RCY00007, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
 BMC50376I 2 PAGES COPIED TO DATASET = 'AMU.EXAMP003.COPY07'
 BMC50376I 2 PAGES COPIED TO DATASET = 'AMU.EXAMP003.RCOPY07'
 BMC50476I DDNAME = RCY00010, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
 BMC50376I 5 PAGES COPIED TO DATASET = 'AMU.EXAMP003.COPY10'
 BMC50376I 5 PAGES COPIED TO DATASET = 'AMU.EXAMP003.RCOPY10'
 BMC50476I DDNAME = CPY00002, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = CPY00001, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = RCY00004, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
 BMC50376I 2 PAGES COPIED TO DATASET = 'AMU.EXAMP003.COPY04'
 BMC50376I 2 PAGES COPIED TO DATASET = 'AMU.EXAMP003.RCOPY04'
 BMC50476I DDNAME = RCY00002, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
 BMC50376I 4 PAGES COPIED TO DATASET = 'AMU.EXAMP003.COPY02'
 BMC50376I 4 PAGES COPIED TO DATASET = 'AMU.EXAMP003.RCOPY02'
 BMC50476I DDNAME = RCY00001, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
 BMC50376I 12 PAGES COPIED TO DATASET = 'AMU.EXAMP003.COPY01'
 BMC50376I 12 PAGES COPIED TO DATASET = 'AMU.EXAMP003.RCOPY01'
 BMC50476I DDNAME = RCY00006, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 2 PAGES COPIED TO DATASET = 'AMU.EXAMP003.COPY06'
 BMC50376I 2 PAGES COPIED TO DATASET = 'AMU.EXAMP003.RCOPY06'
 BMC50476I DDNAME = CPY00008, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = RCY00008, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
 BMC50376I 4 PAGES COPIED TO DATASET = 'AMU.EXAMP003.COPY08'
 BMC50376I 4 PAGES COPIED TO DATASET = 'AMU.EXAMP003.RCOPY08'
 BMC50376I 4 PAGES COPIED TO DATASET = 'AMU.EXAMP003.COPY03'
 BMC50376I 4 PAGES COPIED TO DATASET = 'AMU.EXAMP003.RCOPY03'
 BMC50476I DDNAME = CPY00009, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = RCY00009, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
 BMC50376I 5 PAGES COPIED TO DATASET = 'AMU.EXAMP003.COPY09'
 BMC50376I 5 PAGES COPIED TO DATASET = 'AMU.EXAMP003.RCOPY09'
 BMC50476I DDNAME = CPY00005, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = RCY00005, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
 BMC50376I 4 PAGES COPIED TO DATASET = 'AMU.EXAMP003.COPY05'
 BMC50376I 4 PAGES COPIED TO DATASET = 'AMU.EXAMP003.RCOPY05'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK01', DSNAME = 'SYS15068.T140403.RA000.AMUEX03.R0320149'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK02', DSNAME = 'SYS15068.T140403.RA000.AMUEX03.R0320150'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK03', DSNAME = 'SYS15068.T140403.RA000.AMUEX03.R0320151'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK04', DSNAME = 'SYS15068.T140403.RA000.AMUEX03.R0320152'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK05', DSNAME = 'SYS15068.T140403.RA000.AMUEX03.R0320153'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK06', DSNAME = 'SYS15068.T140403.RA000.AMUEX03.R0320154'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK07', DSNAME = 'SYS15068.T140403.RA000.AMUEX03.R0320155'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK08', DSNAME = 'SYS15068.T140403.RA000.AMUEX03.R0320156'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK09', DSNAME = 'SYS15068.T140403.RA000.AMUEX03.R0320157'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK10', DSNAME = 'SYS15068.T140403.RA000.AMUEX03.R0320158'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK11', DSNAME = 'SYS15068.T140403.RA000.AMUEX03.R0320159'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK12', DSNAME = 'SYS15068.T140403.RA000.AMUEX03.R0320160'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'IXWK02  ', DSNAME = 'AMU.EXAMP003.SYSUT2'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'IXWK01  ', DSNAME = 'AMU.EXAMP003.SYSUT1'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'ERRWK   ', DSNAME = 'AMU.EXAMP003.SYSERR'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'DATAWK  ', DSNAME = 'AMU.EXAMP003.SORTOUT'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I COMBINED PHASE COMPLETE.  ELAPSED TIME = 00:00:05

 BMC50501I DB2 OBJECT STATISTICS
0BMC50503I STATISTICS FOR TABLESPACE 'AMUEX2DB.EX2TS' NOT AVAILABLE
0BMC50503I STATISTICS FOR TABLE      'EXAMPLE2.TBL1' NOT AVAILABLE
0BMC50503I STATISTICS FOR INDEX      'EXAMPLE2.IX0' NOT AVAILABLE
0BMC50503I STATISTICS FOR INDEX      'EXAMPLE2.IX1' NOT AVAILABLE
 BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR LOAD UTILITY SUCCESSFUL FOR ALL OBJECTS
 BMC50004I UTILTERM PHASE COMPLETE.  ELAPSED TIME = 00:00:00

0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0

Related topic

Examples-of-LOADPLUS-jobs



 

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