Example 19 — Unloading data to LOADPLUS

In this example, UNLOAD PLUS uses the FORMAT BMCLOAD option to unload data to an output file that only LOADPLUS can read.

The corresponding LOAD command includes the FORMAT BMCUNLOAD option to load this data. The combination of these FORMAT options provides a high-speed data migration solution.

Related topic

Examples-of-UNLOAD-PLUS-jobs

The load job replaces a partitioned table space that has one non-unique partitioning index that is not a clustering index and one non-unique, nonpartitioning index. No clustering index exists on the table space.

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

To provide a complete picture of these features, this example includes the UNLOAD PLUS JCL and SYSPRINT, the LOADPLUS JCL and SYSPRINT, and the output showing the loaded table.

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

Command options used in JCL

Description

OUTPUT SYSREC

Specifies dynamic allocation options for the default unload data set

CNTLCARDS

Passes LOADPLUS command options to the SYSCNTL data set

The control cards that are specified with this option will generate a LOAD REPLACE run with dynamic allocation.

Because FORMAT BMCLOAD is specified, UNLOAD PLUS forces CNTLCARDS BMCLOAD, here overriding the default of DB2LOAD.

ENUMROWS

Tells UNLOAD PLUS to determine the value to include with the LOADPLUS ENUMROWS option from the number of rows that are unloaded

ORDER YES

Sorts output records in data-sorting key sequence

FORMAT BMCLOAD

Produces a high-speed unload and an output file that only LOADPLUS can use when you are moving data to tables with an identical table structure

SELECT *

Unloads all columns

INTO

Passes to LOADPLUS the name of the table into which LOADPLUS is to load the data

This table is identical in structure to the table from which UNLOAD PLUS is unloading data.

FROM

Names the table to unload

The UNLOAD PLUS SYSPRINT shows the LOADPLUS control cards that UNLOAD PLUS writes to the SYSCNTL data set.

The following table describes the key command options for loading the data using LOADPLUS:

Command options used in JCL

Description

INDSN

Names the SYSREC data set that UNLOAD PLUS created

UNLOAD PLUS builds the data set name dynamically based on the DSNAME defaults in the UNLOAD PLUS installation options.

ENUMROWS

Indicates the estimated number of rows to load

This example shows that UNLOAD PLUS calculated the number of new rows that LOADPLUS will load as 29

This number includes the header records that UNLOAD PLUS creates when using FORMAT BMCLOAD. LOADPLUS uses these header records to ensure that the table being loaded matches the table that was unloaded.

REPLACE

Tells LOADPLUS to delete the existing data before loading

DELETEFILES YES

Tells LOADPLUS to delete all corresponding SORTOUT, SORTWK, SYSUT1, and SYSERR files after the load complete successfully, regardless of the JCL disposition of these files and whether the files were used

SYSDISC YES

Tells LOADPLUS to delete the SYSDISC file if it does not contain any discarded records

FORMAT BMCUNLOAD

Specifies that the input data in the SYSREC data set is in an internal format that was generated by UNLOAD PLUS

This input data is data that was unloaded by using the UNLOAD PLUS option FORMAT BMCLOAD.

INTO TABLE

Identifies the table to load

This example contains the WHEN TABLE= obid option, which is required when using FORMAT BMCUNLOAD. The OBID is the identifier that UNLOAD PLUS generated for this table.

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 because it eliminates the need to specify options in your LOADPLUS JCL. This method maximizes data integrity because it assures that the LOADPLUS control cards match the input data. Note that the JCL does not include an SYSREC DD statement because the input data set is specified with the INDSN option.

In the LOADPLUS SYSPRINT, note message BMC50138I that indicates that ENFORCE CHECK CONSTRAINTS (which is set as the default by the ENFORCE installation option) is not allowed when you specify FORMAT BMCUNLOAD. LOADPLUS sets the ENFORCE option to NO in this case.

The following figure shows the UNLOAD PLUS and LOADPLUS JCL for example 19:

//    JOBCARD
//**********************ADUEX19B **************************************
//*********************************************************************
//*********** Unloading data as FORMAT BMCLOAD    *********************
//*********************************************************************
//*  Replace "DB2SYS" by your DB2 subsystem name.                     *
//*  Use your DB2 product install libraries for STEPLIBS :            *
//*     PRODUCT.LIBRARIES                                             *
//*     DB2.DSNEXIT                                                   *
//*     DB2.DSNLOAD                                                   *
//*********************************************************************
//*  UNLOAD USING FORMAT BMCLOAD
//*********************************************************************
//UNLOAD19 EXEC PGM=ADUUMAIN,COND=EVEN,
//             PARM='DB2SYS,ADUEX19,NEW,,MSGLEVEL(1)'
//STEPLIB  DD DISP=SHR,DSN=PRODUCT.LIBRARIES
//         DD DSN=DB2.DSNEXIT,DISP=SHR
//         DD DSN=DB2.DSNLOAD,DISP=SHR
//SYSPRINT DD DSN=ADU.EXAMPL19.SYSPRNTU,
//            DISP=(NEW,CATLG),SPACE=(CYL,(9,6)),
//            UNIT=SYSDA
//UTPRINT  DD SYSOUT=*
//SYSCNTL  DD DSN=ADU.EXAMPL19.SYSCNTL,
//            DISP=(NEW,CATLG),SPACE=(CYL,(5,2)),
//            UNIT=SYSDA
//SYSIN    DD  *
  UNLOAD
   OUTPUT SYSREC UNIT SYSDA
                 SPACE (5,1)
                 DSNAME 'ADU.EXAMPL19.SYSREC'
