Example 12 — LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY of a partitioned table space
In this example, LOADPLUS uses one of the online load options to load data into a table space that has five partitions.
The LOAD command statement includes the SHRLEVEL CHANGE SQLAPPLY option, which overrides the SHRLEVEL=(NONE,NONE) installation option value.
SYSPRINT A (Output from ORDER NO (example 12A)) shows the output when this job is run with ORDER NO. Because ORDER NO is specified, LOADPLUS sorts only error information for this type of load.
For the second part of this example, the LOAD command is changed to specify ORDER YES. In addition, the EXEC statement in the JCL includes an options module that activates dynamic data set allocation for all data sets by specifying ACTIVE YES for each DDTYPE.
The LOAD command provides the following overrides for dynamic allocation:
- Specifying ENUMROWS 100000 overrides the AUTOENUMROWS=YES installation option and estimates that LOADPLUS will load 100000 rows.
- The DSNPAT command option overrides the pattern for the work file data set names.
- The DELETEFILES YES SYSDISC YES option tells LOADPLUS to delete the work files and SYSDISC file after the load completes.
SYSPRINT B (Output from ORDER YES with dynamic allocation (example 12B)) shows the output from the ORDER YES job.
In both jobs, message 50041I indicates the status of zIIP processing. For this example, the ZIIP installation option is ENABLED, but an XBM subsystem was not specified. LOADPLUS automatically located an available XBM subsystem to provide zIIP processing.
Note the BMC51576 messages, which return information from the High-speed Apply Engine. The High-speed Apply Engine message numbers (for example, APT0166I) are displayed to the right of the BMC51576 message number and timestamp. For message explanations, access the BMC Documentation Center from the BMC Support Central site (http://www.bmc.com/support).
In both jobs, High-speed Apply Engine message APT0166I displays a report of the number of SQL statements (for LOADPLUS, these will always be INSERT statements) committed per agent. Because the value of the APMULTIROW installation option is 100, each INSERT statement contains 100 input rows. Therefore, the number of statements committed is the number of input rows divided by 100.
Although the value of the COPYPEND default installation option is YES, LOADPLUS does not set COPY pending because COPYPEND YES is ignored for an SQLAPPLY load job.
The following figure shows the JCL for example 12A:
//EXAMP12A EXEC PGM=AMUUMAIN,
// PARM='&SSID,EXAM12A,NEW ,,MSGLEVEL(1),AMU$OPTO'
//* SSID,UTILID ,RSTART,NOTIFY,MSGLEVEL
//STEPLIB DD DISP=SHR,DSN=product.libraries
// DD DISP=SHR,DSN=DB2.DSNEXIT
// DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//APTDUMP DD SYSOUT=*
//SYSREC DD DSN=AMU.QA.RGRTESTS.DTAEX12,DISP=SHR
//SYSERR DD DSN=AMU.EXAMP12A.SYSERR,
// DISP=(MOD,CATLG),
// UNIT=WORK,SPACE=(CYL,(5,2),RLSE)
//SYSDISC DD DSN=AMU.EXAMP12A.SYSDISC,
// DISP=(NEW,CATLG),
// UNIT=WORK,SPACE=(CYL,(10,01),RLSE)
//SYSIN DD *
LOAD DATA RESUME YES
SHRLEVEL CHANGE SQLAPPLY
ORDER NO
INTO TABLE EXAMPLEC.TBL1
(RECNO POS(1:4) INTEGER,
INPUT_A POS(5:14) CHAR(10),
RECNO2 POS(15:18) INTEGER,
INPUT_B POS(19:28) CHAR(10),
INPUT_C POS(29:43) CHAR(15),
INPUT_D POS(44:58) CHAR(15)
)
//*
// PARM='&SSID,EXAM12A,NEW ,,MSGLEVEL(1),AMU$OPTO'
//* SSID,UTILID ,RSTART,NOTIFY,MSGLEVEL
//STEPLIB DD DISP=SHR,DSN=product.libraries
// DD DISP=SHR,DSN=DB2.DSNEXIT
// DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//APTDUMP DD SYSOUT=*
//SYSREC DD DSN=AMU.QA.RGRTESTS.DTAEX12,DISP=SHR
//SYSERR DD DSN=AMU.EXAMP12A.SYSERR,
// DISP=(MOD,CATLG),
// UNIT=WORK,SPACE=(CYL,(5,2),RLSE)
//SYSDISC DD DSN=AMU.EXAMP12A.SYSDISC,
// DISP=(NEW,CATLG),
// UNIT=WORK,SPACE=(CYL,(10,01),RLSE)
//SYSIN DD *
LOAD DATA RESUME YES
SHRLEVEL CHANGE SQLAPPLY
ORDER NO
INTO TABLE EXAMPLEC.TBL1
(RECNO POS(1:4) INTEGER,
INPUT_A POS(5:14) CHAR(10),
RECNO2 POS(15:18) INTEGER,
INPUT_B POS(19:28) CHAR(10),
INPUT_C POS(29:43) CHAR(15),
INPUT_D POS(44:58) CHAR(15)
)
//*
The following figure shows the JCL for example 12B:
//EXAMP12B EXEC PGM=AMUUMAIN,
// PARM='&SSID,EXAM12B,NEW ,,MSGLEVEL(1),AMU$OPTE'
//* 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=*
//APTDUMP DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSREC DD DSN=AMU.QA.RGRTESTS.DTAEX12,DISP=SHR
//SYSIN DD *
LOAD DATA RESUME YES
SHRLEVEL CHANGE
ENUMROWS(100000)
ORDER YES
DDTYPE LOAD DSNPAT '&UID..RESUME&RESUME.&DDNAME'
DDTYPE WORK DSNPAT '&UID..RESUME&RESUME.&DDNAME'
DDTYPE SORTWORK DSNPAT '&UID..RESUME&RESUME.&DDNAME'
DDTYPE DISCARD DSNPAT '&UID..RESUME&RESUME.&DDNAME'
DDTYPE ERROR DSNPAT '&UID..RESUME&RESUME.&DDNAME'
DELETEFILES YES SYSDISC YES
INTO TABLE EXAMPLEC.TBL1
(RECNO POS(1:4) INTEGER,
INPUT_A POS(5:14) CHAR(10),
RECNO2 POS(15:18) INTEGER,
INPUT_B POS(19:28) CHAR(10),
INPUT_C POS(29:43) CHAR(15),
INPUT_D POS(44:58) CHAR(15)
)
// PARM='&SSID,EXAM12B,NEW ,,MSGLEVEL(1),AMU$OPTE'
//* 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=*
//APTDUMP DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSREC DD DSN=AMU.QA.RGRTESTS.DTAEX12,DISP=SHR
//SYSIN DD *
LOAD DATA RESUME YES
SHRLEVEL CHANGE
ENUMROWS(100000)
ORDER YES
DDTYPE LOAD DSNPAT '&UID..RESUME&RESUME.&DDNAME'
DDTYPE WORK DSNPAT '&UID..RESUME&RESUME.&DDNAME'
DDTYPE SORTWORK DSNPAT '&UID..RESUME&RESUME.&DDNAME'
DDTYPE DISCARD DSNPAT '&UID..RESUME&RESUME.&DDNAME'
DDTYPE ERROR DSNPAT '&UID..RESUME&RESUME.&DDNAME'
DELETEFILES YES SYSDISC YES
INTO TABLE EXAMPLEC.TBL1
(RECNO POS(1:4) INTEGER,
INPUT_A POS(5:14) CHAR(10),
RECNO2 POS(15:18) INTEGER,
INPUT_B POS(19:28) CHAR(10),
INPUT_C POS(29:43) CHAR(15),
INPUT_D POS(44:58) CHAR(15)
)
Output from ORDER NO (example 12A)The following figure shows the SYSPRINT output for example 12A:
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 15:00:58 ...
BMC50002I UTILITY ID = 'EXAM12A'. DB2 SUBSYSTEM ID = 'DEHJ'. OPTION MODULE = 'AMU$OPTO'.
BMC50471I z/OS 2.1.0,PID=HBB7790,DFSMS FOR Z/OS=2.1.0,DB2=11.1.0
BMC50471I REGION=0M,BELOW 16M=8816K,ABOVE 16M=1306040K,IEFUSI=NO,CPUS=3
BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040308M,MEMLIMIT SET BY:REGION=0
0
BMC50471I LOADPLUS FOR DB2--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I SOLUTION COMMON CODE--V11.01.00
BMC50471I MAINT: BPJ0661 BPJ0667 BPJ0671 BPJ0674 BPJ0675 BPJ0676 BPJ0682 BPJ0686 BPJ0689 BPJ0697 BPJ0700 BPJ0702
BMC50471I BPJ0703 BPJ0706 BPJ0712 BPJ0715 BPJ0729 BPJ0773 BPJ0786 BPJ0794 BPJ0806 BPJ0830 BPJ0833 BPJ0839
BMC50471I BPJ0845 BPJ0866 BPJ0892 BPJ0913 BPJ0914 BPJ0916 BPJ0930 BPJ0944 BPJ0946
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922
BMC50471I BMC STATS API--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.01.00
BMC50471I MAINT: BPE0401 BPE0403 BPE0405 BPE0407 BPE0410 BPE0412 BPE0416 BPE0420 BPE0422 BPE0423 BPE0426 BPE0428
BMC50471I BPE0430 BPE0433 BPE0435 BPE0438 BPE0439
BMC50471I HIGH-SPEED APPLY ENGINE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
0
BMC50471I APCOMMIT=2500 FORCE_AT=(START,3) RCVYDDN=(BMCRCY,BMCRCZ)
BMC50471I APDOPTS= FORCE_RPT=NO REDEFINE=YES
BMC50471I APMULTIROW=100 FORCE=NONE RENMMAX=30
BMC50471I APMXAGNT=10 IBUFFS=20 RULES=STANDARD
BMC50471I APRETLIM=COUNT IDCACHE=1000 SDUMP=YES
BMC50471I APRETVAL=5 IDCDDN=SYSIDCIN SHORTMEMORY=CONTINUE
BMC50471I AUTOENUMROWS=YES IDERROR=DISCARD SHRLEVEL=(NONE,NONE)
BMC50471I AVAILPAGEPCT=0 INDDN=SYSREC SMAX=16
BMC50471I CBUFFS=30 INFORI=NO SMCORE=(0K,0K)
BMC50471I CENTURY=(1950,2049) INLINECP=YES SORTDEVT=(,SYSALLDA)
BMC50471I CHEKPEND=YES KEEPDICTIONARY=NO SORTNUM=32
BMC50471I COPYDDN=(BMCCPY,BMCCPZ) LBUFFS=20 SQLDELAY=3
BMC50471I COPYLVL=FULL LOADDN=SORTOUT SQLRETRY=100
BMC50471I COPYPEND=YES LOBAVGPCT=50 STOP@CMT=YES
BMC50471I COPYSUBSET=NO LOCKROW=YES STOPDELAY=1
BMC50471I DELFILES=(YES,NO) LONGNAMETRUNC=MIDDLE STOPRETRY=300
BMC50471I DISCARDLIMRC=8 MAPDDN=SYSMAP TAPEDISP=DELETE
BMC50471I DISCARDRC=0 MAXP=5 TOTALPAGEPCT=30
BMC50471I DISCDDN=SYSDISC MAXSORTMEMORY=0 TSSAMPLEPCT=100
BMC50471I DRNDELAY=1 MAXTAPE=3 UPDMAXA_AUTHID=USER
BMC50471I DRNRETRY=255 MGEXTENT=CONTINUE UPDMAXA=NO
BMC50471I DRNWAIT=NONE MINSORTMEMORY=0 UXSTATE=SUP
BMC50471I DSNUEXIT=(NONE,ASM) MSGLEVEL=1 WBUFFS=(20,10)
BMC50471I DSNUTILB=YES OPNDB2ID=YES WORKDDN=SYSUT1
BMC50471I ENFORCE=CHECK ORIGDISP=DELETE WORKUNIT=SYSALLDA
BMC50471I ERRDDN=SYSERR PAUSEDISCARDRC=4 XBLKS=3
BMC50471I EXCLDUMP=(X37,X22,X06) PLAN=AMUQA XMLAVGSIZE=10240
BMC50471I FASTSWITCH=NO PREFORMAT=NO ZEROROWRC=0
BMC50471I FILECHK=WARN PRELOAD=LOAD ZIIP=ENABLED
0
BMC50471I APCOLLECTION=
BMC50471I APOWNER=
0
BMC50470I DDTYPE = LOAD WORK SORTWORK
BMC50470I ACTIVE = YES YES NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) N/A
BMC50470I VOLCNT = (25,25) (25,25) N/A
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) N/A
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) N/A
BMC50470I EXPDT = N/A N/A N/A
BMC50470I RETPD = N/A N/A N/A
BMC50470I GDGLIMIT = N/A N/A N/A
BMC50470I GDGEMPTY = N/A N/A N/A
BMC50470I GDGSCRAT = N/A N/A N/A
0
BMC50470I DDTYPE = ERROR DISCARD LOCPFCPY
BMC50470I ACTIVE = YES YES YES
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = N/A N/A 5
BMC50470I GDGEMPTY = N/A N/A NO
BMC50470I GDGSCRAT = N/A N/A NO
0
BMC50470I DDTYPE = LOCBFCPY REMPFCPY REMBFCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = SYSMAP LOCPLCPY LOCBLCPY
BMC50470I ACTIVE = YES YES NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT = N/A
BMC50470I RETPD = N/A
BMC50470I GDGLIMIT = N/A 5 5
BMC50470I GDGEMPTY = N/A NO NO
BMC50470I GDGSCRAT = N/A NO NO
0
BMC50470I DDTYPE = REMPLCPY REMBLCPY LOCPXCPY
BMC50470I ACTIVE = NO NO YES
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = LOCBXCPY REMPXCPY REMBXCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50483I LOAD DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I WORK DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I SORTWORK DSNPAT=NONE
BMC50483I ERROR DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I DISCARD DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I SYSMAP DSNPAT=&UID..BMC.&TS.&DDNAME
0
BMC50483I LOCPFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I LOCBFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMPFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMBFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
BMC50483I LOCPLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I LOCBLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I REMPLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I REMBLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
0
BMC50483I LOCPXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I LOCBXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMPXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMBXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
BMC50471I DB2 DSNHDECP MODULE SETTINGS:
BMC50471I VERSION = 1110
BMC50471I SUBSYSTEM DEFAULT = DEHJ
BMC50471I CHARACTER SET = ALPHANUM
BMC50471I DATE FORMAT = USA
BMC50471I TIME FORMAT = USA
BMC50471I LOCAL DATE LENGTH = 0
BMC50471I LOCAL TIME LENGTH = 0
BMC50471I DECIMAL POINT = PERIOD
BMC50471I DECIMAL ARITHMETIC = 15
BMC50471I DELIMITER = DEFAULT
BMC50471I SQL DELIMITER = DEFAULT
BMC50471I ENCODING SCHEME = EBCDIC
BMC50471I APPL. ENCODING SCHEME = EBCDIC
BMC50471I MIXED = NO
BMC50471I EBCDIC CCSID = (37,65534,65534)
BMC50471I ASCII CCSID = (819,65534,65534)
BMC50471I UNICODE CCSID = (367,1208,1200)
BMC50471I IMPLICIT TIME ZONE = CURRENT (-05:00)
BMC50028I DB2 MODE = NFM
BMC50471I BMC_BMCUTIL ='BMCUTIL.CMN_BMCUTIL'
BMC50471I BMC_BMCSYNC ='BMCUTIL.CMN_BMCSYNC'
BMC50471I BMC_BMCHIST ='BMCUTIL.CMN_BMCHIST'
BMC50471I BMC_BMCDICT ='BMCUTIL.CMN_BMCDICT'
0
0
BMC50102I LOAD DATA RESUME YES
BMC50102I SHRLEVEL CHANGE SQLAPPLY
BMC50102I ORDER NO
BMC50102I INTO TABLE EXAMPLEC.TBL1
BMC50102I (RECNO POS(1:4) INTEGER,
BMC50102I INPUT_A POS(5:14) CHAR(10),
BMC50102I RECNO2 POS(15:18) INTEGER,
BMC50102I INPUT_B POS(19:28) CHAR(10),
BMC50102I INPUT_C POS(29:43) CHAR(15),
BMC50102I INPUT_D POS(44:58) CHAR(15)
BMC50102I )
BMC51424I ANALYZE PHASE WILL BE PERFORMED DUE TO DYNAMIC WORK FILE ALLOCATION
BMC51561I CALCULATED NUMBER OF INPUT RECORDS = 203829 USING A SCALING FACTOR OF 100%
BMC50004I UTILINIT PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I ANALYZE PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50425I &JOBNAME = AMUEX12 &STEPNAME = EXAMP12A &DB = AMUEXCDB &TS = EXCTS &UID = RDAMZL
BMC50425I &RESUME = Y &REPLACE = N &DATE = 030915 &TIME = 150058 &SSID = DEHJ
BMC50425I &UTIL = EXAM12A &UTILPFX = EXAM12A &UTILSFX = &DATE8 = 03092015 &GRPNM = DEHJ
BMC50425I &VCAT = DEHJCAT &TIME4 = 1500 &DATEJ = 2015068 &JDATE = 15068
BMC50445I LOAD PLUS DYNAMIC FILE ALLOCATION REPORT
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8476K, ABOVE 16M = 1299480K, CPUS = 3
BMC50479I TOTAL PAGES: 3736000, ALLOWED: 1120800; AVAILABLE PAGES: 238278, ALLOWED: 0
BMC51499I COMBINED OPTIMIZATION, RC=0, #SORTS=5, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=88012
BMC51499I COMBINED OPTIMIZATION, RC=20, #SORTS=4, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=89088
BMC51500I COMBINED ANALYZE, #SORTS=5, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0
BMC51576I 15:01:01 000 APT0000I HIGH-SPEED APPLY ENGINE V11.02.00
BMC51576I Copyright (c) 1999-2015 BMC Software, Inc. as an unpublished licensed work. All rights reserved.
BMC51576I 15:01:01 000 APT0001I Date: Mon Mar 9, 2015
BMC51576I 15:01:02 000 APT0215I MAINT: HIGH-SPEED APPLY ENGINE V11.02.00
BMC51576I 15:01:02 000 APT0215I MAINT: NONE APPLIED
BMC51576I 15:01:02 000 APT0215I MAINT: SOLUTION COMMON CODE V11.01.00
BMC51576I 15:01:02 000 APT0215I MAINT: BPJ0661 BPJ0667 BPJ0671 BPJ0674 BPJ0675 BPJ0676 BPJ0682
BMC51576I 15:01:02 000 APT0215I MAINT: BPJ0686 BPJ0689 BPJ0697 BPJ0700 BPJ0702 BPJ0703 BPJ0706
BMC51576I 15:01:02 000 APT0215I MAINT: BPJ0712 BPJ0715 BPJ0729 BPJ0773 BPJ0786 BPJ0794 BPJ0806
BMC51576I 15:01:02 000 APT0215I MAINT: BPJ0830 BPJ0833 BPJ0839 BPJ0845 BPJ0866 BPJ0892 BPJ0913
BMC51576I 15:01:02 000 APT0215I MAINT: BPJ0914 BPJ0916 BPJ0930 BPJ0944 BPJ0946
BMC51576I 15:01:02 000 APT0215I MAINT: BMCSORT ENGINE V02.04.01
BMC51576I 15:01:02 000 APT0215I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922
BMC51576I 15:01:02 000 APT0085I /STARTUP/
BMC51576I SSID=DEHJ
BMC51576I INPUTTYPE={3895D640-0BF1-11D4-8027-00104B39B10F}
BMC51576I PLANNAME=APTBREL
BMC51576I BINDQUALIFIER=APTTEST
BMC51576I DBMSTYPE=DB2
BMC51576I DISTRIBUTIONTYPE=OBJECT
BMC51576I LARGESTATEMENTSUPPORT=NO
BMC51576I 15:01:02 000 APT0085I /CONFIGURATION/
BMC51576I FILENAME=NONE
BMC51576I 15:01:02 000 APT0085I /SQL/
BMC51576I FORMAT=PACKED72
BMC51576I 15:01:02 000 APT0085I /COMMITTRIGGERS/
BMC51576I STATEMENTCOUNT=2500
BMC51576I COMMITONDEMAND=NO
BMC51576I 15:01:02 000 APT0085I /OBJECTMAP/
BMC51576I SOURCETABLE=0X1086.0X0003
BMC51576I TARGETTABLE='EXAMPLEC'.'TBL1'
BMC51576I 15:01:02 000 APT0085I /AGENT/
BMC51576I MAXAGENTS=10
BMC51576I INITIALAGENTS=5
BMC51576I MAXPREPARES=50
BMC51576I 15:01:02 000 APT0085I /TEMPORARYFILES/
BMC51576I UNIT=SYSALLDA
BMC51576I 15:01:02 000 APT0085I /DIAGNOSTICOUTPUT/
BMC51576I FILENAME=APTDIAG
BMC51576I 15:01:02 000 APT0085I /RESTART/
BMC51576I RESTARTID=EXAM12A
BMC51576I RESTARTTYPE=NEW
BMC51576I CHECKPOINTFREQUENCY=0
BMC51576I TABLENAME=BMCAPT_APTRSCL
BMC51576I RETAINTIME=7
BMC51576I RETRY=3
BMC51576I 15:01:02 000 APT0085I /DISTRIBUTIONTUNING/
BMC51576I SIMPLETSCLUSTERING=NO
BMC51576I RICLUSTERING=NO
BMC51576I PARTITIONCLUSTERING=NO
BMC51576I URCHECKRI=YES
BMC51576I 15:01:02 000 APT0085I /ANYCONFLICT/
BMC51576I CODE=-803
BMC51576I ACTION=CALLBACK
BMC51576I ACTION=CONTINUE
BMC51576I CODE=-530
BMC51576I ACTION=CALLBACK
BMC51576I ACTION=CONTINUE
BMC51576I CODE=-359
BMC51576I ACTION=CALLBACK
BMC51576I ACTION=CONTINUE
BMC51576I CODE=-330
BMC51576I ACTION=CALLBACK
BMC51576I ACTION=CONTINUE
BMC51576I CODE=SQLWARN0
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN1
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN2
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN3
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN4
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN5
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN6
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN7
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN8
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN9
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARNA
BMC51576I ACTION=WARN
BMC51576I CODE=NEGATIVE
BMC51576I ACTION=ABORT
BMC51576I CODE=POSITIVE
BMC51576I ACTION=WARN
BMC51576I CODE=MULTIPLEROWS
BMC51576I ACTION=WARN
BMC51576I CODE=NOROWS
BMC51576I ACTION=WARN
BMC51576I CODE=TIMEOUT
BMC51576I ACTION=RETRY
BMC51576I 15:01:03 000 APT0085I /INSERTCONFLICT/
BMC51576I CODE=MULTIROWCONFLICT
BMC51576I ACTION=RETRY
BMC51576I 15:01:03 000 APT0085I /CONFLICT/
BMC51576I RETRYLIMIT=COUNT
BMC51576I RETRYVALUE=5
BMC51576I DATATYPE=ID
BMC51576I DATATYPE=SQLCODE
BMC51576I DATATYPE=MESSAGE
BMC51576I RETRYFAIL=ABORT
BMC51576I RETRYDELAY=0
BMC51576I MAXFAILEDRETRIES=5
BMC51576I 15:01:03 000 APT0085I /CONFLICTFILE/
BMC51576I SPACE=TRACK
BMC51576I SPACEPRI=15
BMC51576I SPACESEC=5
BMC51576I FILENAMEMODEL=&SYSUID..BMCAPT.&REQUESTID..D&DATE..T&TIME.
BMC51576I SINGLEFILE=NO
BMC51576I DISP=NEW
BMC51576I MEDIATYPE=FILE
BMC51576I RELEASE=YES
BMC51576I 15:01:03 000 APT0085I /BIND/
BMC51576I FREEOPTION=ALL
BMC51576I PLANPREFIX=APT
BMC51576I 15:01:03 000 APT0085I /BINDTUNING/
BMC51576I STATEMENTCOUNT=1
BMC51576I MAXPACKAGES=25
BMC51576I MAXFAILEDBINDS=5
BMC51576I MAXRETRIES=5
BMC51576I PACKAGEUSAGE=500
BMC51576I STATEMENTUSAGE=200
BMC51576I 15:01:03 000 APT0085I /MULTIROWINSERT/
BMC51576I MULTIROWINSERT=YES
BMC51576I MAXROWS=100
BMC51576I 15:01:03 001 APT0252I zIIP processing enabled using XBM SSID XBMB (v6.2.00)
BMC51576I 15:01:03 001 APT0238I Successful connect to DEHJ (Release 1110(NFM ) of DB2)
BMC51576I 15:01:04 001 APT0236I High-speed Apply starting with Multi-Row Inserts
BMC51576I 15:01:05 001 APT0097I Request ID: ACAG Restart ID: EXAM12A
BMC51576I 15:01:06 000 APT0019I File DBRMLIB :SYS15068.T150106.RA000.AMUEX12.R0338590 allocated - elapsed time: 00:00:00
BMC51576I 15:01:06 001 APT0032I DSN output follows:
BMC51576I DSNT252I *DEHJ DSNTBCM1 BIND OPTIONS FOR PLAN APTACAG
BMC51576I ACTION ADD
BMC51576I OWNER RDAMZL
BMC51576I VALIDATE RUN
BMC51576I ISOLATION CS
BMC51576I ACQUIRE USE
BMC51576I RELEASE COMMIT
BMC51576I EXPLAIN NO
BMC51576I DYNAMICRULES RUN
BMC51576I PROGAUTH DISABLE
BMC51576I DSNT253I *DEHJ DSNTBCM1 BIND OPTIONS FOR PLAN APTACAG
BMC51576I NODEFER PREPARE
BMC51576I CACHESIZE 3072
BMC51576I QUALIFIER RDAMZL
BMC51576I CURRENTSERVER
BMC51576I CURRENTDATA NO
BMC51576I DEGREE 1
BMC51576I SQLRULES DB2
BMC51576I DISCONNECT EXPLICIT
BMC51576I REOPT NONE
BMC51576I KEEPDYNAMIC YES
BMC51576I IMMEDWRITE NO
BMC51576I DBPROTOCOL DRDA
BMC51576I OPTHINT
BMC51576I ENCODING EBCDIC(00037)
BMC51576I CONCURRENTACCESSRESOLUTION
BMC51576I
BMC51576I PATH
BMC51576I DSNT200I *DEHJ BIND FOR PLAN APTACAG SUCCESSFUL
BMC51576I 15:01:06 001 APT0032I DSN output follows:
BMC51576I DSNT254I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I ACTION ADD
BMC51576I OWNER RDAMZL
BMC51576I QUALIFIER RDAMZL
BMC51576I VALIDATE RUN
BMC51576I EXPLAIN NO
BMC51576I ISOLATION CS
BMC51576I RELEASE COMMIT
BMC51576I COPY
BMC51576I APREUSE
BMC51576I APCOMPARE
BMC51576I APRETAINDUP
BMC51576I BUSTIMESENSITIVE YES
BMC51576I SYSTIMESENSITIVE YES
BMC51576I ARCHIVESENSITIVE YES
BMC51576I APPLCOMPAT V11R1
BMC51576I DSNT255I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I SQLERROR NOPACKAGE
BMC51576I CURRENTDATA NO
BMC51576I DEGREE 1
BMC51576I DYNAMICRULES
BMC51576I DEFER
BMC51576I REOPT NONE
BMC51576I KEEPDYNAMIC YES
BMC51576I IMMEDWRITE NO
BMC51576I DBPROTOCOL DRDA
BMC51576I OPTHINT
BMC51576I ENCODING EBCDIC(00037)
BMC51576I PLANMGMT OFF
BMC51576I PLANMGMTSCOPE STATIC
BMC51576I CONCURRENTACCESSRESOLUTION
BMC51576I
BMC51576I EXTENDEDINDICATOR
BMC51576I
BMC51576I PATH
BMC51576I DSNT275I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I QUERYACCELERATION
BMC51576I GETACCELARCHIVE
BMC51576I DSNT232I *DEHJ SUCCESSFUL BIND FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I 15:01:07 006 APT0079I High-speed Apply processing started - Agent: 1
BMC51576I 15:01:07 007 APT0079I High-speed Apply processing started - Agent: 2
BMC51576I 15:01:07 008 APT0079I High-speed Apply processing started - Agent: 3
BMC51576I 15:01:07 009 APT0079I High-speed Apply processing started - Agent: 4
BMC51576I 15:01:07 010 APT0079I High-speed Apply processing started - Agent: 5
BMC51576I 15:01:07 001 APT0148I Bind started for package ACAG0001 - Trigger statistics:
BMC51576I STATEMENTCOUNT...........................1
BMC51576I PACKAGEUSAGE.............................1
BMC51576I STATEMENTUSAGE...........................1
BMC51576I 15:01:07 001 APT0032I DSN output follows:
BMC51576I DSNT254I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I ACTION ADD
BMC51576I OWNER RDAMZL
BMC51576I QUALIFIER RDAMZL
BMC51576I VALIDATE RUN
BMC51576I EXPLAIN NO
BMC51576I ISOLATION CS
BMC51576I RELEASE COMMIT
BMC51576I COPY
BMC51576I APREUSE
BMC51576I APCOMPARE
BMC51576I APRETAINDUP
BMC51576I BUSTIMESENSITIVE YES
BMC51576I SYSTIMESENSITIVE YES
BMC51576I ARCHIVESENSITIVE YES
BMC51576I APPLCOMPAT V11R1
BMC51576I DSNT255I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I SQLERROR NOPACKAGE
BMC51576I CURRENTDATA NO
BMC51576I DEGREE 1
BMC51576I DYNAMICRULES
BMC51576I DEFER
BMC51576I REOPT NONE
BMC51576I KEEPDYNAMIC YES
BMC51576I IMMEDWRITE NO
BMC51576I DBPROTOCOL DRDA
BMC51576I OPTHINT
BMC51576I ENCODING EBCDIC(00037)
BMC51576I PLANMGMT OFF
BMC51576I PLANMGMTSCOPE STATIC
BMC51576I CONCURRENTACCESSRESOLUTION
BMC51576I
BMC51576I EXTENDEDINDICATOR
BMC51576I
BMC51576I PATH
BMC51576I DSNT275I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I QUERYACCELERATION
BMC51576I GETACCELARCHIVE
BMC51576I DSNT232I *DEHJ SUCCESSFUL BIND FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC50481I 1: READ TASK COMPLETE. ELAPSED TIME = 00:00:07
BMC51510I 1: READ TASK, XBLK XFERS = 130, EMPTY WAITS = 102, FULL WAITS = 0
BMC51478I PRELOAD STATISTICS: 100000 PHYSICAL (100000 LOGICAL) RECORDS READ FROM SYSREC
BMC51480I 3: DATA TASK COMPLETE. ELAPSED TIME = 00:00:07. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51510I 3: SORT TASK, XBLK XFERS = 26, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 3: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 43, FULL WAITS = 0
BMC51480I 4: DATA TASK COMPLETE. ELAPSED TIME = 00:00:07. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51480I 2: DATA TASK COMPLETE. ELAPSED TIME = 00:00:07. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51510I 2: SORT TASK, XBLK XFERS = 26, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 2: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 28, FULL WAITS = 0
BMC51510I 4: SORT TASK, XBLK XFERS = 26, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 4: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 43, FULL WAITS = 0
BMC51480I 6: DATA TASK COMPLETE. ELAPSED TIME = 00:00:07. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51510I 6: SORT TASK, XBLK XFERS = 26, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 6: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 43, FULL WAITS = 0
BMC51480I 5: DATA TASK COMPLETE. ELAPSED TIME = 00:00:07. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51510I 5: SORT TASK, XBLK XFERS = 26, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 5: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 42, FULL WAITS = 0
BMC51576I 15:01:07 001 APT0118I Input statements processed: 100000 Statement ID: 000186A000004E200003000501000186A0
BMC51576I 15:01:07 001 APT0066I Input processing complete
BMC51576I 15:01:08 001 APT0185I Statements committed: 12500
BMC51576I 15:01:09 001 APT0185I Statements committed: 65000
BMC51576I 15:01:09 010 APT0080I High-speed Apply processing ended - Agent: 5
BMC51576I 15:01:09 009 APT0080I High-speed Apply processing ended - Agent: 4
BMC51576I 15:01:09 006 APT0080I High-speed Apply processing ended - Agent: 1
BMC51576I 15:01:09 008 APT0080I High-speed Apply processing ended - Agent: 3
BMC51576I 15:01:09 007 APT0080I High-speed Apply processing ended - Agent: 2
BMC51576I 15:01:10 001 APT0185I Statements committed: 100000
BMC51576I 15:01:10 001 APT0047I TABLE STATISTICS - EXAMPLEC.TBL1
BMC51576I AGENT ASSIGNBY INSERT UPDATE DELETE TRUNCATE DDL TOTAL DBMS ELAPSED TIME
BMC51576I 0 PARTITION 100000 0 0 0 0 100000 00:00:07.485625
BMC51576I 15:01:10 001 APT0048I PARTITION STATISTICS - EXAMPLEC.TBL1
BMC51576I AGENT ASSIGNBY PART INSERT UPDATE DELETE TRUNCATE DDL TOTAL DBMS ELAPSED
TIME
BMC51576I 1 PARTITION 1 20000 0 0 0 0 20000 00:00:01.
678225
BMC51576I 4 PARTITION 2 20000 0 0 0 0 20000 00:00:01.
563088
BMC51576I 5 PARTITION 3 20000 0 0 0 0 20000 00:00:01.
552214
BMC51576I 2 PARTITION 4 20000 0 0 0 0 20000 00:00:01.
403187
BMC51576I 3 PARTITION 5 20000 0 0 0 0 20000 00:00:01.
288907
BMC51576I 15:01:10 001 APT0032I DSN output follows:
BMC51576I DSNT200I *DEHJ FREE FOR PLAN APTACAG SUCCESSFUL
BMC51576I 15:01:10 001 APT0032I DSN output follows:
BMC51576I DSNT232I *DEHJ SUCCESSFUL FREE FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I DSNT232I *DEHJ SUCCESSFUL FREE FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I 15:01:10 000 APT0020I File DBRMLIB :SYS15068.T150106.RA000.AMUEX12.R0338590 deallocated
BMC51576I 15:01:10 001 APT0111I INPUT PROCESSING STATISTICS
BMC51576I INSERT UPDATE DELETE TRUNCATE DDL TOTAL
BMC51576I 100000 0 0 0 0 100000
BMC51576I 15:01:10 001 APT0166I STATEMENTS COMMITTED STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE TRUNCATE DDL TOTAL
BMC51576I 1 200 0 0 0 0 200
BMC51576I 2 200 0 0 0 0 200
BMC51576I 3 200 0 0 0 0 200
BMC51576I 4 200 0 0 0 0 200
BMC51576I 5 200 0 0 0 0 200
BMC51576I ----- --------- --------- --------- --------- --------- ----------
BMC51576I TOTAL 1000 0 0 0 0 1000
BMC51576I 15:01:10 001 APT0082I DYNAMIC SQL PROCESSING STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE TRUNCATE COMMIT ROLLBACK TOTAL
BMC51576I 1 0 0 0 0 0 0 0
BMC51576I 2 0 0 0 0 0 0 0
BMC51576I 3 0 0 0 0 0 0 0
BMC51576I 4 0 0 0 0 0 0 0
BMC51576I 5 0 0 0 0 0 0 0
BMC51576I ----- --------- --------- --------- --------- --------- --------- ----------
BMC51576I TOTAL 0 0 0 0 0 0 0
BMC51576I 15:01:10 001 APT0081I STATIC SQL PROCESSING STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE TRUNCATE MASSDEL COMMIT ROLLBACK PREPARE EXECUTE
TOTAL
BMC51576I 1 200 0 0 0 0 8 0 0 0
208
BMC51576I 2 200 0 0 0 0 8 0 0 0
208
BMC51576I 3 200 0 0 0 0 8 0 0 0
208
BMC51576I 4 200 0 0 0 0 8 0 0 0
208
BMC51576I 5 200 0 0 0 0 8 0 0 0
208
BMC51576I ----- --------- --------- --------- --------- --------- --------- --------- --------- ---------
----------
BMC51576I TOTAL 1000 0 0 0 0 40 0 0 0
1040
BMC51576I 15:01:10 001 APT0200I EXECUTE IMMEDIATE PROCESSING STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE TRUNCATE DDL TOTAL
BMC51576I 1 0 0 0 0 0 0
BMC51576I 2 0 0 0 0 0 0
BMC51576I 3 0 0 0 0 0 0
BMC51576I 4 0 0 0 0 0 0
BMC51576I 5 0 0 0 0 0 0
BMC51576I ----- --------- --------- --------- --------- --------- ----------
BMC51576I TOTAL 0 0 0 0 0 0
BMC51576I 15:01:10 001 APT0234I ROW STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE MASSDEL TOTAL
BMC51576I 1 20000 0 0 0 20000
BMC51576I 2 20000 0 0 0 20000
BMC51576I 3 20000 0 0 0 20000
BMC51576I 4 20000 0 0 0 20000
BMC51576I 5 20000 0 0 0 20000
BMC51576I ----- --------- --------- --------- --------- ----------
BMC51576I TOTAL 100000 0 0 0 100000
BMC51576I 15:01:10 001 APT0206I PACKAGE STATISTICS
BMC51576I NAME STMTCNT USAGECNT RETRIES BIND ELAPSED TIME
BMC51576I ACAG0000 101 0 0 00:00:00.234451
BMC51576I ACAG0001 1 100000 0 00:00:00.089450
BMC51576I --------- --------- --------- --------- -----------------
BMC51576I TOTAL 102 100000 0 00:00:00.323902
BMC51576I 15:01:10 001 APT0182I OTHER STATISTICS
BMC51576I AGENT FAILPREPS RETRIES DBMS ELAPSED TIME
BMC51576I 1 0 0 00:00:02.387791
BMC51576I 2 0 0 00:00:02.408654
BMC51576I 3 0 0 00:00:02.242063
BMC51576I 4 0 0 00:00:02.254911
BMC51576I 5 0 0 00:00:02.246764
BMC51576I ----- --------- --------- -----------------
BMC51576I TOTAL 0 0 00:00:11.540187
BMC51576I 15:01:10 001 APT0183I Request elapsed time: 00:00:07.089565
BMC51576I 15:01:10 000 APT0067I Request completed Return code: 0
BMC50481I 10: SQLAPPLY TASK COMPLETE. ELAPSED TIME = 00:00:09
BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC, I/OS = 20, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC51507I XBLKS = 20, XFERS = 130, EMPTY WAITS = 102, FULL WAITS =0
BMC51507I APBUFS = 15, XFERS = 215, EMPTY WAITS = 199, FULL WAITS =0
BMC50476I DDNAME = SYSDISC, I/OS = 0, I/O WAITS = 0, RDB LOCK WAITS = 0
BMC51472I COMBINED PHASE STATISTICS: 100000 ROWS SELECTED FOR SPACE 'AMUEXCDB.EXCTS', 0 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
BMC51479I COMBINED PHASE STATISTICS: 0 PHYSICAL (0 LOGICAL) RECORDS DISCARDED TO SYSDISC
BMC51475I LOAD STATISTICS: 100000 ROWS LOADED INTO TABLE SPACE 'AMUEXCDB.EXCTS'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR ', DSNAME = 'AMU.EXAMP12A.SYSERR'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I COMBINED PHASE COMPLETE. ELAPSED TIME = 00:00:10
BMC51577I ROWS DISCARDED
BMC51578I INSERTED SQLERRORS
BMC51579I SPACE AMUEXCDB.EXCTS 100000 0
BMC51579I PART 0001 20000 0
BMC51579I PART 0002 20000 0
BMC51579I PART 0003 20000 0
BMC51579I PART 0004 20000 0
BMC51579I PART 0005 20000 0
BMC50004I UTILTERM PHASE COMPLETE. ELAPSED TIME = 00:00:00
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 15:00:58 ...
BMC50002I UTILITY ID = 'EXAM12A'. DB2 SUBSYSTEM ID = 'DEHJ'. OPTION MODULE = 'AMU$OPTO'.
BMC50471I z/OS 2.1.0,PID=HBB7790,DFSMS FOR Z/OS=2.1.0,DB2=11.1.0
BMC50471I REGION=0M,BELOW 16M=8816K,ABOVE 16M=1306040K,IEFUSI=NO,CPUS=3
BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040308M,MEMLIMIT SET BY:REGION=0
0
BMC50471I LOADPLUS FOR DB2--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I SOLUTION COMMON CODE--V11.01.00
BMC50471I MAINT: BPJ0661 BPJ0667 BPJ0671 BPJ0674 BPJ0675 BPJ0676 BPJ0682 BPJ0686 BPJ0689 BPJ0697 BPJ0700 BPJ0702
BMC50471I BPJ0703 BPJ0706 BPJ0712 BPJ0715 BPJ0729 BPJ0773 BPJ0786 BPJ0794 BPJ0806 BPJ0830 BPJ0833 BPJ0839
BMC50471I BPJ0845 BPJ0866 BPJ0892 BPJ0913 BPJ0914 BPJ0916 BPJ0930 BPJ0944 BPJ0946
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922
BMC50471I BMC STATS API--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.01.00
BMC50471I MAINT: BPE0401 BPE0403 BPE0405 BPE0407 BPE0410 BPE0412 BPE0416 BPE0420 BPE0422 BPE0423 BPE0426 BPE0428
BMC50471I BPE0430 BPE0433 BPE0435 BPE0438 BPE0439
BMC50471I HIGH-SPEED APPLY ENGINE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
0
BMC50471I APCOMMIT=2500 FORCE_AT=(START,3) RCVYDDN=(BMCRCY,BMCRCZ)
BMC50471I APDOPTS= FORCE_RPT=NO REDEFINE=YES
BMC50471I APMULTIROW=100 FORCE=NONE RENMMAX=30
BMC50471I APMXAGNT=10 IBUFFS=20 RULES=STANDARD
BMC50471I APRETLIM=COUNT IDCACHE=1000 SDUMP=YES
BMC50471I APRETVAL=5 IDCDDN=SYSIDCIN SHORTMEMORY=CONTINUE
BMC50471I AUTOENUMROWS=YES IDERROR=DISCARD SHRLEVEL=(NONE,NONE)
BMC50471I AVAILPAGEPCT=0 INDDN=SYSREC SMAX=16
BMC50471I CBUFFS=30 INFORI=NO SMCORE=(0K,0K)
BMC50471I CENTURY=(1950,2049) INLINECP=YES SORTDEVT=(,SYSALLDA)
BMC50471I CHEKPEND=YES KEEPDICTIONARY=NO SORTNUM=32
BMC50471I COPYDDN=(BMCCPY,BMCCPZ) LBUFFS=20 SQLDELAY=3
BMC50471I COPYLVL=FULL LOADDN=SORTOUT SQLRETRY=100
BMC50471I COPYPEND=YES LOBAVGPCT=50 STOP@CMT=YES
BMC50471I COPYSUBSET=NO LOCKROW=YES STOPDELAY=1
BMC50471I DELFILES=(YES,NO) LONGNAMETRUNC=MIDDLE STOPRETRY=300
BMC50471I DISCARDLIMRC=8 MAPDDN=SYSMAP TAPEDISP=DELETE
BMC50471I DISCARDRC=0 MAXP=5 TOTALPAGEPCT=30
BMC50471I DISCDDN=SYSDISC MAXSORTMEMORY=0 TSSAMPLEPCT=100
BMC50471I DRNDELAY=1 MAXTAPE=3 UPDMAXA_AUTHID=USER
BMC50471I DRNRETRY=255 MGEXTENT=CONTINUE UPDMAXA=NO
BMC50471I DRNWAIT=NONE MINSORTMEMORY=0 UXSTATE=SUP
BMC50471I DSNUEXIT=(NONE,ASM) MSGLEVEL=1 WBUFFS=(20,10)
BMC50471I DSNUTILB=YES OPNDB2ID=YES WORKDDN=SYSUT1
BMC50471I ENFORCE=CHECK ORIGDISP=DELETE WORKUNIT=SYSALLDA
BMC50471I ERRDDN=SYSERR PAUSEDISCARDRC=4 XBLKS=3
BMC50471I EXCLDUMP=(X37,X22,X06) PLAN=AMUQA XMLAVGSIZE=10240
BMC50471I FASTSWITCH=NO PREFORMAT=NO ZEROROWRC=0
BMC50471I FILECHK=WARN PRELOAD=LOAD ZIIP=ENABLED
0
BMC50471I APCOLLECTION=
BMC50471I APOWNER=
0
BMC50470I DDTYPE = LOAD WORK SORTWORK
BMC50470I ACTIVE = YES YES NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) N/A
BMC50470I VOLCNT = (25,25) (25,25) N/A
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) N/A
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) N/A
BMC50470I EXPDT = N/A N/A N/A
BMC50470I RETPD = N/A N/A N/A
BMC50470I GDGLIMIT = N/A N/A N/A
BMC50470I GDGEMPTY = N/A N/A N/A
BMC50470I GDGSCRAT = N/A N/A N/A
0
BMC50470I DDTYPE = ERROR DISCARD LOCPFCPY
BMC50470I ACTIVE = YES YES YES
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = N/A N/A 5
BMC50470I GDGEMPTY = N/A N/A NO
BMC50470I GDGSCRAT = N/A N/A NO
0
BMC50470I DDTYPE = LOCBFCPY REMPFCPY REMBFCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = SYSMAP LOCPLCPY LOCBLCPY
BMC50470I ACTIVE = YES YES NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT = N/A
BMC50470I RETPD = N/A
BMC50470I GDGLIMIT = N/A 5 5
BMC50470I GDGEMPTY = N/A NO NO
BMC50470I GDGSCRAT = N/A NO NO
0
BMC50470I DDTYPE = REMPLCPY REMBLCPY LOCPXCPY
BMC50470I ACTIVE = NO NO YES
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = LOCBXCPY REMPXCPY REMBXCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50483I LOAD DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I WORK DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I SORTWORK DSNPAT=NONE
BMC50483I ERROR DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I DISCARD DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I SYSMAP DSNPAT=&UID..BMC.&TS.&DDNAME
0
BMC50483I LOCPFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I LOCBFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMPFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMBFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
BMC50483I LOCPLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I LOCBLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I REMPLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I REMBLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
0
BMC50483I LOCPXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I LOCBXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMPXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMBXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
BMC50471I DB2 DSNHDECP MODULE SETTINGS:
BMC50471I VERSION = 1110
BMC50471I SUBSYSTEM DEFAULT = DEHJ
BMC50471I CHARACTER SET = ALPHANUM
BMC50471I DATE FORMAT = USA
BMC50471I TIME FORMAT = USA
BMC50471I LOCAL DATE LENGTH = 0
BMC50471I LOCAL TIME LENGTH = 0
BMC50471I DECIMAL POINT = PERIOD
BMC50471I DECIMAL ARITHMETIC = 15
BMC50471I DELIMITER = DEFAULT
BMC50471I SQL DELIMITER = DEFAULT
BMC50471I ENCODING SCHEME = EBCDIC
BMC50471I APPL. ENCODING SCHEME = EBCDIC
BMC50471I MIXED = NO
BMC50471I EBCDIC CCSID = (37,65534,65534)
BMC50471I ASCII CCSID = (819,65534,65534)
BMC50471I UNICODE CCSID = (367,1208,1200)
BMC50471I IMPLICIT TIME ZONE = CURRENT (-05:00)
BMC50028I DB2 MODE = NFM
BMC50471I BMC_BMCUTIL ='BMCUTIL.CMN_BMCUTIL'
BMC50471I BMC_BMCSYNC ='BMCUTIL.CMN_BMCSYNC'
BMC50471I BMC_BMCHIST ='BMCUTIL.CMN_BMCHIST'
BMC50471I BMC_BMCDICT ='BMCUTIL.CMN_BMCDICT'
0
0
BMC50102I LOAD DATA RESUME YES
BMC50102I SHRLEVEL CHANGE SQLAPPLY
BMC50102I ORDER NO
BMC50102I INTO TABLE EXAMPLEC.TBL1
BMC50102I (RECNO POS(1:4) INTEGER,
BMC50102I INPUT_A POS(5:14) CHAR(10),
BMC50102I RECNO2 POS(15:18) INTEGER,
BMC50102I INPUT_B POS(19:28) CHAR(10),
BMC50102I INPUT_C POS(29:43) CHAR(15),
BMC50102I INPUT_D POS(44:58) CHAR(15)
BMC50102I )
BMC51424I ANALYZE PHASE WILL BE PERFORMED DUE TO DYNAMIC WORK FILE ALLOCATION
BMC51561I CALCULATED NUMBER OF INPUT RECORDS = 203829 USING A SCALING FACTOR OF 100%
BMC50004I UTILINIT PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I ANALYZE PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50425I &JOBNAME = AMUEX12 &STEPNAME = EXAMP12A &DB = AMUEXCDB &TS = EXCTS &UID = RDAMZL
BMC50425I &RESUME = Y &REPLACE = N &DATE = 030915 &TIME = 150058 &SSID = DEHJ
BMC50425I &UTIL = EXAM12A &UTILPFX = EXAM12A &UTILSFX = &DATE8 = 03092015 &GRPNM = DEHJ
BMC50425I &VCAT = DEHJCAT &TIME4 = 1500 &DATEJ = 2015068 &JDATE = 15068
BMC50445I LOAD PLUS DYNAMIC FILE ALLOCATION REPORT
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8476K, ABOVE 16M = 1299480K, CPUS = 3
BMC50479I TOTAL PAGES: 3736000, ALLOWED: 1120800; AVAILABLE PAGES: 238278, ALLOWED: 0
BMC51499I COMBINED OPTIMIZATION, RC=0, #SORTS=5, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=88012
BMC51499I COMBINED OPTIMIZATION, RC=20, #SORTS=4, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=89088
BMC51500I COMBINED ANALYZE, #SORTS=5, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0
BMC51576I 15:01:01 000 APT0000I HIGH-SPEED APPLY ENGINE V11.02.00
BMC51576I Copyright (c) 1999-2015 BMC Software, Inc. as an unpublished licensed work. All rights reserved.
BMC51576I 15:01:01 000 APT0001I Date: Mon Mar 9, 2015
BMC51576I 15:01:02 000 APT0215I MAINT: HIGH-SPEED APPLY ENGINE V11.02.00
BMC51576I 15:01:02 000 APT0215I MAINT: NONE APPLIED
BMC51576I 15:01:02 000 APT0215I MAINT: SOLUTION COMMON CODE V11.01.00
BMC51576I 15:01:02 000 APT0215I MAINT: BPJ0661 BPJ0667 BPJ0671 BPJ0674 BPJ0675 BPJ0676 BPJ0682
BMC51576I 15:01:02 000 APT0215I MAINT: BPJ0686 BPJ0689 BPJ0697 BPJ0700 BPJ0702 BPJ0703 BPJ0706
BMC51576I 15:01:02 000 APT0215I MAINT: BPJ0712 BPJ0715 BPJ0729 BPJ0773 BPJ0786 BPJ0794 BPJ0806
BMC51576I 15:01:02 000 APT0215I MAINT: BPJ0830 BPJ0833 BPJ0839 BPJ0845 BPJ0866 BPJ0892 BPJ0913
BMC51576I 15:01:02 000 APT0215I MAINT: BPJ0914 BPJ0916 BPJ0930 BPJ0944 BPJ0946
BMC51576I 15:01:02 000 APT0215I MAINT: BMCSORT ENGINE V02.04.01
BMC51576I 15:01:02 000 APT0215I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922
BMC51576I 15:01:02 000 APT0085I /STARTUP/
BMC51576I SSID=DEHJ
BMC51576I INPUTTYPE={3895D640-0BF1-11D4-8027-00104B39B10F}
BMC51576I PLANNAME=APTBREL
BMC51576I BINDQUALIFIER=APTTEST
BMC51576I DBMSTYPE=DB2
BMC51576I DISTRIBUTIONTYPE=OBJECT
BMC51576I LARGESTATEMENTSUPPORT=NO
BMC51576I 15:01:02 000 APT0085I /CONFIGURATION/
BMC51576I FILENAME=NONE
BMC51576I 15:01:02 000 APT0085I /SQL/
BMC51576I FORMAT=PACKED72
BMC51576I 15:01:02 000 APT0085I /COMMITTRIGGERS/
BMC51576I STATEMENTCOUNT=2500
BMC51576I COMMITONDEMAND=NO
BMC51576I 15:01:02 000 APT0085I /OBJECTMAP/
BMC51576I SOURCETABLE=0X1086.0X0003
BMC51576I TARGETTABLE='EXAMPLEC'.'TBL1'
BMC51576I 15:01:02 000 APT0085I /AGENT/
BMC51576I MAXAGENTS=10
BMC51576I INITIALAGENTS=5
BMC51576I MAXPREPARES=50
BMC51576I 15:01:02 000 APT0085I /TEMPORARYFILES/
BMC51576I UNIT=SYSALLDA
BMC51576I 15:01:02 000 APT0085I /DIAGNOSTICOUTPUT/
BMC51576I FILENAME=APTDIAG
BMC51576I 15:01:02 000 APT0085I /RESTART/
BMC51576I RESTARTID=EXAM12A
BMC51576I RESTARTTYPE=NEW
BMC51576I CHECKPOINTFREQUENCY=0
BMC51576I TABLENAME=BMCAPT_APTRSCL
BMC51576I RETAINTIME=7
BMC51576I RETRY=3
BMC51576I 15:01:02 000 APT0085I /DISTRIBUTIONTUNING/
BMC51576I SIMPLETSCLUSTERING=NO
BMC51576I RICLUSTERING=NO
BMC51576I PARTITIONCLUSTERING=NO
BMC51576I URCHECKRI=YES
BMC51576I 15:01:02 000 APT0085I /ANYCONFLICT/
BMC51576I CODE=-803
BMC51576I ACTION=CALLBACK
BMC51576I ACTION=CONTINUE
BMC51576I CODE=-530
BMC51576I ACTION=CALLBACK
BMC51576I ACTION=CONTINUE
BMC51576I CODE=-359
BMC51576I ACTION=CALLBACK
BMC51576I ACTION=CONTINUE
BMC51576I CODE=-330
BMC51576I ACTION=CALLBACK
BMC51576I ACTION=CONTINUE
BMC51576I CODE=SQLWARN0
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN1
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN2
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN3
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN4
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN5
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN6
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN7
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN8
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN9
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARNA
BMC51576I ACTION=WARN
BMC51576I CODE=NEGATIVE
BMC51576I ACTION=ABORT
BMC51576I CODE=POSITIVE
BMC51576I ACTION=WARN
BMC51576I CODE=MULTIPLEROWS
BMC51576I ACTION=WARN
BMC51576I CODE=NOROWS
BMC51576I ACTION=WARN
BMC51576I CODE=TIMEOUT
BMC51576I ACTION=RETRY
BMC51576I 15:01:03 000 APT0085I /INSERTCONFLICT/
BMC51576I CODE=MULTIROWCONFLICT
BMC51576I ACTION=RETRY
BMC51576I 15:01:03 000 APT0085I /CONFLICT/
BMC51576I RETRYLIMIT=COUNT
BMC51576I RETRYVALUE=5
BMC51576I DATATYPE=ID
BMC51576I DATATYPE=SQLCODE
BMC51576I DATATYPE=MESSAGE
BMC51576I RETRYFAIL=ABORT
BMC51576I RETRYDELAY=0
BMC51576I MAXFAILEDRETRIES=5
BMC51576I 15:01:03 000 APT0085I /CONFLICTFILE/
BMC51576I SPACE=TRACK
BMC51576I SPACEPRI=15
BMC51576I SPACESEC=5
BMC51576I FILENAMEMODEL=&SYSUID..BMCAPT.&REQUESTID..D&DATE..T&TIME.
BMC51576I SINGLEFILE=NO
BMC51576I DISP=NEW
BMC51576I MEDIATYPE=FILE
BMC51576I RELEASE=YES
BMC51576I 15:01:03 000 APT0085I /BIND/
BMC51576I FREEOPTION=ALL
BMC51576I PLANPREFIX=APT
BMC51576I 15:01:03 000 APT0085I /BINDTUNING/
BMC51576I STATEMENTCOUNT=1
BMC51576I MAXPACKAGES=25
BMC51576I MAXFAILEDBINDS=5
BMC51576I MAXRETRIES=5
BMC51576I PACKAGEUSAGE=500
BMC51576I STATEMENTUSAGE=200
BMC51576I 15:01:03 000 APT0085I /MULTIROWINSERT/
BMC51576I MULTIROWINSERT=YES
BMC51576I MAXROWS=100
BMC51576I 15:01:03 001 APT0252I zIIP processing enabled using XBM SSID XBMB (v6.2.00)
BMC51576I 15:01:03 001 APT0238I Successful connect to DEHJ (Release 1110(NFM ) of DB2)
BMC51576I 15:01:04 001 APT0236I High-speed Apply starting with Multi-Row Inserts
BMC51576I 15:01:05 001 APT0097I Request ID: ACAG Restart ID: EXAM12A
BMC51576I 15:01:06 000 APT0019I File DBRMLIB :SYS15068.T150106.RA000.AMUEX12.R0338590 allocated - elapsed time: 00:00:00
BMC51576I 15:01:06 001 APT0032I DSN output follows:
BMC51576I DSNT252I *DEHJ DSNTBCM1 BIND OPTIONS FOR PLAN APTACAG
BMC51576I ACTION ADD
BMC51576I OWNER RDAMZL
BMC51576I VALIDATE RUN
BMC51576I ISOLATION CS
BMC51576I ACQUIRE USE
BMC51576I RELEASE COMMIT
BMC51576I EXPLAIN NO
BMC51576I DYNAMICRULES RUN
BMC51576I PROGAUTH DISABLE
BMC51576I DSNT253I *DEHJ DSNTBCM1 BIND OPTIONS FOR PLAN APTACAG
BMC51576I NODEFER PREPARE
BMC51576I CACHESIZE 3072
BMC51576I QUALIFIER RDAMZL
BMC51576I CURRENTSERVER
BMC51576I CURRENTDATA NO
BMC51576I DEGREE 1
BMC51576I SQLRULES DB2
BMC51576I DISCONNECT EXPLICIT
BMC51576I REOPT NONE
BMC51576I KEEPDYNAMIC YES
BMC51576I IMMEDWRITE NO
BMC51576I DBPROTOCOL DRDA
BMC51576I OPTHINT
BMC51576I ENCODING EBCDIC(00037)
BMC51576I CONCURRENTACCESSRESOLUTION
BMC51576I
BMC51576I PATH
BMC51576I DSNT200I *DEHJ BIND FOR PLAN APTACAG SUCCESSFUL
BMC51576I 15:01:06 001 APT0032I DSN output follows:
BMC51576I DSNT254I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I ACTION ADD
BMC51576I OWNER RDAMZL
BMC51576I QUALIFIER RDAMZL
BMC51576I VALIDATE RUN
BMC51576I EXPLAIN NO
BMC51576I ISOLATION CS
BMC51576I RELEASE COMMIT
BMC51576I COPY
BMC51576I APREUSE
BMC51576I APCOMPARE
BMC51576I APRETAINDUP
BMC51576I BUSTIMESENSITIVE YES
BMC51576I SYSTIMESENSITIVE YES
BMC51576I ARCHIVESENSITIVE YES
BMC51576I APPLCOMPAT V11R1
BMC51576I DSNT255I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I SQLERROR NOPACKAGE
BMC51576I CURRENTDATA NO
BMC51576I DEGREE 1
BMC51576I DYNAMICRULES
BMC51576I DEFER
BMC51576I REOPT NONE
BMC51576I KEEPDYNAMIC YES
BMC51576I IMMEDWRITE NO
BMC51576I DBPROTOCOL DRDA
BMC51576I OPTHINT
BMC51576I ENCODING EBCDIC(00037)
BMC51576I PLANMGMT OFF
BMC51576I PLANMGMTSCOPE STATIC
BMC51576I CONCURRENTACCESSRESOLUTION
BMC51576I
BMC51576I EXTENDEDINDICATOR
BMC51576I
BMC51576I PATH
BMC51576I DSNT275I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I QUERYACCELERATION
BMC51576I GETACCELARCHIVE
BMC51576I DSNT232I *DEHJ SUCCESSFUL BIND FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I 15:01:07 006 APT0079I High-speed Apply processing started - Agent: 1
BMC51576I 15:01:07 007 APT0079I High-speed Apply processing started - Agent: 2
BMC51576I 15:01:07 008 APT0079I High-speed Apply processing started - Agent: 3
BMC51576I 15:01:07 009 APT0079I High-speed Apply processing started - Agent: 4
BMC51576I 15:01:07 010 APT0079I High-speed Apply processing started - Agent: 5
BMC51576I 15:01:07 001 APT0148I Bind started for package ACAG0001 - Trigger statistics:
BMC51576I STATEMENTCOUNT...........................1
BMC51576I PACKAGEUSAGE.............................1
BMC51576I STATEMENTUSAGE...........................1
BMC51576I 15:01:07 001 APT0032I DSN output follows:
BMC51576I DSNT254I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I ACTION ADD
BMC51576I OWNER RDAMZL
BMC51576I QUALIFIER RDAMZL
BMC51576I VALIDATE RUN
BMC51576I EXPLAIN NO
BMC51576I ISOLATION CS
BMC51576I RELEASE COMMIT
BMC51576I COPY
BMC51576I APREUSE
BMC51576I APCOMPARE
BMC51576I APRETAINDUP
BMC51576I BUSTIMESENSITIVE YES
BMC51576I SYSTIMESENSITIVE YES
BMC51576I ARCHIVESENSITIVE YES
BMC51576I APPLCOMPAT V11R1
BMC51576I DSNT255I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I SQLERROR NOPACKAGE
BMC51576I CURRENTDATA NO
BMC51576I DEGREE 1
BMC51576I DYNAMICRULES
BMC51576I DEFER
BMC51576I REOPT NONE
BMC51576I KEEPDYNAMIC YES
BMC51576I IMMEDWRITE NO
BMC51576I DBPROTOCOL DRDA
BMC51576I OPTHINT
BMC51576I ENCODING EBCDIC(00037)
BMC51576I PLANMGMT OFF
BMC51576I PLANMGMTSCOPE STATIC
BMC51576I CONCURRENTACCESSRESOLUTION
BMC51576I
BMC51576I EXTENDEDINDICATOR
BMC51576I
BMC51576I PATH
BMC51576I DSNT275I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I QUERYACCELERATION
BMC51576I GETACCELARCHIVE
BMC51576I DSNT232I *DEHJ SUCCESSFUL BIND FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC50481I 1: READ TASK COMPLETE. ELAPSED TIME = 00:00:07
BMC51510I 1: READ TASK, XBLK XFERS = 130, EMPTY WAITS = 102, FULL WAITS = 0
BMC51478I PRELOAD STATISTICS: 100000 PHYSICAL (100000 LOGICAL) RECORDS READ FROM SYSREC
BMC51480I 3: DATA TASK COMPLETE. ELAPSED TIME = 00:00:07. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51510I 3: SORT TASK, XBLK XFERS = 26, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 3: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 43, FULL WAITS = 0
BMC51480I 4: DATA TASK COMPLETE. ELAPSED TIME = 00:00:07. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51480I 2: DATA TASK COMPLETE. ELAPSED TIME = 00:00:07. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51510I 2: SORT TASK, XBLK XFERS = 26, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 2: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 28, FULL WAITS = 0
BMC51510I 4: SORT TASK, XBLK XFERS = 26, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 4: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 43, FULL WAITS = 0
BMC51480I 6: DATA TASK COMPLETE. ELAPSED TIME = 00:00:07. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51510I 6: SORT TASK, XBLK XFERS = 26, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 6: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 43, FULL WAITS = 0
BMC51480I 5: DATA TASK COMPLETE. ELAPSED TIME = 00:00:07. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51510I 5: SORT TASK, XBLK XFERS = 26, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 5: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 42, FULL WAITS = 0
BMC51576I 15:01:07 001 APT0118I Input statements processed: 100000 Statement ID: 000186A000004E200003000501000186A0
BMC51576I 15:01:07 001 APT0066I Input processing complete
BMC51576I 15:01:08 001 APT0185I Statements committed: 12500
BMC51576I 15:01:09 001 APT0185I Statements committed: 65000
BMC51576I 15:01:09 010 APT0080I High-speed Apply processing ended - Agent: 5
BMC51576I 15:01:09 009 APT0080I High-speed Apply processing ended - Agent: 4
BMC51576I 15:01:09 006 APT0080I High-speed Apply processing ended - Agent: 1
BMC51576I 15:01:09 008 APT0080I High-speed Apply processing ended - Agent: 3
BMC51576I 15:01:09 007 APT0080I High-speed Apply processing ended - Agent: 2
BMC51576I 15:01:10 001 APT0185I Statements committed: 100000
BMC51576I 15:01:10 001 APT0047I TABLE STATISTICS - EXAMPLEC.TBL1
BMC51576I AGENT ASSIGNBY INSERT UPDATE DELETE TRUNCATE DDL TOTAL DBMS ELAPSED TIME
BMC51576I 0 PARTITION 100000 0 0 0 0 100000 00:00:07.485625
BMC51576I 15:01:10 001 APT0048I PARTITION STATISTICS - EXAMPLEC.TBL1
BMC51576I AGENT ASSIGNBY PART INSERT UPDATE DELETE TRUNCATE DDL TOTAL DBMS ELAPSED
TIME
BMC51576I 1 PARTITION 1 20000 0 0 0 0 20000 00:00:01.
678225
BMC51576I 4 PARTITION 2 20000 0 0 0 0 20000 00:00:01.
563088
BMC51576I 5 PARTITION 3 20000 0 0 0 0 20000 00:00:01.
552214
BMC51576I 2 PARTITION 4 20000 0 0 0 0 20000 00:00:01.
403187
BMC51576I 3 PARTITION 5 20000 0 0 0 0 20000 00:00:01.
288907
BMC51576I 15:01:10 001 APT0032I DSN output follows:
BMC51576I DSNT200I *DEHJ FREE FOR PLAN APTACAG SUCCESSFUL
BMC51576I 15:01:10 001 APT0032I DSN output follows:
BMC51576I DSNT232I *DEHJ SUCCESSFUL FREE FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I DSNT232I *DEHJ SUCCESSFUL FREE FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I 15:01:10 000 APT0020I File DBRMLIB :SYS15068.T150106.RA000.AMUEX12.R0338590 deallocated
BMC51576I 15:01:10 001 APT0111I INPUT PROCESSING STATISTICS
BMC51576I INSERT UPDATE DELETE TRUNCATE DDL TOTAL
BMC51576I 100000 0 0 0 0 100000
BMC51576I 15:01:10 001 APT0166I STATEMENTS COMMITTED STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE TRUNCATE DDL TOTAL
BMC51576I 1 200 0 0 0 0 200
BMC51576I 2 200 0 0 0 0 200
BMC51576I 3 200 0 0 0 0 200
BMC51576I 4 200 0 0 0 0 200
BMC51576I 5 200 0 0 0 0 200
BMC51576I ----- --------- --------- --------- --------- --------- ----------
BMC51576I TOTAL 1000 0 0 0 0 1000
BMC51576I 15:01:10 001 APT0082I DYNAMIC SQL PROCESSING STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE TRUNCATE COMMIT ROLLBACK TOTAL
BMC51576I 1 0 0 0 0 0 0 0
BMC51576I 2 0 0 0 0 0 0 0
BMC51576I 3 0 0 0 0 0 0 0
BMC51576I 4 0 0 0 0 0 0 0
BMC51576I 5 0 0 0 0 0 0 0
BMC51576I ----- --------- --------- --------- --------- --------- --------- ----------
BMC51576I TOTAL 0 0 0 0 0 0 0
BMC51576I 15:01:10 001 APT0081I STATIC SQL PROCESSING STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE TRUNCATE MASSDEL COMMIT ROLLBACK PREPARE EXECUTE
TOTAL
BMC51576I 1 200 0 0 0 0 8 0 0 0
208
BMC51576I 2 200 0 0 0 0 8 0 0 0
208
BMC51576I 3 200 0 0 0 0 8 0 0 0
208
BMC51576I 4 200 0 0 0 0 8 0 0 0
208
BMC51576I 5 200 0 0 0 0 8 0 0 0
208
BMC51576I ----- --------- --------- --------- --------- --------- --------- --------- --------- ---------
----------
BMC51576I TOTAL 1000 0 0 0 0 40 0 0 0
1040
BMC51576I 15:01:10 001 APT0200I EXECUTE IMMEDIATE PROCESSING STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE TRUNCATE DDL TOTAL
BMC51576I 1 0 0 0 0 0 0
BMC51576I 2 0 0 0 0 0 0
BMC51576I 3 0 0 0 0 0 0
BMC51576I 4 0 0 0 0 0 0
BMC51576I 5 0 0 0 0 0 0
BMC51576I ----- --------- --------- --------- --------- --------- ----------
BMC51576I TOTAL 0 0 0 0 0 0
BMC51576I 15:01:10 001 APT0234I ROW STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE MASSDEL TOTAL
BMC51576I 1 20000 0 0 0 20000
BMC51576I 2 20000 0 0 0 20000
BMC51576I 3 20000 0 0 0 20000
BMC51576I 4 20000 0 0 0 20000
BMC51576I 5 20000 0 0 0 20000
BMC51576I ----- --------- --------- --------- --------- ----------
BMC51576I TOTAL 100000 0 0 0 100000
BMC51576I 15:01:10 001 APT0206I PACKAGE STATISTICS
BMC51576I NAME STMTCNT USAGECNT RETRIES BIND ELAPSED TIME
BMC51576I ACAG0000 101 0 0 00:00:00.234451
BMC51576I ACAG0001 1 100000 0 00:00:00.089450
BMC51576I --------- --------- --------- --------- -----------------
BMC51576I TOTAL 102 100000 0 00:00:00.323902
BMC51576I 15:01:10 001 APT0182I OTHER STATISTICS
BMC51576I AGENT FAILPREPS RETRIES DBMS ELAPSED TIME
BMC51576I 1 0 0 00:00:02.387791
BMC51576I 2 0 0 00:00:02.408654
BMC51576I 3 0 0 00:00:02.242063
BMC51576I 4 0 0 00:00:02.254911
BMC51576I 5 0 0 00:00:02.246764
BMC51576I ----- --------- --------- -----------------
BMC51576I TOTAL 0 0 00:00:11.540187
BMC51576I 15:01:10 001 APT0183I Request elapsed time: 00:00:07.089565
BMC51576I 15:01:10 000 APT0067I Request completed Return code: 0
BMC50481I 10: SQLAPPLY TASK COMPLETE. ELAPSED TIME = 00:00:09
BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC, I/OS = 20, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC51507I XBLKS = 20, XFERS = 130, EMPTY WAITS = 102, FULL WAITS =0
BMC51507I APBUFS = 15, XFERS = 215, EMPTY WAITS = 199, FULL WAITS =0
BMC50476I DDNAME = SYSDISC, I/OS = 0, I/O WAITS = 0, RDB LOCK WAITS = 0
BMC51472I COMBINED PHASE STATISTICS: 100000 ROWS SELECTED FOR SPACE 'AMUEXCDB.EXCTS', 0 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
BMC51479I COMBINED PHASE STATISTICS: 0 PHYSICAL (0 LOGICAL) RECORDS DISCARDED TO SYSDISC
BMC51475I LOAD STATISTICS: 100000 ROWS LOADED INTO TABLE SPACE 'AMUEXCDB.EXCTS'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR ', DSNAME = 'AMU.EXAMP12A.SYSERR'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I COMBINED PHASE COMPLETE. ELAPSED TIME = 00:00:10
BMC51577I ROWS DISCARDED
BMC51578I INSERTED SQLERRORS
BMC51579I SPACE AMUEXCDB.EXCTS 100000 0
BMC51579I PART 0001 20000 0
BMC51579I PART 0002 20000 0
BMC51579I PART 0003 20000 0
BMC51579I PART 0004 20000 0
BMC51579I PART 0005 20000 0
BMC50004I UTILTERM PHASE COMPLETE. ELAPSED TIME = 00:00:00
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0
Output from ORDER YES with dynamic allocation (example 12B)The following figure shows the SYSPRINT output for example 12B:
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 15:01:13 ...
BMC50002I UTILITY ID = 'EXAM12B'. DB2 SUBSYSTEM ID = 'DEHJ'. OPTION MODULE = 'AMU$OPTE'.
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=1306000K,IEFUSI=NO,CPUS=3
BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040308M,MEMLIMIT SET BY:REGION=0
0
BMC50471I LOADPLUS FOR DB2--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I SOLUTION COMMON CODE--V11.01.00
BMC50471I MAINT: BPJ0661 BPJ0667 BPJ0671 BPJ0674 BPJ0675 BPJ0676 BPJ0682 BPJ0686 BPJ0689 BPJ0697 BPJ0700 BPJ0702
BMC50471I BPJ0703 BPJ0706 BPJ0712 BPJ0715 BPJ0729 BPJ0773 BPJ0786 BPJ0794 BPJ0806 BPJ0830 BPJ0833 BPJ0839
BMC50471I BPJ0845 BPJ0866 BPJ0892 BPJ0913 BPJ0914 BPJ0916 BPJ0930 BPJ0944 BPJ0946
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922
BMC50471I BMC STATS API--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.01.00
BMC50471I MAINT: BPE0401 BPE0403 BPE0405 BPE0407 BPE0410 BPE0412 BPE0416 BPE0420 BPE0422 BPE0423 BPE0426 BPE0428
BMC50471I BPE0430 BPE0433 BPE0435 BPE0438 BPE0439
BMC50471I HIGH-SPEED APPLY ENGINE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
0
BMC50471I APCOMMIT=2500 FORCE_AT=(START,3) RCVYDDN=(BMCRCY,BMCRCZ)
BMC50471I APDOPTS= FORCE_RPT=NO REDEFINE=YES
BMC50471I APMULTIROW=100 FORCE=NONE RENMMAX=30
BMC50471I APMXAGNT=10 IBUFFS=20 RULES=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 = FREE FREE FREE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) N/A
BMC50470I VOLCNT = (25,25) (25,25) N/A
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) N/A
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) N/A
BMC50470I EXPDT = N/A N/A N/A
BMC50470I RETPD = N/A N/A N/A
BMC50470I GDGLIMIT = N/A N/A N/A
BMC50470I GDGEMPTY = N/A N/A N/A
BMC50470I GDGSCRAT = N/A N/A N/A
0
BMC50470I DDTYPE = ERROR DISCARD LOCPFCPY
BMC50470I ACTIVE = YES YES YES
BMC50470I IFALLOC = FREE FREE FREE
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 = FREE FREE FREE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = SYSMAP LOCPLCPY LOCBLCPY
BMC50470I ACTIVE = YES YES YES
BMC50470I IFALLOC = FREE FREE FREE
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 = YES YES YES
BMC50470I IFALLOC = FREE FREE FREE
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 = YES YES YES
BMC50470I IFALLOC = FREE FREE FREE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50483I LOAD DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I WORK DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I SORTWORK DSNPAT=NONE
BMC50483I ERROR DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I DISCARD DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I SYSMAP DSNPAT=&UID..BMC.&TS.&DDNAME
0
BMC50483I LOCPFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I LOCBFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMPFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMBFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
BMC50483I LOCPLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I LOCBLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I REMPLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I REMBLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
0
BMC50483I LOCPXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I LOCBXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMPXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMBXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
BMC50471I DB2 DSNHDECP MODULE SETTINGS:
BMC50471I VERSION = 1110
BMC50471I SUBSYSTEM DEFAULT = DEHJ
BMC50471I CHARACTER SET = ALPHANUM
BMC50471I DATE FORMAT = USA
BMC50471I TIME FORMAT = USA
BMC50471I LOCAL DATE LENGTH = 0
BMC50471I LOCAL TIME LENGTH = 0
BMC50471I DECIMAL POINT = PERIOD
BMC50471I DECIMAL ARITHMETIC = 15
BMC50471I DELIMITER = DEFAULT
BMC50471I SQL DELIMITER = DEFAULT
BMC50471I ENCODING SCHEME = EBCDIC
BMC50471I APPL. ENCODING SCHEME = EBCDIC
BMC50471I MIXED = NO
BMC50471I EBCDIC CCSID = (37,65534,65534)
BMC50471I ASCII CCSID = (819,65534,65534)
BMC50471I UNICODE CCSID = (367,1208,1200)
BMC50471I IMPLICIT TIME ZONE = CURRENT (-05:00)
BMC50028I DB2 MODE = NFM
BMC50471I BMC_BMCUTIL ='BMCUTIL.CMN_BMCUTIL'
BMC50471I BMC_BMCSYNC ='BMCUTIL.CMN_BMCSYNC'
BMC50471I BMC_BMCHIST ='BMCUTIL.CMN_BMCHIST'
BMC50471I BMC_BMCDICT ='BMCUTIL.CMN_BMCDICT'
0
0
BMC50102I LOAD DATA RESUME YES
BMC50102I SHRLEVEL CHANGE
BMC50102I ENUMROWS(100000)
BMC50102I ORDER YES
BMC50102I DDTYPE LOAD DSNPAT '&UID..RESUME&RESUME.&DDNAME'
BMC50102I DDTYPE WORK DSNPAT '&UID..RESUME&RESUME.&DDNAME'
BMC50102I DDTYPE SORTWORK DSNPAT '&UID..RESUME&RESUME.&DDNAME'
BMC50102I DDTYPE DISCARD DSNPAT '&UID..RESUME&RESUME.&DDNAME'
BMC50102I DDTYPE ERROR DSNPAT '&UID..RESUME&RESUME.&DDNAME'
BMC50102I DELETEFILES YES SYSDISC YES
BMC50102I INTO TABLE EXAMPLEC.TBL1
BMC50102I (RECNO POS(1:4) INTEGER,
BMC50102I INPUT_A POS(5:14) CHAR(10),
BMC50102I RECNO2 POS(15:18) INTEGER,
BMC50102I INPUT_B POS(19:28) CHAR(10),
BMC50102I INPUT_C POS(29:43) CHAR(15),
BMC50102I INPUT_D POS(44:58) CHAR(15)
BMC50102I )
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 = AMUEX12 &STEPNAME = EXAMP12B &DB = AMUEXCDB &TS = EXCTS &UID = RDAMZL
BMC50425I &RESUME = Y &REPLACE = N &DATE = 030915 &TIME = 150113 &SSID = DEHJ
BMC50425I &UTIL = EXAM12B &UTILPFX = EXAM12B &UTILSFX = &DATE8 = 03092015 &GRPNM = DEHJ
BMC50425I &VCAT = DEHJCAT &TIME4 = 1501 &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 SORTWK01 RDAMZL.RESUMEY.SORTWK01 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK02 RDAMZL.RESUMEY.SORTWK02 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK03 RDAMZL.RESUMEY.SORTWK03 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK04 RDAMZL.RESUMEY.SORTWK04 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK05 RDAMZL.RESUMEY.SORTWK05 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK06 RDAMZL.RESUMEY.SORTWK06 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK07 RDAMZL.RESUMEY.SORTWK07 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK08 RDAMZL.RESUMEY.SORTWK08 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK09 RDAMZL.RESUMEY.SORTWK09 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK10 RDAMZL.RESUMEY.SORTWK10 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK11 RDAMZL.RESUMEY.SORTWK11 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK12 RDAMZL.RESUMEY.SORTWK12 SYSALLDA 725 73 14 2 TRK
BMC50448I SYSDISC RDAMZL.RESUMEY.SYSDISC SYSALLDA 10218 1277 197 25 TRK
BMC50448I SYSERR RDAMZL.RESUMEY.SYSERR SYSALLDA 5315 2126 103 41 TRK
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8476K, ABOVE 16M = 1299368K, CPUS = 3
BMC50479I TOTAL PAGES: 3786928, ALLOWED: 1136079; AVAILABLE PAGES: 271516, ALLOWED: 0
BMC51499I COMBINED OPTIMIZATION, RC=0, #SORTS=5, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=83712
BMC51499I COMBINED OPTIMIZATION, RC=20, #SORTS=4, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=83712
BMC51500I COMBINED ANALYZE, #SORTS=5, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0
BMC50486I 6: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 5: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51576I 15:01:16 000 APT0000I HIGH-SPEED APPLY ENGINE V11.02.00
BMC51576I Copyright (c) 1999-2015 BMC Software, Inc. as an unpublished licensed work. All rights reserved.
BMC51576I 15:01:16 000 APT0001I Date: Mon Mar 9, 2015
BMC51576I 15:01:16 000 APT0215I MAINT: HIGH-SPEED APPLY ENGINE V11.02.00
BMC51576I 15:01:16 000 APT0215I MAINT: NONE APPLIED
BMC51576I 15:01:16 000 APT0215I MAINT: SOLUTION COMMON CODE V11.01.00
BMC50486I 3: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51576I 15:01:16 000 APT0215I MAINT: BPJ0661 BPJ0667 BPJ0671 BPJ0674 BPJ0675 BPJ0676 BPJ0682
BMC51576I 15:01:16 000 APT0215I MAINT: BPJ0686 BPJ0689 BPJ0697 BPJ0700 BPJ0702 BPJ0703 BPJ0706
BMC51576I 15:01:16 000 APT0215I MAINT: BPJ0712 BPJ0715 BPJ0729 BPJ0773 BPJ0786 BPJ0794 BPJ0806
BMC51576I 15:01:16 000 APT0215I MAINT: BPJ0830 BPJ0833 BPJ0839 BPJ0845 BPJ0866 BPJ0892 BPJ0913
BMC51576I 15:01:16 000 APT0215I MAINT: BPJ0914 BPJ0916 BPJ0930 BPJ0944 BPJ0946
BMC51576I 15:01:16 000 APT0215I MAINT: BMCSORT ENGINE V02.04.01
BMC51576I 15:01:16 000 APT0215I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922
BMC50486I 4: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51576I 15:01:16 000 APT0085I /STARTUP/
BMC51576I SSID=DEHJ
BMC51576I INPUTTYPE={3895D640-0BF1-11D4-8027-00104B39B10F}
BMC51576I PLANNAME=APTBREL
BMC51576I BINDQUALIFIER=APTTEST
BMC51576I DBMSTYPE=DB2
BMC51576I DISTRIBUTIONTYPE=OBJECT
BMC51576I LARGESTATEMENTSUPPORT=NO
BMC51576I 15:01:16 000 APT0085I /CONFIGURATION/
BMC51576I FILENAME=NONE
BMC51576I 15:01:16 000 APT0085I /SQL/
BMC51576I FORMAT=PACKED72
BMC51576I 15:01:16 000 APT0085I /COMMITTRIGGERS/
BMC51576I STATEMENTCOUNT=2500
BMC51576I COMMITONDEMAND=NO
BMC51576I 15:01:16 000 APT0085I /OBJECTMAP/
BMC51576I SOURCETABLE=0X1086.0X0003
BMC51576I TARGETTABLE='EXAMPLEC'.'TBL1'
BMC51576I 15:01:16 000 APT0085I /AGENT/
BMC51576I MAXAGENTS=10
BMC51576I INITIALAGENTS=5
BMC51576I MAXPREPARES=50
BMC51576I 15:01:16 000 APT0085I /TEMPORARYFILES/
BMC51576I UNIT=SYSALLDA
BMC51576I 15:01:16 000 APT0085I /DIAGNOSTICOUTPUT/
BMC51576I FILENAME=APTDIAG
BMC51576I 15:01:16 000 APT0085I /RESTART/
BMC51576I RESTARTID=EXAM12B
BMC51576I RESTARTTYPE=NEW
BMC51576I CHECKPOINTFREQUENCY=0
BMC51576I TABLENAME=BMCAPT_APTRSCL
BMC51576I RETAINTIME=7
BMC51576I RETRY=3
BMC51576I 15:01:16 000 APT0085I /DISTRIBUTIONTUNING/
BMC51576I SIMPLETSCLUSTERING=NO
BMC51576I RICLUSTERING=NO
BMC51576I PARTITIONCLUSTERING=NO
BMC51576I URCHECKRI=YES
BMC51576I 15:01:16 000 APT0085I /ANYCONFLICT/
BMC51576I CODE=-803
BMC51576I ACTION=CALLBACK
BMC51576I ACTION=CONTINUE
BMC51576I CODE=-530
BMC51576I ACTION=CALLBACK
BMC51576I ACTION=CONTINUE
BMC51576I CODE=-359
BMC51576I ACTION=CALLBACK
BMC51576I ACTION=CONTINUE
BMC51576I CODE=-330
BMC51576I ACTION=CALLBACK
BMC51576I ACTION=CONTINUE
BMC51576I CODE=SQLWARN0
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN1
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN2
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN3
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN4
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN5
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN6
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN7
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN8
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN9
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARNA
BMC51576I ACTION=WARN
BMC51576I CODE=NEGATIVE
BMC51576I ACTION=ABORT
BMC51576I CODE=POSITIVE
BMC51576I ACTION=WARN
BMC51576I CODE=MULTIPLEROWS
BMC51576I ACTION=WARN
BMC51576I CODE=NOROWS
BMC51576I ACTION=WARN
BMC51576I CODE=TIMEOUT
BMC51576I ACTION=RETRY
BMC51576I 15:01:16 000 APT0085I /INSERTCONFLICT/
BMC51576I CODE=MULTIROWCONFLICT
BMC51576I ACTION=RETRY
BMC51576I 15:01:16 000 APT0085I /CONFLICT/
BMC51576I RETRYLIMIT=COUNT
BMC51576I RETRYVALUE=5
BMC51576I DATATYPE=ID
BMC51576I DATATYPE=SQLCODE
BMC51576I DATATYPE=MESSAGE
BMC51576I RETRYFAIL=ABORT
BMC51576I RETRYDELAY=0
BMC51576I MAXFAILEDRETRIES=5
BMC51576I 15:01:16 000 APT0085I /CONFLICTFILE/
BMC51576I SPACE=TRACK
BMC51576I SPACEPRI=15
BMC51576I SPACESEC=5
BMC51576I FILENAMEMODEL=&SYSUID..BMCAPT.&REQUESTID..D&DATE..T&TIME.
BMC51576I SINGLEFILE=NO
BMC51576I DISP=NEW
BMC51576I MEDIATYPE=FILE
BMC51576I RELEASE=YES
BMC51576I 15:01:16 000 APT0085I /BIND/
BMC51576I FREEOPTION=ALL
BMC51576I PLANPREFIX=APT
BMC51576I 15:01:16 000 APT0085I /BINDTUNING/
BMC51576I STATEMENTCOUNT=1
BMC51576I MAXPACKAGES=25
BMC51576I MAXFAILEDBINDS=5
BMC51576I MAXRETRIES=5
BMC51576I PACKAGEUSAGE=500
BMC51576I STATEMENTUSAGE=200
BMC51576I 15:01:16 000 APT0085I /MULTIROWINSERT/
BMC51576I MULTIROWINSERT=YES
BMC51576I MAXROWS=100
BMC50486I 2: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51576I 15:01:17 001 APT0252I zIIP processing enabled using XBM SSID XBMB (v6.2.00)
BMC51576I 15:01:17 001 APT0238I Successful connect to DEHJ (Release 1110(NFM ) of DB2)
BMC51576I 15:01:17 001 APT0236I High-speed Apply starting with Multi-Row Inserts
BMC51576I 15:01:17 001 APT0097I Request ID: ACAG Restart ID: EXAM12B
BMC50481I 1: READ TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 1: READ TASK, XBLK XFERS = 140, EMPTY WAITS = 37, FULL WAITS = 0
BMC51478I PRELOAD STATISTICS: 100000 PHYSICAL (100000 LOGICAL) RECORDS READ FROM SYSREC
BMC51576I 15:01:18 000 APT0019I File DBRMLIB :SYS15068.T150118.RA000.AMUEX12.R0338606 allocated - elapsed time: 00:00:00
BMC51576I 15:01:18 001 APT0032I DSN output follows:
BMC51576I DSNT252I *DEHJ DSNTBCM1 BIND OPTIONS FOR PLAN APTACAG
BMC51576I ACTION ADD
BMC51576I OWNER RDAMZL
BMC51576I VALIDATE RUN
BMC51576I ISOLATION CS
BMC51576I ACQUIRE USE
BMC51576I RELEASE COMMIT
BMC51576I EXPLAIN NO
BMC51576I DYNAMICRULES RUN
BMC51576I PROGAUTH DISABLE
BMC51576I DSNT253I *DEHJ DSNTBCM1 BIND OPTIONS FOR PLAN APTACAG
BMC51576I NODEFER PREPARE
BMC51576I CACHESIZE 3072
BMC51576I QUALIFIER RDAMZL
BMC51576I CURRENTSERVER
BMC51576I CURRENTDATA NO
BMC51576I DEGREE 1
BMC51576I SQLRULES DB2
BMC51576I DISCONNECT EXPLICIT
BMC51576I REOPT NONE
BMC51576I KEEPDYNAMIC YES
BMC51576I IMMEDWRITE NO
BMC51576I DBPROTOCOL DRDA
BMC51576I OPTHINT
BMC51576I ENCODING EBCDIC(00037)
BMC51576I CONCURRENTACCESSRESOLUTION
BMC51576I
BMC51576I PATH
BMC51576I DSNT200I *DEHJ BIND FOR PLAN APTACAG SUCCESSFUL
BMC51576I 15:01:18 001 APT0032I DSN output follows:
BMC51576I DSNT254I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I ACTION ADD
BMC51576I OWNER RDAMZL
BMC51576I QUALIFIER RDAMZL
BMC51576I VALIDATE RUN
BMC51576I EXPLAIN NO
BMC51576I ISOLATION CS
BMC51576I RELEASE COMMIT
BMC51576I COPY
BMC51576I APREUSE
BMC51576I APCOMPARE
BMC51576I APRETAINDUP
BMC51576I BUSTIMESENSITIVE YES
BMC51576I SYSTIMESENSITIVE YES
BMC51576I ARCHIVESENSITIVE YES
BMC51576I APPLCOMPAT V11R1
BMC51576I DSNT255I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I SQLERROR NOPACKAGE
BMC51576I CURRENTDATA NO
BMC51576I DEGREE 1
BMC51576I DYNAMICRULES
BMC51576I DEFER
BMC51576I REOPT NONE
BMC51576I KEEPDYNAMIC YES
BMC51576I IMMEDWRITE NO
BMC51576I DBPROTOCOL DRDA
BMC51576I OPTHINT
BMC51576I ENCODING EBCDIC(00037)
BMC51576I PLANMGMT OFF
BMC51576I PLANMGMTSCOPE STATIC
BMC51576I CONCURRENTACCESSRESOLUTION
BMC51576I
BMC51576I EXTENDEDINDICATOR
BMC51576I
BMC51576I PATH
BMC51576I DSNT275I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I QUERYACCELERATION
BMC51576I GETACCELARCHIVE
BMC51576I DSNT232I *DEHJ SUCCESSFUL BIND FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I 15:01:18 006 APT0079I High-speed Apply processing started - Agent: 1
BMC51576I 15:01:18 007 APT0079I High-speed Apply processing started - Agent: 2
BMC51576I 15:01:18 008 APT0079I High-speed Apply processing started - Agent: 3
BMC51576I 15:01:18 009 APT0079I High-speed Apply processing started - Agent: 4
BMC51576I 15:01:18 010 APT0079I High-speed Apply processing started - Agent: 5
BMC51576I 15:01:19 001 APT0148I Bind started for package ACAG0001 - Trigger statistics:
BMC51576I STATEMENTCOUNT...........................1
BMC51576I PACKAGEUSAGE.............................1
BMC51576I STATEMENTUSAGE...........................1
BMC51576I 15:01:19 001 APT0032I DSN output follows:
BMC51576I DSNT254I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I ACTION ADD
BMC51576I OWNER RDAMZL
BMC51576I QUALIFIER RDAMZL
BMC51576I VALIDATE RUN
BMC51576I EXPLAIN NO
BMC51576I ISOLATION CS
BMC51576I RELEASE COMMIT
BMC51576I COPY
BMC51576I APREUSE
BMC51576I APCOMPARE
BMC51576I APRETAINDUP
BMC51576I BUSTIMESENSITIVE YES
BMC51576I SYSTIMESENSITIVE YES
BMC51576I ARCHIVESENSITIVE YES
BMC51576I APPLCOMPAT V11R1
BMC51576I DSNT255I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I SQLERROR NOPACKAGE
BMC51576I CURRENTDATA NO
BMC51576I DEGREE 1
BMC51576I DYNAMICRULES
BMC51576I DEFER
BMC51576I REOPT NONE
BMC51576I KEEPDYNAMIC YES
BMC51576I IMMEDWRITE NO
BMC51576I DBPROTOCOL DRDA
BMC51576I OPTHINT
BMC51576I ENCODING EBCDIC(00037)
BMC51576I PLANMGMT OFF
BMC51576I PLANMGMTSCOPE STATIC
BMC51576I CONCURRENTACCESSRESOLUTION
BMC51576I
BMC51576I EXTENDEDINDICATOR
BMC51576I
BMC51576I PATH
BMC51576I DSNT275I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I QUERYACCELERATION
BMC51576I GETACCELARCHIVE
BMC51576I DSNT232I *DEHJ SUCCESSFUL BIND FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I 15:01:19 001 APT0185I Statements committed: 25000
BMC51480I 3: DATA TASK COMPLETE. ELAPSED TIME = 00:00:04. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51510I 3: SORT TASK, XBLK XFERS = 28, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 3: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 39, FULL WAITS = 0
BMC51576I 15:01:20 001 APT0118I Input statements processed: 100000 Statement ID: 000186A000004E200003000501000186A0
BMC51576I 15:01:20 001 APT0066I Input processing complete
BMC51480I 4: DATA TASK COMPLETE. ELAPSED TIME = 00:00:04. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51480I 2: DATA TASK COMPLETE. ELAPSED TIME = 00:00:04. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51480I 5: DATA TASK COMPLETE. ELAPSED TIME = 00:00:04. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51480I 6: DATA TASK COMPLETE. ELAPSED TIME = 00:00:04. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51510I 2: SORT TASK, XBLK XFERS = 28, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 2: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 39, FULL WAITS = 0
BMC51510I 4: SORT TASK, XBLK XFERS = 28, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 4: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 40, FULL WAITS = 0
BMC51510I 5: SORT TASK, XBLK XFERS = 28, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 5: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 41, FULL WAITS = 0
BMC51510I 6: SORT TASK, XBLK XFERS = 28, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 6: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 41, FULL WAITS = 0
BMC51576I 15:01:20 001 APT0185I Statements committed: 65000
BMC51576I 15:01:21 007 APT0080I High-speed Apply processing ended - Agent: 2
BMC51576I 15:01:21 010 APT0080I High-speed Apply processing ended - Agent: 5
BMC51576I 15:01:21 009 APT0080I High-speed Apply processing ended - Agent: 4
BMC51576I 15:01:21 006 APT0080I High-speed Apply processing ended - Agent: 1
BMC51576I 15:01:21 008 APT0080I High-speed Apply processing ended - Agent: 3
BMC51576I 15:01:21 001 APT0047I TABLE STATISTICS - EXAMPLEC.TBL1
BMC51576I AGENT ASSIGNBY INSERT UPDATE DELETE TRUNCATE DDL TOTAL DBMS ELAPSED TIME
BMC51576I 0 PARTITION 100000 0 0 0 0 100000 00:00:07.620016
BMC51576I 15:01:21 001 APT0048I PARTITION STATISTICS - EXAMPLEC.TBL1
BMC51576I AGENT ASSIGNBY PART INSERT UPDATE DELETE TRUNCATE DDL TOTAL DBMS ELAPSED
TIME
BMC51576I 2 PARTITION 1 20000 0 0 0 0 20000 00:00:01.
446688
BMC51576I 4 PARTITION 2 20000 0 0 0 0 20000 00:00:01.
587457
BMC51576I 1 PARTITION 3 20000 0 0 0 0 20000 00:00:01.
620484
BMC51576I 3 PARTITION 4 20000 0 0 0 0 20000 00:00:01.
580643
BMC51576I 5 PARTITION 5 20000 0 0 0 0 20000 00:00:01.
384740
BMC51576I 15:01:22 001 APT0185I Statements committed: 100000
BMC51576I 15:01:22 001 APT0032I DSN output follows:
BMC51576I DSNT200I *DEHJ FREE FOR PLAN APTACAG SUCCESSFUL
BMC51576I 15:01:22 001 APT0032I DSN output follows:
BMC51576I DSNT232I *DEHJ SUCCESSFUL FREE FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I DSNT232I *DEHJ SUCCESSFUL FREE FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I 15:01:22 000 APT0020I File DBRMLIB :SYS15068.T150118.RA000.AMUEX12.R0338606 deallocated
BMC51576I 15:01:22 001 APT0111I INPUT PROCESSING STATISTICS
BMC51576I INSERT UPDATE DELETE TRUNCATE DDL TOTAL
BMC51576I 100000 0 0 0 0 100000
BMC51576I 15:01:22 001 APT0166I STATEMENTS COMMITTED STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE TRUNCATE DDL TOTAL
BMC51576I 1 200 0 0 0 0 200
BMC51576I 2 200 0 0 0 0 200
BMC51576I 3 200 0 0 0 0 200
BMC51576I 4 200 0 0 0 0 200
BMC51576I 5 200 0 0 0 0 200
BMC51576I ----- --------- --------- --------- --------- --------- ----------
BMC51576I TOTAL 1000 0 0 0 0 1000
BMC51576I 15:01:22 001 APT0082I DYNAMIC SQL PROCESSING STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE TRUNCATE COMMIT ROLLBACK TOTAL
BMC51576I 1 0 0 0 0 0 0 0
BMC51576I 2 0 0 0 0 0 0 0
BMC51576I 3 0 0 0 0 0 0 0
BMC51576I 4 0 0 0 0 0 0 0
BMC51576I 5 0 0 0 0 0 0 0
BMC51576I ----- --------- --------- --------- --------- --------- --------- ----------
BMC51576I TOTAL 0 0 0 0 0 0 0
BMC51576I 15:01:22 001 APT0081I STATIC SQL PROCESSING STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE TRUNCATE MASSDEL COMMIT ROLLBACK PREPARE EXECUTE
TOTAL
BMC51576I 1 200 0 0 0 0 8 0 0 0
208
BMC51576I 2 200 0 0 0 0 8 0 0 0
208
BMC51576I 3 200 0 0 0 0 8 0 0 0
208
BMC51576I 4 200 0 0 0 0 8 0 0 0
208
BMC51576I 5 200 0 0 0 0 8 0 0 0
208
BMC51576I ----- --------- --------- --------- --------- --------- --------- --------- --------- ---------
----------
BMC51576I TOTAL 1000 0 0 0 0 40 0 0 0
1040
BMC51576I 15:01:22 001 APT0200I EXECUTE IMMEDIATE PROCESSING STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE TRUNCATE DDL TOTAL
BMC51576I 1 0 0 0 0 0 0
BMC51576I 2 0 0 0 0 0 0
BMC51576I 3 0 0 0 0 0 0
BMC51576I 4 0 0 0 0 0 0
BMC51576I 5 0 0 0 0 0 0
BMC51576I ----- --------- --------- --------- --------- --------- ----------
BMC51576I TOTAL 0 0 0 0 0 0
BMC51576I 15:01:22 001 APT0234I ROW STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE MASSDEL TOTAL
BMC51576I 1 20000 0 0 0 20000
BMC51576I 2 20000 0 0 0 20000
BMC51576I 3 20000 0 0 0 20000
BMC51576I 4 20000 0 0 0 20000
BMC51576I 5 20000 0 0 0 20000
BMC51576I ----- --------- --------- --------- --------- ----------
BMC51576I TOTAL 100000 0 0 0 100000
BMC51576I 15:01:22 001 APT0206I PACKAGE STATISTICS
BMC51576I NAME STMTCNT USAGECNT RETRIES BIND ELAPSED TIME
BMC51576I ACAG0000 101 0 0 00:00:00.187001
BMC51576I ACAG0001 1 100000 0 00:00:00.163639
BMC51576I --------- --------- --------- --------- -----------------
BMC51576I TOTAL 102 100000 0 00:00:00.350641
BMC51576I 15:01:22 001 APT0182I OTHER STATISTICS
BMC51576I AGENT FAILPREPS RETRIES DBMS ELAPSED TIME
BMC51576I 1 0 0 00:00:02.327402
BMC51576I 2 0 0 00:00:02.267974
BMC51576I 3 0 0 00:00:02.281307
BMC51576I 4 0 0 00:00:02.292870
BMC51576I 5 0 0 00:00:02.241191
BMC51576I ----- --------- --------- -----------------
BMC51576I TOTAL 0 0 00:00:11.410748
BMC51576I 15:01:22 001 APT0183I Request elapsed time: 00:00:05.202493
BMC51576I 15:01:22 000 APT0067I Request completed Return code: 0
BMC50481I 10: SQLAPPLY TASK COMPLETE. ELAPSED TIME = 00:00:06
BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC, I/OS = 20, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC51507I XBLKS = 20, XFERS = 140, EMPTY WAITS = 37, FULL WAITS =0
BMC51507I APBUFS = 15, XFERS = 215, EMPTY WAITS = 200, FULL WAITS =0
BMC50476I DDNAME = SYSDISC, I/OS = 0, I/O WAITS = 0, RDB LOCK WAITS = 0
BMC51472I COMBINED PHASE STATISTICS: 100000 ROWS SELECTED FOR SPACE 'AMUEXCDB.EXCTS', 0 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
BMC51479I COMBINED PHASE STATISTICS: 0 PHYSICAL (0 LOGICAL) RECORDS DISCARDED TO SYSDISC
BMC51475I LOAD STATISTICS: 100000 ROWS LOADED INTO TABLE SPACE 'AMUEXCDB.EXCTS'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR ', DSNAME = 'RDAMZL.RESUMEY.SYSERR'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK01', DSNAME = 'RDAMZL.RESUMEY.SORTWK01'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK02', DSNAME = 'RDAMZL.RESUMEY.SORTWK02'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK03', DSNAME = 'RDAMZL.RESUMEY.SORTWK03'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK04', DSNAME = 'RDAMZL.RESUMEY.SORTWK04'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK05', DSNAME = 'RDAMZL.RESUMEY.SORTWK05'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK06', DSNAME = 'RDAMZL.RESUMEY.SORTWK06'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK07', DSNAME = 'RDAMZL.RESUMEY.SORTWK07'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK08', DSNAME = 'RDAMZL.RESUMEY.SORTWK08'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK09', DSNAME = 'RDAMZL.RESUMEY.SORTWK09'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK10', DSNAME = 'RDAMZL.RESUMEY.SORTWK10'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK11', DSNAME = 'RDAMZL.RESUMEY.SORTWK11'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK12', DSNAME = 'RDAMZL.RESUMEY.SORTWK12'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSDISC ', DSNAME = 'RDAMZL.RESUMEY.SYSDISC'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I COMBINED PHASE COMPLETE. ELAPSED TIME = 00:00:06
BMC51577I ROWS DISCARDED
BMC51578I INSERTED SQLERRORS
BMC51579I SPACE AMUEXCDB.EXCTS 100000 0
BMC51579I PART 0001 20000 0
BMC51579I PART 0002 20000 0
BMC51579I PART 0003 20000 0
BMC51579I PART 0004 20000 0
BMC51579I PART 0005 20000 0
BMC50004I UTILTERM PHASE COMPLETE. ELAPSED TIME = 00:00:00
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 15:01:13 ...
BMC50002I UTILITY ID = 'EXAM12B'. DB2 SUBSYSTEM ID = 'DEHJ'. OPTION MODULE = 'AMU$OPTE'.
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=1306000K,IEFUSI=NO,CPUS=3
BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040308M,MEMLIMIT SET BY:REGION=0
0
BMC50471I LOADPLUS FOR DB2--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I SOLUTION COMMON CODE--V11.01.00
BMC50471I MAINT: BPJ0661 BPJ0667 BPJ0671 BPJ0674 BPJ0675 BPJ0676 BPJ0682 BPJ0686 BPJ0689 BPJ0697 BPJ0700 BPJ0702
BMC50471I BPJ0703 BPJ0706 BPJ0712 BPJ0715 BPJ0729 BPJ0773 BPJ0786 BPJ0794 BPJ0806 BPJ0830 BPJ0833 BPJ0839
BMC50471I BPJ0845 BPJ0866 BPJ0892 BPJ0913 BPJ0914 BPJ0916 BPJ0930 BPJ0944 BPJ0946
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922
BMC50471I BMC STATS API--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.01.00
BMC50471I MAINT: BPE0401 BPE0403 BPE0405 BPE0407 BPE0410 BPE0412 BPE0416 BPE0420 BPE0422 BPE0423 BPE0426 BPE0428
BMC50471I BPE0430 BPE0433 BPE0435 BPE0438 BPE0439
BMC50471I HIGH-SPEED APPLY ENGINE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
0
BMC50471I APCOMMIT=2500 FORCE_AT=(START,3) RCVYDDN=(BMCRCY,BMCRCZ)
BMC50471I APDOPTS= FORCE_RPT=NO REDEFINE=YES
BMC50471I APMULTIROW=100 FORCE=NONE RENMMAX=30
BMC50471I APMXAGNT=10 IBUFFS=20 RULES=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 = FREE FREE FREE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) N/A
BMC50470I VOLCNT = (25,25) (25,25) N/A
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) N/A
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) N/A
BMC50470I EXPDT = N/A N/A N/A
BMC50470I RETPD = N/A N/A N/A
BMC50470I GDGLIMIT = N/A N/A N/A
BMC50470I GDGEMPTY = N/A N/A N/A
BMC50470I GDGSCRAT = N/A N/A N/A
0
BMC50470I DDTYPE = ERROR DISCARD LOCPFCPY
BMC50470I ACTIVE = YES YES YES
BMC50470I IFALLOC = FREE FREE FREE
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 = FREE FREE FREE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = SYSMAP LOCPLCPY LOCBLCPY
BMC50470I ACTIVE = YES YES YES
BMC50470I IFALLOC = FREE FREE FREE
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 = YES YES YES
BMC50470I IFALLOC = FREE FREE FREE
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 = YES YES YES
BMC50470I IFALLOC = FREE FREE FREE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50483I LOAD DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I WORK DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I SORTWORK DSNPAT=NONE
BMC50483I ERROR DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I DISCARD DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I SYSMAP DSNPAT=&UID..BMC.&TS.&DDNAME
0
BMC50483I LOCPFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I LOCBFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMPFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMBFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
BMC50483I LOCPLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I LOCBLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I REMPLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I REMBLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
0
BMC50483I LOCPXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I LOCBXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMPXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMBXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
BMC50471I DB2 DSNHDECP MODULE SETTINGS:
BMC50471I VERSION = 1110
BMC50471I SUBSYSTEM DEFAULT = DEHJ
BMC50471I CHARACTER SET = ALPHANUM
BMC50471I DATE FORMAT = USA
BMC50471I TIME FORMAT = USA
BMC50471I LOCAL DATE LENGTH = 0
BMC50471I LOCAL TIME LENGTH = 0
BMC50471I DECIMAL POINT = PERIOD
BMC50471I DECIMAL ARITHMETIC = 15
BMC50471I DELIMITER = DEFAULT
BMC50471I SQL DELIMITER = DEFAULT
BMC50471I ENCODING SCHEME = EBCDIC
BMC50471I APPL. ENCODING SCHEME = EBCDIC
BMC50471I MIXED = NO
BMC50471I EBCDIC CCSID = (37,65534,65534)
BMC50471I ASCII CCSID = (819,65534,65534)
BMC50471I UNICODE CCSID = (367,1208,1200)
BMC50471I IMPLICIT TIME ZONE = CURRENT (-05:00)
BMC50028I DB2 MODE = NFM
BMC50471I BMC_BMCUTIL ='BMCUTIL.CMN_BMCUTIL'
BMC50471I BMC_BMCSYNC ='BMCUTIL.CMN_BMCSYNC'
BMC50471I BMC_BMCHIST ='BMCUTIL.CMN_BMCHIST'
BMC50471I BMC_BMCDICT ='BMCUTIL.CMN_BMCDICT'
0
0
BMC50102I LOAD DATA RESUME YES
BMC50102I SHRLEVEL CHANGE
BMC50102I ENUMROWS(100000)
BMC50102I ORDER YES
BMC50102I DDTYPE LOAD DSNPAT '&UID..RESUME&RESUME.&DDNAME'
BMC50102I DDTYPE WORK DSNPAT '&UID..RESUME&RESUME.&DDNAME'
BMC50102I DDTYPE SORTWORK DSNPAT '&UID..RESUME&RESUME.&DDNAME'
BMC50102I DDTYPE DISCARD DSNPAT '&UID..RESUME&RESUME.&DDNAME'
BMC50102I DDTYPE ERROR DSNPAT '&UID..RESUME&RESUME.&DDNAME'
BMC50102I DELETEFILES YES SYSDISC YES
BMC50102I INTO TABLE EXAMPLEC.TBL1
BMC50102I (RECNO POS(1:4) INTEGER,
BMC50102I INPUT_A POS(5:14) CHAR(10),
BMC50102I RECNO2 POS(15:18) INTEGER,
BMC50102I INPUT_B POS(19:28) CHAR(10),
BMC50102I INPUT_C POS(29:43) CHAR(15),
BMC50102I INPUT_D POS(44:58) CHAR(15)
BMC50102I )
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 = AMUEX12 &STEPNAME = EXAMP12B &DB = AMUEXCDB &TS = EXCTS &UID = RDAMZL
BMC50425I &RESUME = Y &REPLACE = N &DATE = 030915 &TIME = 150113 &SSID = DEHJ
BMC50425I &UTIL = EXAM12B &UTILPFX = EXAM12B &UTILSFX = &DATE8 = 03092015 &GRPNM = DEHJ
BMC50425I &VCAT = DEHJCAT &TIME4 = 1501 &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 SORTWK01 RDAMZL.RESUMEY.SORTWK01 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK02 RDAMZL.RESUMEY.SORTWK02 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK03 RDAMZL.RESUMEY.SORTWK03 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK04 RDAMZL.RESUMEY.SORTWK04 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK05 RDAMZL.RESUMEY.SORTWK05 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK06 RDAMZL.RESUMEY.SORTWK06 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK07 RDAMZL.RESUMEY.SORTWK07 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK08 RDAMZL.RESUMEY.SORTWK08 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK09 RDAMZL.RESUMEY.SORTWK09 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK10 RDAMZL.RESUMEY.SORTWK10 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK11 RDAMZL.RESUMEY.SORTWK11 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK12 RDAMZL.RESUMEY.SORTWK12 SYSALLDA 725 73 14 2 TRK
BMC50448I SYSDISC RDAMZL.RESUMEY.SYSDISC SYSALLDA 10218 1277 197 25 TRK
BMC50448I SYSERR RDAMZL.RESUMEY.SYSERR SYSALLDA 5315 2126 103 41 TRK
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8476K, ABOVE 16M = 1299368K, CPUS = 3
BMC50479I TOTAL PAGES: 3786928, ALLOWED: 1136079; AVAILABLE PAGES: 271516, ALLOWED: 0
BMC51499I COMBINED OPTIMIZATION, RC=0, #SORTS=5, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=83712
BMC51499I COMBINED OPTIMIZATION, RC=20, #SORTS=4, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=83712
BMC51500I COMBINED ANALYZE, #SORTS=5, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0
BMC50486I 6: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 5: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51576I 15:01:16 000 APT0000I HIGH-SPEED APPLY ENGINE V11.02.00
BMC51576I Copyright (c) 1999-2015 BMC Software, Inc. as an unpublished licensed work. All rights reserved.
BMC51576I 15:01:16 000 APT0001I Date: Mon Mar 9, 2015
BMC51576I 15:01:16 000 APT0215I MAINT: HIGH-SPEED APPLY ENGINE V11.02.00
BMC51576I 15:01:16 000 APT0215I MAINT: NONE APPLIED
BMC51576I 15:01:16 000 APT0215I MAINT: SOLUTION COMMON CODE V11.01.00
BMC50486I 3: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51576I 15:01:16 000 APT0215I MAINT: BPJ0661 BPJ0667 BPJ0671 BPJ0674 BPJ0675 BPJ0676 BPJ0682
BMC51576I 15:01:16 000 APT0215I MAINT: BPJ0686 BPJ0689 BPJ0697 BPJ0700 BPJ0702 BPJ0703 BPJ0706
BMC51576I 15:01:16 000 APT0215I MAINT: BPJ0712 BPJ0715 BPJ0729 BPJ0773 BPJ0786 BPJ0794 BPJ0806
BMC51576I 15:01:16 000 APT0215I MAINT: BPJ0830 BPJ0833 BPJ0839 BPJ0845 BPJ0866 BPJ0892 BPJ0913
BMC51576I 15:01:16 000 APT0215I MAINT: BPJ0914 BPJ0916 BPJ0930 BPJ0944 BPJ0946
BMC51576I 15:01:16 000 APT0215I MAINT: BMCSORT ENGINE V02.04.01
BMC51576I 15:01:16 000 APT0215I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922
BMC50486I 4: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51576I 15:01:16 000 APT0085I /STARTUP/
BMC51576I SSID=DEHJ
BMC51576I INPUTTYPE={3895D640-0BF1-11D4-8027-00104B39B10F}
BMC51576I PLANNAME=APTBREL
BMC51576I BINDQUALIFIER=APTTEST
BMC51576I DBMSTYPE=DB2
BMC51576I DISTRIBUTIONTYPE=OBJECT
BMC51576I LARGESTATEMENTSUPPORT=NO
BMC51576I 15:01:16 000 APT0085I /CONFIGURATION/
BMC51576I FILENAME=NONE
BMC51576I 15:01:16 000 APT0085I /SQL/
BMC51576I FORMAT=PACKED72
BMC51576I 15:01:16 000 APT0085I /COMMITTRIGGERS/
BMC51576I STATEMENTCOUNT=2500
BMC51576I COMMITONDEMAND=NO
BMC51576I 15:01:16 000 APT0085I /OBJECTMAP/
BMC51576I SOURCETABLE=0X1086.0X0003
BMC51576I TARGETTABLE='EXAMPLEC'.'TBL1'
BMC51576I 15:01:16 000 APT0085I /AGENT/
BMC51576I MAXAGENTS=10
BMC51576I INITIALAGENTS=5
BMC51576I MAXPREPARES=50
BMC51576I 15:01:16 000 APT0085I /TEMPORARYFILES/
BMC51576I UNIT=SYSALLDA
BMC51576I 15:01:16 000 APT0085I /DIAGNOSTICOUTPUT/
BMC51576I FILENAME=APTDIAG
BMC51576I 15:01:16 000 APT0085I /RESTART/
BMC51576I RESTARTID=EXAM12B
BMC51576I RESTARTTYPE=NEW
BMC51576I CHECKPOINTFREQUENCY=0
BMC51576I TABLENAME=BMCAPT_APTRSCL
BMC51576I RETAINTIME=7
BMC51576I RETRY=3
BMC51576I 15:01:16 000 APT0085I /DISTRIBUTIONTUNING/
BMC51576I SIMPLETSCLUSTERING=NO
BMC51576I RICLUSTERING=NO
BMC51576I PARTITIONCLUSTERING=NO
BMC51576I URCHECKRI=YES
BMC51576I 15:01:16 000 APT0085I /ANYCONFLICT/
BMC51576I CODE=-803
BMC51576I ACTION=CALLBACK
BMC51576I ACTION=CONTINUE
BMC51576I CODE=-530
BMC51576I ACTION=CALLBACK
BMC51576I ACTION=CONTINUE
BMC51576I CODE=-359
BMC51576I ACTION=CALLBACK
BMC51576I ACTION=CONTINUE
BMC51576I CODE=-330
BMC51576I ACTION=CALLBACK
BMC51576I ACTION=CONTINUE
BMC51576I CODE=SQLWARN0
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN1
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN2
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN3
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN4
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN5
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN6
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN7
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN8
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARN9
BMC51576I ACTION=WARN
BMC51576I CODE=SQLWARNA
BMC51576I ACTION=WARN
BMC51576I CODE=NEGATIVE
BMC51576I ACTION=ABORT
BMC51576I CODE=POSITIVE
BMC51576I ACTION=WARN
BMC51576I CODE=MULTIPLEROWS
BMC51576I ACTION=WARN
BMC51576I CODE=NOROWS
BMC51576I ACTION=WARN
BMC51576I CODE=TIMEOUT
BMC51576I ACTION=RETRY
BMC51576I 15:01:16 000 APT0085I /INSERTCONFLICT/
BMC51576I CODE=MULTIROWCONFLICT
BMC51576I ACTION=RETRY
BMC51576I 15:01:16 000 APT0085I /CONFLICT/
BMC51576I RETRYLIMIT=COUNT
BMC51576I RETRYVALUE=5
BMC51576I DATATYPE=ID
BMC51576I DATATYPE=SQLCODE
BMC51576I DATATYPE=MESSAGE
BMC51576I RETRYFAIL=ABORT
BMC51576I RETRYDELAY=0
BMC51576I MAXFAILEDRETRIES=5
BMC51576I 15:01:16 000 APT0085I /CONFLICTFILE/
BMC51576I SPACE=TRACK
BMC51576I SPACEPRI=15
BMC51576I SPACESEC=5
BMC51576I FILENAMEMODEL=&SYSUID..BMCAPT.&REQUESTID..D&DATE..T&TIME.
BMC51576I SINGLEFILE=NO
BMC51576I DISP=NEW
BMC51576I MEDIATYPE=FILE
BMC51576I RELEASE=YES
BMC51576I 15:01:16 000 APT0085I /BIND/
BMC51576I FREEOPTION=ALL
BMC51576I PLANPREFIX=APT
BMC51576I 15:01:16 000 APT0085I /BINDTUNING/
BMC51576I STATEMENTCOUNT=1
BMC51576I MAXPACKAGES=25
BMC51576I MAXFAILEDBINDS=5
BMC51576I MAXRETRIES=5
BMC51576I PACKAGEUSAGE=500
BMC51576I STATEMENTUSAGE=200
BMC51576I 15:01:16 000 APT0085I /MULTIROWINSERT/
BMC51576I MULTIROWINSERT=YES
BMC51576I MAXROWS=100
BMC50486I 2: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51576I 15:01:17 001 APT0252I zIIP processing enabled using XBM SSID XBMB (v6.2.00)
BMC51576I 15:01:17 001 APT0238I Successful connect to DEHJ (Release 1110(NFM ) of DB2)
BMC51576I 15:01:17 001 APT0236I High-speed Apply starting with Multi-Row Inserts
BMC51576I 15:01:17 001 APT0097I Request ID: ACAG Restart ID: EXAM12B
BMC50481I 1: READ TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 1: READ TASK, XBLK XFERS = 140, EMPTY WAITS = 37, FULL WAITS = 0
BMC51478I PRELOAD STATISTICS: 100000 PHYSICAL (100000 LOGICAL) RECORDS READ FROM SYSREC
BMC51576I 15:01:18 000 APT0019I File DBRMLIB :SYS15068.T150118.RA000.AMUEX12.R0338606 allocated - elapsed time: 00:00:00
BMC51576I 15:01:18 001 APT0032I DSN output follows:
BMC51576I DSNT252I *DEHJ DSNTBCM1 BIND OPTIONS FOR PLAN APTACAG
BMC51576I ACTION ADD
BMC51576I OWNER RDAMZL
BMC51576I VALIDATE RUN
BMC51576I ISOLATION CS
BMC51576I ACQUIRE USE
BMC51576I RELEASE COMMIT
BMC51576I EXPLAIN NO
BMC51576I DYNAMICRULES RUN
BMC51576I PROGAUTH DISABLE
BMC51576I DSNT253I *DEHJ DSNTBCM1 BIND OPTIONS FOR PLAN APTACAG
BMC51576I NODEFER PREPARE
BMC51576I CACHESIZE 3072
BMC51576I QUALIFIER RDAMZL
BMC51576I CURRENTSERVER
BMC51576I CURRENTDATA NO
BMC51576I DEGREE 1
BMC51576I SQLRULES DB2
BMC51576I DISCONNECT EXPLICIT
BMC51576I REOPT NONE
BMC51576I KEEPDYNAMIC YES
BMC51576I IMMEDWRITE NO
BMC51576I DBPROTOCOL DRDA
BMC51576I OPTHINT
BMC51576I ENCODING EBCDIC(00037)
BMC51576I CONCURRENTACCESSRESOLUTION
BMC51576I
BMC51576I PATH
BMC51576I DSNT200I *DEHJ BIND FOR PLAN APTACAG SUCCESSFUL
BMC51576I 15:01:18 001 APT0032I DSN output follows:
BMC51576I DSNT254I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I ACTION ADD
BMC51576I OWNER RDAMZL
BMC51576I QUALIFIER RDAMZL
BMC51576I VALIDATE RUN
BMC51576I EXPLAIN NO
BMC51576I ISOLATION CS
BMC51576I RELEASE COMMIT
BMC51576I COPY
BMC51576I APREUSE
BMC51576I APCOMPARE
BMC51576I APRETAINDUP
BMC51576I BUSTIMESENSITIVE YES
BMC51576I SYSTIMESENSITIVE YES
BMC51576I ARCHIVESENSITIVE YES
BMC51576I APPLCOMPAT V11R1
BMC51576I DSNT255I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I SQLERROR NOPACKAGE
BMC51576I CURRENTDATA NO
BMC51576I DEGREE 1
BMC51576I DYNAMICRULES
BMC51576I DEFER
BMC51576I REOPT NONE
BMC51576I KEEPDYNAMIC YES
BMC51576I IMMEDWRITE NO
BMC51576I DBPROTOCOL DRDA
BMC51576I OPTHINT
BMC51576I ENCODING EBCDIC(00037)
BMC51576I PLANMGMT OFF
BMC51576I PLANMGMTSCOPE STATIC
BMC51576I CONCURRENTACCESSRESOLUTION
BMC51576I
BMC51576I EXTENDEDINDICATOR
BMC51576I
BMC51576I PATH
BMC51576I DSNT275I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I QUERYACCELERATION
BMC51576I GETACCELARCHIVE
BMC51576I DSNT232I *DEHJ SUCCESSFUL BIND FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I 15:01:18 006 APT0079I High-speed Apply processing started - Agent: 1
BMC51576I 15:01:18 007 APT0079I High-speed Apply processing started - Agent: 2
BMC51576I 15:01:18 008 APT0079I High-speed Apply processing started - Agent: 3
BMC51576I 15:01:18 009 APT0079I High-speed Apply processing started - Agent: 4
BMC51576I 15:01:18 010 APT0079I High-speed Apply processing started - Agent: 5
BMC51576I 15:01:19 001 APT0148I Bind started for package ACAG0001 - Trigger statistics:
BMC51576I STATEMENTCOUNT...........................1
BMC51576I PACKAGEUSAGE.............................1
BMC51576I STATEMENTUSAGE...........................1
BMC51576I 15:01:19 001 APT0032I DSN output follows:
BMC51576I DSNT254I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I ACTION ADD
BMC51576I OWNER RDAMZL
BMC51576I QUALIFIER RDAMZL
BMC51576I VALIDATE RUN
BMC51576I EXPLAIN NO
BMC51576I ISOLATION CS
BMC51576I RELEASE COMMIT
BMC51576I COPY
BMC51576I APREUSE
BMC51576I APCOMPARE
BMC51576I APRETAINDUP
BMC51576I BUSTIMESENSITIVE YES
BMC51576I SYSTIMESENSITIVE YES
BMC51576I ARCHIVESENSITIVE YES
BMC51576I APPLCOMPAT V11R1
BMC51576I DSNT255I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I SQLERROR NOPACKAGE
BMC51576I CURRENTDATA NO
BMC51576I DEGREE 1
BMC51576I DYNAMICRULES
BMC51576I DEFER
BMC51576I REOPT NONE
BMC51576I KEEPDYNAMIC YES
BMC51576I IMMEDWRITE NO
BMC51576I DBPROTOCOL DRDA
BMC51576I OPTHINT
BMC51576I ENCODING EBCDIC(00037)
BMC51576I PLANMGMT OFF
BMC51576I PLANMGMTSCOPE STATIC
BMC51576I CONCURRENTACCESSRESOLUTION
BMC51576I
BMC51576I EXTENDEDINDICATOR
BMC51576I
BMC51576I PATH
BMC51576I DSNT275I *DEHJ DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I QUERYACCELERATION
BMC51576I GETACCELARCHIVE
BMC51576I DSNT232I *DEHJ SUCCESSFUL BIND FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I 15:01:19 001 APT0185I Statements committed: 25000
BMC51480I 3: DATA TASK COMPLETE. ELAPSED TIME = 00:00:04. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51510I 3: SORT TASK, XBLK XFERS = 28, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 3: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 39, FULL WAITS = 0
BMC51576I 15:01:20 001 APT0118I Input statements processed: 100000 Statement ID: 000186A000004E200003000501000186A0
BMC51576I 15:01:20 001 APT0066I Input processing complete
BMC51480I 4: DATA TASK COMPLETE. ELAPSED TIME = 00:00:04. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51480I 2: DATA TASK COMPLETE. ELAPSED TIME = 00:00:04. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51480I 5: DATA TASK COMPLETE. ELAPSED TIME = 00:00:04. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51480I 6: DATA TASK COMPLETE. ELAPSED TIME = 00:00:04. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51510I 2: SORT TASK, XBLK XFERS = 28, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 2: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 39, FULL WAITS = 0
BMC51510I 4: SORT TASK, XBLK XFERS = 28, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 4: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 40, FULL WAITS = 0
BMC51510I 5: SORT TASK, XBLK XFERS = 28, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 5: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 41, FULL WAITS = 0
BMC51510I 6: SORT TASK, XBLK XFERS = 28, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 6: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 41, FULL WAITS = 0
BMC51576I 15:01:20 001 APT0185I Statements committed: 65000
BMC51576I 15:01:21 007 APT0080I High-speed Apply processing ended - Agent: 2
BMC51576I 15:01:21 010 APT0080I High-speed Apply processing ended - Agent: 5
BMC51576I 15:01:21 009 APT0080I High-speed Apply processing ended - Agent: 4
BMC51576I 15:01:21 006 APT0080I High-speed Apply processing ended - Agent: 1
BMC51576I 15:01:21 008 APT0080I High-speed Apply processing ended - Agent: 3
BMC51576I 15:01:21 001 APT0047I TABLE STATISTICS - EXAMPLEC.TBL1
BMC51576I AGENT ASSIGNBY INSERT UPDATE DELETE TRUNCATE DDL TOTAL DBMS ELAPSED TIME
BMC51576I 0 PARTITION 100000 0 0 0 0 100000 00:00:07.620016
BMC51576I 15:01:21 001 APT0048I PARTITION STATISTICS - EXAMPLEC.TBL1
BMC51576I AGENT ASSIGNBY PART INSERT UPDATE DELETE TRUNCATE DDL TOTAL DBMS ELAPSED
TIME
BMC51576I 2 PARTITION 1 20000 0 0 0 0 20000 00:00:01.
446688
BMC51576I 4 PARTITION 2 20000 0 0 0 0 20000 00:00:01.
587457
BMC51576I 1 PARTITION 3 20000 0 0 0 0 20000 00:00:01.
620484
BMC51576I 3 PARTITION 4 20000 0 0 0 0 20000 00:00:01.
580643
BMC51576I 5 PARTITION 5 20000 0 0 0 0 20000 00:00:01.
384740
BMC51576I 15:01:22 001 APT0185I Statements committed: 100000
BMC51576I 15:01:22 001 APT0032I DSN output follows:
BMC51576I DSNT200I *DEHJ FREE FOR PLAN APTACAG SUCCESSFUL
BMC51576I 15:01:22 001 APT0032I DSN output follows:
BMC51576I DSNT232I *DEHJ SUCCESSFUL FREE FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0000.()
BMC51576I DSNT232I *DEHJ SUCCESSFUL FREE FOR
BMC51576I PACKAGE = DEHJ.APTACAG.ACAG0001.()
BMC51576I 15:01:22 000 APT0020I File DBRMLIB :SYS15068.T150118.RA000.AMUEX12.R0338606 deallocated
BMC51576I 15:01:22 001 APT0111I INPUT PROCESSING STATISTICS
BMC51576I INSERT UPDATE DELETE TRUNCATE DDL TOTAL
BMC51576I 100000 0 0 0 0 100000
BMC51576I 15:01:22 001 APT0166I STATEMENTS COMMITTED STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE TRUNCATE DDL TOTAL
BMC51576I 1 200 0 0 0 0 200
BMC51576I 2 200 0 0 0 0 200
BMC51576I 3 200 0 0 0 0 200
BMC51576I 4 200 0 0 0 0 200
BMC51576I 5 200 0 0 0 0 200
BMC51576I ----- --------- --------- --------- --------- --------- ----------
BMC51576I TOTAL 1000 0 0 0 0 1000
BMC51576I 15:01:22 001 APT0082I DYNAMIC SQL PROCESSING STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE TRUNCATE COMMIT ROLLBACK TOTAL
BMC51576I 1 0 0 0 0 0 0 0
BMC51576I 2 0 0 0 0 0 0 0
BMC51576I 3 0 0 0 0 0 0 0
BMC51576I 4 0 0 0 0 0 0 0
BMC51576I 5 0 0 0 0 0 0 0
BMC51576I ----- --------- --------- --------- --------- --------- --------- ----------
BMC51576I TOTAL 0 0 0 0 0 0 0
BMC51576I 15:01:22 001 APT0081I STATIC SQL PROCESSING STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE TRUNCATE MASSDEL COMMIT ROLLBACK PREPARE EXECUTE
TOTAL
BMC51576I 1 200 0 0 0 0 8 0 0 0
208
BMC51576I 2 200 0 0 0 0 8 0 0 0
208
BMC51576I 3 200 0 0 0 0 8 0 0 0
208
BMC51576I 4 200 0 0 0 0 8 0 0 0
208
BMC51576I 5 200 0 0 0 0 8 0 0 0
208
BMC51576I ----- --------- --------- --------- --------- --------- --------- --------- --------- ---------
----------
BMC51576I TOTAL 1000 0 0 0 0 40 0 0 0
1040
BMC51576I 15:01:22 001 APT0200I EXECUTE IMMEDIATE PROCESSING STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE TRUNCATE DDL TOTAL
BMC51576I 1 0 0 0 0 0 0
BMC51576I 2 0 0 0 0 0 0
BMC51576I 3 0 0 0 0 0 0
BMC51576I 4 0 0 0 0 0 0
BMC51576I 5 0 0 0 0 0 0
BMC51576I ----- --------- --------- --------- --------- --------- ----------
BMC51576I TOTAL 0 0 0 0 0 0
BMC51576I 15:01:22 001 APT0234I ROW STATISTICS
BMC51576I AGENT INSERT UPDATE DELETE MASSDEL TOTAL
BMC51576I 1 20000 0 0 0 20000
BMC51576I 2 20000 0 0 0 20000
BMC51576I 3 20000 0 0 0 20000
BMC51576I 4 20000 0 0 0 20000
BMC51576I 5 20000 0 0 0 20000
BMC51576I ----- --------- --------- --------- --------- ----------
BMC51576I TOTAL 100000 0 0 0 100000
BMC51576I 15:01:22 001 APT0206I PACKAGE STATISTICS
BMC51576I NAME STMTCNT USAGECNT RETRIES BIND ELAPSED TIME
BMC51576I ACAG0000 101 0 0 00:00:00.187001
BMC51576I ACAG0001 1 100000 0 00:00:00.163639
BMC51576I --------- --------- --------- --------- -----------------
BMC51576I TOTAL 102 100000 0 00:00:00.350641
BMC51576I 15:01:22 001 APT0182I OTHER STATISTICS
BMC51576I AGENT FAILPREPS RETRIES DBMS ELAPSED TIME
BMC51576I 1 0 0 00:00:02.327402
BMC51576I 2 0 0 00:00:02.267974
BMC51576I 3 0 0 00:00:02.281307
BMC51576I 4 0 0 00:00:02.292870
BMC51576I 5 0 0 00:00:02.241191
BMC51576I ----- --------- --------- -----------------
BMC51576I TOTAL 0 0 00:00:11.410748
BMC51576I 15:01:22 001 APT0183I Request elapsed time: 00:00:05.202493
BMC51576I 15:01:22 000 APT0067I Request completed Return code: 0
BMC50481I 10: SQLAPPLY TASK COMPLETE. ELAPSED TIME = 00:00:06
BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC, I/OS = 20, I/O WAITS = 2, RDB LOCK WAITS = 0
BMC51507I XBLKS = 20, XFERS = 140, EMPTY WAITS = 37, FULL WAITS =0
BMC51507I APBUFS = 15, XFERS = 215, EMPTY WAITS = 200, FULL WAITS =0
BMC50476I DDNAME = SYSDISC, I/OS = 0, I/O WAITS = 0, RDB LOCK WAITS = 0
BMC51472I COMBINED PHASE STATISTICS: 100000 ROWS SELECTED FOR SPACE 'AMUEXCDB.EXCTS', 0 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
BMC51479I COMBINED PHASE STATISTICS: 0 PHYSICAL (0 LOGICAL) RECORDS DISCARDED TO SYSDISC
BMC51475I LOAD STATISTICS: 100000 ROWS LOADED INTO TABLE SPACE 'AMUEXCDB.EXCTS'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR ', DSNAME = 'RDAMZL.RESUMEY.SYSERR'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK01', DSNAME = 'RDAMZL.RESUMEY.SORTWK01'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK02', DSNAME = 'RDAMZL.RESUMEY.SORTWK02'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK03', DSNAME = 'RDAMZL.RESUMEY.SORTWK03'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK04', DSNAME = 'RDAMZL.RESUMEY.SORTWK04'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK05', DSNAME = 'RDAMZL.RESUMEY.SORTWK05'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK06', DSNAME = 'RDAMZL.RESUMEY.SORTWK06'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK07', DSNAME = 'RDAMZL.RESUMEY.SORTWK07'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK08', DSNAME = 'RDAMZL.RESUMEY.SORTWK08'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK09', DSNAME = 'RDAMZL.RESUMEY.SORTWK09'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK10', DSNAME = 'RDAMZL.RESUMEY.SORTWK10'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK11', DSNAME = 'RDAMZL.RESUMEY.SORTWK11'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK12', DSNAME = 'RDAMZL.RESUMEY.SORTWK12'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSDISC ', DSNAME = 'RDAMZL.RESUMEY.SYSDISC'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I COMBINED PHASE COMPLETE. ELAPSED TIME = 00:00:06
BMC51577I ROWS DISCARDED
BMC51578I INSERTED SQLERRORS
BMC51579I SPACE AMUEXCDB.EXCTS 100000 0
BMC51579I PART 0001 20000 0
BMC51579I PART 0002 20000 0
BMC51579I PART 0003 20000 0
BMC51579I PART 0004 20000 0
BMC51579I PART 0005 20000 0
BMC50004I UTILTERM PHASE COMPLETE. ELAPSED TIME = 00:00:00
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*