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 8 — LOAD REPLACE with ANALYZE PAUSE

This example shows a LOAD REPLACE of a compressed table space with 10 partitions, a unique clustering index, and a non-unique nonpartitioned index.

The job is run first with ANALYZE PAUSE. You might use this option to obtain the optimal number and size of data sets to use.

Because the installation options module includes AUTOENUMROWS=YES, the command statement does not need to include the ENUMROWS option. Message BMC51561I shows the number of input records that the utility calculated using automated file size estimation.

SYSPRINT A (Output from the ANALYZE phase (example 8A)) shows the ANALYZE report that LOADPLUS generates. The numbers from the ANALYZE report can be used to modify the space allocations on the data set DD statements. The job pauses with return code 4.

The job is run again, with the NEW/RESTART option on the EXEC statement, to perform the actual load. SYSPRINT B (Output from restarting the job (example 8B)) shows this output.

The JCL contains multiple SYSREC and SORTOUT DD statements, enabling LOADPLUS to multitask in both the PRELOAD and LOAD phases. Only the nonpartitioned index is processed by using a SYSUT1 work file, so the JCL includes only one SYSUT1 DD statement.

Because the LOAD command includes the ORDER YES option, LOADPLUS sorts the data rows and partitioned index keys together. Because the LOAD command does not specify a value for the UNIQUECHECK option, LOADPLUS defaults to UNIQUECHECK YES, which tells LOADPLUS to check the clustering index for uniqueness in the PRELOAD phase.

COPY YES INLINE NO REGISTER NONE creates unregistered copies (DSN1COPY-type copies). DDTYPE LOCPFCPY ACTIVE NO disables dynamic allocation for the primary copy data set, overriding the default in the installation options module. The copy DD statements in the JCL direct LOADPLUS to create a single copy of each partition, with each copy in a separate data set.

Specifying CENTURY(1900,1999) overrides the default of (1950,2049) that was specified in the installation option. This override loads the proper century value for records that contain two-digit years for dates earlier than 1950.

This example illustrates how LOADPLUS automatically provides partition parallelism to achieve optimal performance. Message BMC51508I shows that LOADPLUS performs nine data tasks concurrently, with up to two partitions per task.

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.

LOADPLUS updates statistics in the Db2 catalog. The JCL for this example includes a DD statement for the ASUSRPRT data set. This DD statement tells LOADPLUS not to print the statistics from the Common Statistics component to SYSPRINT, but to send them to a separate data set. Statistics output (example 8B) shows a portion of this ASUSRPRT data set for 8B.

The following figure shows the JCL for example 8:

//EXAMPLE8 EXEC PGM=AMUUMAIN,
//             PARM='&SSID,EXAMPLE8,NEW        ,,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=*
//ASUSRPRT  DD  DSN=AMU.EXAMP08B.ASUSRPRT,                 
//            UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG)
//*
//SYSREC1  DD DISP=SHR,DSN=AMU.QA.RGRTESTS.DTA112
//SYSREC2  DD DISP=SHR,DSN=AMU.QA.RGRTESTS.DTA113
//SYSREC3  DD DISP=SHR,DSN=AMU.QA.RGRTESTS.DTA114
//SYSREC4  DD DISP=SHR,DSN=AMU.QA.RGRTESTS.DTA115
//*
//SORTOUT1 DD DSN=AMU.EXAMP008.SORTOUT1,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SORTOUT2 DD DSN=AMU.EXAMP008.SORTOUT2,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SORTOUT3 DD DSN=AMU.EXAMP008.SORTOUT3,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SORTOUT4 DD DSN=AMU.EXAMP008.SORTOUT4,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SORTOUT5 DD DSN=AMU.EXAMP008.SORTOUT5,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//*
//SYSERR   DD DSN=AMU.EXAMP008.SYSERR,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//SYSDISC  DD DSN=AMU.EXAMP008.SYSDISC,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//*
//SYSUT101 DD DSN=AMU.EXAMP008.SYSUT1,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,CATLG)
//*
//SORTWK01 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK02 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK03 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK04 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK05 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK06 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK07 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK08 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK09 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK10 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK11 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//SORTWK12 DD UNIT=WORK,DISP=NEW,SPACE=(CYL,(5,1))
//*
//BMCCPY01 DD DSN=AMU.EXAMP008.COPY01,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY02 DD DSN=AMU.EXAMP008.COPY02,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY03 DD DSN=AMU.EXAMP008.COPY03,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY04 DD DSN=AMU.EXAMP008.COPY04,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY05 DD DSN=AMU.EXAMP008.COPY05,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY06 DD DSN=AMU.EXAMP008.COPY06,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY07 DD DSN=AMU.EXAMP008.COPY07,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY08 DD DSN=AMU.EXAMP008.COPY08,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY09 DD DSN=AMU.EXAMP008.COPY09,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//BMCCPY10 DD DSN=AMU.EXAMP008.COPY10,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG,CATLG)
//*
//SYSIN    DD *
  LOAD REPLACE ORDER YES
    PRELOAD CONTINUE
    UPDATEDB2STATS YES
    CENTURY(1900,1999)
    REDEFINE NO
  INTO TABLE EXAMPLE8.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 INLINE NO REGISTER NONE
  ANALYZE PAUSE
  DDTYPE   LOCPFCPY  ACTIVE NO