*
    UNLOADDN SYSREC ACTIVE YES
    CNTLCARDS 'ENUMROWS' 'REPLACE'
      'DELETEFILES YES SYSDISC YES'
    ORDER YES
    FORMAT BMCLOAD
    SELECT * INTO NAME BMC.TBEXB19
      FROM BMC.RET_EMPLS
//***************************************************************
//*  LOAD USING CONTROL CARDS FROM UNLOAD
//*  SEE SYSCNTL OR SYSPRINT FOR LOAD CONTROL CARDS
//***************************************************************
//LOADEX19 EXEC PGM=AMUUMAIN,
//             PARM='DB2SYS,ADUEX19,NEW,,MSGLEVEL(1)'
//STEPLIB  DD DISP=SHR,DSN=PRODUCT.LIBRARIES
//         DD DSN=DB2.DSNEXIT,DISP=SHR
//         DD DSN=DB2.DSNLOAD,DISP=SHR
//SYSOUT   DD SYSOUT=*
//SORTOUT  DD DISP=(,DELETE,DELETE),DSN=&&SORTOUT,
//            UNIT=SYSDA,SPACE=(CYL,(1,1))
//SYSUT1   DD DISP=(,DELETE,DELETE),DSN=&&SYSUT1,
//            UNIT=SYSDA,SPACE=(CYL,(1,1))
//SYSERR   DD DISP=(,DELETE,DELETE),DSN=&&SYSERR,
//            UNIT=SYSDA,SPACE=(CYL,(1,1))
//SYSDISC  DD DISP=(,DELETE,DELETE),DSN=&&SYSDISC,
//            UNIT=SYSDA,SPACE=(CYL,(1,1))
//SYSMAP   DD DISP=(,DELETE,DELETE),DSN=&&SYSMAP,
//            UNIT=SYSDA,SPACE=(CYL,(1,1))
//SYSPRINT DD DSN=ADU.EXAMPL19.SYSPRNTL,
//            DISP=(NEW,CATLG),SPACE=(CYL,(9,6)),
//            UNIT=SYSDA
//SYSIN    DD DISP=SHR,DSN=ADU.EXAMPL19.SYSCNTL

SYSPRINT for example 19 - UNLOAD PLUS

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

1                               *****  B M C   U N L O A D   P L U S   F O R   D B 2    V13R1.00 *****
                                             (C) COPYRIGHT 1990 - 2022 BMC SOFTWARE, INC.
-BMC50001I UTILITY EXECUTION STARTING    1/25/2022    7:52:40 ...
 BMC50002I UTILITY ID = 'ADUEX19'.  DB2 SUBSYSTEM ID = 'DEMO'.  OPTION MODULE = 'ADU$OPTS'.
 BMC50471I z/OS 2.4.0,PID=HBB77C0,DFSMS FOR Z/OS=2.4.0,DB2=13.1.501
 BMC50471I REGION=0M,BELOW 16M=8.5M,ABOVE 16M=1,006.6M,IEFUSI=NO,CPUs=7,GPs=5,zIIPs=2
 BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
 BMC50471I SMFID=DB2B,JOBID=J0940231,JOB=ADUEX19,STEP=UNLOAD19,CPU=8561-615 (z15)/1.71,72.0G
0
 BMC50471I UNLOAD PLUS FOR DB2--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I DB2 UTILITIES COMMON CODE--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I SOLUTION COMMON CODE--V13.01.00 BASE
 BMC50471I   MAINT: BPJ1541  BPJ1713  BPJ2211
 BMC50471I BMCSORT ENGINE--V02.04.01
 BMC50471I   MAINT: BPJ0691  BPJ0718  BPJ0881  BPJ0922  BPJ0996  BPJ1164  BPJ1309  BPJ1386  BPJ1497  BPJ1594  BPJ1724  BPJ1809
 BMC50471I          BPJ1833  BPJ1891  BPJ1905  BPJ2109  BPJ2232  BPJ2297
 BMC50471I BMC STATS API--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I EXTENDED BUFFER MANAGER--V06.02.01
 BMC50471I   MAINT: BPE0443  BPE0445  BPE0447  BPE0449  BPE0450  BPE0451  BPE0452  BPE0455  BPE0456  BPE0457  BPE0460  BPE0463
 BMC50471I          BPE0467  BPE0468  BPE0469  BPE0473  BPE0474  BPE0475  BPE0479  BPE0480  BPE0482  BPE0487  BPE0488  BPE0489
 BMC50471I          BPE0493  BPE0497  BPE0498  BPE0501  BPE0503  BPE0507  BPE0512  BPE0513  BPE0517  BPE0518  BPE0519  BPE0523
 BMC50471I          BPE0524  BPE0527  BPE0528  BPE0530  BPE0531  BPE0534  BPE0535  BPE0540  BPE0541  BPE0542  BPE0545  BPE0549
 BMC50471I          BPE0551  BPE0552  BPE0555  BPE0557  BPE0560

