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 UNLOAD PLUS for DB2 13.1.

Example 18 — Unloading a table space and loading data as Unicode

In this example, UNLOAD PLUS unloads all of the data from an EBCDIC employee table space by using a Unicode encoding scheme (specified by using the UNICODE keyword).

After unloading the data as Unicode, LOADPLUS loads it into identically defined tables on another Db2 subsystem. This example includes both the UNLOAD PLUS JCL and SYSPRINT, and the LOADPLUS JCL and SYSPRINT.

Specifying UNLOAD TABLESPACE tells UNLOAD PLUS to generate a SELECT statement for each object in the table space. The functionality of this option is the same as if you had specified SELECT * FROM for every table in the table space. The AUTOTAG YES option adds a four-byte character constant value at the beginning of each output record for each generated SELECT statement. This tag identifies the table source when you use a single output data set.

In both jobs, message 50041I indicates the status of zIIP processing. For this example, the ZIIP installation option is ENABLED, but an XBM subsystem was not specified. UNLOAD PLUS and LOADPLUS automatically locate an available XBM subsystem to provide zIIP processing.

The following table describes the UNLOAD PLUS key command options for this job:

Command options used in JCL

Description

UNLOAD TABLESPACE

Unloads table space BMCEXDB.BMCEXBTS and generates SELECT statements for the following tables (see message BMC51657I and BMC51658I in the SYSPRINT output):

  • BMC.RET_EMPLS
  • BMC.HRLY_EMPLS
  • BMC.SAL_EMPLS

UNICODE

Tells UNLOAD PLUS to use the Db2 installation default (DSNHDECP) CCSIDs to encode the unloaded data in Unicode

AUTOTAG YES

Precedes each output record with a unique four-byte value for each generated SELECT statement

CNTLCARDS 'REPLACE'

Tells UNLOAD PLUS to write Db2 LOAD control statements

'REPLACE' is added to the Db2 LOAD control statement.

UNLOADDN SYSREC ACTIVE NO

Disables dynamic allocation for the primary unload data set, overriding the default in the installation options module

The following table describes the LOADPLUS key command options for this job:

Command options used in JCL

Description

REPLACE

Tells LOADPLUS to delete the existing data in the tables before loading

UNICODE

Specifies that the data that you are loading from the SYSREC data set is in Unicode format

CCSID

Specifies the three CCSIDs used to encode the data coming from UNLOAD PLUS

INTO TABLE

Identifies the data to load by specifying the table name

WHEN

Specifies the condition that must be true for LOADPLUS to select a row

The SYSIN DD statement in the LOADPLUS JCL specifies the name of the SYSCNTL data set that contains the LOAD command options that UNLOAD PLUS created. Passing the options from UNLOAD PLUS to LOADPLUS in this way streamlines the data migration process by eliminating the need to manually modify options in your LOADPLUS JCL.

The following figure shows the UNLOAD PLUS JCL for example 18:

//        JOB
//UNLOADZA EXEC PGM=ADUUMAIN,REGION=0M,
//         PARM=(DEHJ,'ADUXM18A','NEW ',,'MSGLEVEL(1)')
//STEPLIB  DD DISP=SHR,DSN=<product.libraries>
//         DD DISP=SHR,DSN=DB2.DSNEXIT
//         DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSREC   DD DSN=ADU.EXAMPL18.UNICODE.SYSREC,
//            DISP=(NEW,CATLG),SPACE=(TRK,(5,1)),UNIT=SYSDA
//SYSCNTL  DD DSN=ADU.EXAMPL18.UNICODE.SYSCNTL,
//            DISP=(NEW,CATLG),SPACE=(TRK,(1,1)),UNIT=SYSDA
//SYSPRINT DD SYSOUT=*
//UTPRINT  DD SYSOUT=*
//SYSIN    DD   *
*
 UNLOAD
  TABLESPACE BMCEXDB.BMCEXBTS
  UNICODE
    AUTOTAG YES
    CNTLCARDS 'REPLACE'
    UNLOADDN SYSREC ACTIVE NO
*

The following figure shows the LOADPLUS JCL for example 18:

//        JOB
//LODPLUS1 EXEC PGM=AMUUMAIN,
//             PARM='DECS,ADUXM18B,NEW,,MSGLEVEL(1)'
//STEPLIB  DD DISP=SHR,DSN=<product.libraries>
//         DD DISP=SHR,DSN=DB2.DSNEXIT
//         DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSPRINT DD SYSOUT=*,HOLD=YES
//SYSOUT   DD SYSOUT=*
//UTPRINT  DD SYSOUT=*,HOLD=YES
//SYSUDUMP DD SYSOUT=*
//SORTOUT  DD DSN=&SORTOUT,
//            DISP=(NEW,PASS),UNIT=WORK,SPACE=(CYL,(1,1))
//SYSUT101 DD DSN=&SYSUT1,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,PASS)
//SORTWK01 DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK02 DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK03 DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK04 DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//*
//SYSERR   DD DSN=&SYSERR,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,PASS)
//*
//SYSDISC  DD DSN=&SYSDISC,
//            UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,DELETE)
//*
//SYSREC   DD DSN=ADU.EXAMPL18.SYSREC,DISP=SHR
//*
//SYSIN    DD DSN=ADU.EXAMPL18.SYSCNTL,DISP=SHR
*

SYSPRINT for example 18 - UNLOAD PLUS