Output from the ANALYZE phase (example 8A)The following figure shows the SYSPRINT output for example 8A:

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:44:22 ...
 BMC50002I UTILITY ID = 'EXAMPLE8'.  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=8768K,ABOVE 16M=1307120K,IEFUSI=NO,CPUS=3
 BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040306M,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 REPLACE ORDER YES
 BMC50102I     PRELOAD CONTINUE
 BMC50102I     UPDATEDB2STATS YES
 BMC50102I     CENTURY(1900,1999)
 BMC50102I     REDEFINE NO
 BMC50102I   INTO TABLE EXAMPLE8.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 INLINE NO REGISTER NONE
 BMC50102I   ANALYZE PAUSE
 BMC50102I   DDTYPE   LOCPFCPY  ACTIVE NO

 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 = 18945 USING A SCALING FACTOR OF 100%
 BMC50004I UTILINIT PHASE COMPLETE.  ELAPSED TIME = 00:00:00

 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB

 BMC51530I LOADPLUS DASD REQUIREMENT ESTIMATES
 BMC51531I                          3380 CYLS     3390 CYLS
 BMC51532I DDNAME          KBYTES    PRI    SEC    PRI    SEC INDEX

 BMC51533I SORTOUT           2100      4      1      3      1
 BMC51533I SORTOUT9           234      1      1      1      1
 BMC51533I SORTOUT8           234      1      1      1      1
 BMC51533I SORTOUT7           234      1      1      1      1
 BMC51533I SORTOUT6           234      1      1      1      1
 BMC51533I SORTOUT5           234      1      1      1      1
 BMC51533I SORTOUT4           234      1      1      1      1
 BMC51533I SORTOUT3           234      1      1      1      1
 BMC51533I SORTOUT2           234      1      1      1      1
 BMC51533I SORTOUT1           234      1      1      1      1

 BMC51533I SYSUT101           426      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001

 BMC51533I SYSUT1             426      1      1      1      1

 BMC51533I SORTWK            2980      5      1      4      1

 BMC51533I BMCCPY01           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPY02           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPY03           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPY04           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPY05           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPY06           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPY07           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPY08           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPY09           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPY10           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001

 BMC51533I BMCCPY            1800      3      1      3      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001

 BMC51533I BMCCPZ01           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPZ02           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPZ03           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPZ04           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPZ05           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPZ06           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPZ07           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPZ08           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPZ09           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCCPZ10           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001

 BMC51533I BMCCPZ            1800      3      1      3      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001

 BMC51533I BMCRCY01           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCY02           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCY03           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCY04           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCY05           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCY06           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCY07           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCY08           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCY09           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCY10           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001

 BMC51533I BMCRCY            1800      3      1      3      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001

 BMC51533I BMCRCZ01           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCZ02           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCZ03           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCZ04           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCZ05           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCZ06           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCZ07           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCZ08           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCZ09           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
 BMC51533I BMCRCZ10           180      1      1      1      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001

 BMC51533I BMCRCZ            1800      3      1      3      1 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001

 BMC51533I SYSERR             630      1      1      1      1

 BMC51533I SYSDISC           1480      3      1      2      1

 BMC50004I ANALYZE PHASE COMPLETE.  ELAPSED TIME = 00:00:00

 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50005I LOAD COMMAND EXECUTION PAUSING BEFORE PHASE = 'PRELOAD'
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 4


Output from restarting the job (example 8B)The following figure shows the SYSPRINT output for example 8B:

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:44:24 ...
 BMC50002I UTILITY ID = 'EXAMPLE8'.  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=8768K,ABOVE 16M=1307060K,IEFUSI=NO,CPUS=3
 BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040306M,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'
 BMC50003I RESTARTING UTILITY: COMMAND = 'LOAD', PHASE = 'PRELOAD'