0
 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                             SSREPORT=REPORT_SWITCH
 BMC50471I CONSTRULES=BMC                          LOCKROW=YES                             TAPEDISP=DELETE
 BMC50471I CURRENTDEGREE=NONE                      MAXP=5                                  TASKMAX=200%
 BMC50471I DELFILES=YES                            MSGLEVEL=1                              UBUFFS=25
 BMC50471I DRNDELAY=1                              NULLCHAR=X'6F'                          UNLDMAX=200%
 BMC50471I DRNRETRY=255                            NULLTYPE=T1                             UNLOADDN_ACTIVE=(YES,NO)
 BMC50471I DRNWAIT=NONE                            OPNDB2ID=YES                            UNLOADDN=(SYSREC,SYSRED)
 BMC50471I DSPLOCKS=DRNFAIL                        PLAN=ADU1310T                           USELRECL=NO
 BMC50471I EXCLDUMP=(X37,X22,X06)                  RECFM=AUTO                              UXSTATE=SUP
 BMC50471I FILEREFDN=SYSREF                        ROWSETSZ=100                            WORKUNIT=SYSALLDA
 BMC50471I FILL=NO                                 SDUMP=YES                               ZIIP=ENABLED
 BMC50471I FORCE_AT=(START,3)                      SHRLEVEL=REFERENCE                      ZONEDDECOVP=(C,D)
0
0
 BMC50471I TAPES=NONE
0
 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                                 LIBRARY
 BMC50483I SYSREC     VOLUMES=NONE
 BMC50483I SYSRED     VOLUMES=NONE
 BMC50483I SYSREF     VOLUMES=NONE
0
 BMC50483I SYSREC     DSNAME=&USERID.&TYPE.S&SELNUM
 BMC50483I SYSRED     DSNAME=&USERID.&TYPE.S&SELNUM
 BMC50483I SYSREF     DSNAME=&USERID.&TYPE.S&SELNUM
0

 BMC50471I DB2 DSNHDECP MODULE SETTINGS:
 BMC50471I VERSION                 = 1310
 BMC50471I SUBSYSTEM DEFAULT       = DEMO
 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 (-06:00)


 BMC50658I DB2 CURRENT FUNCTION LEVEL IS V13R1M501
 BMC50659I DB2 CATALOG LEVEL IS V13R1M501
 BMC50660I DB2 HIGHEST ACTIVATED FUNCTION LEVEL IS V13R1M501
 BMC50661I DB2 CODE LEVEL IS V13R1M501

 BMC50471I BMC_BMCUTIL       ='BMCUTIL.CMN_BMCUTIL'
 BMC50471I BMC_BMCSYNC       ='BMCUTIL.CMN_BMCSYNC'
 BMC50471I BMC_BMCHIST       ='BMCUTIL.CMN_BMCHIST'
 BMC50471I BMC_BMCXCOPY      ='BMCUTIL.CMN_BMCXCOPY'
 BMC50471I BMC_BMCSMARTSWITCH='BMCUTIL.CMN_BMCSWITCH'
 BMC50471I BMC_BMCSSTRACKING ='BMCUTIL.CMN_BMCSSTRACK'