The following figure shows the UNLOAD PLUS SYSPRINT for example 18:

                                *****  B M C   U N L O A D   P L U S   F O R   D B 2    V11R1.00 *****
                                             (C) COPYRIGHT 1991 - 2013 BMC SOFTWARE, INC.
 BMC50001I UTILITY EXECUTION STARTING   10/28/2013   13:18:16 ...
 BMC50002I UTILITY ID = 'ADUXM18A'.  DB2 SUBSYSTEM ID = 'DEHJ'.  OPTION MODULE = 'ADU$OPTS'.
 BMC50471I z/OS 2.1.0,PID=HBB7790,DFSMS FOR Z/OS=2.1.0,DB2=11.1.0
 BMC50471I REGION=0M,BELOW 16M=8840K,ABOVE 16M=1414968K,IEFUSI=NO,CPUS=3
 BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040313M,MEMLIMIT SET BY:REGION=0

 BMC50471I UNLOAD PLUS FOR DB2--V11.01.00
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I DB2 UTILITIES COMMON CODE--V11.01.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
 BMC50471I BMCSORT ENGINE--V02.04.01
 BMC50471I   MAINT: BPJ0691
 BMC50471I BMC STATS API--V11.01.00
 BMC50471I   MAINT: BPU5409  BPU5534  BPU5674
 BMC50471I EXTENDED BUFFER MANAGER--V06.01.00
 BMC50471I   MAINT: BPE0401  BPE0403  BPE0405  BPE0407  BPE0410  BPE0412  BPE0416

 BMC50471I ANALYZE=(DB2STATS,NOLIMIT)              FORCE_RPT=NO                            SMAX=16
 BMC50471I CENTURY=(1950,2049)                     FORCE=NONE                              SMCORE=(0K,0K)
 BMC50471I CHANGE_CONSISTENT=NO                    HISTORY=YES                             SORTNUM=32
 BMC50471I CHANGE_QUIESCE=NO                       IBUFFS=25                               SQLDELAY=3
 BMC50471I CMAX=16                                 INLINE=NO                               SQLRETRY=100
 BMC50471I CMRATIO=50                              LOADDECP=NO                             TAPEDISP=DELETE
 BMC50471I CONSTRULES=BMC                          LOCKROW=YES                             TASKMAX=200%
 BMC50471I CURRENTDEGREE=NONE                      MAXP=5                                  UBUFFS=25
 BMC50471I DELFILES=YES                            MSGLEVEL=1                              UNLDMAX=200%
 BMC50471I DRNDELAY=1                              NULLCHAR=X'6F'                          UNLOADDN_ACTIVE=(YES,NO)
 BMC50471I DRNRETRY=255                            NULLTYPE=T1                             UNLOADDN=(SYSREC,SYSRED)
 BMC50471I DRNWAIT=NONE                            OPNDB2ID=YES                            USELRECL=NO
 BMC50471I DSPLOCKS=DRNFAIL                        PLAN=ADUQA                              UXSTATE=SUP
 BMC50471I EXCLDUMP=(X37,X22,X06)                  RECFM=AUTO                              WORKUNIT=SYSALLDA
 BMC50471I FILEREFDN=SYSREF                        ROWSETSZ=100                            ZIIP=ENABLED
 BMC50471I FILL=NO                                 SDUMP=YES                               ZONEDDECOVP=(C,D)
 BMC50471I FORCE_AT=(START,3)                      SHRLEVEL=REFERENCE


 BMC50471I TAPES=NONE

 BMC50470I OUTPUT   = SYSREC                             SYSRED                               SYSREF
 BMC50470I UNIT     = SYSALLDA                           SYSALLDA                             SYSALLDA
 BMC50470I VOLCNT   = 25                                 25                                   25
 BMC50470I GDGLIMIT = 5                                  5                                    5
 BMC50470I GDGEMPTY = NO                                 NO                                   NO
 BMC50470I GDGSCRAT = NO                                 NO                                   NO
 BMC50470I STORCLAS = NONE                               NONE                                 NONE
 BMC50470I DATACLAS = NONE                               NONE                                 NONE
 BMC50470I MGMTCLAS = NONE                               NONE                                 NONE
 BMC50470I UNITCNT  = 0                                  0                                    0
 BMC50470I SPACE    = CYL                                CYL                                  CYL
 BMC50470I PCTPRIM  = AUTO                               AUTO                                 AUTO
 BMC50470I MAXPRIM  = 0                                  0                                    0
 BMC50470I MAXSECD  = 0                                  0                                    0
 BMC50470I FILESZPCT  100                                100                                  100
 BMC50470I NBRSECD  = AUTO                               AUTO                                 AUTO
 BMC50470I DISKRETN = NONE                               NONE                                 NONE
 BMC50470I DISKEXPD = NONE                               NONE                                 NONE
 BMC50470I RETPD    = NONE                               NONE                                 NONE
 BMC50470I EXPDT    = 99000                              99000                                99000
 BMC50470I TRTCH    = NONE                               NONE                                 NONE
 BMC50470I DSNTYPE  = NONE                               NONE                                 PDS
 BMC50483I SYSREC     VOLUMES=NONE
 BMC50483I SYSRED     VOLUMES=NONE
 BMC50483I SYSREF     VOLUMES=NONE

 BMC50483I SYSREC     DSNAME=&USERID.&TYPE.S&SELNUM
 BMC50483I SYSRED     DSNAME=&USERID.&TYPE.S&SELNUM
 BMC50483I SYSREF     DSNAME=&USERID.BMC


 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_BMCXCOPY      ='BMCUTIL.CMN_BMCXCOPY'


 BMC50102I *
 BMC50102I  UNLOAD
 BMC50102I   TABLESPACE BMCEXDB.BMCEXBTS
 BMC50102I   UNICODE
 BMC50102I     AUTOTAG YES
 BMC50102I     CNTLCARDS 'REPLACE'
 BMC50102I     UNLOADDN SYSREC ACTIVE NO
 BMC50102I *

 BMC51654I DIRECT YES IN EFFECT

 BMC51687I ESTIMATED ROWS FOR TABLE SPACE BMCEXDB.BMCEXBTS PART 0 IS 6240 FROM HURBA
 BMC51688I ESTIMATED ROWS FOR TABLE     BMC.RET_EMPLS IS 6240 FROM TABLESPACE
 BMC51688I ESTIMATED ROWS FOR TABLE     BMC.HRLY_EMPLS IS 6240 FROM TABLESPACE
 BMC51688I ESTIMATED ROWS FOR TABLE     BMC.SAL_EMPLS IS 6240 FROM TABLESPACE

 BMC51657I GENERATED SELECT STATEMENTS:
 BMC51658I SELECT     1 OBID     8 TABLE 'BMC.RET_EMPLS'
 BMC51658I SELECT     2 OBID     9 TABLE 'BMC.HRLY_EMPLS'
 BMC51658I SELECT     3 OBID    10 TABLE 'BMC.SAL_EMPLS'

 BMC51689I ESTIMATED ROWS FOR SELECT 1 IS 6240
 BMC51689I ESTIMATED ROWS FOR SELECT 2 IS 6240
 BMC51689I ESTIMATED ROWS FOR SELECT 3 IS 6240

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

 BMC51639I FOR DDNAME 'SYSREC' DSN=ADU.EXAMPL18.SYSREC,DCB=(RECFM=VB,BLKSIZE=27993,LRECL=145)

 BMC50894I PAGE EXTERNALIZATION PROCESS STARTING AT  10/28/2013  13:18:16

 BMC50650I ESTABLISHING A POINT OF CONSISTENCY FOR:
 BMC50651I SPACE BMCEXDB.BMCEXBTS PART(0) PSID(0007)

 BMC50895I PAGE EXTERNALIZATION PROCESS COMPLETE.  ELAPSED TIME =  00:00:00

 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8484K, ABOVE 16M = 1407664K, CPUS = 3
 BMC51701I MAX TASKS = 1, MAX PARTITIONS PER TASK = 1, SORTWKS PER TASK = 0, MAX OPEN PARTITIONS PER TASK = 1
 BMC50477I 1: PARTITION =    0, ROWS/KEYS = 40, I/O WAITS = 2 ,DDNAME = SYS00008
 BMC50478I 1: RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51686I UNLOADING OF DATASET 'DEHJCAT.DSNDBD.BMCEXDB.BMCEXBTS.I0001.A001' READ 5 PAGES
 BMC51670I UNLOAD STATISTICS:  20 ROWS PROCESSED FROM TABLE 'BMC.RET_EMPLS', 0 NOT SELECTED, 0 DISCARDED
 BMC51670I UNLOAD STATISTICS:  11 ROWS PROCESSED FROM TABLE 'BMC.HRLY_EMPLS', 0 NOT SELECTED, 0 DISCARDED
 BMC51670I UNLOAD STATISTICS:  9 ROWS PROCESSED FROM TABLE 'BMC.SAL_EMPLS', 0 NOT SELECTED, 0 DISCARDED
 BMC51672I UNLOAD STATISTICS:  40 ROWS PROCESSED FROM SPACE 'BMCEXDB.BMCEXBTS', 0 NOT SELECTED, 0 DISCARDED
 BMC51674I UNLOAD STATISTICS:  40 RECORDS WRITTEN TO DDNAME 'SYSREC'
 BMC51675I UNLOAD STATISTICS:  0 RECORDS DISCARDED DUE TO ERRORS
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I UNLOAD PHASE COMPLETE.  ELAPSED TIME = 00:00:00


 BMC51639I FOR DDNAME 'SYSCNTL' DSN=ADU.EXAMPL18.SYSCNTL,DCB=(RECFM=FB,BLKSIZE=3120,LRECL=80)
 BMC51801I LOAD TABLE STATEMENTS WRITTEN TO DDNAME 'SYSCNTL'

 BMC51810I LOAD DATA INDDN SYSREC
 BMC51809I REPLACE
 BMC51940I      UNICODE CCSID(367,1208,1200)
 BMC51811I   INTO TABLE
 BMC51809I BMC.RET_EMPLS
 BMC51941I      WHEN (1:4) = X'30303031'
 BMC51813I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
 BMC51813I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
 BMC51815I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR  MIXED(3)
 BMC51813I ,EMPL_SALARY_HRLY POSITION(*:*+4) DECIMAL
 BMC51814I       NULLIF BMC_NULL1=X'3F'
 BMC51819I     ,     BMC_NULL1 POSITION(*) CHAR(1)
 BMC51815I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR  MIXED(12)
 BMC51815I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE  EXTERNAL(10)
 BMC51814I       NULLIF BMC_NULL2=X'3F'
 BMC51819I     ,     BMC_NULL2 POSITION(*) CHAR(1)
 BMC51815I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP  EXTERNAL(26)
 BMC51809I )
 BMC51811I   INTO TABLE
 BMC51809I BMC.HRLY_EMPLS
 BMC51941I      WHEN (1:4) = X'30303032'
 BMC51813I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
 BMC51813I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
 BMC51815I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR  MIXED(3)
 BMC51813I ,EMPL_HRLY_RATE POSITION(*:*+4) DECIMAL
 BMC51814I       NULLIF BMC_NULL1=X'3F'
 BMC51819I     ,     BMC_NULL1 POSITION(*) CHAR(1)
 BMC51815I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR  MIXED(12)
 BMC51815I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE  EXTERNAL(10)
 BMC51814I       NULLIF BMC_NULL2=X'3F'
 BMC51819I     ,     BMC_NULL2 POSITION(*) CHAR(1)
 BMC51815I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP  EXTERNAL(26)
 BMC51809I )
 BMC51811I   INTO TABLE
 BMC51809I BMC.SAL_EMPLS
 BMC51941I      WHEN (1:4) = X'30303033'
 BMC51813I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
 BMC51813I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
 BMC51815I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR  MIXED(3)
 BMC51813I ,EMPL_SALARY POSITION(*:*+4) DECIMAL
 BMC51814I       NULLIF BMC_NULL1=X'3F'
 BMC51819I     ,     BMC_NULL1 POSITION(*) CHAR(1)
 BMC51815I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR  MIXED(12)
 BMC51815I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE  EXTERNAL(10)
 BMC51814I       NULLIF BMC_NULL2=X'3F'
 BMC51819I     ,     BMC_NULL2 POSITION(*) CHAR(1)
 BMC51815I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP  EXTERNAL(26)
 BMC51809I )

 BMC50476I DDNAME = SYSCNTL, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0