0
0
 BMC50102I   LOAD REPLACE ORDER YES
 BMC50102I     PRELOAD CONTINUE
 BMC50102I     UPDATEDB2STATS YES
 BMC50102I     CENTURY(1900,1999)
 BMC50102I     REDEFINE NO
 BMC50102I   INTO TABLE EXAMPLE8.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 INLINE NO REGISTER NONE
 BMC50102I   ANALYZE PAUSE
 BMC50102I   DDTYPE   LOCPFCPY  ACTIVE NO

 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 = 18945 USING A SCALING FACTOR OF 100%
 BMC50004I UTILINIT PHASE COMPLETE.  ELAPSED TIME = 00:00:00

 BMC50425I &JOBNAME  = AMUEX08   &STEPNAME = RESTART8  &DB       = AMUEX8DB  &TS       = EX8TS     &UID      = RDAMZL
 BMC50425I &RESUME   = N         &REPLACE  = Y         &DATE     = 030915    &TIME     = 144424    &SSID     = DEHJ
 BMC50425I &UTIL     = EXAMPLE8  &UTILPFX  = EXAMPLE8  &UTILSFX  =           &DATE8    = 03092015  &GRPNM    = DEHJ
 BMC50425I &VCAT     = DEHJCAT   &TIME4    = 1444      &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 SORTOUT6 RDAMZL.BMC.EX8TS.SORTOUT6                    SYSALLDA                        234       58        5         2  TRK
 BMC50448I SORTOUT7 RDAMZL.BMC.EX8TS.SORTOUT7                    SYSALLDA                        234       58        5         2  TRK
 BMC50448I SORTOUT8 RDAMZL.BMC.EX8TS.SORTOUT8                    SYSALLDA                        234       58        5         2  TRK
 BMC50448I SORTOUT9 RDAMZL.BMC.EX8TS.SORTOUT9                    SYSALLDA                        234       58        5         2  TRK

 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8424K, ABOVE 16M = 1277940K, CPUS = 3
 BMC50479I TOTAL PAGES: 4019444, ALLOWED: 1205833; AVAILABLE PAGES: 705222, ALLOWED: 0
 BMC51495I PRELOAD OPTIMIZATION, RC = 15, #SORTS = 9, #READERS = 4, INDEX TASKS = 1, TIME = 79360
 BMC51495I PRELOAD OPTIMIZATION, RC = 15, #SORTS = 9, #READERS = 3, INDEX TASKS = 1, TIME = 86160
 BMC51495I PRELOAD OPTIMIZATION, RC = 15, #SORTS = 9, #READERS = 2, INDEX TASKS = 1, TIME = 99840
 BMC51495I PRELOAD OPTIMIZATION, RC = 15, #SORTS = 9, #READERS = 1, INDEX TASKS = 1, TIME = 140800
 BMC51495I PRELOAD OPTIMIZATION, RC = 0, #SORTS = 8, #READERS = 4, INDEX TASKS = 1, TIME = 86720
 BMC51495I PRELOAD OPTIMIZATION, RC = 14, #SORTS = 8, #READERS = 3, INDEX TASKS = 1, TIME = 93520
 BMC51495I PRELOAD OPTIMIZATION, RC = 14, #SORTS = 8, #READERS = 2, INDEX TASKS = 1, TIME = 107200
 BMC51495I PRELOAD OPTIMIZATION, RC = 14, #SORTS = 8, #READERS = 1, INDEX TASKS = 1, TIME = 148160
 BMC51495I PRELOAD OPTIMIZATION, RC = 14, #SORTS = 7, #READERS = 4, INDEX TASKS = 1, TIME = 96150
 BMC51495I PRELOAD OPTIMIZATION, RC = 14, #SORTS = 7, #READERS = 3, INDEX TASKS = 1, TIME = 102950
 BMC51495I PRELOAD OPTIMIZATION, RC = 14, #SORTS = 7, #READERS = 2, INDEX TASKS = 1, TIME = 116630
 BMC51495I PRELOAD OPTIMIZATION, RC = 14, #SORTS = 7, #READERS = 1, INDEX TASKS = 1, TIME = 157590
 BMC51496I PRELOAD ANALYZE, #SORTS = 8, #READERS = 4, INDEX TASKS = 1
 BMC50486I 10: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 11: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 9: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 12: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 7: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 5: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 8: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 6: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50481I 4: READ TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 2: READ TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 4: READ TASK, XBLK XFERS = 7, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51478I PRELOAD STATISTICS:  854 PHYSICAL (854 LOGICAL) RECORDS READ FROM SYSREC4
 BMC51510I 2: READ TASK, XBLK XFERS = 9, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51478I PRELOAD STATISTICS:  3442 PHYSICAL (3442 LOGICAL) RECORDS READ FROM SYSREC2
 BMC50481I 3: READ TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 3: READ TASK, XBLK XFERS = 8, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51478I PRELOAD STATISTICS:  1735 PHYSICAL (1735 LOGICAL) RECORDS READ FROM SYSREC3
 BMC50481I 1: READ TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 1: READ TASK, XBLK XFERS = 19, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51478I PRELOAD STATISTICS:  10000 PHYSICAL (10000 LOGICAL) RECORDS READ FROM SYSREC1
 BMC50481I 6: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 10: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 7: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 9: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 11: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 5: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 12: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50481I 12: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 12: SORT TASK, XBLK XFERS = 0, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50481I 8: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 7
 BMC50481I 6: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 6: SORT TASK, XBLK XFERS = 4, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51503E DUPLICATE KEY FOUND FOR DATA SORTING INDEX 'EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000000',RECORD NO. = 100 OF SYSREC4
 BMC51504E     KEY VALUE = ' 1/25/1990,100'
 BMC51503E DUPLICATE KEY FOUND FOR DATA SORTING INDEX 'EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000000',RECORD NO. = 1 OF SYSREC3
 BMC51504E     KEY VALUE = ' 1/25/1990,100'
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 2
 BMC50481I 5: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 5: SORT TASK, XBLK XFERS = 4, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 9
 BMC50481I 9: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 3
 BMC51510I 9: SORT TASK, XBLK XFERS = 4, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50481I 7: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 4
 BMC51510I 7: SORT TASK, XBLK XFERS = 4, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 1
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 5
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 8
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 6
 BMC50481I 10: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50367I COMPRESSION DICTIONARY BUILT FOR TABLESPACE AMUEX8DB.EX8TS PARTITION 10
 BMC51510I 10: SORT TASK, XBLK XFERS = 4, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50481I 8: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 8: SORT TASK, XBLK XFERS = 18, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50481I 11: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 11: SORT TASK, XBLK XFERS = 5, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50476I DDNAME = SYSREC1, I/OS = 2, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC2, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC3, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC4, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT1, 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 = 4, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT5, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT6, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT7, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT8, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SORTOUT9, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSUT101, I/OS = 3, I/O WAITS = 3, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSERR, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
 BMC51507I XBLKS = 56, XFERS = 43, 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 = SYSREC3, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC4, 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 EXAMPLE8.TBL1
 BMC51522I    INPUT        DISCARD  DISCARD               RELATED
 BMC51523I  ID: RECORD #    RECORD#  TYPE                 ID: RECORD #  FIELD, INDEX, OR CONSTRAINT NAME

 BMC51524E   3:         1          1 DUPLICATE KEY         4:       100 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000000
 BMC51524E   4:       100          2 DUPLICATE KEY         4:       100 EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000000
 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:  11031 ROWS SELECTED FOR PARTITION 1
 BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A001' WILL REQUIRE 163 PAGES
 BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A001' WILL REQUIRE 52 PAGES (APPROX.)
 BMC51471I PRELOAD STATISTICS:  522 ROWS SELECTED FOR PARTITION 2
 BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A002' WILL REQUIRE 29 PAGES
 BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A002' WILL REQUIRE 6 PAGES (APPROX.)
 BMC51471I PRELOAD STATISTICS:  529 ROWS SELECTED FOR PARTITION 3
 BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A003' WILL REQUIRE 29 PAGES
 BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A003' WILL REQUIRE 6 PAGES (APPROX.)
 BMC51471I PRELOAD STATISTICS:  577 ROWS SELECTED FOR PARTITION 4
 BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A004' WILL REQUIRE 30 PAGES
 BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A004' WILL REQUIRE 6 PAGES (APPROX.)
 BMC51471I PRELOAD STATISTICS:  543 ROWS SELECTED FOR PARTITION 5
 BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A005' WILL REQUIRE 29 PAGES
 BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A005' WILL REQUIRE 6 PAGES (APPROX.)
 BMC51471I PRELOAD STATISTICS:  109 ROWS SELECTED FOR PARTITION 6
 BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A006' WILL REQUIRE 21 PAGES
 BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A006' WILL REQUIRE 4 PAGES (APPROX.)
 BMC51471I PRELOAD STATISTICS:  236 ROWS SELECTED FOR PARTITION 7
 BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A007' WILL REQUIRE 23 PAGES
 BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A007' WILL REQUIRE 5 PAGES (APPROX.)
 BMC51471I PRELOAD STATISTICS:  793 ROWS SELECTED FOR PARTITION 8
 BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A008' WILL REQUIRE 34 PAGES
 BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A008' WILL REQUIRE 7 PAGES (APPROX.)
 BMC51471I PRELOAD STATISTICS:  789 ROWS SELECTED FOR PARTITION 9
 BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A009' WILL REQUIRE 34 PAGES
 BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A009' WILL REQUIRE 7 PAGES (APPROX.)
 BMC51471I PRELOAD STATISTICS:  900 ROWS SELECTED FOR PARTITION 10
 BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A010' WILL REQUIRE 36 PAGES
 BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A010' WILL REQUIRE 7 PAGES (APPROX.)
 BMC51488I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEX8DB.LONG1PKZ.I0001.A001' MAY REQUIRE 87 PAGES
 BMC51472I PRELOAD PHASE STATISTICS:  16029 ROWS SELECTED FOR SPACE 'AMUEX8DB.EX8TS', 2 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
 BMC51479I PRELOAD PHASE STATISTICS:  2 PHYSICAL (2 LOGICAL) RECORDS DISCARDED TO SYSDISC
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I PRELOAD PHASE COMPLETE.  ELAPSED TIME = 00:00:03

 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8244K, ABOVE 16M = 1295948K, CPUS = 3
 BMC50479I TOTAL PAGES: 4027075, ALLOWED: 1208123; AVAILABLE PAGES: 712685, ALLOWED: 0
 BMC51498I LOAD OPTIMIZATION, RC = 0, #LOAD TASKS = 9, #COPY TASKS = 9, #INDEX TASKS = 1
 BMC50486I 0: BMCSORT STARTED, 256K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50370I STARTING 9 IMAGE COPY TASKS
 BMC51508I MAX DATA TASKS = 9, MAX PARTS PER TASK = 2, SORTWKS PER TASK = 0, MAX OPEN PARTITIONS PER TASK = 1
 BMC51453I EXISTING ROWS IN TABLESPACE 'AMUEX8DB.EX8TS' DELETED
 BMC51508I MAX INDEX TASKS = 1, INDEXES PER TASK = 1, SORTWKS PER TASK = 12, MAX OPEN PARTITIONS PER TASK = 1
 BMC50476I DDNAME = SORTOUT8, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50482I 0: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A002'
 BMC50477I 0: PARTITION =    2, ROWS/KEYS = 522, I/O WAITS = 7 ,DDNAME = SYS00021
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A007'
 BMC50477I 1: PARTITION =    7, ROWS/KEYS = 236, I/O WAITS = 7 ,DDNAME = SYS00023
 BMC50482I 4: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A009'
 BMC50477I 4: PARTITION =    9, ROWS/KEYS = 789, I/O WAITS = 7 ,DDNAME = SYS00026
 BMC50476I DDNAME = SORTOUT9, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50482I 5: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A004'
 BMC50482I 6: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A008'
 BMC50477I 6: PARTITION =    8, ROWS/KEYS = 793, I/O WAITS = 7 ,DDNAME = SYS00029
 BMC50482I 2: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A003'
 BMC50477I 2: PARTITION =    3, ROWS/KEYS = 529, I/O WAITS = 7 ,DDNAME = SYS00022
 BMC50477I 5: PARTITION =    4, ROWS/KEYS = 577, I/O WAITS = 7 ,DDNAME = SYS00028
 BMC50486I 1: BMCSORT STARTED, 384K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50482I 3: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A001'
 BMC50477I 3: PARTITION =    1, ROWS/KEYS = 11031, I/O WAITS = 7 ,DDNAME = SYS00025
 BMC50482I 0: LOAD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A002'
 BMC50477I 0: PARTITION =    2, ROWS/KEYS = 522, I/O WAITS = 5 ,DDNAME = SYS00016
 BMC51474I LOAD STATISTICS:  522 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 2
 BMC50482I 1: LOAD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A007'
 BMC50477I 1: PARTITION =    7, ROWS/KEYS = 236, I/O WAITS = 5 ,DDNAME = SYS00017
 BMC50482I 4: LOAD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A009'
 BMC50477I 4: PARTITION =    9, ROWS/KEYS = 789, I/O WAITS = 5 ,DDNAME = SYS00020
 BMC51474I LOAD STATISTICS:  236 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 7
 BMC50482I 5: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A004'
 BMC50477I 5: PARTITION =    4, ROWS/KEYS = 577, I/O WAITS = 5 ,DDNAME = SYS00024
 BMC51474I LOAD STATISTICS:  577 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 4
 BMC51474I LOAD STATISTICS:  789 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 9
 BMC50482I 3: LOAD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A001'
 BMC50476I DDNAME = SORTOUT1, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50482I 2: LOAD COMPLETE.  ELAPSED TIME = 00:00:01  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A003'
 BMC50477I 2: PARTITION =    3, ROWS/KEYS = 529, I/O WAITS = 5 ,DDNAME = SYS00018
 BMC51474I LOAD STATISTICS:  529 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 3
 BMC50482I 6: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A008'
 BMC50477I 6: PARTITION =    8, ROWS/KEYS = 793, I/O WAITS = 5 ,DDNAME = SYS00027
 BMC50476I DDNAME = SORTOUT2, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51474I LOAD STATISTICS:  793 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 8
 BMC50477I 3: PARTITION =    1, ROWS/KEYS = 11031, I/O WAITS = 5 ,DDNAME = SYS00019
 BMC51474I LOAD STATISTICS:  11031 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 1
 BMC50476I DDNAME = SORTOUT5, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A002'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A007'
 BMC50476I DDNAME = SORTOUT3, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A009'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A004'
 BMC50476I DDNAME = BMCCPY02, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 29 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY02'
 BMC50476I DDNAME = SORTOUT4, I/OS = 2, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = BMCCPY07, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 23 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY07'
 BMC50476I DDNAME = BMCCPY09, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 34 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY09'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A003'
 BMC50476I DDNAME = BMCCPY04, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 30 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY04'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A001'
 BMC50482I 5: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A005'
 BMC50477I 5: PARTITION =    5, ROWS/KEYS = 543, I/O WAITS = 7 ,DDNAME = SYS00036
 BMC50476I DDNAME = BMCCPY03, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 29 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY03'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A008'
 BMC50482I 6: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A010'
 BMC50477I 6: PARTITION =   10, ROWS/KEYS = 900, I/O WAITS = 7 ,DDNAME = SYS00038
 BMC50476I DDNAME = BMCCPY01, I/OS = 2, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 163 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY01'
 BMC50476I DDNAME = BMCCPY08, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 34 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY08'
 BMC50482I 5: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A005'
 BMC50477I 5: PARTITION =    5, ROWS/KEYS = 543, I/O WAITS = 5 ,DDNAME = SYS00031
 BMC50476I DDNAME = SYSUT101, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50482I 6: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A010'
 BMC50477I 6: PARTITION =   10, ROWS/KEYS = 900, I/O WAITS = 5 ,DDNAME = SYS00034
 BMC50481I 1: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51474I LOAD STATISTICS:  900 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 10
 BMC51474I LOAD STATISTICS:  543 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 5
 BMC50476I DDNAME = SORTOUT7, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A005'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A010'
 BMC50476I DDNAME = BMCCPY05, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 29 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY05'
 BMC50482I 1: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.LONG1PKZ.I0001.A001'
 BMC50477I 1: PARTITION =    0, ROWS/KEYS = 16029, I/O WAITS = 7 ,DDNAME = SYS00042
 BMC50476I DDNAME = BMCCPY10, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 36 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY10'
 BMC51476I BUILD STATISTICS:  16029 KEYS LOADED INTO INDEX 'EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001'
 BMC50482I 5: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.LONGNAME.I0001.A006'
 BMC50477I 5: PARTITION =    6, ROWS/KEYS = 109, I/O WAITS = 7 ,DDNAME = SYS00047
 BMC50482I 5: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A006'
 BMC50477I 5: PARTITION =    6, ROWS/KEYS = 109, I/O WAITS = 5 ,DDNAME = SYS00043
 BMC51474I LOAD STATISTICS:  109 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS' PARTITION 6
 BMC50476I DDNAME = SORTOUT6, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51476I BUILD STATISTICS:  16029 KEYS LOADED INTO INDEX 'EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000000'
 BMC51475I LOAD STATISTICS:  16029 ROWS LOADED INTO TABLE SPACE 'AMUEX8DB.EX8TS'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEX8DB.EX8TS.I0001.A006'
 BMC50476I DDNAME = BMCCPY06, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50376I 21 PAGES COPIED TO DATASET = 'AMU.EXAMP008.COPY06'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR  ', DSNAME = 'AMU.EXAMP008.SYSERR'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK01', DSNAME = 'SYS15068.T144415.RA000.AMUEX08.R0330846'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK02', DSNAME = 'SYS15068.T144415.RA000.AMUEX08.R0330847'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK03', DSNAME = 'SYS15068.T144415.RA000.AMUEX08.R0330848'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK04', DSNAME = 'SYS15068.T144415.RA000.AMUEX08.R0330849'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK05', DSNAME = 'SYS15068.T144415.RA000.AMUEX08.R0330850'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK06', DSNAME = 'SYS15068.T144415.RA000.AMUEX08.R0330851'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK07', DSNAME = 'SYS15068.T144415.RA000.AMUEX08.R0330852'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK08', DSNAME = 'SYS15068.T144415.RA000.AMUEX08.R0330853'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK09', DSNAME = 'SYS15068.T144415.RA000.AMUEX08.R0330854'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK10', DSNAME = 'SYS15068.T144415.RA000.AMUEX08.R0330855'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK11', DSNAME = 'SYS15068.T144415.RA000.AMUEX08.R0330856'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK12', DSNAME = 'SYS15068.T144415.RA000.AMUEX08.R0330857'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT6', DSNAME = 'RDAMZL.BMC.EX8TS.SORTOUT6'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT7', DSNAME = 'RDAMZL.BMC.EX8TS.SORTOUT7'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT101', DSNAME = 'AMU.EXAMP008.SYSUT1'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT4', DSNAME = 'AMU.EXAMP008.SORTOUT4'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT3', DSNAME = 'AMU.EXAMP008.SORTOUT3'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT5', DSNAME = 'AMU.EXAMP008.SORTOUT5'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT2', DSNAME = 'AMU.EXAMP008.SORTOUT2'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT1', DSNAME = 'AMU.EXAMP008.SORTOUT1'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT9', DSNAME = 'RDAMZL.BMC.EX8TS.SORTOUT9'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT8', DSNAME = 'RDAMZL.BMC.EX8TS.SORTOUT8'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I LOAD PHASE COMPLETE.  ELAPSED TIME = 00:00:04

 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