0
0
 BMC50102I   UNLOAD
 BMC50102I    OUTPUT SYSREC UNIT SYSDA
 BMC50102I                  SPACE (5,1)
 BMC50102I                  DSNAME 'ADU.EXAMPL19.SYSREC'
 BMC50102I *
 BMC50102I     UNLOADDN SYSREC ACTIVE YES
 BMC50102I     CNTLCARDS 'ENUMROWS' 'REPLACE'
 BMC50102I       'DELETEFILES YES SYSDISC YES'
 BMC50102I     ORDER YES
 BMC50102I     FORMAT BMCLOAD
 BMC50102I     SELECT * INTO NAME BMC.TBEXB19
 BMC50102I       FROM BMC.RET_EMPLS

 BMC51654I DIRECT YES IN EFFECT

 BMC51687I ESTIMATED ROWS FOR TABLE SPACE BMCEXDB.BMCEXBTS PART 0 IS 1053 FROM HURBA
 BMC51688I ESTIMATED ROWS FOR TABLE     BMC.RET_EMPLS IS 1053 FROM TABLESPACE
 BMC51688I ESTIMATED ROWS FOR TABLE     BMC.HRLY_EMPLS IS 1053 FROM TABLESPACE
 BMC51688I ESTIMATED ROWS FOR TABLE     BMC.SAL_EMPLS IS 1053 FROM TABLESPACE
 BMC50004I UTILINIT PHASE COMPLETE.  ELAPSED TIME = 00:00:00


 BMC54000I SMARTSWITCH NOT SUPPORTED - NO BMC AMI UTILITIES VERSION FOUND
 BMC54003I SMARTSWITCH RULE: FORCE_NO_SWITCH  COMMENT: SMARTSWITCH NOT ACTIVATED, TABLE/ALIAS DOES NOT EXIST

 BMC50199I UNLOAD PLUS PROCESSING CONTINUES

 BMC51689I ESTIMATED ROWS FOR SELECT 1 IS 1053


 BMC50445I UNLOAD PLUS DYNAMIC FILE ALLOCATION REPORT

 BMC50446I                                                       UNIT OR                      KBYTES   KBYTES     ALOC      ALOC
 BMC50447I DDNAME   DSNAME                                       DATACLAS MGMTCLAS STORCLAS      PRI      SEC      PRI       SEC

 BMC50448I SYS00008 ADU.EXAMPL19.SYSREC                          SYSDA                             0        0        5         1  CYL

 BMC51639I FOR DDNAME 'SYS00008' DSN=ADU.EXAMPL19.SYSREC,DCB=(RECFM=VB,BLKSIZE=27998,LRECL=334)
 BMC50394I UNABLE TO LOCATE SORT WORK DATASETS, DDNAME = 'SORTWKNN'

 BMC50894I PAGE EXTERNALIZATION PROCESS STARTING AT   2/15/2022   3:17:22

 BMC50651I SPACE BMCEXDB.BMCEXBTS PART(0) PSID(0007)

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

 BMC50877I POINT OF CONSISTENCY ESTABLISHED AT RBA/LRSN = 00000000234575A17400

 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8488K, ABOVE 16M = 1020828K, CPUS = 5
 BMC51701I MAX TASKS = 1, MAX PARTITIONS PER TASK = 1, SORTWKS PER TASK = 32, MAX OPEN PARTITIONS PER TASK = 1
 BMC50477I 1: PARTITION =    0, ROWS/KEYS = 20, I/O WAITS = 2 ,DDNAME = SYS00009
 BMC50478I 1: RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYS00008, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51686I UNLOADING OF DATASET 'DEMOCAT.DSNDBD.BMCEXDB.BMCEXBTS.I0001.A001' READ 1706 PAGES
 BMC51670I UNLOAD STATISTICS:  20 ROWS PROCESSED FROM TABLE 'BMC.RET_EMPLS', 0 NOT SELECTED, 0 DISCARDED
 BMC51672I UNLOAD STATISTICS:  20 ROWS PROCESSED FROM SPACE 'BMCEXDB.BMCEXBTS', 0 NOT SELECTED, 0 DISCARDED
 BMC51674I UNLOAD STATISTICS:  29 RECORDS WRITTEN TO DDNAME 'SYS00008'
 BMC51679I UNLOAD STATISTICS:  20 DATA RECORDS AND 9 CONTROL RECORDS WRITTEN TO DDNAME 'SYS00008'  
 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.EXAMPL19.SYSCNTL,DCB=(RECFM=FB,BLKSIZE=3120,LRECL=80)
 BMC51801I LOAD TABLE STATEMENTS WRITTEN TO DDNAME 'SYSCNTL'
0
 BMC51936I LOAD DATA INDSN ('ADU.EXAMPL19.SYSREC'
 BMC51809I )
 BMC51800I ENUMROWS (,29)
 BMC51809I REPLACE
 BMC51809I DELETEFILES YES SYSDISC YES
 BMC51955I      FORMAT BMCUNLOAD
 BMC51811I   INTO TABLE
 BMC51809I BMC.TBEXB19
 BMC51956I        WHEN TABLE=1
0
 BMC50476I DDNAME = SYSCNTL, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0

SYSPRINT for example 19 - LOADPLUS

The following figure shows the LOADPLUS JCL for example 19:

1                          *************  B M C   L O A D P L U S   F O R   D B 2    V13R1.00 ************
                                             (C) COPYRIGHT 1990 - 2022 BMC SOFTWARE, INC.
                           LOADPLUS TECHNOLOGY IS PROTECTED BY U.S. PATENT NUMBERS 7,664,790 AND 7,930,291
-BMC50001I UTILITY EXECUTION STARTING    1/25/2022   11:18:06 ...
 BMC50002I UTILITY ID = 'ADUXM19B'.  DB2 SUBSYSTEM ID = 'DEMO'.  OPTION MODULE = 'AMU$OPTS'.
 BMC50471I z/OS 2.4.0,PID=HBB77C0,DFSMS FOR Z/OS=2.4.0,DB2=13.1.501
 BMC50471I REGION=0M,BELOW 16M=8.5M,ABOVE 16M=1,008.1M,IEFUSI=NO,CPUs=9,GPs=5,zIIPs=4
 BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
 BMC50471I SMFID=DB2B,JOBID=J0925571,JOB=ADUEX19,STEP=LOADEX19,CPU=3931-612 (z16)/1.47,76.0G
