Example 11 — LOAD REPLACE with dynamic allocation
This example illustrates the use of dynamic allocation during a LOAD REPLACE of a table space with ten partitions, a unique clustering index, and a non-unique nonpartitioned index.
This example loads seven of ten partitions. Individual INTO PART command options are not specified because processing multiple INTO PART command options is less efficient and offers no benefit on a REPLACE run.
The EXEC statement in the JCL includes a parameter to override the installation options module. This options module activates dynamic data set allocation for all copy files by specifying ACTIVE YES for each corresponding DDTYPE. The options module de-activates dynamic allocation for the SYSERR data set by specifying ACTIVE NO for DDTYPE=ERROR.
This example specifies ORDER NO to demonstrate an additional override capability with the IFALLOC option. Because the table has two indexes and ORDER NO is specified, dynamic allocation would normally allocate two SYSUT1 data sets. However, because IFALLOC=USE is specified for SYSUT1 in the options module and the JCL contains a DD statement for a SYSUT101 data set, LOADPLUS uses that data set and dynamically allocates only one additional SYSUT1 data set.
The LOAD statement shows overrides of some of the installation options, including turning on dynamic allocation for the error data set. Also, as a result of specifying IFALLOC=FREE for the error data set, LOADPLUS ignores the DD statement for SYSERR. Because the installation options module includes AUTOENUMROWS=YES, the command statement does not need to include the ENUMROWS option. Message BMC51561I shows the number of input records that the utility calculated using automated file size estimation.
Additional dynamic allocation options perform the following functions:
- DSNPAT creates unique data set names.
- SIZEPCT tells LOADPLUS to allocate 500 percent of the primary and 50 percent of the secondary data set size calculation.
- UNIT tells LOADPLUS what type of device to use for allocation.
- UNITCNT tells LOADPLUS how many devices to allocate.
- VOLCNT tells LOADPLUS the maximum number of volumes to use during dynamic allocation.
- The copy data sets are allocated with GDG names. The GDGLIMIT option tells LOADPLUS to keep five generations of each copy data set.
This job allocates multiple SORTOUT and SORTWK data sets, demonstrating how LOADPLUS automatically multitasks for optimal performance when you use dynamic allocation.
Message 50041I indicates the status of zIIP processing. For this example, the ZIIP installation option is ENABLED, but an XBM subsystem was not specified. LOADPLUS automatically located an available XBM subsystem to provide zIIP processing.
LOADPLUS updates statistics in both the Db2 catalog and the DASD MANAGER PLUS database statistics tables. The JCL for this example includes the DD statement //ASUSRPRT DD DUMMY. This DD statement tells LOADPLUS not to produce a report of the statistics.
The following figure shows the JCL for example 11:
//EXAMPL11 EXEC PGM=AMUUMAIN,
// PARM='&SSID,EXAMPL11,NEW ,,MSGLEVEL(1),AMU$OPTH'
//* SSID,UTILID ,RSTART,NOTIFY,MSGLEVEL
//STEPLIB DD DISP=SHR,DSN=product.libraries
// DD DISP=SHR,DSN=DB2.DSNEXIT
// DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//ASUSRPRT DD DUMMY
//*
//SYSREC DD DSN=AMU.VQA.EXAMPL11.SYSREC,DISP=SHR
//SYSERR DD DSN=AMU.EXAMP011.SYSERR,
// UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,DELETE)
//SYSUT101 DD DSN=AMU.EXAMP011.SYSUT101,
// UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,DELETE)
//*
//*
//SYSIN DD *
LOAD REPLACE ORDER NO
PRELOAD CONTINUE
UPDATEDB2STATS YES BMCSTATS YES
COPY YES INLINE NO
REDEFINE NO
INTO TABLE EXAMPLEB.TBL1
(DATE_OF_SALE POSITION(72:77) DATE-2 EXTERNAL
,SALES_TRANS_ID POSITION(52:61) INTEGER EXTERNAL
,SALES_ITEM_ID POSITION(1:10) CHARACTER
,SALES_QTY POSITION(11:21) INTEGER EXTERNAL
,SALES_PR_PER_ITEM POSITION(22:30) DECIMAL EXTERNAL(9,2)
,SALES_TOTAL_TX POSITION(31:39) DECIMAL EXTERNAL(9,2)
,SALES_TOTAL POSITION(42:50) DECIMAL EXTERNAL(9,2)
,SELLER_ID POSITION(62:71) CHARACTER
)
LOG NO
DDTYPE LOAD THRESHLD 50000 UNIT(WORK,CART)
VOLCNT 100 UNITCNT 15
DDTYPE SORTWORK DSNPAT 'NONE'
DDTYPE DISCARD DSNPAT 'AMU.&UTIL..T&TIME.&DDNAME'
VOLCNT 100 UNITCNT 15
DDTYPE ERROR ACTIVE YES IFALLOC FREE SIZEPCT(500,50)
VOLCNT 100 UNITCNT 15
DDTYPE LOCPFCPY
DSNPAT 'AMU.EXAMP011.LOCPFCPY.&DDNAME.(+1)'
DDTYPE LOCBFCPY
DSNPAT 'AMU.EXAMP011.LOCBFCPY.&DDNAME.(+1)'
DDTYPE REMPFCPY
DSNPAT 'AMU.EXAMP011.REMPFCPY.&DDNAME.(+1)'
DDTYPE REMBFCPY
DSNPAT 'AMU.EXAMP011.REMBFCPY.&DDNAME.(+1)'
// PARM='&SSID,EXAMPL11,NEW ,,MSGLEVEL(1),AMU$OPTH'
//* SSID,UTILID ,RSTART,NOTIFY,MSGLEVEL
//STEPLIB DD DISP=SHR,DSN=product.libraries
// DD DISP=SHR,DSN=DB2.DSNEXIT
// DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//ASUSRPRT DD DUMMY
//*
//SYSREC DD DSN=AMU.VQA.EXAMPL11.SYSREC,DISP=SHR
//SYSERR DD DSN=AMU.EXAMP011.SYSERR,
// UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,DELETE)
//SYSUT101 DD DSN=AMU.EXAMP011.SYSUT101,
// UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(MOD,CATLG,DELETE)
//*
//*
//SYSIN DD *
LOAD REPLACE ORDER NO
PRELOAD CONTINUE
UPDATEDB2STATS YES BMCSTATS YES
COPY YES INLINE NO
REDEFINE NO
INTO TABLE EXAMPLEB.TBL1
(DATE_OF_SALE POSITION(72:77) DATE-2 EXTERNAL
,SALES_TRANS_ID POSITION(52:61) INTEGER EXTERNAL
,SALES_ITEM_ID POSITION(1:10) CHARACTER
,SALES_QTY POSITION(11:21) INTEGER EXTERNAL
,SALES_PR_PER_ITEM POSITION(22:30) DECIMAL EXTERNAL(9,2)
,SALES_TOTAL_TX POSITION(31:39) DECIMAL EXTERNAL(9,2)
,SALES_TOTAL POSITION(42:50) DECIMAL EXTERNAL(9,2)
,SELLER_ID POSITION(62:71) CHARACTER
)
LOG NO
DDTYPE LOAD THRESHLD 50000 UNIT(WORK,CART)
VOLCNT 100 UNITCNT 15
DDTYPE SORTWORK DSNPAT 'NONE'
DDTYPE DISCARD DSNPAT 'AMU.&UTIL..T&TIME.&DDNAME'
VOLCNT 100 UNITCNT 15
DDTYPE ERROR ACTIVE YES IFALLOC FREE SIZEPCT(500,50)
VOLCNT 100 UNITCNT 15
DDTYPE LOCPFCPY
DSNPAT 'AMU.EXAMP011.LOCPFCPY.&DDNAME.(+1)'
DDTYPE LOCBFCPY
DSNPAT 'AMU.EXAMP011.LOCBFCPY.&DDNAME.(+1)'
DDTYPE REMPFCPY
DSNPAT 'AMU.EXAMP011.REMPFCPY.&DDNAME.(+1)'
DDTYPE REMBFCPY
DSNPAT 'AMU.EXAMP011.REMBFCPY.&DDNAME.(+1)'
SYSPRINT for example 11The following figure shows the SYSPRINT output for example 11:
1 ************* B M C L O A D P L U S F O R D B 2 V11R2.00 ************
(C) COPYRIGHT 1990 - 2015 BMC SOFTWARE, INC.
LOADPLUS TECHNOLOGY IS PROTECTED BY U.S. PATENT NUMBERS 7,664,790 AND 7,930,291
-BMC50001I UTILITY EXECUTION STARTING 3/09/2015 14:59:20 ...
BMC50002I UTILITY ID = 'EXAMPL11'. DB2 SUBSYSTEM ID = 'DEHJ'. OPTION MODULE = 'AMU$OPTH'.
BMC50471I z/OS 2.1.0,PID=HBB7790,DFSMS FOR Z/OS=2.1.0,DB2=11.1.0
BMC50471I REGION=0M,BELOW 16M=8820K,ABOVE 16M=1307220K,IEFUSI=NO,CPUS=3
BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040306M,MEMLIMIT SET BY:REGION=0
0
BMC50471I LOADPLUS FOR DB2--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I SOLUTION COMMON CODE--V11.01.00
BMC50471I MAINT: BPJ0661 BPJ0667 BPJ0671 BPJ0674 BPJ0675 BPJ0676 BPJ0682 BPJ0686 BPJ0689 BPJ0697 BPJ0700 BPJ0702
BMC50471I BPJ0703 BPJ0706 BPJ0712 BPJ0715 BPJ0729 BPJ0773 BPJ0786 BPJ0794 BPJ0806 BPJ0830 BPJ0833 BPJ0839
BMC50471I BPJ0845 BPJ0866 BPJ0892 BPJ0913 BPJ0914 BPJ0916 BPJ0930 BPJ0944 BPJ0946
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922
BMC50471I BMC STATS API--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.01.00
BMC50471I MAINT: BPE0401 BPE0403 BPE0405 BPE0407 BPE0410 BPE0412 BPE0416 BPE0420 BPE0422 BPE0423 BPE0426 BPE0428
BMC50471I BPE0430 BPE0433 BPE0435 BPE0438 BPE0439
BMC50471I HIGH-SPEED APPLY ENGINE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
0
BMC50471I APCOMMIT=2500 FORCE_AT=(START,3) RCVYDDN=(BMCRCY,BMCRCZ)
BMC50471I APDOPTS= FORCE_RPT=NO REDEFINE=YES
BMC50471I APMULTIROW=100 FORCE=NONE RENMMAX=30
BMC50471I APMXAGNT=10 IBUFFS=20 RULES=BMC
BMC50471I APRETLIM=COUNT IDCACHE=1000 SDUMP=YES
BMC50471I APRETVAL=5 IDCDDN=SYSIDCIN SHORTMEMORY=CONTINUE
BMC50471I AUTOENUMROWS=YES IDERROR=DISCARD SHRLEVEL=(NONE,NONE)
BMC50471I AVAILPAGEPCT=0 INDDN=SYSREC SMAX=16
BMC50471I CBUFFS=30 INFORI=NO SMCORE=(0K,0K)
BMC50471I CENTURY=(1950,2049) INLINECP=YES SORTDEVT=(,SYSALLDA)
BMC50471I CHEKPEND=YES KEEPDICTIONARY=NO SORTNUM=32
BMC50471I COPYDDN=(BMCCPY,BMCCPZ) LBUFFS=20 SQLDELAY=3
BMC50471I COPYLVL=FULL LOADDN=SORTOUT SQLRETRY=100
BMC50471I COPYPEND=YES LOBAVGPCT=50 STOP@CMT=YES
BMC50471I COPYSUBSET=NO LOCKROW=YES STOPDELAY=1
BMC50471I DELFILES=(YES,NO) LONGNAMETRUNC=MIDDLE STOPRETRY=300
BMC50471I DISCARDLIMRC=8 MAPDDN=SYSMAP TAPEDISP=DELETE
BMC50471I DISCARDRC=0 MAXP=5 TOTALPAGEPCT=30
BMC50471I DISCDDN=SYSDISC MAXSORTMEMORY=0 TSSAMPLEPCT=100
BMC50471I DRNDELAY=1 MAXTAPE=3 UPDMAXA_AUTHID=USER
BMC50471I DRNRETRY=255 MGEXTENT=CONTINUE UPDMAXA=NO
BMC50471I DRNWAIT=NONE MINSORTMEMORY=0 UXSTATE=SUP
BMC50471I DSNUEXIT=(NONE,ASM) MSGLEVEL=1 WBUFFS=(20,10)
BMC50471I DSNUTILB=YES OPNDB2ID=YES WORKDDN=SYSUT1
BMC50471I ENFORCE=CHECK ORIGDISP=DELETE WORKUNIT=SYSALLDA
BMC50471I ERRDDN=SYSERR PAUSEDISCARDRC=4 XBLKS=3
BMC50471I EXCLDUMP=(X37,X22,X06) PLAN=AMUQA XMLAVGSIZE=10240
BMC50471I FASTSWITCH=NO PREFORMAT=NO ZEROROWRC=0
BMC50471I FILECHK=WARN PRELOAD=LOAD ZIIP=ENABLED
0
BMC50471I APCOLLECTION=
BMC50471I APOWNER=
0
BMC50470I DDTYPE = LOAD WORK SORTWORK
BMC50470I ACTIVE = YES YES 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) 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 YES YES
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = N/A N/A 5
BMC50470I GDGEMPTY = N/A N/A NO
BMC50470I GDGSCRAT = N/A N/A NO
0
BMC50470I DDTYPE = LOCBFCPY REMPFCPY REMBFCPY
BMC50470I ACTIVE = 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 = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = SYSMAP LOCPLCPY LOCBLCPY
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 = 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 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 = LOCBXCPY REMPXCPY REMBXCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50483I LOAD DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I WORK DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I SORTWORK DSNPAT=NONE
BMC50483I ERROR DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I DISCARD DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I SYSMAP DSNPAT=&UID..BMC.&TS.&DDNAME
0
BMC50483I LOCPFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I LOCBFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMPFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMBFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
BMC50483I LOCPLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I LOCBLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I REMPLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I REMBLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
0
BMC50483I LOCPXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I LOCBXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMPXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMBXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
BMC50471I DB2 DSNHDECP MODULE SETTINGS:
BMC50471I VERSION = 1110
BMC50471I SUBSYSTEM DEFAULT = DEHJ
BMC50471I CHARACTER SET = ALPHANUM
BMC50471I DATE FORMAT = USA
BMC50471I TIME FORMAT = USA
BMC50471I LOCAL DATE LENGTH = 0
BMC50471I LOCAL TIME LENGTH = 0
BMC50471I DECIMAL POINT = PERIOD
BMC50471I DECIMAL ARITHMETIC = 15
BMC50471I DELIMITER = DEFAULT
BMC50471I SQL DELIMITER = DEFAULT
BMC50471I ENCODING SCHEME = EBCDIC
BMC50471I APPL. ENCODING SCHEME = EBCDIC
BMC50471I MIXED = NO
BMC50471I EBCDIC CCSID = (37,65534,65534)
BMC50471I ASCII CCSID = (819,65534,65534)
BMC50471I UNICODE CCSID = (367,1208,1200)
BMC50471I IMPLICIT TIME ZONE = CURRENT (-05:00)
BMC50028I DB2 MODE = NFM
BMC50471I BMC_BMCUTIL ='BMCUTIL.CMN_BMCUTIL'
BMC50471I BMC_BMCSYNC ='BMCUTIL.CMN_BMCSYNC'
BMC50471I BMC_BMCHIST ='BMCUTIL.CMN_BMCHIST'
BMC50471I BMC_BMCDICT ='BMCUTIL.CMN_BMCDICT'
0
0
BMC50102I LOAD REPLACE ORDER NO
BMC50102I PRELOAD CONTINUE
BMC50102I UPDATEDB2STATS YES BMCSTATS YES
BMC50102I COPY YES INLINE NO
BMC50102I REDEFINE NO
BMC50102I INTO TABLE EXAMPLEB.TBL1
BMC50102I (DATE_OF_SALE POSITION(72:77) DATE-2 EXTERNAL
BMC50102I ,SALES_TRANS_ID POSITION(52:61) INTEGER EXTERNAL
BMC50102I ,SALES_ITEM_ID POSITION(1:10) CHARACTER
BMC50102I ,SALES_QTY POSITION(11:21) INTEGER EXTERNAL
BMC50102I ,SALES_PR_PER_ITEM POSITION(22:30) DECIMAL EXTERNAL(9,2)
BMC50102I ,SALES_TOTAL_TX POSITION(31:39) DECIMAL EXTERNAL(9,2)
BMC50102I ,SALES_TOTAL POSITION(42:50) DECIMAL EXTERNAL(9,2)
BMC50102I ,SELLER_ID POSITION(62:71) CHARACTER
BMC50102I )
BMC50102I LOG NO
BMC50102I DDTYPE LOAD THRESHLD 50000 UNIT(WORK,CART)
BMC50102I VOLCNT 100 UNITCNT 15
BMC50102I DDTYPE SORTWORK DSNPAT 'NONE'
BMC50102I DDTYPE DISCARD DSNPAT 'AMU.&UTIL..T&TIME.&DDNAME'
BMC50102I VOLCNT 100 UNITCNT 15
BMC50102I DDTYPE ERROR ACTIVE YES IFALLOC FREE SIZEPCT(500,50)
BMC50102I VOLCNT 100 UNITCNT 15
BMC50102I DDTYPE LOCPFCPY
BMC50102I DSNPAT 'AMU.EXAMP011.LOCPFCPY.&DDNAME.(+1)'
BMC50102I DDTYPE LOCBFCPY
BMC50102I DSNPAT 'AMU.EXAMP011.LOCBFCPY.&DDNAME.(+1)'
BMC50102I DDTYPE REMPFCPY
BMC50102I DSNPAT 'AMU.EXAMP011.REMPFCPY.&DDNAME.(+1)'
BMC50102I DDTYPE REMBFCPY
BMC50102I DSNPAT 'AMU.EXAMP011.REMBFCPY.&DDNAME.(+1)'
BMC51424I ANALYZE PHASE WILL BE PERFORMED DUE TO DYNAMIC WORK FILE ALLOCATION
BMC51421I NO FIELD SPECIFICATION FOR COLUMN 'SALES_ITEM_DESC '. VALUE IS DEFAULTED
BMC51421I NO FIELD SPECIFICATION FOR COLUMN 'ENTRY_TIMESTAMP '. VALUE IS DEFAULTED
BMC51561I CALCULATED NUMBER OF INPUT RECORDS = 871 USING A SCALING FACTOR OF 100%
BMC50004I UTILINIT PHASE COMPLETE. ELAPSED TIME = 00:00:01
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I ANALYZE PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50425I &JOBNAME = AMUEX11 &STEPNAME = EXAMPL11 &DB = AMUEXBDB &TS = EXBTS &UID = RDAMZL
BMC50425I &RESUME = N &REPLACE = Y &DATE = 030915 &TIME = 145920 &SSID = DEHJ
BMC50425I &UTIL = EXAMPL11 &UTILPFX = EXAMPL11 &UTILSFX = &DATE8 = 03092015 &GRPNM = DEHJ
BMC50425I &VCAT = DEHJCAT &TIME4 = 1459 &DATEJ = 2015068 &JDATE = 15068
BMC50445I LOAD PLUS DYNAMIC FILE ALLOCATION REPORT
BMC50446I UNIT OR KBYTES KBYTES ALOC ALOC
BMC50447I DDNAME DSNAME DATACLAS MGMTCLAS STORCLAS PRI SEC PRI SEC
BMC50448I BMCCPY AMU.EXAMP011.LOCPFCPY.BMCCPY.G0041V00 SYSALLDA 120 12 3 1 TRK
BMC50448I BMCCPZ AMU.EXAMP011.LOCBFCPY.BMCCPZ.G0040V00 SYSALLDA 120 12 3 1 TRK
BMC50448I BMCRCY AMU.EXAMP011.REMPFCPY.BMCRCY.G0040V00 SYSALLDA 120 12 3 1 TRK
BMC50448I BMCRCZ AMU.EXAMP011.REMBFCPY.BMCRCZ.G0040V00 SYSALLDA 120 12 3 1 TRK
BMC50448I SORTOUT1 RDAMZL.BMC.EXBTS.SORTOUT1 *WORK 9 2 1 1 TRK
BMC50448I SORTOUT2 RDAMZL.BMC.EXBTS.SORTOUT2 *WORK 9 2 1 1 TRK
BMC50448I SORTOUT3 RDAMZL.BMC.EXBTS.SORTOUT3 *WORK 9 2 1 1 TRK
BMC50448I SORTOUT4 RDAMZL.BMC.EXBTS.SORTOUT4 *WORK 9 2 1 1 TRK
BMC50448I SORTOUT5 RDAMZL.BMC.EXBTS.SORTOUT5 *WORK 9 2 1 1 TRK
BMC50448I SORTOUT6 RDAMZL.BMC.EXBTS.SORTOUT6 *WORK 9 2 1 1 TRK
BMC50448I SORTOUT7 RDAMZL.BMC.EXBTS.SORTOUT7 *WORK 9 2 1 1 TRK
BMC50448I SORTOUT8 RDAMZL.BMC.EXBTS.SORTOUT8 *WORK 9 2 1 1 TRK
BMC50448I SORTOUT9 RDAMZL.BMC.EXBTS.SORTOUT9 *WORK 9 2 1 1 TRK
BMC50448I SORTWK01 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK02 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK03 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK04 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK05 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK06 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK07 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK08 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK09 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK10 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK11 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK12 *SYSALLDA 5 1 1 1 TRK
BMC50448I SYSDISC AMU.EXAMPL11.T145920.SYSDISC SYSALLDA 68 8 2 1 TRK
BMC50448I SYSERR RDAMZL.BMC.EXBTS.SYSERR SYSALLDA 145 1 3 1 TRK
BMC50448I SYSUT102 RDAMZL.BMC.EXBTS.SYSUT102 SYSALLDA 19 2 1 1 TRK
BMC50466W TEMPORARY DATASET NOT RECOMMENDED FOR DDNAME = 'SYSUT101'
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8408K, ABOVE 16M = 1282364K, CPUS = 3
BMC50479I TOTAL PAGES: 3827159, ALLOWED: 1148148; AVAILABLE PAGES: 296915, ALLOWED: 0
BMC51495I PRELOAD OPTIMIZATION, RC = 0, #SORTS = 9, #READERS = 1, INDEX TASKS = 1, TIME = 59648
BMC51495I PRELOAD OPTIMIZATION, RC = 14, #SORTS = 8, #READERS = 1, INDEX TASKS = 1, TIME = 66432
BMC51496I PRELOAD ANALYZE, #SORTS = 9, #READERS = 1, INDEX TASKS = 1
BMC50486I 11: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50481I 1: READ TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 1: READ TASK, XBLK XFERS = 6, EMPTY WAITS = 0, FULL WAITS = 0
BMC51478I PRELOAD STATISTICS: 854 PHYSICAL (854 LOGICAL) RECORDS READ FROM SYSREC
BMC50481I 2: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC50481I 9: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 9: SORT TASK, XBLK XFERS = 2, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 2: SORT TASK, XBLK XFERS = 0, EMPTY WAITS = 0, FULL WAITS = 0
BMC50481I 3: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 3: SORT TASK, XBLK XFERS = 2, EMPTY WAITS = 0, FULL WAITS = 0
BMC50481I 4: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 4: SORT TASK, XBLK XFERS = 2, EMPTY WAITS = 0, FULL WAITS = 0
BMC50481I 5: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 5: SORT TASK, XBLK XFERS = 2, EMPTY WAITS = 0, FULL WAITS = 0
BMC50481I 6: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC50481I 8: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC50481I 7: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 6: SORT TASK, XBLK XFERS = 2, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 8: SORT TASK, XBLK XFERS = 0, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 7: SORT TASK, XBLK XFERS = 2, EMPTY WAITS = 0, FULL WAITS = 0
BMC50481I 10: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 10: SORT TASK, XBLK XFERS = 0, EMPTY WAITS = 0, FULL WAITS = 0
BMC50481I 11: INDEX SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50481I 11: INDEX TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 11: INDEX TASK, XBLK XFERS = 6, EMPTY WAITS = 0, FULL WAITS = 2
BMC50476I DDNAME = SYSREC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT1, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT2, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT3, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT4, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT5, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT6, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT7, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT8, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT9, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSUT101, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSUT102, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC51507I XBLKS = 58, XFERS = 12, EMPTY WAITS = 0, FULL WAITS =2
BMC50476I DDNAME = SYSDISC, I/OS = 0, I/O WAITS = 0, RDB LOCK WAITS = 0
BMC51471I PRELOAD STATISTICS: 454 ROWS SELECTED FOR PARTITION 1
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A001' WILL REQUIRE 12 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A001' WILL REQUIRE 6 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 59 ROWS SELECTED FOR PARTITION 2
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A002' WILL REQUIRE 4 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A002' WILL REQUIRE 4 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 60 ROWS SELECTED FOR PARTITION 3
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A003' WILL REQUIRE 4 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A003' WILL REQUIRE 4 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 0 ROWS SELECTED FOR PARTITION 4
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A004' WILL REQUIRE 2 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A004' WILL REQUIRE 3 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 62 ROWS SELECTED FOR PARTITION 5
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A005' WILL REQUIRE 4 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A005' WILL REQUIRE 4 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 0 ROWS SELECTED FOR PARTITION 6
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A006' WILL REQUIRE 2 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A006' WILL REQUIRE 3 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 19 ROWS SELECTED FOR PARTITION 7
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A007' WILL REQUIRE 3 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A007' WILL REQUIRE 4 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 100 ROWS SELECTED FOR PARTITION 8
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A008' WILL REQUIRE 4 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A008' WILL REQUIRE 4 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 100 ROWS SELECTED FOR PARTITION 9
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A009' WILL REQUIRE 4 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A009' WILL REQUIRE 4 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 0 ROWS SELECTED FOR PARTITION 10
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A010' WILL REQUIRE 2 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A010' WILL REQUIRE 3 PAGES (APPROX.)
BMC51488I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX1.I0001.A001' MAY REQUIRE 8 PAGES
BMC51472I PRELOAD PHASE STATISTICS: 854 ROWS SELECTED FOR SPACE 'AMUEXBDB.EXBTS', 0 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
BMC51479I PRELOAD PHASE STATISTICS: 0 PHYSICAL (0 LOGICAL) RECORDS DISCARDED TO SYSDISC
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I PRELOAD PHASE COMPLETE. ELAPSED TIME = 00:00:01
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8236K, ABOVE 16M = 1296868K, CPUS = 3
BMC50479I TOTAL PAGES: 3810073, ALLOWED: 1143022; AVAILABLE PAGES: 285851, ALLOWED: 0
BMC51498I LOAD OPTIMIZATION, RC = 0, #LOAD TASKS = 9, #COPY TASKS = 1, #INDEX TASKS = 2
BMC50370I STARTING 1 IMAGE COPY TASKS
BMC51508I MAX INDEX TASKS = 2, INDEXES PER TASK = 1, SORTWKS PER TASK = 12, MAX OPEN PARTITIONS PER TASK = 1
BMC51508I MAX DATA TASKS = 9, MAX PARTS PER TASK = 2, SORTWKS PER TASK = 0, MAX OPEN PARTITIONS PER TASK = 2
BMC51453I EXISTING ROWS IN TABLESPACE 'AMUEXBDB.EXBTS' DELETED
BMC50482I 2: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A008'
BMC50477I 2: PARTITION = 8, ROWS/KEYS = 100, I/O WAITS = 5 ,DDNAME = SYS00006
BMC50482I 1: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A007'
BMC50477I 1: PARTITION = 7, ROWS/KEYS = 19, I/O WAITS = 5 ,DDNAME = SYS00005
BMC51474I LOAD STATISTICS: 100 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 8
BMC50482I 3: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A001'
BMC50477I 3: PARTITION = 1, ROWS/KEYS = 454, I/O WAITS = 5 ,DDNAME = SYS00008
BMC51474I LOAD STATISTICS: 19 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 7
BMC51474I LOAD STATISTICS: 454 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 1
BMC50482I 4: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A005'
BMC50477I 4: PARTITION = 5, ROWS/KEYS = 62, I/O WAITS = 5 ,DDNAME = SYS00009
BMC51474I LOAD STATISTICS: 62 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 5
BMC50482I 5: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A009'
BMC50477I 5: PARTITION = 9, ROWS/KEYS = 100, I/O WAITS = 5 ,DDNAME = SYS00010
BMC51474I LOAD STATISTICS: 100 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 9
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A001'
BMC50477I 1: PARTITION = 1, ROWS/KEYS = 454, I/O WAITS = 6 ,DDNAME = SYS00007
BMC51474I BUILD STATISTICS: 454 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 1
BMC50476I DDNAME = SORTOUT1, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50482I 7: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A002'
BMC50477I 7: PARTITION = 2, ROWS/KEYS = 59, I/O WAITS = 5 ,DDNAME = SYS00011
BMC50486I 2: BMCSORT STARTED, 384K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51474I LOAD STATISTICS: 59 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 2
BMC50476I DDNAME = SORTOUT2, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT3, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT4, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT5, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50482I 7: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A003'
BMC50477I 7: PARTITION = 3, ROWS/KEYS = 60, I/O WAITS = 5 ,DDNAME = SYS00014
BMC51474I LOAD STATISTICS: 60 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 3
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A001'
BMC50476I DDNAME = SORTOUT6, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT7, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT8, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A002'
BMC50476I DDNAME = SORTOUT9, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A003'
BMC50482I 0: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A004'
BMC50477I 0: PARTITION = 4, ROWS/KEYS = 0, I/O WAITS = 5 ,DDNAME = SYS00018
BMC51474I LOAD STATISTICS: 0 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 4
BMC50476I DDNAME = SYSUT102, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50481I 2: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A004'
BMC50482I 0: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A006'
BMC50477I 0: PARTITION = 6, ROWS/KEYS = 0, I/O WAITS = 5 ,DDNAME = SYS00020
BMC51474I LOAD STATISTICS: 0 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 6
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A005'
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A002'
BMC50477I 1: PARTITION = 2, ROWS/KEYS = 59, I/O WAITS = 7 ,DDNAME = SYS00012
BMC51474I BUILD STATISTICS: 59 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 2
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A006'
BMC50482I 0: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A010'
BMC50477I 0: PARTITION = 10, ROWS/KEYS = 0, I/O WAITS = 5 ,DDNAME = SYS00024
BMC51474I LOAD STATISTICS: 0 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 10
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A007'
BMC51475I LOAD STATISTICS: 854 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS'
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A008'
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A009'
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A010'
BMC50476I DDNAME = BMCCPY, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCCPZ, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCY, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCZ, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
BMC50376I 41 PAGES COPIED TO DATASET = 'AMU.EXAMP011.LOCPFCPY.BMCCPY.G0041V00'
BMC50376I 41 PAGES COPIED TO DATASET = 'AMU.EXAMP011.LOCBFCPY.BMCCPZ.G0040V00'
BMC50376I 41 PAGES COPIED TO DATASET = 'AMU.EXAMP011.REMPFCPY.BMCRCY.G0040V00'
BMC50376I 41 PAGES COPIED TO DATASET = 'AMU.EXAMP011.REMBFCPY.BMCRCZ.G0040V00'
BMC50482I 2: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX1.I0001.A001'
BMC50477I 2: PARTITION = 0, ROWS/KEYS = 854, I/O WAITS = 7 ,DDNAME = SYS00021
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A003'
BMC50477I 1: PARTITION = 3, ROWS/KEYS = 60, I/O WAITS = 7 ,DDNAME = SYS00026
BMC51474I BUILD STATISTICS: 60 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 3
BMC51476I BUILD STATISTICS: 854 KEYS LOADED INTO INDEX 'EXAMPLEB.IX1'
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A005'
BMC50477I 1: PARTITION = 5, ROWS/KEYS = 62, I/O WAITS = 7 ,DDNAME = SYS00031
BMC51474I BUILD STATISTICS: 62 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 5
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A007'
BMC50477I 1: PARTITION = 7, ROWS/KEYS = 19, I/O WAITS = 7 ,DDNAME = SYS00032
BMC51474I BUILD STATISTICS: 19 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 7
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A008'
BMC50477I 1: PARTITION = 8, ROWS/KEYS = 100, I/O WAITS = 7 ,DDNAME = SYS00033
BMC51474I BUILD STATISTICS: 100 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 8
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A009'
BMC50477I 1: PARTITION = 9, ROWS/KEYS = 100, I/O WAITS = 7 ,DDNAME = SYS00034
BMC51474I BUILD STATISTICS: 100 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 9
BMC50476I DDNAME = SYSUT101, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A004'
BMC50477I 1: PARTITION = 4, ROWS/KEYS = 0, I/O WAITS = 7 ,DDNAME = SYS00035
BMC51474I BUILD STATISTICS: 0 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 4
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A006'
BMC50477I 1: PARTITION = 6, ROWS/KEYS = 0, I/O WAITS = 7 ,DDNAME = SYS00036
BMC51474I BUILD STATISTICS: 0 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 6
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A010'
BMC50477I 1: PARTITION = 10, ROWS/KEYS = 0, I/O WAITS = 7 ,DDNAME = SYS00037
BMC51474I BUILD STATISTICS: 0 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 10
BMC51476I BUILD STATISTICS: 854 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR ', DSNAME = 'RDAMZL.BMC.EXBTS.SYSERR'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK01', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338313'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK02', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338314'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK03', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338315'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK04', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338316'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK05', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338317'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK06', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338318'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK07', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338319'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK08', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338320'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK09', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338321'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK10', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338322'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK11', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338323'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK12', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338324'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT101', DSNAME = 'AMU.EXAMP011.SYSUT101'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT102', DSNAME = 'RDAMZL.BMC.EXBTS.SYSUT102'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT9', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT9'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT8', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT8'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT7', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT7'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT6', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT6'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT5', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT5'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT4', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT4'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT3', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT3'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT2', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT2'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT1', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT1'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR ', DSNAME = 'AMU.EXAMP011.SYSERR'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I LOAD PHASE COMPLETE. ELAPSED TIME = 00:00:07
BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR LOAD UTILITY SUCCESSFUL FOR ALL OBJECTS
BMC50004I UTILTERM PHASE COMPLETE. ELAPSED TIME = 00:00:11
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0
(C) COPYRIGHT 1990 - 2015 BMC SOFTWARE, INC.
LOADPLUS TECHNOLOGY IS PROTECTED BY U.S. PATENT NUMBERS 7,664,790 AND 7,930,291
-BMC50001I UTILITY EXECUTION STARTING 3/09/2015 14:59:20 ...
BMC50002I UTILITY ID = 'EXAMPL11'. DB2 SUBSYSTEM ID = 'DEHJ'. OPTION MODULE = 'AMU$OPTH'.
BMC50471I z/OS 2.1.0,PID=HBB7790,DFSMS FOR Z/OS=2.1.0,DB2=11.1.0
BMC50471I REGION=0M,BELOW 16M=8820K,ABOVE 16M=1307220K,IEFUSI=NO,CPUS=3
BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040306M,MEMLIMIT SET BY:REGION=0
0
BMC50471I LOADPLUS FOR DB2--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I SOLUTION COMMON CODE--V11.01.00
BMC50471I MAINT: BPJ0661 BPJ0667 BPJ0671 BPJ0674 BPJ0675 BPJ0676 BPJ0682 BPJ0686 BPJ0689 BPJ0697 BPJ0700 BPJ0702
BMC50471I BPJ0703 BPJ0706 BPJ0712 BPJ0715 BPJ0729 BPJ0773 BPJ0786 BPJ0794 BPJ0806 BPJ0830 BPJ0833 BPJ0839
BMC50471I BPJ0845 BPJ0866 BPJ0892 BPJ0913 BPJ0914 BPJ0916 BPJ0930 BPJ0944 BPJ0946
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922
BMC50471I BMC STATS API--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.01.00
BMC50471I MAINT: BPE0401 BPE0403 BPE0405 BPE0407 BPE0410 BPE0412 BPE0416 BPE0420 BPE0422 BPE0423 BPE0426 BPE0428
BMC50471I BPE0430 BPE0433 BPE0435 BPE0438 BPE0439
BMC50471I HIGH-SPEED APPLY ENGINE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
0
BMC50471I APCOMMIT=2500 FORCE_AT=(START,3) RCVYDDN=(BMCRCY,BMCRCZ)
BMC50471I APDOPTS= FORCE_RPT=NO REDEFINE=YES
BMC50471I APMULTIROW=100 FORCE=NONE RENMMAX=30
BMC50471I APMXAGNT=10 IBUFFS=20 RULES=BMC
BMC50471I APRETLIM=COUNT IDCACHE=1000 SDUMP=YES
BMC50471I APRETVAL=5 IDCDDN=SYSIDCIN SHORTMEMORY=CONTINUE
BMC50471I AUTOENUMROWS=YES IDERROR=DISCARD SHRLEVEL=(NONE,NONE)
BMC50471I AVAILPAGEPCT=0 INDDN=SYSREC SMAX=16
BMC50471I CBUFFS=30 INFORI=NO SMCORE=(0K,0K)
BMC50471I CENTURY=(1950,2049) INLINECP=YES SORTDEVT=(,SYSALLDA)
BMC50471I CHEKPEND=YES KEEPDICTIONARY=NO SORTNUM=32
BMC50471I COPYDDN=(BMCCPY,BMCCPZ) LBUFFS=20 SQLDELAY=3
BMC50471I COPYLVL=FULL LOADDN=SORTOUT SQLRETRY=100
BMC50471I COPYPEND=YES LOBAVGPCT=50 STOP@CMT=YES
BMC50471I COPYSUBSET=NO LOCKROW=YES STOPDELAY=1
BMC50471I DELFILES=(YES,NO) LONGNAMETRUNC=MIDDLE STOPRETRY=300
BMC50471I DISCARDLIMRC=8 MAPDDN=SYSMAP TAPEDISP=DELETE
BMC50471I DISCARDRC=0 MAXP=5 TOTALPAGEPCT=30
BMC50471I DISCDDN=SYSDISC MAXSORTMEMORY=0 TSSAMPLEPCT=100
BMC50471I DRNDELAY=1 MAXTAPE=3 UPDMAXA_AUTHID=USER
BMC50471I DRNRETRY=255 MGEXTENT=CONTINUE UPDMAXA=NO
BMC50471I DRNWAIT=NONE MINSORTMEMORY=0 UXSTATE=SUP
BMC50471I DSNUEXIT=(NONE,ASM) MSGLEVEL=1 WBUFFS=(20,10)
BMC50471I DSNUTILB=YES OPNDB2ID=YES WORKDDN=SYSUT1
BMC50471I ENFORCE=CHECK ORIGDISP=DELETE WORKUNIT=SYSALLDA
BMC50471I ERRDDN=SYSERR PAUSEDISCARDRC=4 XBLKS=3
BMC50471I EXCLDUMP=(X37,X22,X06) PLAN=AMUQA XMLAVGSIZE=10240
BMC50471I FASTSWITCH=NO PREFORMAT=NO ZEROROWRC=0
BMC50471I FILECHK=WARN PRELOAD=LOAD ZIIP=ENABLED
0
BMC50471I APCOLLECTION=
BMC50471I APOWNER=
0
BMC50470I DDTYPE = LOAD WORK SORTWORK
BMC50470I ACTIVE = YES YES 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) 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 YES YES
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = N/A N/A 5
BMC50470I GDGEMPTY = N/A N/A NO
BMC50470I GDGSCRAT = N/A N/A NO
0
BMC50470I DDTYPE = LOCBFCPY REMPFCPY REMBFCPY
BMC50470I ACTIVE = 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 = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = SYSMAP LOCPLCPY LOCBLCPY
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 = 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 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 = LOCBXCPY REMPXCPY REMBXCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50483I LOAD DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I WORK DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I SORTWORK DSNPAT=NONE
BMC50483I ERROR DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I DISCARD DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I SYSMAP DSNPAT=&UID..BMC.&TS.&DDNAME
0
BMC50483I LOCPFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I LOCBFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMPFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMBFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
BMC50483I LOCPLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I LOCBLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I REMPLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I REMBLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
0
BMC50483I LOCPXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I LOCBXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMPXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMBXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
BMC50471I DB2 DSNHDECP MODULE SETTINGS:
BMC50471I VERSION = 1110
BMC50471I SUBSYSTEM DEFAULT = DEHJ
BMC50471I CHARACTER SET = ALPHANUM
BMC50471I DATE FORMAT = USA
BMC50471I TIME FORMAT = USA
BMC50471I LOCAL DATE LENGTH = 0
BMC50471I LOCAL TIME LENGTH = 0
BMC50471I DECIMAL POINT = PERIOD
BMC50471I DECIMAL ARITHMETIC = 15
BMC50471I DELIMITER = DEFAULT
BMC50471I SQL DELIMITER = DEFAULT
BMC50471I ENCODING SCHEME = EBCDIC
BMC50471I APPL. ENCODING SCHEME = EBCDIC
BMC50471I MIXED = NO
BMC50471I EBCDIC CCSID = (37,65534,65534)
BMC50471I ASCII CCSID = (819,65534,65534)
BMC50471I UNICODE CCSID = (367,1208,1200)
BMC50471I IMPLICIT TIME ZONE = CURRENT (-05:00)
BMC50028I DB2 MODE = NFM
BMC50471I BMC_BMCUTIL ='BMCUTIL.CMN_BMCUTIL'
BMC50471I BMC_BMCSYNC ='BMCUTIL.CMN_BMCSYNC'
BMC50471I BMC_BMCHIST ='BMCUTIL.CMN_BMCHIST'
BMC50471I BMC_BMCDICT ='BMCUTIL.CMN_BMCDICT'
0
0
BMC50102I LOAD REPLACE ORDER NO
BMC50102I PRELOAD CONTINUE
BMC50102I UPDATEDB2STATS YES BMCSTATS YES
BMC50102I COPY YES INLINE NO
BMC50102I REDEFINE NO
BMC50102I INTO TABLE EXAMPLEB.TBL1
BMC50102I (DATE_OF_SALE POSITION(72:77) DATE-2 EXTERNAL
BMC50102I ,SALES_TRANS_ID POSITION(52:61) INTEGER EXTERNAL
BMC50102I ,SALES_ITEM_ID POSITION(1:10) CHARACTER
BMC50102I ,SALES_QTY POSITION(11:21) INTEGER EXTERNAL
BMC50102I ,SALES_PR_PER_ITEM POSITION(22:30) DECIMAL EXTERNAL(9,2)
BMC50102I ,SALES_TOTAL_TX POSITION(31:39) DECIMAL EXTERNAL(9,2)
BMC50102I ,SALES_TOTAL POSITION(42:50) DECIMAL EXTERNAL(9,2)
BMC50102I ,SELLER_ID POSITION(62:71) CHARACTER
BMC50102I )
BMC50102I LOG NO
BMC50102I DDTYPE LOAD THRESHLD 50000 UNIT(WORK,CART)
BMC50102I VOLCNT 100 UNITCNT 15
BMC50102I DDTYPE SORTWORK DSNPAT 'NONE'
BMC50102I DDTYPE DISCARD DSNPAT 'AMU.&UTIL..T&TIME.&DDNAME'
BMC50102I VOLCNT 100 UNITCNT 15
BMC50102I DDTYPE ERROR ACTIVE YES IFALLOC FREE SIZEPCT(500,50)
BMC50102I VOLCNT 100 UNITCNT 15
BMC50102I DDTYPE LOCPFCPY
BMC50102I DSNPAT 'AMU.EXAMP011.LOCPFCPY.&DDNAME.(+1)'
BMC50102I DDTYPE LOCBFCPY
BMC50102I DSNPAT 'AMU.EXAMP011.LOCBFCPY.&DDNAME.(+1)'
BMC50102I DDTYPE REMPFCPY
BMC50102I DSNPAT 'AMU.EXAMP011.REMPFCPY.&DDNAME.(+1)'
BMC50102I DDTYPE REMBFCPY
BMC50102I DSNPAT 'AMU.EXAMP011.REMBFCPY.&DDNAME.(+1)'
BMC51424I ANALYZE PHASE WILL BE PERFORMED DUE TO DYNAMIC WORK FILE ALLOCATION
BMC51421I NO FIELD SPECIFICATION FOR COLUMN 'SALES_ITEM_DESC '. VALUE IS DEFAULTED
BMC51421I NO FIELD SPECIFICATION FOR COLUMN 'ENTRY_TIMESTAMP '. VALUE IS DEFAULTED
BMC51561I CALCULATED NUMBER OF INPUT RECORDS = 871 USING A SCALING FACTOR OF 100%
BMC50004I UTILINIT PHASE COMPLETE. ELAPSED TIME = 00:00:01
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I ANALYZE PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50425I &JOBNAME = AMUEX11 &STEPNAME = EXAMPL11 &DB = AMUEXBDB &TS = EXBTS &UID = RDAMZL
BMC50425I &RESUME = N &REPLACE = Y &DATE = 030915 &TIME = 145920 &SSID = DEHJ
BMC50425I &UTIL = EXAMPL11 &UTILPFX = EXAMPL11 &UTILSFX = &DATE8 = 03092015 &GRPNM = DEHJ
BMC50425I &VCAT = DEHJCAT &TIME4 = 1459 &DATEJ = 2015068 &JDATE = 15068
BMC50445I LOAD PLUS DYNAMIC FILE ALLOCATION REPORT
BMC50446I UNIT OR KBYTES KBYTES ALOC ALOC
BMC50447I DDNAME DSNAME DATACLAS MGMTCLAS STORCLAS PRI SEC PRI SEC
BMC50448I BMCCPY AMU.EXAMP011.LOCPFCPY.BMCCPY.G0041V00 SYSALLDA 120 12 3 1 TRK
BMC50448I BMCCPZ AMU.EXAMP011.LOCBFCPY.BMCCPZ.G0040V00 SYSALLDA 120 12 3 1 TRK
BMC50448I BMCRCY AMU.EXAMP011.REMPFCPY.BMCRCY.G0040V00 SYSALLDA 120 12 3 1 TRK
BMC50448I BMCRCZ AMU.EXAMP011.REMBFCPY.BMCRCZ.G0040V00 SYSALLDA 120 12 3 1 TRK
BMC50448I SORTOUT1 RDAMZL.BMC.EXBTS.SORTOUT1 *WORK 9 2 1 1 TRK
BMC50448I SORTOUT2 RDAMZL.BMC.EXBTS.SORTOUT2 *WORK 9 2 1 1 TRK
BMC50448I SORTOUT3 RDAMZL.BMC.EXBTS.SORTOUT3 *WORK 9 2 1 1 TRK
BMC50448I SORTOUT4 RDAMZL.BMC.EXBTS.SORTOUT4 *WORK 9 2 1 1 TRK
BMC50448I SORTOUT5 RDAMZL.BMC.EXBTS.SORTOUT5 *WORK 9 2 1 1 TRK
BMC50448I SORTOUT6 RDAMZL.BMC.EXBTS.SORTOUT6 *WORK 9 2 1 1 TRK
BMC50448I SORTOUT7 RDAMZL.BMC.EXBTS.SORTOUT7 *WORK 9 2 1 1 TRK
BMC50448I SORTOUT8 RDAMZL.BMC.EXBTS.SORTOUT8 *WORK 9 2 1 1 TRK
BMC50448I SORTOUT9 RDAMZL.BMC.EXBTS.SORTOUT9 *WORK 9 2 1 1 TRK
BMC50448I SORTWK01 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK02 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK03 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK04 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK05 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK06 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK07 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK08 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK09 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK10 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK11 *SYSALLDA 5 1 1 1 TRK
BMC50448I SORTWK12 *SYSALLDA 5 1 1 1 TRK
BMC50448I SYSDISC AMU.EXAMPL11.T145920.SYSDISC SYSALLDA 68 8 2 1 TRK
BMC50448I SYSERR RDAMZL.BMC.EXBTS.SYSERR SYSALLDA 145 1 3 1 TRK
BMC50448I SYSUT102 RDAMZL.BMC.EXBTS.SYSUT102 SYSALLDA 19 2 1 1 TRK
BMC50466W TEMPORARY DATASET NOT RECOMMENDED FOR DDNAME = 'SYSUT101'
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8408K, ABOVE 16M = 1282364K, CPUS = 3
BMC50479I TOTAL PAGES: 3827159, ALLOWED: 1148148; AVAILABLE PAGES: 296915, ALLOWED: 0
BMC51495I PRELOAD OPTIMIZATION, RC = 0, #SORTS = 9, #READERS = 1, INDEX TASKS = 1, TIME = 59648
BMC51495I PRELOAD OPTIMIZATION, RC = 14, #SORTS = 8, #READERS = 1, INDEX TASKS = 1, TIME = 66432
BMC51496I PRELOAD ANALYZE, #SORTS = 9, #READERS = 1, INDEX TASKS = 1
BMC50486I 11: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50481I 1: READ TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 1: READ TASK, XBLK XFERS = 6, EMPTY WAITS = 0, FULL WAITS = 0
BMC51478I PRELOAD STATISTICS: 854 PHYSICAL (854 LOGICAL) RECORDS READ FROM SYSREC
BMC50481I 2: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC50481I 9: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 9: SORT TASK, XBLK XFERS = 2, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 2: SORT TASK, XBLK XFERS = 0, EMPTY WAITS = 0, FULL WAITS = 0
BMC50481I 3: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 3: SORT TASK, XBLK XFERS = 2, EMPTY WAITS = 0, FULL WAITS = 0
BMC50481I 4: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 4: SORT TASK, XBLK XFERS = 2, EMPTY WAITS = 0, FULL WAITS = 0
BMC50481I 5: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 5: SORT TASK, XBLK XFERS = 2, EMPTY WAITS = 0, FULL WAITS = 0
BMC50481I 6: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC50481I 8: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC50481I 7: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 6: SORT TASK, XBLK XFERS = 2, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 8: SORT TASK, XBLK XFERS = 0, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 7: SORT TASK, XBLK XFERS = 2, EMPTY WAITS = 0, FULL WAITS = 0
BMC50481I 10: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 10: SORT TASK, XBLK XFERS = 0, EMPTY WAITS = 0, FULL WAITS = 0
BMC50481I 11: INDEX SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50481I 11: INDEX TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 11: INDEX TASK, XBLK XFERS = 6, EMPTY WAITS = 0, FULL WAITS = 2
BMC50476I DDNAME = SYSREC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT1, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT2, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT3, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT4, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT5, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT6, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT7, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT8, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT9, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSUT101, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSUT102, I/OS = 2, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC51507I XBLKS = 58, XFERS = 12, EMPTY WAITS = 0, FULL WAITS =2
BMC50476I DDNAME = SYSDISC, I/OS = 0, I/O WAITS = 0, RDB LOCK WAITS = 0
BMC51471I PRELOAD STATISTICS: 454 ROWS SELECTED FOR PARTITION 1
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A001' WILL REQUIRE 12 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A001' WILL REQUIRE 6 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 59 ROWS SELECTED FOR PARTITION 2
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A002' WILL REQUIRE 4 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A002' WILL REQUIRE 4 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 60 ROWS SELECTED FOR PARTITION 3
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A003' WILL REQUIRE 4 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A003' WILL REQUIRE 4 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 0 ROWS SELECTED FOR PARTITION 4
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A004' WILL REQUIRE 2 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A004' WILL REQUIRE 3 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 62 ROWS SELECTED FOR PARTITION 5
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A005' WILL REQUIRE 4 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A005' WILL REQUIRE 4 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 0 ROWS SELECTED FOR PARTITION 6
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A006' WILL REQUIRE 2 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A006' WILL REQUIRE 3 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 19 ROWS SELECTED FOR PARTITION 7
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A007' WILL REQUIRE 3 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A007' WILL REQUIRE 4 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 100 ROWS SELECTED FOR PARTITION 8
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A008' WILL REQUIRE 4 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A008' WILL REQUIRE 4 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 100 ROWS SELECTED FOR PARTITION 9
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A009' WILL REQUIRE 4 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A009' WILL REQUIRE 4 PAGES (APPROX.)
BMC51471I PRELOAD STATISTICS: 0 ROWS SELECTED FOR PARTITION 10
BMC51486I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A010' WILL REQUIRE 2 PAGES
BMC51490I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A010' WILL REQUIRE 3 PAGES (APPROX.)
BMC51488I LOADING OF DATASET 'DEHJCAT.DSNDBD.AMUEXBDB.IX1.I0001.A001' MAY REQUIRE 8 PAGES
BMC51472I PRELOAD PHASE STATISTICS: 854 ROWS SELECTED FOR SPACE 'AMUEXBDB.EXBTS', 0 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
BMC51479I PRELOAD PHASE STATISTICS: 0 PHYSICAL (0 LOGICAL) RECORDS DISCARDED TO SYSDISC
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I PRELOAD PHASE COMPLETE. ELAPSED TIME = 00:00:01
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8236K, ABOVE 16M = 1296868K, CPUS = 3
BMC50479I TOTAL PAGES: 3810073, ALLOWED: 1143022; AVAILABLE PAGES: 285851, ALLOWED: 0
BMC51498I LOAD OPTIMIZATION, RC = 0, #LOAD TASKS = 9, #COPY TASKS = 1, #INDEX TASKS = 2
BMC50370I STARTING 1 IMAGE COPY TASKS
BMC51508I MAX INDEX TASKS = 2, INDEXES PER TASK = 1, SORTWKS PER TASK = 12, MAX OPEN PARTITIONS PER TASK = 1
BMC51508I MAX DATA TASKS = 9, MAX PARTS PER TASK = 2, SORTWKS PER TASK = 0, MAX OPEN PARTITIONS PER TASK = 2
BMC51453I EXISTING ROWS IN TABLESPACE 'AMUEXBDB.EXBTS' DELETED
BMC50482I 2: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A008'
BMC50477I 2: PARTITION = 8, ROWS/KEYS = 100, I/O WAITS = 5 ,DDNAME = SYS00006
BMC50482I 1: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A007'
BMC50477I 1: PARTITION = 7, ROWS/KEYS = 19, I/O WAITS = 5 ,DDNAME = SYS00005
BMC51474I LOAD STATISTICS: 100 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 8
BMC50482I 3: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A001'
BMC50477I 3: PARTITION = 1, ROWS/KEYS = 454, I/O WAITS = 5 ,DDNAME = SYS00008
BMC51474I LOAD STATISTICS: 19 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 7
BMC51474I LOAD STATISTICS: 454 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 1
BMC50482I 4: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A005'
BMC50477I 4: PARTITION = 5, ROWS/KEYS = 62, I/O WAITS = 5 ,DDNAME = SYS00009
BMC51474I LOAD STATISTICS: 62 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 5
BMC50482I 5: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A009'
BMC50477I 5: PARTITION = 9, ROWS/KEYS = 100, I/O WAITS = 5 ,DDNAME = SYS00010
BMC51474I LOAD STATISTICS: 100 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 9
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A001'
BMC50477I 1: PARTITION = 1, ROWS/KEYS = 454, I/O WAITS = 6 ,DDNAME = SYS00007
BMC51474I BUILD STATISTICS: 454 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 1
BMC50476I DDNAME = SORTOUT1, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50482I 7: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A002'
BMC50477I 7: PARTITION = 2, ROWS/KEYS = 59, I/O WAITS = 5 ,DDNAME = SYS00011
BMC50486I 2: BMCSORT STARTED, 384K BELOW 16M, 1280K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51474I LOAD STATISTICS: 59 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 2
BMC50476I DDNAME = SORTOUT2, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT3, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT4, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT5, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50482I 7: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A003'
BMC50477I 7: PARTITION = 3, ROWS/KEYS = 60, I/O WAITS = 5 ,DDNAME = SYS00014
BMC51474I LOAD STATISTICS: 60 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 3
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A001'
BMC50476I DDNAME = SORTOUT6, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT7, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SORTOUT8, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A002'
BMC50476I DDNAME = SORTOUT9, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A003'
BMC50482I 0: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A004'
BMC50477I 0: PARTITION = 4, ROWS/KEYS = 0, I/O WAITS = 5 ,DDNAME = SYS00018
BMC51474I LOAD STATISTICS: 0 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 4
BMC50476I DDNAME = SYSUT102, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50481I 2: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A004'
BMC50482I 0: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A006'
BMC50477I 0: PARTITION = 6, ROWS/KEYS = 0, I/O WAITS = 5 ,DDNAME = SYS00020
BMC51474I LOAD STATISTICS: 0 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 6
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A005'
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A002'
BMC50477I 1: PARTITION = 2, ROWS/KEYS = 59, I/O WAITS = 7 ,DDNAME = SYS00012
BMC51474I BUILD STATISTICS: 59 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 2
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A006'
BMC50482I 0: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A010'
BMC50477I 0: PARTITION = 10, ROWS/KEYS = 0, I/O WAITS = 5 ,DDNAME = SYS00024
BMC51474I LOAD STATISTICS: 0 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS' PARTITION 10
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A007'
BMC51475I LOAD STATISTICS: 854 ROWS LOADED INTO TABLE SPACE 'AMUEXBDB.EXBTS'
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A008'
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A009'
BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEHJCAT.DSNDBD.AMUEXBDB.EXBTS.I0001.A010'
BMC50476I DDNAME = BMCCPY, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCCPZ, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCY, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
BMC50476I DDNAME = BMCRCZ, I/OS = 1, I/O WAITS = 0, RDB LOCK WAITS = 0
BMC50376I 41 PAGES COPIED TO DATASET = 'AMU.EXAMP011.LOCPFCPY.BMCCPY.G0041V00'
BMC50376I 41 PAGES COPIED TO DATASET = 'AMU.EXAMP011.LOCBFCPY.BMCCPZ.G0040V00'
BMC50376I 41 PAGES COPIED TO DATASET = 'AMU.EXAMP011.REMPFCPY.BMCRCY.G0040V00'
BMC50376I 41 PAGES COPIED TO DATASET = 'AMU.EXAMP011.REMBFCPY.BMCRCZ.G0040V00'
BMC50482I 2: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX1.I0001.A001'
BMC50477I 2: PARTITION = 0, ROWS/KEYS = 854, I/O WAITS = 7 ,DDNAME = SYS00021
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A003'
BMC50477I 1: PARTITION = 3, ROWS/KEYS = 60, I/O WAITS = 7 ,DDNAME = SYS00026
BMC51474I BUILD STATISTICS: 60 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 3
BMC51476I BUILD STATISTICS: 854 KEYS LOADED INTO INDEX 'EXAMPLEB.IX1'
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A005'
BMC50477I 1: PARTITION = 5, ROWS/KEYS = 62, I/O WAITS = 7 ,DDNAME = SYS00031
BMC51474I BUILD STATISTICS: 62 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 5
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A007'
BMC50477I 1: PARTITION = 7, ROWS/KEYS = 19, I/O WAITS = 7 ,DDNAME = SYS00032
BMC51474I BUILD STATISTICS: 19 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 7
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A008'
BMC50477I 1: PARTITION = 8, ROWS/KEYS = 100, I/O WAITS = 7 ,DDNAME = SYS00033
BMC51474I BUILD STATISTICS: 100 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 8
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A009'
BMC50477I 1: PARTITION = 9, ROWS/KEYS = 100, I/O WAITS = 7 ,DDNAME = SYS00034
BMC51474I BUILD STATISTICS: 100 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 9
BMC50476I DDNAME = SYSUT101, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A004'
BMC50477I 1: PARTITION = 4, ROWS/KEYS = 0, I/O WAITS = 7 ,DDNAME = SYS00035
BMC51474I BUILD STATISTICS: 0 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 4
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A006'
BMC50477I 1: PARTITION = 6, ROWS/KEYS = 0, I/O WAITS = 7 ,DDNAME = SYS00036
BMC51474I BUILD STATISTICS: 0 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 6
BMC50482I 1: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEHJCAT.DSNDBD.AMUEXBDB.IX0.I0001.A010'
BMC50477I 1: PARTITION = 10, ROWS/KEYS = 0, I/O WAITS = 7 ,DDNAME = SYS00037
BMC51474I BUILD STATISTICS: 0 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0' PARTITION 10
BMC51476I BUILD STATISTICS: 854 KEYS LOADED INTO INDEX 'EXAMPLEB.IX0'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR ', DSNAME = 'RDAMZL.BMC.EXBTS.SYSERR'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK01', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338313'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK02', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338314'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK03', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338315'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK04', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338316'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK05', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338317'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK06', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338318'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK07', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338319'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK08', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338320'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK09', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338321'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK10', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338322'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK11', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338323'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK12', DSNAME = 'SYS15068.T145924.RA000.AMUEX11.R0338324'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT101', DSNAME = 'AMU.EXAMP011.SYSUT101'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT102', DSNAME = 'RDAMZL.BMC.EXBTS.SYSUT102'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT9', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT9'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT8', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT8'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT7', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT7'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT6', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT6'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT5', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT5'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT4', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT4'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT3', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT3'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT2', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT2'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTOUT1', DSNAME = 'RDAMZL.BMC.EXBTS.SORTOUT1'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR ', DSNAME = 'AMU.EXAMP011.SYSERR'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I LOAD PHASE COMPLETE. ELAPSED TIME = 00:00:07
BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR LOAD UTILITY SUCCESSFUL FOR ALL OBJECTS
BMC50004I UTILTERM PHASE COMPLETE. ELAPSED TIME = 00:00:11
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0
Related topics
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*