Statistics output (example 8B)

The following figure shows a portion of the statistics reports sent to ASUSRPRT for example 8B.

This figure shows one set of statistics for each object type. Ellipses (...) at the beginning of a line indicate the omitted statistics sections.

1BMCSTATS V11.02.00 REPORT FOR DEHJ V1115 (111)       TIME 2015-03-09-14.44.30.149820                                          1
0

   INDEX --------------- EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000000
     ASSOCIATIONS
       TABLESPACE ------ AMUEX8DB.EX8TS
       TABLE ----------- EXAMPLE8.TBL1
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------L  LOCATION------------------DEHJ
       SAMPLING---------------------N
     ATTRIBUTES
       PIECESIZE--------------------0  TYPE TS----------------(BLANK)  UNIQUERULE-------------------U  KEYLENGTH--------------------9
       SPARSE-----------------------N  INDEXTYPE--------------------2  CLUSTERING-------------------Y  COLCOUNT---------------------2
       INDEXSPACE------------LONGNAME  PGSIZE-----------------------4  EXTTYPE----------------(BLANK)  COMPRESS---------------------N
       COLNAME-----------DATE_OF_SALE
     STATISTICS
       FIRSTKEYCARD---------------132  FULLKEYCARD--------------16029  NACTIVE--------------------117  TBCARDF------------------16029
       NUMNONLEAF------------------10  NLEVELS----------------------2  CLUSTERRATIO---------------100  NLEAF-----------------------77
       AVGKEYLEN--------------------9  REORGSPACE-----------------150  REORGSPACE_KB-------------7200  REORGNLEVELS-----------------2
       HIGH2K-------------X'19980306'  HIGH2K (CHAR)-------------.q..  LOW2K--------------X'19010301'  LOW2K (CHAR)--------------....
       DATAREPEAT-----------------248
     ALLOCATION
       SPACE----------------------150  SPACE_KB------------------7200

   INDEXPART ----------- EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000000 PART 001
     ASSOCIATIONS
       TABLESPACE ------ AMUEX8DB.EX8TS
       TABLE ----------- EXAMPLE8.TBL1
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------L  LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------1  SQTY-------------------------1  PCTFREE---------------------10  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  NLAVGKEYLEN------------------8  VCATNAME---------------DEHJCAT
       RBA_FORMAT------------EXTENDED  STORNAME--------------AMUQASTO
     STATISTICS
       FIRSTKEYCARD----------------95  FULLKEYCARD--------------11031  CARD---------------------11031  NACTIVE---------------------54
       CLUSTERRATIO---------------100  NUMNONLEAF-------------------1  NLEVELS----------------------2  FAROFFPOS--------------------0
       NEAROFFPOS-------------------0  LEAFDIST---------------------2  NLEAF-----------------------50  FREE------------------------26
       FULL-------------------------0  AVGKEYLEN--------------------9
       LEAFNEAR---------------------1  LEAFFAR----------------------0  PSEUDO_DEL_RIDS--------------0  REORGSPACE------------------15
       REORGSPACE_KB--------------720  REORGNLEVELS-----------------2  PCTUSED--------------------100  PQTYROWS-----------------40196
       DATAREPEAT-----------------145
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------DEVS9F