0
 BMC50471I LOADPLUS FOR DB2--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I DB2 UTILITIES COMMON CODE--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I SOLUTION COMMON CODE--V13.01.00 BASE
 BMC50471I   MAINT: BPJ1541  BPJ1713  BPJ2211
 BMC50471I BMCSORT ENGINE--V02.04.01
 BMC50471I   MAINT: BPJ0691  BPJ0718  BPJ0881  BPJ0922  BPJ0996  BPJ1164  BPJ1309  BPJ1386  BPJ1497  BPJ1594  BPJ1724  BPJ1809
 BMC50471I          BPJ1833  BPJ1891  BPJ1905  BPJ2109  BPJ2232  BPJ2297
 BMC50471I BMC STATS API--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I EXTENDED BUFFER MANAGER--V06.02.01
 BMC50471I   MAINT: BPE0443  BPE0445  BPE0447  BPE0449  BPE0450  BPE0451  BPE0452  BPE0455  BPE0456  BPE0457  BPE0460  BPE0463
 BMC50471I          BPE0467  BPE0468  BPE0469  BPE0473  BPE0474  BPE0475  BPE0479  BPE0480  BPE0482  BPE0487  BPE0488  BPE0489
 BMC50471I          BPE0493  BPE0497  BPE0498  BPE0501  BPE0503  BPE0507  BPE0512  BPE0513  BPE0517  BPE0518  BPE0519  BPE0523
 BMC50471I          BPE0524  BPE0527  BPE0528  BPE0530  BPE0531  BPE0534  BPE0535  BPE0540  BPE0541  BPE0542  BPE0545  BPE0549
 BMC50471I          BPE0551  BPE0552  BPE0555  BPE0556  BPE0557  BPE0560  BPE0561
 BMC50471I High-speed Apply Engine--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
0
 BMC50471I APCOMMIT=2500                           FORCE=NONE                              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=NO                             SORTNUM=32
 BMC50471I CBUFFS=30                               INVALIDATECACHE=YES                     SQLDELAY=3
 BMC50471I CENTURY=(1950,2049)                     KEEPDICTIONARY=NO                       SQLRETRY=100
 BMC50471I CHEKPEND=YES                            LBUFFS=20                               SSIGNRPAUSE=NO
 BMC50471I COPYDDN=(BMCCPY,BMCCPZ)                 LOADDN=SORTOUT                          SSREPORT=REPORT_SWITCH
 BMC50471I COPYLVL=FULL                            LOBAVGPCT=50                            STOP@CMT=YES
 BMC50471I COPYPEND=YES                            LOCKROW=YES                             STOPDELAY=1
 BMC50471I COPYSUBSET=NO                           LONGNAMETRUNC=MIDDLE                    STOPRETRY=300
 BMC50471I DELFILES=(YES,NO)                       MAPDDN=SYSMAP                           TAPEDISP=DELETE
 BMC50471I DISCARDLIMRC=8                          MAXP=5                                  TOTALPAGEPCT=30
 BMC50471I DISCARDRC=0                             MAXSORTMEMORY=0                         TSSAMPLEPCT=100
 BMC50471I DISCDDN=SYSDISC                         MAXTAPE=3                               UPDMAXA_AUTHID=USER
 BMC50471I DRNDELAY=1                              MGEXTENT=CONTINUE                       UPDMAXA=NO
 BMC50471I DRNRETRY=255                            MINSORTMEMORY=0                         UXSTATE=SUP
 BMC50471I DRNWAIT=NONE                            MSGLEVEL=1                              WBUFFS=(20,10)
 BMC50471I DSNUEXIT=(NONE,ASM)                     OPNDB2ID=YES                            WORKDDN=SYSUT1
 BMC50471I DSNUTILB=YES                            ORIGDISP=DELETE                         WORKUNIT=SYSALLDA
 BMC50471I ENFORCE=CHECK                           PAUSEDISCARDRC=4                        WRLOG=NO
 BMC50471I ERRDDN=SYSERR                           PLAN=AMU1310D                           XBLKS=3
 BMC50471I EXCLDUMP=(X37,X22,X06)                  PREFORMAT=NO                            XMLAVGSIZE=10240
 BMC50471I FASTSWITCH=NO                           PRELOAD=CONTINUE                        ZEROROWRC=0
 BMC50471I FILECHK=WARN                            RCVYDDN=(BMCRCY,BMCRCZ)                 ZIIP=ENABLED
 BMC50471I FORCE_AT=(START,3)                      REDEFINE=YES
 BMC50471I FORCE_RPT=NO                            RENMMAX=30
0
 BMC50471I APCOLLECTION=
 BMC50471I APOWNER=
0
 BMC50470I DDTYPE   = LOAD                               WORK                                 SORTWORK
 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)                                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   = 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 = 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   = NO                                 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.&UTILPFX.&DDNAME
 BMC50483I WORK       DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I SORTWORK   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I ERROR      DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I DISCARD    DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I SYSMAP     DSNPAT=&UID.&UTILPFX.&DDNAME
0
 BMC50483I LOCPFCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I LOCBFCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMPFCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMBFCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
0
 BMC50483I LOCPLCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I LOCBLCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMPLCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMBLCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