SYSPRINT for example 18 - LOADPLUS

The following figure shows the LOADPLUS SYSPRINT for example 18:

                                   *****  B M C   L O A D P L U S   F O R   D B 2    V11R1.00 *****
                                             (C) COPYRIGHT 1990 - 2013 BMC SOFTWARE, INC.
                                   LOADPLUS TECHNOLOGY IS PROTECTED BY U.S. PATENT NUMBER 7,664,790
 BMC50001I UTILITY EXECUTION STARTING   10/28/2013   14:17:09 ...
 BMC50002I UTILITY ID = 'ADUXM18B'.  DB2 SUBSYSTEM ID = 'DEHJ'.  OPTION MODULE = 'AMU$OPTS'.
 BMC50471I z/OS 2.1.0,PID=HBB7790,DFSMS FOR Z/OS=2.1.0,DB2=11.1.0
 BMC50471I REGION=0M,BELOW 16M=8816K,ABOVE 16M=1414436K,IEFUSI=NO,CPUS=3
 BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040313M,MEMLIMIT SET BY:REGION=0

 BMC50471I LOADPLUS FOR DB2--V11.01.00
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I DB2 UTILITIES COMMON CODE--V11.01.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
 BMC50471I BMCSORT ENGINE--V02.04.01
 BMC50471I   MAINT: BPJ0691
 BMC50471I BMC STATS API--V11.01.00
 BMC50471I   MAINT: BPU5409  BPU5534  BPU5674
 BMC50471I EXTENDED BUFFER MANAGER--V06.01.00
 BMC50471I   MAINT: BPE0401  BPE0403  BPE0405  BPE0407  BPE0410  BPE0412  BPE0416
 BMC50471I HIGH-SPEED APPLY ENGINE--V11.01.00
 BMC50471I   MAINT: BPU5598  BPU5948  BPU6072  BPU6264

 BMC50471I APCOMMIT=2500                           HASHAX=YES                              RULES=BMC
 BMC50471I APDOPTS=                                IBUFFS=20                               SDUMP=YES
 BMC50471I APMULTIROW=100                          IDCACHE=1000                            SHORTMEMORY=CONTINUE
 BMC50471I APMXAGNT=10                             IDCDDN=SYSIDCIN                         SHRLEVEL=(NONE,NONE)
 BMC50471I APRETLIM=COUNT                          IDERROR=DISCARD                         SMAX=16
 BMC50471I APRETVAL=5                              INDDN=SYSREC                            SMCORE=(0K,0K)
 BMC50471I AUTOENUMROWS=YES                        INFORI=NO                               SORTDEVT=(,SYSALLDA)
 BMC50471I AVAILPAGEPCT=0                          INLINECP=YES                            SORTNUM=32
 BMC50471I CBUFFS=30                               IXONEX=NO                               SQLDELAY=3
 BMC50471I CENTURY=(1950,2049)                     IXRANDOM=NO                             SQLRETRY=100
 BMC50471I CHEKPEND=YES                            KEEPDICTIONARY=NO                       STOP@CMT=YES
 BMC50471I COPYDDN=(BMCCPY,BMCCPZ)                 LBUFFS=20                               STOPDELAY=1
 BMC50471I COPYLVL=FULL                            LOADDN=SORTOUT                          STOPRETRY=300
 BMC50471I COPYPEND=YES                            LOB=YES                                 TAPEDISP=DELETE
 BMC50471I COPYSUBSET=NO                           LOBAVGPCT=50                            TEMPRALDATA=YES
 BMC50471I DELFILES=(YES,NO)                       LOCKROW=YES                             TOTALPAGEPCT=30
 BMC50471I DISCARDLIMRC=8                          LONGNAMETRUNC=MIDDLE                    TSSAMPLEPCT=100
 BMC50471I DISCARDRC=0                             MAPDDN=SYSMAP                           UNICODE=YES
 BMC50471I DISCDDN=SYSDISC                         MAXP=5                                  UPDMAXA_AUTHID=USER
 BMC50471I DRNDELAY=1                              MAXSORTMEMORY=0                         UPDMAXA=NO
 BMC50471I DRNRETRY=255                            MAXTAPE=3                               UTILB_COLCCSID=UTILB
 BMC50471I DRNWAIT=NONE                            MGEXTENT=CONTINUE                       UTILB_NULLIX=UTILB
 BMC50471I DSNUEXIT=(NONE,ASM)                     MINSORTMEMORY=0                         UXSTATE=SUP
 BMC50471I DSNUTILB=YES                            MSGLEVEL=1                              WBUFFS=(20,10)
 BMC50471I ENFORCE=CHECK                           OPNDB2ID=YES                            WORKDDN=SYSUT1
 BMC50471I ERRDDN=SYSERR                           ORIGDISP=DELETE                         WORKUNIT=SYSALLDA
 BMC50471I EXCLDUMP=(X37,X22,X06)                  PAUSEDISCARDRC=4                        XBLKS=3
 BMC50471I FASTSWITCH=NO                           PLAN=AMUQA                              XML=YES
 BMC50471I FILECHK=WARN                            PREFORMAT=NO                            XMLAVGSIZE=10240
 BMC50471I FILEVAR=YES                             PRELOAD=LOAD                            ZEROROWRC=0
 BMC50471I FORCE_AT=(START,3)                      RCVYDDN=(BMCRCY,BMCRCZ)                 ZIIP=ENABLED
 BMC50471I FORCE_RPT=NO                            REDEFINE=YES
 BMC50471I FORCE=NONE                              RENMMAX=30

 BMC50471I APCOLLECTION=
 BMC50471I APOWNER=

 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

 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

 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

 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

 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

 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

 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

 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

 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

 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


 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'


 BMC50102I LOAD DATA INDDN SYSREC
 BMC50102I REPLACE
 BMC50102I      UNICODE CCSID(367,1208,1200)
 BMC50102I   INTO TABLE
 BMC50102I BMC.RET_EMPLS
 BMC50102I      WHEN (1:4) = X'30303031'
 BMC50102I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
 BMC50102I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
 BMC50102I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR  MIXED(3)
 BMC50102I ,EMPL_SALARY_HRLY POSITION(*:*+4) DECIMAL
 BMC50102I       NULLIF BMC_NULL1=X'3F'
 BMC50102I     ,     BMC_NULL1 POSITION(*) CHAR(1)
 BMC50102I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR  MIXED(12)
 BMC50102I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE  EXTERNAL(10)
 BMC50102I       NULLIF BMC_NULL2=X'3F'
 BMC50102I     ,     BMC_NULL2 POSITION(*) CHAR(1)
 BMC50102I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP  EXTERNAL(26)
 BMC50102I )
 BMC50102I   INTO TABLE
 BMC50102I BMC.HRLY_EMPLS
 BMC50102I      WHEN (1:4) = X'30303032'
 BMC50102I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
 BMC50102I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
 BMC50102I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR  MIXED(3)
 BMC50102I ,EMPL_HRLY_RATE POSITION(*:*+4) DECIMAL
 BMC50102I       NULLIF BMC_NULL1=X'3F'
 BMC50102I     ,     BMC_NULL1 POSITION(*) CHAR(1)
 BMC50102I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR  MIXED(12)
 BMC50102I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE  EXTERNAL(10)
 BMC50102I       NULLIF BMC_NULL2=X'3F'
 BMC50102I     ,     BMC_NULL2 POSITION(*) CHAR(1)
 BMC50102I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP  EXTERNAL(26)
 BMC50102I )
 BMC50102I   INTO TABLE
 BMC50102I BMC.SAL_EMPLS
 BMC50102I      WHEN (1:4) = X'30303033'
 BMC50102I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
 BMC50102I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
 BMC50102I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR  MIXED(3)
 BMC50102I ,EMPL_SALARY POSITION(*:*+4) DECIMAL
 BMC50102I       NULLIF BMC_NULL1=X'3F'
 BMC50102I     ,     BMC_NULL1 POSITION(*) CHAR(1)
 BMC50102I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR  MIXED(12)
 BMC50102I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE  EXTERNAL(10)
 BMC50102I       NULLIF BMC_NULL2=X'3F'
 BMC50102I     ,     BMC_NULL2 POSITION(*) CHAR(1)
 BMC50102I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP  EXTERNAL(26)
 BMC50102I )

 BMC51424I ANALYZE PHASE WILL BE PERFORMED DUE TO DYNAMIC WORK FILE ALLOCATION
 BMC51403I FOR FIELD 'EMPL_FNAME', END POSITION IGNORED
 BMC51403I FOR FIELD 'EMPL_FNAME', END POSITION IGNORED
 BMC51403I FOR FIELD 'EMPL_FNAME', END POSITION IGNORED
 BMC51561I CALCULATED NUMBER OF INPUT RECORDS = 378 USING A SCALING FACTOR OF 100%
 BMC50004I UTILINIT PHASE COMPLETE.  ELAPSED TIME = 00:00:00

 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I ANALYZE PHASE COMPLETE.  ELAPSED TIME = 00:00:00

 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50425I &JOBNAME  = ADUEX18B  &STEPNAME = LODPLUS1  &DB       = BMCEXDB   &TS       = BMCEXBTS  &UID      = RDAMZL3
 BMC50425I &RESUME   = N         &REPLACE  = Y         &DATE     = 102813    &TIME     = 141709    &SSID     = DEHJ
 BMC50425I &UTIL     = ADUXM18B  &UTILPFX  = ADUXM18B  &UTILSFX  =           &DATE8    = 10282013  &GRPNM    = DEHJ
 BMC50425I &VCAT     = DEHJCAT   &TIME4    = 1417      &DATEJ    = 2013301   &JDATE    = 13301

 BMC50445I LOAD PLUS DYNAMIC FILE ALLOCATION REPORT
 BMC50466W TEMPORARY DATASET NOT RECOMMENDED FOR DDNAME = 'SYSERR'
 BMC50466W TEMPORARY DATASET NOT RECOMMENDED FOR DDNAME = 'SYSDISC'
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8432K, ABOVE 16M = 1407456K, CPUS = 3
 BMC50479I TOTAL PAGES: 3077826, ALLOWED: 923348; AVAILABLE PAGES: 180530, ALLOWED: 0
 BMC51499I COMBINED OPTIMIZATION, RC=0, #SORTS=1, #READERS=1, #INDEX TASKS=1, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=85760
 BMC51500I COMBINED ANALYZE, #SORTS=1, #READERS=1, #INDEX TASKS=1, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0
 BMC50486I 3: BMCSORT STARTED, 424K BELOW 16M, 1448K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC51453I EXISTING ROWS IN TABLESPACE 'BMCEXDB.BMCEXBTS' DELETED
 BMC50486I 2: BMCSORT STARTED, 344K BELOW 16M, 1368K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50481I 1: READ TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 1: READ TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51478I PRELOAD STATISTICS:  40 PHYSICAL (40 LOGICAL) RECORDS READ FROM SYSREC
 BMC50481I 2: SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50482I 2: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.BMCEXDB.BMCEXBTS.I0001.A001'
 BMC50477I 2: PARTITION =    0, ROWS/KEYS = 40, I/O WAITS = 5 ,DDNAME = SYS00010
 BMC50481I 2: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 2: SORT TASK, XBLK XFERS = 2, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50481I 3: INDEX SORT COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50482I 3: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.BMCEXDB.RETIX1.I0001.A001'
 BMC50477I 3: PARTITION =    0, ROWS/KEYS = 20, I/O WAITS = 7 ,DDNAME = SYS00014
 BMC50482I 3: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.BMCEXDB.HRLYIX1.I0001.A001'
 BMC50477I 3: PARTITION =    0, ROWS/KEYS = 11, I/O WAITS = 7 ,DDNAME = SYS00018
 BMC50482I 3: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEHJCAT.DSNDBD.BMCEXDB.SALIX1.I0001.A001'
 BMC50477I 3: PARTITION =    0, ROWS/KEYS = 9, I/O WAITS = 7 ,DDNAME = SYS00022
 BMC51476I BUILD STATISTICS:  20 KEYS LOADED INTO INDEX 'BMC.RETIX1'
 BMC51476I BUILD STATISTICS:  11 KEYS LOADED INTO INDEX 'BMC.HRLYIX1'
 BMC51476I BUILD STATISTICS:  9 KEYS LOADED INTO INDEX 'BMC.SALIX1'
 BMC50481I 3: INDEX TASK COMPLETE.  ELAPSED TIME = 00:00:02
 BMC51510I 3: INDEX TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 2
 BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51507I XBLKS = 8, XFERS = 2, EMPTY WAITS = 0, FULL WAITS =2
 BMC50476I DDNAME = SYSDISC, I/OS = 0, I/O WAITS = 0, RDB LOCK WAITS = 0
 BMC51472I COMBINED PHASE STATISTICS:  40 ROWS SELECTED FOR SPACE 'BMCEXDB.BMCEXBTS', 0 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
 BMC51479I COMBINED PHASE STATISTICS:  0 PHYSICAL (0 LOGICAL) RECORDS DISCARDED TO SYSDISC
 BMC51473I LOAD STATISTICS:  20 ROWS LOADED INTO TABLE 'BMC.RET_EMPLS'
 BMC51473I LOAD STATISTICS:  11 ROWS LOADED INTO TABLE 'BMC.HRLY_EMPLS'
 BMC51473I LOAD STATISTICS:  9 ROWS LOADED INTO TABLE 'BMC.SAL_EMPLS'
 BMC51475I LOAD STATISTICS:  40 ROWS LOADED INTO TABLE SPACE 'BMCEXDB.BMCEXBTS'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK01', DSNAME = 'SYS13301.T141708.RA000.ADUEX18B.R0322579'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK02', DSNAME = 'SYS13301.T141708.RA000.ADUEX18B.R0322580'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK03', DSNAME = 'SYS13301.T141708.RA000.ADUEX18B.R0322581'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK04', DSNAME = 'SYS13301.T141708.RA000.ADUEX18B.R0322582'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I COMBINED PHASE COMPLETE.  ELAPSED TIME = 00:00:03

 BMC50501I DB2 OBJECT STATISTICS
 BMC50515I TABLESPACE  BMCEXDB.BMCEXBTS  PARTS   = 0         TABLES  = 3     SEGSIZE = 32    DSSIZE =    0G    PAGESIZE = 4K
 BMC50516I             PART  NACTIVE       CARD   EXTENTS   DBCARD PCOMP   KSAVED  PSAVED
 BMC50517I                0       66         40         1        0     0        0       0
 BMC50518I   TABLE     BMC.RET_EMPLS
 BMC50519I             ROWAVG    NPAGES       CARD   PCTPAGES
 BMC50520I                 43         1         20          3
 BMC50525I     INDEX   BMC.RETIX1
 BMC50526I             FIRST KEY COLUMN = EMPL_LNAME
 BMC50527I             CLUSTER = N   UNIQUE = D   COMPRESS = N   PAGESIZE = 4K   KEYLEN =   29   COLCOUNT = 2
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0         5         20         1        2
 BMC50518I   TABLE     BMC.HRLY_EMPLS
 BMC50519I             ROWAVG    NPAGES       CARD   PCTPAGES
 BMC50520I                 43         1         11          3
 BMC50525I     INDEX   BMC.HRLYIX1
 BMC50526I             FIRST KEY COLUMN = EMPL_LNAME
 BMC50527I             CLUSTER = N   UNIQUE = D   COMPRESS = N   PAGESIZE = 4K   KEYLEN =   29   COLCOUNT = 2
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0         5         11         1        2
 BMC50518I   TABLE     BMC.SAL_EMPLS
 BMC50519I             ROWAVG    NPAGES       CARD   PCTPAGES
 BMC50520I                 42         1          9          3
 BMC50525I     INDEX   BMC.SALIX1
 BMC50526I             FIRST KEY COLUMN = EMPL_LNAME
 BMC50527I             CLUSTER = N   UNIQUE = D   COMPRESS = N   PAGESIZE = 4K   KEYLEN =   29   COLCOUNT = 2
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0         5          9         1        2
 BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR LOAD UTILITY SUCCESSFUL FOR ALL OBJECTS
 BMC50386W IMAGE COPY REQUIRED.  TABLE SPACE BMCEXDB.BMCEXBTS REMAINS IN 'COPY PENDING' STATE
 BMC50004I UTILTERM PHASE COMPLETE.  ELAPSED TIME = 00:00:00

 BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 4

Related topic

Examples-of-UNLOAD-PLUS-jobs

 

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