. . .

   COLUMN -------------- DATE_OF_SALE
     ASSOCIATIONS
       TABLESPACE ------ AMUEX8DB.EX8TS
       TABLE ----------- EXAMPLE8.TBL1
     ATTRIBUTES
       COLNO------------------------9  COLTYPE-------------------DATE  LENGTH-----------------------4  NULLS------------------------N
       SCALE------------------------0
     STATISTICS
       COLCARD--------------------132  COLNULLS---------------------0  COLAVG-----------------------4  COLMIN-----------------------4
       COLMAX-----------------------4
       HIGH2K-------------X'19980306'  HIGH2K (CHAR)-------------.q..  LOW2K--------------X'19010301'  LOW2K (CHAR)--------------....

       MOST FREQUENT VALUES
       FREQUENCY-------------0.087342  COLVAL-------------X'19820617'
                                       (CHAR)--------------------.b..
       FREQUENCY-------------0.043234  COLVAL-------------X'19891025'
                                       (CHAR)--------------------.i..
       FREQUENCY-------------0.042985  COLVAL-------------X'19900125'
                                       (CHAR)--------------------....
       FREQUENCY-------------0.042673  COLVAL-------------X'19820705'
                                       (CHAR)--------------------.b..
       FREQUENCY-------------0.033627  COLVAL-------------X'19820810'
                                       (CHAR)--------------------.b..
       FREQUENCY-------------0.028823  COLVAL-------------X'19850224'
                                       (CHAR)--------------------.e..
       FREQUENCY-------------0.026203  COLVAL-------------X'19840321'
                                       (CHAR)--------------------.d..
       FREQUENCY-------------0.025766  COLVAL-------------X'19830101'
                                       (CHAR)--------------------.c..
       FREQUENCY-------------0.025766  COLVAL-------------X'19861012'
                                       (CHAR)--------------------.f..
       FREQUENCY-------------0.008297  COLVAL-------------X'19880514'
                                       (CHAR)--------------------.h..