0
 BMC50483I LOCPXCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I LOCBXCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMPXCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
 BMC50483I REMBXCPY   DSNPAT=&UID.&UTILPFX.&DDNAME
0

 BMC50471I DB2 DSNHDECP MODULE SETTINGS:
 BMC50471I VERSION                 = 1310
 BMC50471I SUBSYSTEM DEFAULT       = DEMO
 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 INDSN ('ADU.EXAMPL19.SYSREC'
 BMC50102I )
 BMC50102I ENUMROWS (,29)
 BMC50102I REPLACE
 BMC50102I DELETEFILES YES SYSDISC YES
 BMC50102I      FORMAT BMCUNLOAD
 BMC50102I   INTO TABLE
 BMC50102I BMC.TBEXB19
 BMC50102I        WHEN TABLE=1

 BMC50138I 'ENFORCE CHECK CONSTRAINTS' CHANGED TO 'ENFORCE NO' DUE TO FORMAT BMCUNLOAD
 BMC51424I ANALYZE PHASE WILL BE PERFORMED DUE TO DYNAMIC WORK FILE ALLOCATION  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  = ADUEX19B  &STEPNAME = LOADEX19  &DB       = BMCEXDB   &TS       = TSEXB19   &UID      = RDAMZL
 BMC50425I &RESUME   = N         &REPLACE  = Y         &DATE     = 102813    &TIME     = 132131    &SSID     = DEMO
 BMC50425I &UTIL     = ADUXM19   &UTILPFX  = ADUXM19   &UTILSFX  =           &DATE8    = 10282013  &GRPNM    = DEMO
 BMC50425I &VCAT     = DEMOCAT   &TIME4    = 1321      &DATEJ    = 2013301   &JDATE    = 13301

 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 SYSDISC  RDAMZL.BMC.TSEXB19.SYSDISC                   SYSALLDA                          5        1    1         1  TRK

 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8456K, ABOVE 16M = 1405696K, CPUS = 3
 BMC50479I TOTAL PAGES: 3109622, ALLOWED: 932887; AVAILABLE PAGES: 292840, ALLOWED: 0
 BMC51499I COMBINED OPTIMIZATION, RC=0, #SORTS=4, #READERS=1, #INDEX TASKS=2, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=95744
 BMC51499I COMBINED OPTIMIZATION, RC=20, #SORTS=4, #READERS=1, #INDEX TASKS=1, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=105984
 BMC51499I COMBINED OPTIMIZATION, RC=20, #SORTS=3, #READERS=1, #INDEX TASKS=2, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=95744
 BMC51500I COMBINED ANALYZE, #SORTS=4, #READERS=1, #INDEX TASKS=2, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0
 BMC50486I 6: BMCSORT STARTED, 332K BELOW 16M, 1356K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 7: BMCSORT STARTED, 436K BELOW 16M, 1460K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC51453I EXISTING ROWS IN TABLESPACE 'BMCEXDB.TSEXB19' DELETED
 BMC50481I 1: READ TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 1: READ TASK, XBLK XFERS = 4, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51592I PRELOAD STATISTICS:  9 BMCUNLOAD VERIFICATION RECORDS READ FROM SYSREC01
 BMC51478I PRELOAD STATISTICS:  20 PHYSICAL (20 LOGICAL) RECORDS READ FROM SYSREC01
 BMC50482I 5: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.BMCEXDB.TSEXB19.I0001.A003'
 BMC50477I 5: PARTITION =    3, ROWS/KEYS = 5, I/O WAITS = 7 ,DDNAME = SYS00024
 BMC50482I 3: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.BMCEXDB.TSEXB19.I0001.A001'
 BMC50477I 3: PARTITION =    1, ROWS/KEYS = 8, I/O WAITS = 7 ,DDNAME = SYS00023
 BMC51474I LOAD STATISTICS:  5 ROWS LOADED INTO TABLE SPACE 'BMCEXDB.TSEXB19' PARTITION 3
 BMC50481I 5: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51474I LOAD STATISTICS:  8 ROWS LOADED INTO TABLE SPACE 'BMCEXDB.TSEXB19' PARTITION 1
 BMC50481I 3: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC50482I 2: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.BMCEXDB.TSEXB19.I0001.A004'
 BMC50477I 2: PARTITION =    4, ROWS/KEYS = 2, I/O WAITS = 7 ,DDNAME = SYS00022
 BMC51510I 5: SORT TASK, XBLK XFERS = 3, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51474I LOAD STATISTICS:  2 ROWS LOADED INTO TABLE SPACE 'BMCEXDB.TSEXB19' PARTITION 4
 BMC51510I 3: SORT TASK, XBLK XFERS = 3, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50481I 2: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 2: SORT TASK, XBLK XFERS = 3, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50482I 4: LOAD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.BMCEXDB.TSEXB19.I0001.A002'
 BMC50477I 4: PARTITION =    2, ROWS/KEYS = 5, I/O WAITS = 7 ,DDNAME = SYS00025
 BMC51474I LOAD STATISTICS:  5 ROWS LOADED INTO TABLE SPACE 'BMCEXDB.TSEXB19' PARTITION 2
 BMC50481I 4: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:00
 BMC51510I 4: SORT TASK, XBLK XFERS = 3, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50481I 6: INDEX SORT COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50481I 7: INDEX SORT COMPLETE.  ELAPSED TIME = 00:00:01
 BMC50482I 6: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.BMCEXDB.IXEXB19.I0001.A001'
 BMC50477I 6: PARTITION =    1, ROWS/KEYS = 8, I/O WAITS = 7 ,DDNAME = SYS00030
 BMC51474I BUILD STATISTICS:  8 KEYS LOADED INTO INDEX 'BMC.IXEXB19' PARTITION 1
 BMC50482I 7: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.BMCEXDB.IXEXB19A.I0001.A001'
 BMC50477I 7: PARTITION =    0, ROWS/KEYS = 20, I/O WAITS = 7 ,DDNAME = SYS00031
 BMC51476I BUILD STATISTICS:  20 KEYS LOADED INTO INDEX 'BMC.IXEXB19A'
 BMC50481I 7: INDEX TASK COMPLETE.  ELAPSED TIME = 00:00:01
 BMC51510I 7: INDEX TASK, XBLK XFERS = 4, EMPTY WAITS = 0, FULL WAITS = 4
 BMC50482I 6: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.BMCEXDB.IXEXB19.I0001.A002'
 BMC50477I 6: PARTITION =    2, ROWS/KEYS = 5, I/O WAITS = 7 ,DDNAME = SYS00035
 BMC51474I BUILD STATISTICS:  5 KEYS LOADED INTO INDEX 'BMC.IXEXB19' PARTITION 2
 BMC50482I 6: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.BMCEXDB.IXEXB19.I0001.A003'
 BMC50477I 6: PARTITION =    3, ROWS/KEYS = 5, I/O WAITS = 7 ,DDNAME = SYS00038
 BMC51474I BUILD STATISTICS:  5 KEYS LOADED INTO INDEX 'BMC.IXEXB19' PARTITION 3
 BMC50482I 6: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEMOCAT.DSNDBD.BMCEXDB.IXEXB19.I0001.A004'
 BMC50477I 6: PARTITION =    4, ROWS/KEYS = 2, I/O WAITS = 7 ,DDNAME = SYS00041
 BMC51474I BUILD STATISTICS:  2 KEYS LOADED INTO INDEX 'BMC.IXEXB19' PARTITION 4
 BMC51476I BUILD STATISTICS:  20 KEYS LOADED INTO INDEX 'BMC.IXEXB19'
 BMC50481I 6: INDEX TASK COMPLETE.  ELAPSED TIME = 00:00:02
 BMC51510I 6: INDEX TASK, XBLK XFERS = 4, EMPTY WAITS = 0, FULL WAITS = 4
 BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 1
 BMC50476I DDNAME = SYSREC01, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51507I XBLKS = 30, XFERS = 12, EMPTY WAITS = 0, FULL WAITS =8
 BMC50476I DDNAME = SYSDISC, I/OS = 0, I/O WAITS = 0, RDB LOCK WAITS = 0
 BMC51472I COMBINED PHASE STATISTICS:  20 ROWS SELECTED FOR SPACE 'BMCEXDB.TSEXB19', 0 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
 BMC51479I COMBINED PHASE STATISTICS:  0 PHYSICAL (0 LOGICAL) RECORDS DISCARDED TO SYSDISC
 BMC51474I LOAD STATISTICS:  8 ROWS LOADED INTO TABLE SPACE 'BMCEXDB.TSEXB19' PARTITION 1
 BMC51474I LOAD STATISTICS:  5 ROWS LOADED INTO TABLE SPACE 'BMCEXDB.TSEXB19' PARTITION 2
 BMC51474I LOAD STATISTICS:  5 ROWS LOADED INTO TABLE SPACE 'BMCEXDB.TSEXB19' PARTITION 3
 BMC51474I LOAD STATISTICS:  2 ROWS LOADED INTO TABLE SPACE 'BMCEXDB.TSEXB19' PARTITION 4
 BMC51475I LOAD STATISTICS:  20 ROWS LOADED INTO TABLE SPACE 'BMCEXDB.TSEXB19'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR  ', DSNAME = 'ADU.EXAMPL19.SYSERR'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSDISC ', DSNAME = 'RDAMZL.BMC.TSEXB19.SYSDISC'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I COMBINED PHASE COMPLETE.  ELAPSED TIME = 00:00:04  
 BMC50501I DB2 OBJECT STATISTICS
 BMC50515I TABLESPACE  BMCEXDB.TSEXB19  PARTS   = 4         TABLES  = 1     SEGSIZE = 32    DSSIZE =    4G   PAGESIZE = 4K
 BMC50516I             PART  NACTIVE       CARD   EXTENTS   DBCARD PCOMP   KSAVED  PSAVED
 BMC50517I                1        2          8         1        0     0        0       0
 BMC50517I                2        2          5         1        0     0        0       0
 BMC50517I                3        2          5         1        0     0        0       0
 BMC50517I                4        2          2         1        0     0        0       0
 BMC50518I   TABLE     BMC.TBEXB19
 BMC50519I             ROWAVG    NPAGES       CARD   PCTPAGES
 BMC50520I                 43         8         20        100
 BMC50525I     INDEX   BMC.IXEXB19
 BMC50526I             FIRST KEY COLUMN = EMPL_DEPT_NO
 BMC50527I             CLUSTER = N   UNIQUE = D   COMPRESS = N   PAGESIZE = 4K   KEYLEN =    4   COLCOUNT = 1
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                1         5          8         1        2
 BMC50529I                2         5          5         1        2
 BMC50529I                3         5          5         1        2
 BMC50529I                4         5          2         1        2
 BMC50525I     INDEX   BMC.IXEXB19A
 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
 BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR LOAD UTILITY SUCCESSFUL FOR ALL OBJECTS
 BMC50387W IMAGE COPY REQUIRED.  TABLE SPACE BMCEXDB.TSEXB19 STATE SET TO 'COPY PENDING'  BMC50004I UTILTERM PHASE COMPLETE.  ELAPSED TIME = 00:00:00  
 BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 4