1BMCSTATS V11.02.00 REPORT FOR DEHJ V1115 (111)       TIME 2015-03-09-14.44.30.149820                                          6
0

   KEYCARD ------------- DATE_OF_SALE
     ASSOCIATIONS
       TABLESPACE ------ AMUEX8DB.EX8TS
       TABLE ----------- EXAMPLE8.TBL1
     ATTRIBUTES AND STATISTICS
       COLUMN------------DATE_OF_SALE  COLCARD--------------------132  COLTYPE-------------------DATE  LENGTH-----------------------4
       COLUMN----------SALES_TRANS_ID  COLCARD------------------15232  COLTYPE----------------INTEGER  LENGTH-----------------------4

   COLUMN -------------- DATE_OF_SALE PART 001
     ATTRIBUTES
       COLNO------------------------9  COLTYPE-------------------DATE  LENGTH-----------------------4  NULLS------------------------N
       SCALE------------------------0
     STATISTICS
       COLCARD---------------------95  COLNULLS---------------------0  COLAVG-----------------------4  COLMIN-----------------------4
       COLMAX-----------------------4
       HIGH2K-------------X'19820810'  HIGH2K (CHAR)-------------.b..  LOW2K--------------X'19010301'  LOW2K (CHAR)--------------....
       HIGHK--------------X'19821025'  HIGHK (CHAR)--------------.b..  LOWK---------------X'19000306'  LOWK (CHAR)---------------....

       MOST FREQUENT VALUES
       FREQUENCY-------------0.126915  COLVAL-------------X'19820617'
                                       (CHAR)--------------------.b..
       FREQUENCY-------------0.062007  COLVAL-------------X'19820705'
                                       (CHAR)--------------------.b..
       FREQUENCY-------------0.048862  COLVAL-------------X'19820810'
                                       (CHAR)--------------------.b..
       FREQUENCY-------------0.009065  COLVAL-------------X'19160306'
                                       (CHAR)--------------------....
       FREQUENCY-------------0.009065  COLVAL-------------X'19150301'
                                       (CHAR)--------------------....
       FREQUENCY-------------0.009065  COLVAL-------------X'19140306'
                                       (CHAR)--------------------....
       FREQUENCY-------------0.009065  COLVAL-------------X'19130301'
                                       (CHAR)--------------------....
       FREQUENCY-------------0.009065  COLVAL-------------X'19120306'
                                       (CHAR)--------------------....
       FREQUENCY-------------0.009065  COLVAL-------------X'19110301'
                                       (CHAR)--------------------....
       FREQUENCY-------------0.009065  COLVAL-------------X'19100306'
                                       (CHAR)--------------------....

   KEYCARD ------------- DATE_OF_SALE PART 001
     ATTRIBUTES AND STATISTICS
       COLUMN------------DATE_OF_SALE  COLCARD---------------------95  COLTYPE-------------------DATE  LENGTH-----------------------4
       COLUMN----------SALES_TRANS_ID  COLCARD------------------11031  COLTYPE----------------INTEGER  LENGTH-----------------------4

. . .

   INDEX --------------- EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
     ASSOCIATIONS
       TABLESPACE ------ AMUEX8DB.EX8TS
       TABLE ----------- EXAMPLE8.TBL1
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------L  LOCATION------------------DEHJ
       SAMPLING---------------------N
     ATTRIBUTES
       PIECESIZE--------------2097152  TYPE TS----------------(BLANK)  UNIQUERULE-------------------D  KEYLENGTH-------------------10
       SPARSE-----------------------N  INDEXTYPE--------------------2  CLUSTERING-------------------N  COLCOUNT---------------------1
       INDEXSPACE------------LONG1PKZ  PGSIZE-----------------------4  EXTTYPE----------------(BLANK)  COMPRESS---------------------N
       COLNAME--------------SELLER_ID
     STATISTICS
       FIRSTKEYCARD----------------66  FULLKEYCARD-----------------66  NACTIVE---------------------27  TBCARDF------------------16029
       NUMNONLEAF-------------------1  NLEVELS----------------------2  CLUSTERRATIO----------------95  NLEAF-----------------------23
       AVGKEYLEN-------------------10  REORGSPACE------------------15  REORGSPACE_KB--------------720  REORGNLEVELS-----------------2
       HIGH2K-----X'F8F9404A4BF8F940'  HIGH2K (CHAR)---------89 ..89   LOW2K------X'4A4B4C4D4E4A4B4C'  LOW2K (CHAR)----------..<(+..<
       DATAREPEAT----------------7674
     ALLOCATION
       SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1

   INDEXPART ----------- EXAMPLE8.LONGNAME_INDEX_ON_EXAMPLE8_IX000001
     ASSOCIATIONS
       TABLESPACE ------ AMUEX8DB.EX8TS
       TABLE ----------- EXAMPLE8.TBL1
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------L  LOCATION----------------(NULL)
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------1  SQTY-------------------------1  PCTFREE---------------------10  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  NLAVGKEYLEN-----------------10  VCATNAME---------------DEHJCAT
       RBA_FORMAT------------EXTENDED  STORNAME--------------AMUQASTO
     STATISTICS
       FIRSTKEYCARD----------------66  FULLKEYCARD-----------------66  CARD---------------------16029  NACTIVE---------------------27
       CLUSTERRATIO----------------95  NUMNONLEAF-------------------1  NLEVELS----------------------2  FAROFFPOS------------------652
       NEAROFFPOS-----------------600  LEAFDIST---------------------4  NLEAF-----------------------23  FREE------------------------14
       FULL-------------------------0  AVGKEYLEN-------------------10
       LEAFNEAR---------------------1  LEAFFAR----------------------0  PSEUDO_DEL_RIDS--------------0  REORGSPACE------------------15
       REORGSPACE_KB--------------720  REORGNLEVELS-----------------2  PCTUSED--------------------100  PQTYROWS----------------127022
       DATAREPEAT----------------7674
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------DEVS0C

   COLUMN -------------- SELLER_ID
     ASSOCIATIONS
       TABLESPACE ------ AMUEX8DB.EX8TS
       TABLE ----------- EXAMPLE8.TBL1
     ATTRIBUTES
       COLNO------------------------8  COLTYPE-------------------CHAR  LENGTH----------------------10  NULLS------------------------N
     STATISTICS
       COLCARD---------------------66  COLNULLS---------------------0  COLAVG----------------------10  COLMIN----------------------10
       COLMAX----------------------10
       HIGH2K-----X'F8F9404A4BF8F940'  HIGH2K (CHAR)---------89 ..89   LOW2K------X'4A4B4C4D4E4A4B4C'  LOW2K (CHAR)----------..<(+..<

       MOST FREQUENT VALUES
1BMCSTATS V11.02.00 REPORT FOR DEHJ V1115 (111)       TIME 2015-03-09-14.44.30.149820                                          2
0
        FREQUENCY-------------0.235760     COLVAL-X'E2D4C9E3C8F540404040'
                                           (CHAR)--------------SMITH5
        FREQUENCY-------------0.129453     COLVAL-X'E9C9C7C1C6D6D6E24040'
                                           (CHAR)--------------ZIGAFOOS
        FREQUENCY-------------0.010918     COLVAL-X'E64BC14BD9C5C5C44040'
                                           (CHAR)--------------W.A.REED
        FREQUENCY-------------0.009920     COLVAL-X'6B6C6D6E6F6B6C6D6E6F'
                                           (CHAR)--------------,%_>?,%_>?
        FREQUENCY-------------0.009920     COLVAL-X'616B6C6D6E616B6C6D6E'
                                           (CHAR)--------------/,%_>/,%_>
        FREQUENCY-------------0.009920     COLVAL-X'60616B6C6D60616B6C6D'
                                           (CHAR)---------------/,%_-/,%_
        FREQUENCY-------------0.009920     COLVAL-X'5F60616B6C5F60616B6C'
                                           (CHAR)--------------¬-/,%¬-/,%
        FREQUENCY-------------0.009920     COLVAL-X'5E5F60616B5E5F60616B'
                                           (CHAR)--------------;¬-/,;¬-/,
        FREQUENCY-------------0.009920     COLVAL-X'5D5E5F60615D5E5F6061'
                                           (CHAR)--------------);¬-/);¬-/
        FREQUENCY-------------0.009920     COLVAL-X'5C5D5E5F605C5D5E5F60'
                                           (CHAR)--------------*);¬-*);¬-