SELECT output from example 19

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

1
1PAGE    1
 ***INPUT STATEMENT:
   SELECT * FROM BMC.TBEXB19;
                  +-----------------------------------------------------------------------------------------------------
                  |   EMPL_LNAME    | EMPL_FNAME | EMPL_SALARY_CODE | EMPL_SALARY_HRLY | EMPL_DEPT_NO | EMPL_HIRE_DATE |
                  +-----------------------------------------------------------------------------------------------------
                1_| Johnson         | Raymond    | H                |        9.00      | 1100         | 01/16/1993     |
                2_| Broderick       | Samuel     | S                |    44000.00      | 1300         | 08/23/1992     |
                3_| Baker           | Kathy      | H                |        4.75      | 1300         | ?              |
                4_| Adkinson        | William    | H                | ?                | 2100         | 04/02/1990     |
                5_| Jackson         | William    | S                |    76000.00      | 2400         | 09/14/1992     |
                6_| Jackson         | David      | S                |    92000.00      | 2500         | 07/02/1991     |
                7_| Billingsly      | Randy      | H                |        8.10      | 2500         | 06/17/1988     |
                8_| Brown           | Ellen      | S                |    24000.00      | 2700         | 11/02/1991     |
                9_| Bronson         | Parker     | H                |        6.25      | 3200         | 03/05/1990     |
               10_| Doe             | John       | S                |    32000.00      | 3300         | ?              |
               11_| Welch           | John       | S                |    44500.00      | 3600         | 08/26/1993     |
               12_| Britain         | Michelle   | H                | ?                | 4200         | 12/24/1994     |
               13_| Franklin        | Erica      | S                |    32000.00      | 4300         | 04/18/1990     |
               14_| Williamson      | Floyd      | H                |        5.75      | 5100         | 04/03/1992     |
               15_| George          | Hugh       | H                |        7.50      | 5100         | 05/19/1989     |
               16_| Slaughter       | Johnathon  | H                |        6.25      | 5200         | ?              |
               17_| Johnson         | Robert     | H                | ?                | 6300         | 07/31/1991     |
               18_| Peterson        | Barbara    | H                |        6.90      | 6700         | 12/19/1989     |
               19_| Kennedy         | Jennifer   | S                |    36000.00      | 8200         | 03/31/1993     |
               20_| Wilson          | Lindsay    | S                |    45000.00      | 8200         | 04/25/1992     |
                  +-----------------------------------------------------------------------------------------------------