1BMCSTATS V11.02.00 REPORT FOR DEHJ V1115 (111)       TIME 2015-03-09-14.44.30.149820                                          1
0

 TABLESPACE ------------ AMUEX8DB.EX8TS
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------L  LOCATION------------------DEHJ
       SAMPLING---------------------N
     ATTRIBUTES
       PARTITIONS------------------10  NTABLES----------------------1  PGSIZE-----------------------4  SEGSIZE----------------------0
       DSSIZE-----------------------0
       MAXROWS--------------------255  TYPE-------------------(BLANK)  ENCODING---------------------E  MAXPARTITIONS----------------0
       LOB--------------------------N  XML--------------------------N  MEMBER_CLUSTER---------(BLANK)
     STATISTICS
       NACTIVE--------------------428  REORGSPACE-----------------150  REORGSPACE_KB-------------7200  ROWMAXFOUND-----------------74
       ROWMINFOUND-----------------27  ROWAVG----------------------57
     ALLOCATION
       SPACE----------------------150  SPACE_KB------------------7200

   TABLEPART ----------- AMUEX8DB.EX8TS    PART 001
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  LOCATION----------------(NULL)  UTILCODE---------------------L
       SAMPLING---------------------N
     ATTRIBUTES
       PQTY-------------------------1  SQTY-------------------------1  PCTFREE----------------------5  FREEPAGE---------------------0
       ALLOCUNIT--------------------C  STORTYPE---------------------I  COMPRESS---------------------Y  TRACKMOD---------------(BLANK)
       ROW_FORMAT-----------------RRF  RBA_FORMAT------------EXTENDED  VCATNAME---------------DEHJCAT  STORNAME--------------AMUQASTO
     STATISTICS
       CARD---------------------11031  NACTIVE--------------------163  NPAGES---------------------145  ROWAVG----------------------49
       ROWMAXFOUND-----------------74  ROWMINFOUND-----------------27  AVGNONCOMPROWLEN----------(-1)  DIRTY------------------------0
       FULL------------------------16  FARINDREF--------------------0  NEARINDREF-------------------0  PERCACTIVE------------------79
       PCTPAGES--------------------88  PERCDROP---------------------0  REORGSPACE------------------15  REORGSPACE_KB--------------720
       PCTUSED--------------------100  PQTYROWS-----------------12149  NDICTIONARY-----------------16  PCTROWCOMP------------------82
       PAGESAVE---------------------0
     ALLOCATION
       IPREFIX----------------------I  SPACE-----------------------15  SPACE_KB-------------------720  NUMDATASETS------------------1
       EXTENTS----------------------1  VOLCOUNT---------------------1  DEVTYPE-------------------3390  VOLUME------------------DEVSSG

. . .
   TABLE --------------- EXAMPLE8.TBL1
     ASSOCIATIONS
       TABLESPACE ------ AMUEX8DB.EX8TS
     HISTORY
       SAVESTATS--------------------N  UPDATEDB2--------------------Y  UTILCODE---------------------L  LOCATION----------------(NULL)
     STATISTICS
       CARD---------------------16029  NPAGES---------------------248  SPACE_KB------------------7200  AVGNONCOMPROWLEN----------(-1)
       ROWAVG----------------------57  ROWMAXFOUND-----------------74  ROWMINFOUND-----------------27  INDREF-----------------------0
       PCTPAGES--------------------57  PCTROWCOMP------------------56

Related topics

Examples-of-LOADPLUS-jobs

PAUSE


 

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