1PAGE    2
                                                      -----------------------------+
                                                      |      EMPL_REC_CREATED      |
                                                      -----------------------------+
                                                    1_| 2022-02-14-08.17.54.120497 |
                                                    2_| 2022-02-14-08.17.54.120531 |
                                                    3_| 2022-02-14-08.17.54.120534 |
                                                    4_| 2022-02-14-08.17.54.120535 |
                                                    5_| 2022-02-14-08.17.54.120535 |
                                                    6_| 2022-02-14-08.17.54.120536 |
                                                    7_| 2022-02-14-08.17.54.120537 |
                                                    8_| 2022-02-14-08.17.54.120537 |
                                                    9_| 2022-02-14-08.17.54.120538 |
                                                   10_| 2022-02-14-08.17.54.120539 |
                                                   11_| 2022-02-14-08.17.54.120539 |
                                                   12_| 2022-02-14-08.17.54.120540 |
                                                   13_| 2022-02-14-08.17.54.120540 |
                                                   14_| 2022-02-14-08.17.54.120541 |
                                                   15_| 2022-02-14-08.17.54.120542 |
                                                   16_| 2022-02-14-08.17.54.120542 |
                                                   17_| 2022-02-14-08.17.54.120543 |
                                                   18_| 2022-02-14-08.17.54.120543 |
                                                   19_| 2022-02-14-08.17.54.120544 |
                                                   20_| 2022-02-14-08.17.54.120545 |
                                                      -----------------------------+
0SUCCESSFUL RETRIEVAL OF         20 ROW(S)

 

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