Example 12 — LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY of a partitioned table space
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 BMC51576I 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 BMC51576I 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, the 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:
// JOBCARD
//********************** AMUEX12 ************************************
//*******************************************************************
//* LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY
//* of a partitioned table space
//*******************************************************************
//*******************************************************************
//* Replace "DB2SYS" by your DB2 subsystem name. *
//* Use your DB2 product install libraries for STEPLIBS : *
//* PRODUCT.LIBRARIES *
//* DB2.DSNEXIT *
//* DB2.DSNLOAD *
//*******************************************************************
//EXAMP12A EXEC PGM=AMUUMAIN,
// PARM='DB2SYS,AMUEX12A,NEW,,MSGLEVEL(1),AMU$OPTO'
//* SSID,UTILID ,RSTART,NOTIFY,MSGLEVEL
//STEPLIB DD DISP=SHR,DSN=PRODUCT.LIBRARIES
// DD DSN=DB2.DSNEXIT,DISP=SHR
// DD DSN=DB2.DSNLOAD,DISP=SHR
//*
//SYSPRINT DD DSN=AMU.EXAMP12A.SYSPRINT,
// UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG)
//SYSOUT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSREC DD DSN=AMU.INPUT.EXAMPL12.SYSREC,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)
)
//*
//********************** AMUEX12 ************************************
//*******************************************************************
//* LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY
//* of a partitioned table space
//*******************************************************************
//*******************************************************************
//* Replace "DB2SYS" by your DB2 subsystem name. *
//* Use your DB2 product install libraries for STEPLIBS : *
//* PRODUCT.LIBRARIES *
//* DB2.DSNEXIT *
//* DB2.DSNLOAD *
//*******************************************************************
//EXAMP12A EXEC PGM=AMUUMAIN,
// PARM='DB2SYS,AMUEX12A,NEW,,MSGLEVEL(1),AMU$OPTO'
//* SSID,UTILID ,RSTART,NOTIFY,MSGLEVEL
//STEPLIB DD DISP=SHR,DSN=PRODUCT.LIBRARIES
// DD DSN=DB2.DSNEXIT,DISP=SHR
// DD DSN=DB2.DSNLOAD,DISP=SHR
//*
//SYSPRINT DD DSN=AMU.EXAMP12A.SYSPRINT,
// UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG)
//SYSOUT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSREC DD DSN=AMU.INPUT.EXAMPL12.SYSREC,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='DB2SYS,AMUEX12B,NEW,,MSGLEVEL(1),AMU$OPTE'
//* SSID,UTILID ,RSTART,NOTIFY,MSGLEVEL
//STEPLIB DD DISP=SHR,DSN=PRODUCT.LIBRARIES
// DD DSN=DB2.DSNEXIT,DISP=SHR
// DD DSN=DB2.DSNLOAD,DISP=SHR
//*
//SYSPRINT DD DSN=AMU.EXAMP12B.SYSPRINT,
// UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG)
//SYSOUT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSREC DD DSN=AMU.INPUT.EXAMPL12.SYSREC,DISP=SHR
//SYSIN DD *
LOAD DATA RESUME YES
SHRLEVEL CHANGE
ENUMROWS(100000)
ORDER YES
DDTYPE LOAD DSNPAT 'AMU..RESUME&RESUME.&DDNAME'
DDTYPE WORK DSNPAT 'AMU..RESUME&RESUME.&DDNAME'
DDTYPE SORTWORK DSNPAT 'AMU..RESUME&RESUME.&DDNAME'
DDTYPE DISCARD DSNPAT 'AMU..RESUME&RESUME.&DDNAME'
DDTYPE ERROR DSNPAT 'AMU..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='DB2SYS,AMUEX12B,NEW,,MSGLEVEL(1),AMU$OPTE'
//* SSID,UTILID ,RSTART,NOTIFY,MSGLEVEL
//STEPLIB DD DISP=SHR,DSN=PRODUCT.LIBRARIES
// DD DSN=DB2.DSNEXIT,DISP=SHR
// DD DSN=DB2.DSNLOAD,DISP=SHR
//*
//SYSPRINT DD DSN=AMU.EXAMP12B.SYSPRINT,
// UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG)
//SYSOUT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSREC DD DSN=AMU.INPUT.EXAMPL12.SYSREC,DISP=SHR
//SYSIN DD *
LOAD DATA RESUME YES
SHRLEVEL CHANGE
ENUMROWS(100000)
ORDER YES
DDTYPE LOAD DSNPAT 'AMU..RESUME&RESUME.&DDNAME'
DDTYPE WORK DSNPAT 'AMU..RESUME&RESUME.&DDNAME'
DDTYPE SORTWORK DSNPAT 'AMU..RESUME&RESUME.&DDNAME'
DDTYPE DISCARD DSNPAT 'AMU..RESUME&RESUME.&DDNAME'
DDTYPE ERROR DSNPAT 'AMU..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 V13R1.00 ************
(C) COPYRIGHT 1990 - 2022 BMC SOFTWARE, INC.
LOADPLUS TECHNOLOGY IS PROTECTED BY U.S. PATENT NUMBERS 7,664,790 AND 7,930,291
-BMC50001I UTILITY EXECUTION STARTING 9/02/2022 7:03:32 ...
BMC50002I UTILITY ID = 'AMUEX12'. DB2 SUBSYSTEM ID = 'DEMO'. OPTION MODULE = 'AMU$OPTE'.
BMC50471I z/OS 2.4.0,PID=HBB77C0,DFSMS FOR Z/OS=2.4.0,DB2=13.1.501
BMC50471I REGION=0M,BELOW 16M=8.6M,ABOVE 16M=1,007.6M,IEFUSI=NO,CPUs=9,GPs=5,zIIPs=4
BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
BMC50471I SMFID=DB2B,JOBID=J0052461,JOB=AMUEX12,STEP=EXAMP12A,CPU=3931-612 (z16)/1.47,76.0G
0
BMC50471I LOADPLUS FOR DB2--V13.01.00 SPE2207
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V13.01.00 SPE2207
BMC50471I MAINT: BQU4035
BMC50471I SOLUTION COMMON CODE--V13.01.00 BASE
BMC50471I MAINT: BPJ2315
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922 BPJ0996 BPJ1164 BPJ1309 BPJ1386 BPJ1497 BPJ1594 BPJ1724 BPJ1809
BMC50471I BPJ1833 BPJ1891 BPJ1905 BPJ2109 BPJ2232 BPJ2297
BMC50471I BMC STATS API--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.02.01
BMC50471I MAINT: BPE0443 BPE0445 BPE0447 BPE0449 BPE0450 BPE0451 BPE0452 BPE0455 BPE0456 BPE0457 BPE0460 BPE0463
BMC50471I BPE0467 BPE0468 BPE0469 BPE0473 BPE0474 BPE0475 BPE0479 BPE0480 BPE0482 BPE0487 BPE0488 BPE0489
BMC50471I BPE0493 BPE0497 BPE0498 BPE0501 BPE0503 BPE0507 BPE0512 BPE0513 BPE0517 BPE0518 BPE0519 BPE0523
BMC50471I BPE0524 BPE0527 BPE0528 BPE0530 BPE0531 BPE0534 BPE0535 BPE0540 BPE0541 BPE0542 BPE0545 BPE0549
BMC50471I BPE0551 BPE0552 BPE0555 BPE0556 BPE0557 BPE0560 BPE0561
BMC50471I High-speed Apply Engine--V13.01.00 SPE2210
BMC50471I MAINT: BQU4146
0
BMC50471I APCOMMIT=2500 FORCE=NONE RULES=BMC
BMC50471I APDOPTS= IBUFFS=20 SDUMP=YES
BMC50471I APMULTIROW=100 IDCACHE=1000 SHORTMEMORY=CONTINUE
BMC50471I APMXAGNT=10 IDCDDN=SYSIDCIN SHRLEVEL=(NONE,NONE)
BMC50471I APRETLIM=COUNT IDERROR=DISCARD SMAX=16
BMC50471I APRETVAL=5 INDDN=SYSREC SMCORE=(0K,0K)
BMC50471I AUTOENUMROWS=YES INFORI=NO SORTDEVT=(,SYSALLDA)
BMC50471I AVAILPAGEPCT=0 INLINECP=YES SORTNUM=32
BMC50471I CBUFFS=30 INVALIDATECACHE=YES SQLDELAY=3
BMC50471I CENTURY=(1950,2049) KEEPDICTIONARY=NO SQLRETRY=100
BMC50471I CHEKPEND=YES LBUFFS=20 SSIGNRPAUSE=NO
BMC50471I COPYDDN=(BMCCPY,BMCCPZ) LOADDN=SORTOUT SSREPORT=REPORT_SWITCH
BMC50471I COPYLVL=FULL LOBAVGPCT=50 STOP@CMT=YES
BMC50471I COPYPEND=YES LOCKROW=YES STOPDELAY=1
BMC50471I COPYSUBSET=NO LONGNAMETRUNC=MIDDLE STOPRETRY=300
BMC50471I DELFILES=(YES,NO) MAPDDN=SYSMAP TAPEDISP=DELETE
BMC50471I DISCARDLIMRC=8 MAXP=5 TOTALPAGEPCT=30
BMC50471I DISCARDRC=0 MAXSORTMEMORY=0 TSSAMPLEPCT=100
BMC50471I DISCDDN=SYSDISC MAXTAPE=3 UPDMAXA_AUTHID=USER
BMC50471I DRNDELAY=1 MGEXTENT=CONTINUE UPDMAXA=NO
BMC50471I DRNRETRY=255 MINSORTMEMORY=0 UXSTATE=SUP
BMC50471I DRNWAIT=NONE MSGLEVEL=1 WBUFFS=(20,10)
BMC50471I DSNUEXIT=(NONE,ASM) OPNDB2ID=YES WORKDDN=SYSUT1
BMC50471I DSNUTILB=YES ORIGDISP=DELETE WORKUNIT=SYSALLDA
BMC50471I ENFORCE=CHECK PAUSEDISCARDRC=4 WRLOG=NO
BMC50471I ERRDDN=SYSERR PLAN=AMU1310I XBLKS=3
BMC50471I EXCLDUMP=(X37,X22,X06) PREFORMAT=NO XMLAVGSIZE=10240
BMC50471I FASTSWITCH=NO PRELOAD=LOAD ZEROROWRC=0
BMC50471I FILECHK=WARN RCVYDDN=(BMCRCY,BMCRCZ) ZIIP=ENABLED
BMC50471I FORCE_AT=(START,3) REDEFINE=YES
BMC50471I FORCE_RPT=NO RENMMAX=30
0
BMC50471I APCOLLECTION=
BMC50471I APOWNER=
0
BMC50470I DDTYPE = LOAD WORK SORTWORK
BMC50470I ACTIVE = 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 = NO NO NO
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 = NO NO NO
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.&UTILPFX.&DDNAME
BMC50483I WORK DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I SORTWORK DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I ERROR DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I DISCARD DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I SYSMAP DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50483I LOCPFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I LOCBFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMPFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMBFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50483I LOCPLCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I LOCBLCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMPLCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMBLCPY DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50483I LOCPXCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I LOCBXCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMPXCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMBXCPY DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50471I DB2 DSNHDECP MODULE SETTINGS:
BMC50471I VERSION = 1310
BMC50471I SUBSYSTEM DEFAULT = DEMO
BMC50471I CHARACTER SET = ALPHANUM
BMC50471I DATE FORMAT = USA
BMC50471I TIME FORMAT = USA
BMC50471I LOCAL DATE LENGTH = 0
BMC50471I LOCAL TIME LENGTH = 0
BMC50471I DECIMAL POINT = PERIOD
BMC50471I DECIMAL ARITHMETIC = 15
BMC50471I DELIMITER = DEFAULT
BMC50471I SQL DELIMITER = DEFAULT
BMC50471I ENCODING SCHEME = EBCDIC
BMC50471I APPL. ENCODING SCHEME = EBCDIC
BMC50471I MIXED = NO
BMC50471I EBCDIC CCSID = (37,65534,65534)
BMC50471I ASCII CCSID = (819,65534,65534)
BMC50471I UNICODE CCSID = (367,1208,1200)
BMC50471I IMPLICIT TIME ZONE = CURRENT (-05:00)
BMC50658I DB2 CURRENT FUNCTION LEVEL IS V13R1M501
BMC50659I DB2 CATALOG LEVEL IS V13R1M501
BMC50660I DB2 HIGHEST ACTIVATED FUNCTION LEVEL IS V13R1M501
BMC50661I DB2 CODE LEVEL IS V13R1M501
BMC50471I BMC_BMCUTIL ='BMCUTIL.CMN_BMCUTIL'
BMC50471I BMC_BMCSYNC ='BMCUTIL.CMN_BMCSYNC'
BMC50471I BMC_BMCHIST ='BMCUTIL.CMN_BMCHIST'
BMC50471I BMC_BMCDICT ='BMCUTIL.CMN_BMCDICT'
BMC50471I BMC_BMCSMARTSWITCH='BMCUTIL.CMN_BMCSWITCH'
BMC50471I BMC_BMCSSTRACKING ='BMCUTIL.CMN_BMCSSTRACK'
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
BMC54000I SMARTSWITCH NOT SUPPORTED - NO BMC AMI UTILITIES VERSION FOUND
BMC54003I SMARTSWITCH RULE: FORCE_NO_SWITCH COMMENT: SMARTSWITCH IS ACTIVATED, BUT NO RULE APPLIES. PLUS UTILITY WILL BE USED
BMC50004I NGTUTIL PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50199I LOAD PLUS PROCESSING CONTINUES
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
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 = BMCJXS
BMC50425I &RESUME = Y &REPLACE = N &DATE = 090222 &TIME = 070332 &SSID = DEMO
BMC50425I &UTIL = AMUEX12 &UTILPFX = AMUEX12 &UTILSFX = &DATE8 = 09022022 &GRPNM = DEMO
BMC50425I &VCAT = DEMOCAT &TIME4 = 0703 &DATEJ = 2022245 &JDATE = 22245
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 BMCJXS.AMUEX12.SORTWK01 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK02 BMCJXS.AMUEX12.SORTWK02 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK03 BMCJXS.AMUEX12.SORTWK03 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK04 BMCJXS.AMUEX12.SORTWK04 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK05 BMCJXS.AMUEX12.SORTWK05 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK06 BMCJXS.AMUEX12.SORTWK06 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK07 BMCJXS.AMUEX12.SORTWK07 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK08 BMCJXS.AMUEX12.SORTWK08 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK09 BMCJXS.AMUEX12.SORTWK09 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK10 BMCJXS.AMUEX12.SORTWK10 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK11 BMCJXS.AMUEX12.SORTWK11 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK12 BMCJXS.AMUEX12.SORTWK12 SYSALLDA 16 2 1 1 TRK
BMC50448I SYSDISC BMCJXS.AMUEX12.SYSDISC SYSALLDA 10218 1277 197 25 TRK
BMC50448I SYSERR BMCJXS.AMUEX12.SYSERR SYSALLDA 5160 2064 100 40 TRK
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8432K, ABOVE 16M = 1024924K, CPUS = 5
BMC50479I TOTAL PAGES: 11071997, ALLOWED: 3321599; AVAILABLE PAGES: 1328889, ALLOWED: 0
BMC51499I COMBINED OPTIMIZATION, RC=0, #SORTS=5, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=88115
BMC51499I COMBINED OPTIMIZATION, RC=20, #SORTS=4, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=89216
BMC51500I COMBINED ANALYZE, #SORTS=5, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0
BMC51576I 07:03:35 000 APT0000I High-speed Apply Engine V13.01.00
BMC51576I Copyright (c) 1999-2022 BMC Software, Inc. as an unpublished licensed work. All rights reserved.
BMC51576I 07:03:35 000 APT0001I Date: Fri Sep 2, 2022
BMC51576I 07:03:35 000 APT0215I MAINT: High-speed Apply Engine V13.01.00 SPE2210
BMC51576I 07:03:35 000 APT0215I MAINT: BQU4146
BMC51576I 07:03:35 000 APT0215I MAINT: SOLUTION COMMON CODE V13.01.00 BASE
BMC51576I 07:03:35 000 APT0215I MAINT: BPJ2315
BMC51576I 07:03:35 000 APT0215I MAINT: BMCSORT ENGINE V02.04.01
BMC51576I 07:03:35 000 APT0215I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922 BPJ0996 BPJ1164 BPJ1309
BMC51576I 07:03:35 000 APT0215I MAINT: BPJ1386 BPJ1497 BPJ1594 BPJ1724 BPJ1809 BPJ1833 BPJ1891
BMC51576I 07:03:35 000 APT0215I MAINT: BPJ1905 BPJ2109 BPJ2232 BPJ2297
BMC51576I 07:03:35 000 APT0272I Main thread started - TCB: 008A7B88
BMC51576I 07:03:35 000 APT0085I /STARTUP/
BMC51576I SSID=DEMO
BMC51576I INPUTTYPE={3895D640-0BF1-11D4-8027-00104B39B10F}
BMC51576I PLANNAME=APTBBLD
BMC51576I BINDQUALIFIER=APTTEST
BMC51576I DBMSTYPE=DB2
BMC51576I DISTRIBUTIONTYPE=OBJECT
BMC51576I LARGESTATEMENTSUPPORT=NO
BMC51576I 07:03:35 000 APT0085I /CONFIGURATION/
BMC51576I FILENAME=NONE
BMC51576I 07:03:35 000 APT0085I /SQL/
BMC51576I FORMAT=PACKED72
BMC51576I 07:03:35 000 APT0085I /COMMITTRIGGERS/
BMC51576I STATEMENTCOUNT=2500
BMC51576I COMMITONDEMAND=NO
BMC51576I 07:03:35 000 APT0085I /OBJECTMAP/
BMC51576I SOURCETABLE=0X0599.0X0003
BMC51576I TARGETTABLE="EXAMPLEC"."TBL1"
BMC51576I 07:03:35 000 APT0085I /AGENT/
BMC51576I MAXAGENTS=10
BMC51576I INITIALAGENTS=5
BMC51576I MAXPREPARES=50
BMC51576I 07:03:35 000 APT0085I /TEMPORARYFILES/
BMC51576I UNIT=SYSALLDA
BMC51576I 07:03:35 000 APT0085I /DIAGNOSTICOUTPUT/
BMC51576I FILENAME=APTDIAG
BMC51576I 07:03:35 000 APT0085I /RESTART/
BMC51576I RESTARTID=AMUEX12
BMC51576I RESTARTTYPE=NEW
BMC51576I CHECKPOINTFREQUENCY=0
BMC51576I TABLENAME=BMCAPT_APTRSCL
BMC51576I RETAINTIME=7
BMC51576I RETRY=3
BMC51576I 07:03:35 000 APT0085I /DISTRIBUTIONTUNING/
BMC51576I SIMPLETSCLUSTERING=NO
BMC51576I RICLUSTERING=NO
BMC51576I PARTITIONCLUSTERING=NO
BMC51576I URCHECKRI=YES
BMC51576I 07:03:35 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 07:03:35 000 APT0085I /INSERTCONFLICT/
BMC51576I CODE=MULTIROWCONFLICT
BMC51576I ACTION=RETRY
BMC51576I 07:03:35 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 07:03:35 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 07:03:35 000 APT0085I /BIND/
BMC51576I FREEOPTION=ALL
BMC51576I PLANPREFIX=APT
BMC51576I 07:03:35 000 APT0085I /BINDTUNING/
BMC51576I STATEMENTCOUNT=1
BMC51576I MAXPACKAGES=25
BMC51576I MAXFAILEDBINDS=5
BMC51576I MAXRETRIES=5
BMC51576I PACKAGEUSAGE=500
BMC51576I STATEMENTUSAGE=200
BMC51576I 07:03:35 000 APT0085I /MULTIROWINSERT/
BMC51576I MULTIROWINSERT=YES
BMC51576I MAXROWS=100
BMC51576I 07:03:35 000 APT0085I /LOGICALLOG/
BMC51576I 07:03:35 001 APT0262I OS Release = SP7.2.4 , OS PID = HBB77C0 , DF/SMS Release = DFP 2.4.0
BMC51576I 07:03:35 001 APT0263I Available region below 16M = 8828K, Available region above 16M = 1026188K, MEMLIMIT = NOLIMIT
(74572M)
BMC51576I 07:03:35 001 APT0270I CPU = 001CA498-3931(z16), Number of CPUs = 9 (GPs = 5, zIIPs = 4)
BMC51576I 07:03:35 001 APT0252I zIIP processing enabled using XBM SSID XBMB (v6.2.01)
BMC51576I 07:03:35 002 APT0272I Monitor thread started - TCB: 00893B20
BMC51576I 07:03:35 003 APT0272I Message thread started - TCB: 00893900
BMC51576I 07:03:35 001 APT0238I Successful connect to DEMO (Release 131501 of DB2)
BMC51576I 07:03:35 001 APT0269I DB2 CURRENT FUNCTION LEVEL IS V13R1M501
BMC51576I 07:03:35 001 APT0269I DB2 HIGHEST ACTIVATED FUNCTION LEVEL IS V13R1M501
BMC51576I 07:03:35 001 APT0269I DB2 CATALOG LEVEL IS V13R1M501
BMC51576I 07:03:35 001 APT0269I DB2 CODE LEVEL IS V13R1M501
BMC51576I 07:03:35 001 APT0236I High-speed Apply starting with Multi-Row Inserts
BMC51576I 07:03:35 001 APT0097I Request ID: BERJ Restart ID: AMUEX12
BMC51576I 07:03:35 004 APT0272I Distribution(Object) thread started - TCB: 008933F8
BMC51576I 07:03:36 000 APT0019I File DBRMLIB :SYS22245.T070336.RA000.AMUEX12.R0861592 allocated - elapsed time: 00:00:00
BMC51576I 07:03:36 005 APT0272I Bind thread started - TCB: 00893010
BMC51576I 07:03:36 001 APT0032I DSN output follows:
BMC51576I DSNT252I *DEMO DSNTBCM1 BIND OPTIONS FOR PLAN APTBERJ
BMC51576I ACTION ADD
BMC51576I OWNER BMCJXS
BMC51576I OWNERTYPE USER
BMC51576I VALIDATE RUN
BMC51576I ISOLATION CS
BMC51576I ACQUIRE USE
BMC51576I RELEASE COMMIT
BMC51576I EXPLAIN NO
BMC51576I DYNAMICRULES RUN
BMC51576I PROGAUTH DISABLE
BMC51576I DSNT253I *DEMO DSNTBCM1 BIND OPTIONS FOR PLAN APTBERJ
BMC51576I NODEFER PREPARE
BMC51576I CACHESIZE 4096
BMC51576I QUALIFIER BMCJXS
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 *DEMO BIND FOR PLAN APTBERJ SUCCESSFUL
BMC51576I 07:03:36 001 APT0032I DSN output follows:
BMC51576I DSNT254I *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
BMC51576I ACTION ADD
BMC51576I OWNER BMCJXS
BMC51576I QUALIFIER BMCJXS
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 V13R1M501
BMC51576I DESCSTAT YES
BMC51576I APREUSESOURCE
BMC51576I DSNT255I *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
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 *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
BMC51576I QUERYACCELERATION
BMC51576I GETACCELARCHIVE
BMC51576I ACCELERATOR
BMC51576I CONCENTRATESTMT
BMC51576I ACCELERATIONWAITFORDATA
BMC51576I RESTSERVICEDEFAULT
BMC51576I OWNERTYPE USER
BMC51576I DEPLEVEL
BMC51576I
BMC51576I DSNT232I *DEMO SUCCESSFUL BIND FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
BMC51576I 07:03:36 006 APT0272I Apply Engine thread started - TCB: 0088D7C8
BMC51576I 07:03:36 007 APT0272I Apply Engine thread started - TCB: 0088D400
BMC51576I 07:03:36 008 APT0272I Apply Engine thread started - TCB: 0088D0D8
BMC51576I 07:03:36 009 APT0272I Apply Engine thread started - TCB: 00890D70
BMC51576I 07:03:36 010 APT0272I Apply Engine thread started - TCB: 00890A58
BMC51576I 07:03:36 001 APT0272I Request thread started - TCB: 00893E68
BMC51576I 07:03:36 006 APT0079I High-speed Apply processing started - Agent: 1
BMC51576I 07:03:36 007 APT0079I High-speed Apply processing started - Agent: 2
BMC51576I 07:03:36 008 APT0079I High-speed Apply processing started - Agent: 3
BMC51576I 07:03:36 009 APT0079I High-speed Apply processing started - Agent: 4
BMC51576I 07:03:36 010 APT0079I High-speed Apply processing started - Agent: 5
BMC51576I 07:03:36 001 APT0148I Bind started for package BERJ0001 - Trigger statistics:
BMC51576I STATEMENTCOUNT...........................1
BMC51576I PACKAGEUSAGE.............................1
BMC51576I STATEMENTUSAGE...........................1
BMC51576I 07:03:36 001 APT0032I DSN output follows:
BMC51576I DSNT254I *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
BMC51576I ACTION ADD
BMC51576I OWNER BMCJXS
BMC51576I QUALIFIER BMCJXS
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 V13R1M501
BMC51576I DESCSTAT YES
BMC51576I APREUSESOURCE
BMC51576I DSNT255I *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
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 *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
BMC51576I QUERYACCELERATION
BMC51576I GETACCELARCHIVE
BMC51576I ACCELERATOR
BMC51576I CONCENTRATESTMT
BMC51576I ACCELERATIONWAITFORDATA
BMC51576I RESTSERVICEDEFAULT
BMC51576I OWNERTYPE USER
BMC51576I DEPLEVEL
BMC51576I
BMC51576I DSNT232I *DEMO SUCCESSFUL BIND FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
BMC50481I 1: READ TASK COMPLETE. ELAPSED TIME = 00:00:01
BMC51510I 1: READ TASK, XBLK XFERS = 130, EMPTY WAITS = 99, FULL WAITS = 0
BMC51478I PRELOAD STATISTICS: 100000 PHYSICAL (100000 LOGICAL) RECORDS READ FROM SYSREC
BMC51480I 3: DATA TASK COMPLETE. ELAPSED TIME = 00:00:01. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51480I 2: DATA TASK COMPLETE. ELAPSED TIME = 00:00:01. 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 = 28, FULL WAITS = 0
BMC51510I 2: SORT TASK, XBLK XFERS = 26, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 2: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 43, FULL WAITS = 0
BMC51480I 5: DATA TASK COMPLETE. ELAPSED TIME = 00:00:01. 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 = 43, FULL WAITS = 0
BMC51480I 6: DATA TASK COMPLETE. ELAPSED TIME = 00:00:01. 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 4: DATA TASK COMPLETE. ELAPSED TIME = 00:00:01. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
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
BMC51576I 07:03:36 001 APT0118I Input statements processed: 100000 Statement ID: 000186A000004E200003000501000186A0
BMC51576I 07:03:36 001 APT0066I Input processing complete
BMC51576I 07:03:36 009 APT0080I High-speed Apply processing ended - Agent: 4
BMC51576I 07:03:36 006 APT0080I High-speed Apply processing ended - Agent: 1
BMC51576I 07:03:37 010 APT0080I High-speed Apply processing ended - Agent: 5
BMC51576I 07:03:37 008 APT0080I High-speed Apply processing ended - Agent: 3
BMC51576I 07:03:37 007 APT0080I High-speed Apply processing ended - Agent: 2
BMC51576I 07:03:37 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:01.820108
BMC51576I 07:03:37 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:00.
285407
BMC51576I 4 PARTITION 2 20000 0 0 0 0 20000 00:00:00.
248733
BMC51576I 5 PARTITION 3 20000 0 0 0 0 20000 00:00:00.
449698
BMC51576I 2 PARTITION 4 20000 0 0 0 0 20000 00:00:00.
489561
BMC51576I 3 PARTITION 5 20000 0 0 0 0 20000 00:00:00.
346705
BMC51576I 07:03:37 010 APT0273I Apply Engine thread ended - TCB: 00890A58 CPU Time: 00:00:00.135411
BMC51576I 07:03:37 009 APT0273I Apply Engine thread ended - TCB: 00890D70 CPU Time: 00:00:00.141720
BMC51576I 07:03:37 008 APT0273I Apply Engine thread ended - TCB: 0088D0D8 CPU Time: 00:00:00.134006
BMC51576I 07:03:37 007 APT0273I Apply Engine thread ended - TCB: 0088D400 CPU Time: 00:00:00.131023
BMC51576I 07:03:37 006 APT0273I Apply Engine thread ended - TCB: 0088D7C8 CPU Time: 00:00:00.151123
BMC51576I 07:03:37 004 APT0273I Distribution(Object) thread ended - TCB: 008933F8 CPU Time: 00:00:00.029924
BMC51576I 07:03:37 001 APT0032I DSN output follows:
BMC51576I DSNT200I *DEMO FREE FOR PLAN APTBERJ SUCCESSFUL
BMC51576I 07:03:37 001 APT0032I DSN output follows:
BMC51576I DSNT232I *DEMO SUCCESSFUL FREE FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
BMC51576I DSNT232I *DEMO SUCCESSFUL FREE FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
BMC51576I 07:03:37 005 APT0273I Bind thread ended - TCB: 00893010 CPU Time: 00:00:00.035186
BMC51576I 07:03:37 000 APT0020I File DBRMLIB :SYS22245.T070336.RA000.AMUEX12.R0861592 deallocated
BMC51576I 07:03:37 003 APT0273I Message thread ended - TCB: 00893900 CPU Time: 00:00:00.005574
BMC51576I 07:03:37 001 APT0111I INPUT PROCESSING STATISTICS
BMC51576I INSERT UPDATE DELETE TRUNCATE DDL TOTAL
BMC51576I 100000 0 0 0 0 100000
BMC51576I 07:03:37 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 07:03:37 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 07:03:37 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 07:03:37 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 07:03:37 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 07:03:37 001 APT0206I PACKAGE STATISTICS
BMC51576I NAME STMTCNT USAGECNT RETRIES BIND ELAPSED TIME
BMC51576I BERJ0000 101 0 0 00:00:00.066772
BMC51576I BERJ0001 1 100000 0 00:00:00.046823
BMC51576I --------- --------- --------- --------- -----------------
BMC51576I TOTAL 102 100000 0 00:00:00.113596
BMC51576I 07:03:37 001 APT0182I OTHER STATISTICS
BMC51576I AGENT FAILPREPS RETRIES DBMS ELAPSED TIME
BMC51576I 1 0 0 00:00:00.307987
BMC51576I 2 0 0 00:00:00.508038
BMC51576I 3 0 0 00:00:00.367750
BMC51576I 4 0 0 00:00:00.270335
BMC51576I 5 0 0 00:00:00.480675
BMC51576I ----- --------- --------- -----------------
BMC51576I TOTAL 0 0 00:00:01.934789
BMC51576I 07:03:37 001 APT0183I Request elapsed time: 00:00:01.723919
BMC51576I 07:03:37 002 APT0273I Monitor thread ended - TCB: 00893B20 CPU Time: 00:00:00.005555
BMC51576I 07:03:37 001 APT0273I Request thread ended - TCB: 00893E68 CPU Time: 00:00:00.335439
BMC51576I 07:03:37 000 APT0273I Main thread ended - TCB: 008A7B88 CPU Time: 00:00:00.080591
BMC51576I 07:03:37 000 APT0067I Request completed Return code: 0
BMC50481I 10: SQLAPPLY TASK COMPLETE. ELAPSED TIME = 00:00:02
BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC, I/OS = 20, I/O WAITS = 19, RDB LOCK WAITS = 0
BMC51507I XBLKS = 20, XFERS = 130, EMPTY WAITS = 99, 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 = 'SORTWK01', DSNAME = 'BMCJXS.AMUEX12.SORTWK01'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK02', DSNAME = 'BMCJXS.AMUEX12.SORTWK02'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK03', DSNAME = 'BMCJXS.AMUEX12.SORTWK03'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR ', DSNAME = 'BMCJXS.AMUEX12.SYSERR'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK04', DSNAME = 'BMCJXS.AMUEX12.SORTWK04'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK05', DSNAME = 'BMCJXS.AMUEX12.SORTWK05'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK06', DSNAME = 'BMCJXS.AMUEX12.SORTWK06'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK07', DSNAME = 'BMCJXS.AMUEX12.SORTWK07'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK08', DSNAME = 'BMCJXS.AMUEX12.SORTWK08'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK09', DSNAME = 'BMCJXS.AMUEX12.SORTWK09'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK10', DSNAME = 'BMCJXS.AMUEX12.SORTWK10'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK11', DSNAME = 'BMCJXS.AMUEX12.SORTWK11'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK12', DSNAME = 'BMCJXS.AMUEX12.SORTWK12'
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:04
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 - 2022 BMC SOFTWARE, INC.
LOADPLUS TECHNOLOGY IS PROTECTED BY U.S. PATENT NUMBERS 7,664,790 AND 7,930,291
-BMC50001I UTILITY EXECUTION STARTING 9/02/2022 7:03:32 ...
BMC50002I UTILITY ID = 'AMUEX12'. DB2 SUBSYSTEM ID = 'DEMO'. OPTION MODULE = 'AMU$OPTE'.
BMC50471I z/OS 2.4.0,PID=HBB77C0,DFSMS FOR Z/OS=2.4.0,DB2=13.1.501
BMC50471I REGION=0M,BELOW 16M=8.6M,ABOVE 16M=1,007.6M,IEFUSI=NO,CPUs=9,GPs=5,zIIPs=4
BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
BMC50471I SMFID=DB2B,JOBID=J0052461,JOB=AMUEX12,STEP=EXAMP12A,CPU=3931-612 (z16)/1.47,76.0G
0
BMC50471I LOADPLUS FOR DB2--V13.01.00 SPE2207
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V13.01.00 SPE2207
BMC50471I MAINT: BQU4035
BMC50471I SOLUTION COMMON CODE--V13.01.00 BASE
BMC50471I MAINT: BPJ2315
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922 BPJ0996 BPJ1164 BPJ1309 BPJ1386 BPJ1497 BPJ1594 BPJ1724 BPJ1809
BMC50471I BPJ1833 BPJ1891 BPJ1905 BPJ2109 BPJ2232 BPJ2297
BMC50471I BMC STATS API--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.02.01
BMC50471I MAINT: BPE0443 BPE0445 BPE0447 BPE0449 BPE0450 BPE0451 BPE0452 BPE0455 BPE0456 BPE0457 BPE0460 BPE0463
BMC50471I BPE0467 BPE0468 BPE0469 BPE0473 BPE0474 BPE0475 BPE0479 BPE0480 BPE0482 BPE0487 BPE0488 BPE0489
BMC50471I BPE0493 BPE0497 BPE0498 BPE0501 BPE0503 BPE0507 BPE0512 BPE0513 BPE0517 BPE0518 BPE0519 BPE0523
BMC50471I BPE0524 BPE0527 BPE0528 BPE0530 BPE0531 BPE0534 BPE0535 BPE0540 BPE0541 BPE0542 BPE0545 BPE0549
BMC50471I BPE0551 BPE0552 BPE0555 BPE0556 BPE0557 BPE0560 BPE0561
BMC50471I High-speed Apply Engine--V13.01.00 SPE2210
BMC50471I MAINT: BQU4146
0
BMC50471I APCOMMIT=2500 FORCE=NONE RULES=BMC
BMC50471I APDOPTS= IBUFFS=20 SDUMP=YES
BMC50471I APMULTIROW=100 IDCACHE=1000 SHORTMEMORY=CONTINUE
BMC50471I APMXAGNT=10 IDCDDN=SYSIDCIN SHRLEVEL=(NONE,NONE)
BMC50471I APRETLIM=COUNT IDERROR=DISCARD SMAX=16
BMC50471I APRETVAL=5 INDDN=SYSREC SMCORE=(0K,0K)
BMC50471I AUTOENUMROWS=YES INFORI=NO SORTDEVT=(,SYSALLDA)
BMC50471I AVAILPAGEPCT=0 INLINECP=YES SORTNUM=32
BMC50471I CBUFFS=30 INVALIDATECACHE=YES SQLDELAY=3
BMC50471I CENTURY=(1950,2049) KEEPDICTIONARY=NO SQLRETRY=100
BMC50471I CHEKPEND=YES LBUFFS=20 SSIGNRPAUSE=NO
BMC50471I COPYDDN=(BMCCPY,BMCCPZ) LOADDN=SORTOUT SSREPORT=REPORT_SWITCH
BMC50471I COPYLVL=FULL LOBAVGPCT=50 STOP@CMT=YES
BMC50471I COPYPEND=YES LOCKROW=YES STOPDELAY=1
BMC50471I COPYSUBSET=NO LONGNAMETRUNC=MIDDLE STOPRETRY=300
BMC50471I DELFILES=(YES,NO) MAPDDN=SYSMAP TAPEDISP=DELETE
BMC50471I DISCARDLIMRC=8 MAXP=5 TOTALPAGEPCT=30
BMC50471I DISCARDRC=0 MAXSORTMEMORY=0 TSSAMPLEPCT=100
BMC50471I DISCDDN=SYSDISC MAXTAPE=3 UPDMAXA_AUTHID=USER
BMC50471I DRNDELAY=1 MGEXTENT=CONTINUE UPDMAXA=NO
BMC50471I DRNRETRY=255 MINSORTMEMORY=0 UXSTATE=SUP
BMC50471I DRNWAIT=NONE MSGLEVEL=1 WBUFFS=(20,10)
BMC50471I DSNUEXIT=(NONE,ASM) OPNDB2ID=YES WORKDDN=SYSUT1
BMC50471I DSNUTILB=YES ORIGDISP=DELETE WORKUNIT=SYSALLDA
BMC50471I ENFORCE=CHECK PAUSEDISCARDRC=4 WRLOG=NO
BMC50471I ERRDDN=SYSERR PLAN=AMU1310I XBLKS=3
BMC50471I EXCLDUMP=(X37,X22,X06) PREFORMAT=NO XMLAVGSIZE=10240
BMC50471I FASTSWITCH=NO PRELOAD=LOAD ZEROROWRC=0
BMC50471I FILECHK=WARN RCVYDDN=(BMCRCY,BMCRCZ) ZIIP=ENABLED
BMC50471I FORCE_AT=(START,3) REDEFINE=YES
BMC50471I FORCE_RPT=NO RENMMAX=30
0
BMC50471I APCOLLECTION=
BMC50471I APOWNER=
0
BMC50470I DDTYPE = LOAD WORK SORTWORK
BMC50470I ACTIVE = 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 = NO NO NO
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 = NO NO NO
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.&UTILPFX.&DDNAME
BMC50483I WORK DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I SORTWORK DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I ERROR DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I DISCARD DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I SYSMAP DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50483I LOCPFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I LOCBFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMPFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMBFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50483I LOCPLCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I LOCBLCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMPLCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMBLCPY DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50483I LOCPXCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I LOCBXCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMPXCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMBXCPY DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50471I DB2 DSNHDECP MODULE SETTINGS:
BMC50471I VERSION = 1310
BMC50471I SUBSYSTEM DEFAULT = DEMO
BMC50471I CHARACTER SET = ALPHANUM
BMC50471I DATE FORMAT = USA
BMC50471I TIME FORMAT = USA
BMC50471I LOCAL DATE LENGTH = 0
BMC50471I LOCAL TIME LENGTH = 0
BMC50471I DECIMAL POINT = PERIOD
BMC50471I DECIMAL ARITHMETIC = 15
BMC50471I DELIMITER = DEFAULT
BMC50471I SQL DELIMITER = DEFAULT
BMC50471I ENCODING SCHEME = EBCDIC
BMC50471I APPL. ENCODING SCHEME = EBCDIC
BMC50471I MIXED = NO
BMC50471I EBCDIC CCSID = (37,65534,65534)
BMC50471I ASCII CCSID = (819,65534,65534)
BMC50471I UNICODE CCSID = (367,1208,1200)
BMC50471I IMPLICIT TIME ZONE = CURRENT (-05:00)
BMC50658I DB2 CURRENT FUNCTION LEVEL IS V13R1M501
BMC50659I DB2 CATALOG LEVEL IS V13R1M501
BMC50660I DB2 HIGHEST ACTIVATED FUNCTION LEVEL IS V13R1M501
BMC50661I DB2 CODE LEVEL IS V13R1M501
BMC50471I BMC_BMCUTIL ='BMCUTIL.CMN_BMCUTIL'
BMC50471I BMC_BMCSYNC ='BMCUTIL.CMN_BMCSYNC'
BMC50471I BMC_BMCHIST ='BMCUTIL.CMN_BMCHIST'
BMC50471I BMC_BMCDICT ='BMCUTIL.CMN_BMCDICT'
BMC50471I BMC_BMCSMARTSWITCH='BMCUTIL.CMN_BMCSWITCH'
BMC50471I BMC_BMCSSTRACKING ='BMCUTIL.CMN_BMCSSTRACK'
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
BMC54000I SMARTSWITCH NOT SUPPORTED - NO BMC AMI UTILITIES VERSION FOUND
BMC54003I SMARTSWITCH RULE: FORCE_NO_SWITCH COMMENT: SMARTSWITCH IS ACTIVATED, BUT NO RULE APPLIES. PLUS UTILITY WILL BE USED
BMC50004I NGTUTIL PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50199I LOAD PLUS PROCESSING CONTINUES
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
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 = BMCJXS
BMC50425I &RESUME = Y &REPLACE = N &DATE = 090222 &TIME = 070332 &SSID = DEMO
BMC50425I &UTIL = AMUEX12 &UTILPFX = AMUEX12 &UTILSFX = &DATE8 = 09022022 &GRPNM = DEMO
BMC50425I &VCAT = DEMOCAT &TIME4 = 0703 &DATEJ = 2022245 &JDATE = 22245
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 BMCJXS.AMUEX12.SORTWK01 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK02 BMCJXS.AMUEX12.SORTWK02 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK03 BMCJXS.AMUEX12.SORTWK03 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK04 BMCJXS.AMUEX12.SORTWK04 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK05 BMCJXS.AMUEX12.SORTWK05 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK06 BMCJXS.AMUEX12.SORTWK06 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK07 BMCJXS.AMUEX12.SORTWK07 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK08 BMCJXS.AMUEX12.SORTWK08 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK09 BMCJXS.AMUEX12.SORTWK09 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK10 BMCJXS.AMUEX12.SORTWK10 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK11 BMCJXS.AMUEX12.SORTWK11 SYSALLDA 16 2 1 1 TRK
BMC50448I SORTWK12 BMCJXS.AMUEX12.SORTWK12 SYSALLDA 16 2 1 1 TRK
BMC50448I SYSDISC BMCJXS.AMUEX12.SYSDISC SYSALLDA 10218 1277 197 25 TRK
BMC50448I SYSERR BMCJXS.AMUEX12.SYSERR SYSALLDA 5160 2064 100 40 TRK
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8432K, ABOVE 16M = 1024924K, CPUS = 5
BMC50479I TOTAL PAGES: 11071997, ALLOWED: 3321599; AVAILABLE PAGES: 1328889, ALLOWED: 0
BMC51499I COMBINED OPTIMIZATION, RC=0, #SORTS=5, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=88115
BMC51499I COMBINED OPTIMIZATION, RC=20, #SORTS=4, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=89216
BMC51500I COMBINED ANALYZE, #SORTS=5, #READERS=1, #INDEX TASKS=0, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0
BMC51576I 07:03:35 000 APT0000I High-speed Apply Engine V13.01.00
BMC51576I Copyright (c) 1999-2022 BMC Software, Inc. as an unpublished licensed work. All rights reserved.
BMC51576I 07:03:35 000 APT0001I Date: Fri Sep 2, 2022
BMC51576I 07:03:35 000 APT0215I MAINT: High-speed Apply Engine V13.01.00 SPE2210
BMC51576I 07:03:35 000 APT0215I MAINT: BQU4146
BMC51576I 07:03:35 000 APT0215I MAINT: SOLUTION COMMON CODE V13.01.00 BASE
BMC51576I 07:03:35 000 APT0215I MAINT: BPJ2315
BMC51576I 07:03:35 000 APT0215I MAINT: BMCSORT ENGINE V02.04.01
BMC51576I 07:03:35 000 APT0215I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922 BPJ0996 BPJ1164 BPJ1309
BMC51576I 07:03:35 000 APT0215I MAINT: BPJ1386 BPJ1497 BPJ1594 BPJ1724 BPJ1809 BPJ1833 BPJ1891
BMC51576I 07:03:35 000 APT0215I MAINT: BPJ1905 BPJ2109 BPJ2232 BPJ2297
BMC51576I 07:03:35 000 APT0272I Main thread started - TCB: 008A7B88
BMC51576I 07:03:35 000 APT0085I /STARTUP/
BMC51576I SSID=DEMO
BMC51576I INPUTTYPE={3895D640-0BF1-11D4-8027-00104B39B10F}
BMC51576I PLANNAME=APTBBLD
BMC51576I BINDQUALIFIER=APTTEST
BMC51576I DBMSTYPE=DB2
BMC51576I DISTRIBUTIONTYPE=OBJECT
BMC51576I LARGESTATEMENTSUPPORT=NO
BMC51576I 07:03:35 000 APT0085I /CONFIGURATION/
BMC51576I FILENAME=NONE
BMC51576I 07:03:35 000 APT0085I /SQL/
BMC51576I FORMAT=PACKED72
BMC51576I 07:03:35 000 APT0085I /COMMITTRIGGERS/
BMC51576I STATEMENTCOUNT=2500
BMC51576I COMMITONDEMAND=NO
BMC51576I 07:03:35 000 APT0085I /OBJECTMAP/
BMC51576I SOURCETABLE=0X0599.0X0003
BMC51576I TARGETTABLE="EXAMPLEC"."TBL1"
BMC51576I 07:03:35 000 APT0085I /AGENT/
BMC51576I MAXAGENTS=10
BMC51576I INITIALAGENTS=5
BMC51576I MAXPREPARES=50
BMC51576I 07:03:35 000 APT0085I /TEMPORARYFILES/
BMC51576I UNIT=SYSALLDA
BMC51576I 07:03:35 000 APT0085I /DIAGNOSTICOUTPUT/
BMC51576I FILENAME=APTDIAG
BMC51576I 07:03:35 000 APT0085I /RESTART/
BMC51576I RESTARTID=AMUEX12
BMC51576I RESTARTTYPE=NEW
BMC51576I CHECKPOINTFREQUENCY=0
BMC51576I TABLENAME=BMCAPT_APTRSCL
BMC51576I RETAINTIME=7
BMC51576I RETRY=3
BMC51576I 07:03:35 000 APT0085I /DISTRIBUTIONTUNING/
BMC51576I SIMPLETSCLUSTERING=NO
BMC51576I RICLUSTERING=NO
BMC51576I PARTITIONCLUSTERING=NO
BMC51576I URCHECKRI=YES
BMC51576I 07:03:35 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 07:03:35 000 APT0085I /INSERTCONFLICT/
BMC51576I CODE=MULTIROWCONFLICT
BMC51576I ACTION=RETRY
BMC51576I 07:03:35 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 07:03:35 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 07:03:35 000 APT0085I /BIND/
BMC51576I FREEOPTION=ALL
BMC51576I PLANPREFIX=APT
BMC51576I 07:03:35 000 APT0085I /BINDTUNING/
BMC51576I STATEMENTCOUNT=1
BMC51576I MAXPACKAGES=25
BMC51576I MAXFAILEDBINDS=5
BMC51576I MAXRETRIES=5
BMC51576I PACKAGEUSAGE=500
BMC51576I STATEMENTUSAGE=200
BMC51576I 07:03:35 000 APT0085I /MULTIROWINSERT/
BMC51576I MULTIROWINSERT=YES
BMC51576I MAXROWS=100
BMC51576I 07:03:35 000 APT0085I /LOGICALLOG/
BMC51576I 07:03:35 001 APT0262I OS Release = SP7.2.4 , OS PID = HBB77C0 , DF/SMS Release = DFP 2.4.0
BMC51576I 07:03:35 001 APT0263I Available region below 16M = 8828K, Available region above 16M = 1026188K, MEMLIMIT = NOLIMIT
(74572M)
BMC51576I 07:03:35 001 APT0270I CPU = 001CA498-3931(z16), Number of CPUs = 9 (GPs = 5, zIIPs = 4)
BMC51576I 07:03:35 001 APT0252I zIIP processing enabled using XBM SSID XBMB (v6.2.01)
BMC51576I 07:03:35 002 APT0272I Monitor thread started - TCB: 00893B20
BMC51576I 07:03:35 003 APT0272I Message thread started - TCB: 00893900
BMC51576I 07:03:35 001 APT0238I Successful connect to DEMO (Release 131501 of DB2)
BMC51576I 07:03:35 001 APT0269I DB2 CURRENT FUNCTION LEVEL IS V13R1M501
BMC51576I 07:03:35 001 APT0269I DB2 HIGHEST ACTIVATED FUNCTION LEVEL IS V13R1M501
BMC51576I 07:03:35 001 APT0269I DB2 CATALOG LEVEL IS V13R1M501
BMC51576I 07:03:35 001 APT0269I DB2 CODE LEVEL IS V13R1M501
BMC51576I 07:03:35 001 APT0236I High-speed Apply starting with Multi-Row Inserts
BMC51576I 07:03:35 001 APT0097I Request ID: BERJ Restart ID: AMUEX12
BMC51576I 07:03:35 004 APT0272I Distribution(Object) thread started - TCB: 008933F8
BMC51576I 07:03:36 000 APT0019I File DBRMLIB :SYS22245.T070336.RA000.AMUEX12.R0861592 allocated - elapsed time: 00:00:00
BMC51576I 07:03:36 005 APT0272I Bind thread started - TCB: 00893010
BMC51576I 07:03:36 001 APT0032I DSN output follows:
BMC51576I DSNT252I *DEMO DSNTBCM1 BIND OPTIONS FOR PLAN APTBERJ
BMC51576I ACTION ADD
BMC51576I OWNER BMCJXS
BMC51576I OWNERTYPE USER
BMC51576I VALIDATE RUN
BMC51576I ISOLATION CS
BMC51576I ACQUIRE USE
BMC51576I RELEASE COMMIT
BMC51576I EXPLAIN NO
BMC51576I DYNAMICRULES RUN
BMC51576I PROGAUTH DISABLE
BMC51576I DSNT253I *DEMO DSNTBCM1 BIND OPTIONS FOR PLAN APTBERJ
BMC51576I NODEFER PREPARE
BMC51576I CACHESIZE 4096
BMC51576I QUALIFIER BMCJXS
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 *DEMO BIND FOR PLAN APTBERJ SUCCESSFUL
BMC51576I 07:03:36 001 APT0032I DSN output follows:
BMC51576I DSNT254I *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
BMC51576I ACTION ADD
BMC51576I OWNER BMCJXS
BMC51576I QUALIFIER BMCJXS
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 V13R1M501
BMC51576I DESCSTAT YES
BMC51576I APREUSESOURCE
BMC51576I DSNT255I *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
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 *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
BMC51576I QUERYACCELERATION
BMC51576I GETACCELARCHIVE
BMC51576I ACCELERATOR
BMC51576I CONCENTRATESTMT
BMC51576I ACCELERATIONWAITFORDATA
BMC51576I RESTSERVICEDEFAULT
BMC51576I OWNERTYPE USER
BMC51576I DEPLEVEL
BMC51576I
BMC51576I DSNT232I *DEMO SUCCESSFUL BIND FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
BMC51576I 07:03:36 006 APT0272I Apply Engine thread started - TCB: 0088D7C8
BMC51576I 07:03:36 007 APT0272I Apply Engine thread started - TCB: 0088D400
BMC51576I 07:03:36 008 APT0272I Apply Engine thread started - TCB: 0088D0D8
BMC51576I 07:03:36 009 APT0272I Apply Engine thread started - TCB: 00890D70
BMC51576I 07:03:36 010 APT0272I Apply Engine thread started - TCB: 00890A58
BMC51576I 07:03:36 001 APT0272I Request thread started - TCB: 00893E68
BMC51576I 07:03:36 006 APT0079I High-speed Apply processing started - Agent: 1
BMC51576I 07:03:36 007 APT0079I High-speed Apply processing started - Agent: 2
BMC51576I 07:03:36 008 APT0079I High-speed Apply processing started - Agent: 3
BMC51576I 07:03:36 009 APT0079I High-speed Apply processing started - Agent: 4
BMC51576I 07:03:36 010 APT0079I High-speed Apply processing started - Agent: 5
BMC51576I 07:03:36 001 APT0148I Bind started for package BERJ0001 - Trigger statistics:
BMC51576I STATEMENTCOUNT...........................1
BMC51576I PACKAGEUSAGE.............................1
BMC51576I STATEMENTUSAGE...........................1
BMC51576I 07:03:36 001 APT0032I DSN output follows:
BMC51576I DSNT254I *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
BMC51576I ACTION ADD
BMC51576I OWNER BMCJXS
BMC51576I QUALIFIER BMCJXS
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 V13R1M501
BMC51576I DESCSTAT YES
BMC51576I APREUSESOURCE
BMC51576I DSNT255I *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
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 *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
BMC51576I QUERYACCELERATION
BMC51576I GETACCELARCHIVE
BMC51576I ACCELERATOR
BMC51576I CONCENTRATESTMT
BMC51576I ACCELERATIONWAITFORDATA
BMC51576I RESTSERVICEDEFAULT
BMC51576I OWNERTYPE USER
BMC51576I DEPLEVEL
BMC51576I
BMC51576I DSNT232I *DEMO SUCCESSFUL BIND FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
BMC50481I 1: READ TASK COMPLETE. ELAPSED TIME = 00:00:01
BMC51510I 1: READ TASK, XBLK XFERS = 130, EMPTY WAITS = 99, FULL WAITS = 0
BMC51478I PRELOAD STATISTICS: 100000 PHYSICAL (100000 LOGICAL) RECORDS READ FROM SYSREC
BMC51480I 3: DATA TASK COMPLETE. ELAPSED TIME = 00:00:01. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51480I 2: DATA TASK COMPLETE. ELAPSED TIME = 00:00:01. 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 = 28, FULL WAITS = 0
BMC51510I 2: SORT TASK, XBLK XFERS = 26, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 2: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 43, FULL WAITS = 0
BMC51480I 5: DATA TASK COMPLETE. ELAPSED TIME = 00:00:01. 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 = 43, FULL WAITS = 0
BMC51480I 6: DATA TASK COMPLETE. ELAPSED TIME = 00:00:01. 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 4: DATA TASK COMPLETE. ELAPSED TIME = 00:00:01. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
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
BMC51576I 07:03:36 001 APT0118I Input statements processed: 100000 Statement ID: 000186A000004E200003000501000186A0
BMC51576I 07:03:36 001 APT0066I Input processing complete
BMC51576I 07:03:36 009 APT0080I High-speed Apply processing ended - Agent: 4
BMC51576I 07:03:36 006 APT0080I High-speed Apply processing ended - Agent: 1
BMC51576I 07:03:37 010 APT0080I High-speed Apply processing ended - Agent: 5
BMC51576I 07:03:37 008 APT0080I High-speed Apply processing ended - Agent: 3
BMC51576I 07:03:37 007 APT0080I High-speed Apply processing ended - Agent: 2
BMC51576I 07:03:37 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:01.820108
BMC51576I 07:03:37 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:00.
285407
BMC51576I 4 PARTITION 2 20000 0 0 0 0 20000 00:00:00.
248733
BMC51576I 5 PARTITION 3 20000 0 0 0 0 20000 00:00:00.
449698
BMC51576I 2 PARTITION 4 20000 0 0 0 0 20000 00:00:00.
489561
BMC51576I 3 PARTITION 5 20000 0 0 0 0 20000 00:00:00.
346705
BMC51576I 07:03:37 010 APT0273I Apply Engine thread ended - TCB: 00890A58 CPU Time: 00:00:00.135411
BMC51576I 07:03:37 009 APT0273I Apply Engine thread ended - TCB: 00890D70 CPU Time: 00:00:00.141720
BMC51576I 07:03:37 008 APT0273I Apply Engine thread ended - TCB: 0088D0D8 CPU Time: 00:00:00.134006
BMC51576I 07:03:37 007 APT0273I Apply Engine thread ended - TCB: 0088D400 CPU Time: 00:00:00.131023
BMC51576I 07:03:37 006 APT0273I Apply Engine thread ended - TCB: 0088D7C8 CPU Time: 00:00:00.151123
BMC51576I 07:03:37 004 APT0273I Distribution(Object) thread ended - TCB: 008933F8 CPU Time: 00:00:00.029924
BMC51576I 07:03:37 001 APT0032I DSN output follows:
BMC51576I DSNT200I *DEMO FREE FOR PLAN APTBERJ SUCCESSFUL
BMC51576I 07:03:37 001 APT0032I DSN output follows:
BMC51576I DSNT232I *DEMO SUCCESSFUL FREE FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
BMC51576I DSNT232I *DEMO SUCCESSFUL FREE FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
BMC51576I 07:03:37 005 APT0273I Bind thread ended - TCB: 00893010 CPU Time: 00:00:00.035186
BMC51576I 07:03:37 000 APT0020I File DBRMLIB :SYS22245.T070336.RA000.AMUEX12.R0861592 deallocated
BMC51576I 07:03:37 003 APT0273I Message thread ended - TCB: 00893900 CPU Time: 00:00:00.005574
BMC51576I 07:03:37 001 APT0111I INPUT PROCESSING STATISTICS
BMC51576I INSERT UPDATE DELETE TRUNCATE DDL TOTAL
BMC51576I 100000 0 0 0 0 100000
BMC51576I 07:03:37 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 07:03:37 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 07:03:37 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 07:03:37 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 07:03:37 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 07:03:37 001 APT0206I PACKAGE STATISTICS
BMC51576I NAME STMTCNT USAGECNT RETRIES BIND ELAPSED TIME
BMC51576I BERJ0000 101 0 0 00:00:00.066772
BMC51576I BERJ0001 1 100000 0 00:00:00.046823
BMC51576I --------- --------- --------- --------- -----------------
BMC51576I TOTAL 102 100000 0 00:00:00.113596
BMC51576I 07:03:37 001 APT0182I OTHER STATISTICS
BMC51576I AGENT FAILPREPS RETRIES DBMS ELAPSED TIME
BMC51576I 1 0 0 00:00:00.307987
BMC51576I 2 0 0 00:00:00.508038
BMC51576I 3 0 0 00:00:00.367750
BMC51576I 4 0 0 00:00:00.270335
BMC51576I 5 0 0 00:00:00.480675
BMC51576I ----- --------- --------- -----------------
BMC51576I TOTAL 0 0 00:00:01.934789
BMC51576I 07:03:37 001 APT0183I Request elapsed time: 00:00:01.723919
BMC51576I 07:03:37 002 APT0273I Monitor thread ended - TCB: 00893B20 CPU Time: 00:00:00.005555
BMC51576I 07:03:37 001 APT0273I Request thread ended - TCB: 00893E68 CPU Time: 00:00:00.335439
BMC51576I 07:03:37 000 APT0273I Main thread ended - TCB: 008A7B88 CPU Time: 00:00:00.080591
BMC51576I 07:03:37 000 APT0067I Request completed Return code: 0
BMC50481I 10: SQLAPPLY TASK COMPLETE. ELAPSED TIME = 00:00:02
BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC, I/OS = 20, I/O WAITS = 19, RDB LOCK WAITS = 0
BMC51507I XBLKS = 20, XFERS = 130, EMPTY WAITS = 99, 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 = 'SORTWK01', DSNAME = 'BMCJXS.AMUEX12.SORTWK01'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK02', DSNAME = 'BMCJXS.AMUEX12.SORTWK02'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK03', DSNAME = 'BMCJXS.AMUEX12.SORTWK03'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR ', DSNAME = 'BMCJXS.AMUEX12.SYSERR'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK04', DSNAME = 'BMCJXS.AMUEX12.SORTWK04'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK05', DSNAME = 'BMCJXS.AMUEX12.SORTWK05'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK06', DSNAME = 'BMCJXS.AMUEX12.SORTWK06'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK07', DSNAME = 'BMCJXS.AMUEX12.SORTWK07'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK08', DSNAME = 'BMCJXS.AMUEX12.SORTWK08'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK09', DSNAME = 'BMCJXS.AMUEX12.SORTWK09'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK10', DSNAME = 'BMCJXS.AMUEX12.SORTWK10'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK11', DSNAME = 'BMCJXS.AMUEX12.SORTWK11'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK12', DSNAME = 'BMCJXS.AMUEX12.SORTWK12'
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:04
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 the 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 V13R1.00 ************
(C) COPYRIGHT 1990 - 2022 BMC SOFTWARE, INC.
LOADPLUS TECHNOLOGY IS PROTECTED BY U.S. PATENT NUMBERS 7,664,790 AND 7,930,291
-BMC50001I UTILITY EXECUTION STARTING 9/02/2022 7:03:40 ...
BMC50002I UTILITY ID = 'AMUEX12'. DB2 SUBSYSTEM ID = 'DEMO'. OPTION MODULE = 'AMU$OPTE'.
BMC50471I z/OS 2.4.0,PID=HBB77C0,DFSMS FOR Z/OS=2.4.0,DB2=13.1.501
BMC50471I REGION=0M,BELOW 16M=8.6M,ABOVE 16M=1,007.5M,IEFUSI=NO,CPUs=9,GPs=5,zIIPs=4
BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
BMC50471I SMFID=DB2B,JOBID=J0052461,JOB=AMUEX12,STEP=EXAMP12B,CPU=3931-612 (z16)/1.47,76.0G
0
BMC50471I LOADPLUS FOR DB2--V13.01.00 SPE2207
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V13.01.00 SPE2207
BMC50471I MAINT: BQU4035
BMC50471I SOLUTION COMMON CODE--V13.01.00 BASE
BMC50471I MAINT: BPJ2315
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922 BPJ0996 BPJ1164 BPJ1309 BPJ1386 BPJ1497 BPJ1594 BPJ1724 BPJ1809
BMC50471I BPJ1833 BPJ1891 BPJ1905 BPJ2109 BPJ2232 BPJ2297
BMC50471I BMC STATS API--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.02.01
BMC50471I MAINT: BPE0443 BPE0445 BPE0447 BPE0449 BPE0450 BPE0451 BPE0452 BPE0455 BPE0456 BPE0457 BPE0460 BPE0463
BMC50471I BPE0467 BPE0468 BPE0469 BPE0473 BPE0474 BPE0475 BPE0479 BPE0480 BPE0482 BPE0487 BPE0488 BPE0489
BMC50471I BPE0493 BPE0497 BPE0498 BPE0501 BPE0503 BPE0507 BPE0512 BPE0513 BPE0517 BPE0518 BPE0519 BPE0523
BMC50471I BPE0524 BPE0527 BPE0528 BPE0530 BPE0531 BPE0534 BPE0535 BPE0540 BPE0541 BPE0542 BPE0545 BPE0549
BMC50471I BPE0551 BPE0552 BPE0555 BPE0556 BPE0557 BPE0560 BPE0561
BMC50471I High-speed Apply Engine--V13.01.00 SPE2210
BMC50471I MAINT: BQU4146
0
BMC50471I APCOMMIT=2500 FORCE=NONE RULES=BMC
BMC50471I APDOPTS= IBUFFS=20 SDUMP=YES
BMC50471I APMULTIROW=100 IDCACHE=1000 SHORTMEMORY=CONTINUE
BMC50471I APMXAGNT=10 IDCDDN=SYSIDCIN SHRLEVEL=(NONE,NONE)
BMC50471I APRETLIM=COUNT IDERROR=DISCARD SMAX=16
BMC50471I APRETVAL=5 INDDN=SYSREC SMCORE=(0K,0K)
BMC50471I AUTOENUMROWS=YES INFORI=NO SORTDEVT=(,SYSALLDA)
BMC50471I AVAILPAGEPCT=0 INLINECP=YES SORTNUM=32
BMC50471I CBUFFS=30 INVALIDATECACHE=YES SQLDELAY=3
BMC50471I CENTURY=(1950,2049) KEEPDICTIONARY=NO SQLRETRY=100
BMC50471I CHEKPEND=YES LBUFFS=20 SSIGNRPAUSE=NO
BMC50471I COPYDDN=(BMCCPY,BMCCPZ) LOADDN=SORTOUT SSREPORT=REPORT_SWITCH
BMC50471I COPYLVL=FULL LOBAVGPCT=50 STOP@CMT=YES
BMC50471I COPYPEND=YES LOCKROW=YES STOPDELAY=1
BMC50471I COPYSUBSET=NO LONGNAMETRUNC=MIDDLE STOPRETRY=300
BMC50471I DELFILES=(YES,NO) MAPDDN=SYSMAP TAPEDISP=DELETE
BMC50471I DISCARDLIMRC=8 MAXP=5 TOTALPAGEPCT=30
BMC50471I DISCARDRC=0 MAXSORTMEMORY=0 TSSAMPLEPCT=100
BMC50471I DISCDDN=SYSDISC MAXTAPE=3 UPDMAXA_AUTHID=USER
BMC50471I DRNDELAY=1 MGEXTENT=CONTINUE UPDMAXA=NO
BMC50471I DRNRETRY=255 MINSORTMEMORY=0 UXSTATE=SUP
BMC50471I DRNWAIT=NONE MSGLEVEL=1 WBUFFS=(20,10)
BMC50471I DSNUEXIT=(NONE,ASM) OPNDB2ID=YES WORKDDN=SYSUT1
BMC50471I DSNUTILB=YES ORIGDISP=DELETE WORKUNIT=SYSALLDA
BMC50471I ENFORCE=CHECK PAUSEDISCARDRC=4 WRLOG=NO
BMC50471I ERRDDN=SYSERR PLAN=AMU1310I XBLKS=3
BMC50471I EXCLDUMP=(X37,X22,X06) PREFORMAT=NO XMLAVGSIZE=10240
BMC50471I FASTSWITCH=NO PRELOAD=LOAD ZEROROWRC=0
BMC50471I FILECHK=WARN RCVYDDN=(BMCRCY,BMCRCZ) ZIIP=ENABLED
BMC50471I FORCE_AT=(START,3) REDEFINE=YES
BMC50471I FORCE_RPT=NO RENMMAX=30
0
BMC50471I APCOLLECTION=
BMC50471I APOWNER=
0
BMC50470I DDTYPE = LOAD WORK SORTWORK
BMC50470I ACTIVE = 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 = NO NO NO
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 = NO NO NO
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.&UTILPFX.&DDNAME
BMC50483I WORK DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I SORTWORK DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I ERROR DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I DISCARD DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I SYSMAP DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50483I LOCPFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I LOCBFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMPFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMBFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50483I LOCPLCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I LOCBLCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMPLCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMBLCPY DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50483I LOCPXCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I LOCBXCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMPXCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMBXCPY DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50471I DB2 DSNHDECP MODULE SETTINGS:
BMC50471I VERSION = 1310
BMC50471I SUBSYSTEM DEFAULT = DEMO
BMC50471I CHARACTER SET = ALPHANUM
BMC50471I DATE FORMAT = USA
BMC50471I TIME FORMAT = USA
BMC50471I LOCAL DATE LENGTH = 0
BMC50471I LOCAL TIME LENGTH = 0
BMC50471I DECIMAL POINT = PERIOD
BMC50471I DECIMAL ARITHMETIC = 15
BMC50471I DELIMITER = DEFAULT
BMC50471I SQL DELIMITER = DEFAULT
BMC50471I ENCODING SCHEME = EBCDIC
BMC50471I APPL. ENCODING SCHEME = EBCDIC
BMC50471I MIXED = NO
BMC50471I EBCDIC CCSID = (37,65534,65534)
BMC50471I ASCII CCSID = (819,65534,65534)
BMC50471I UNICODE CCSID = (367,1208,1200)
BMC50471I IMPLICIT TIME ZONE = CURRENT (-05:00)
BMC50658I DB2 CURRENT FUNCTION LEVEL IS V13R1M501
BMC50659I DB2 CATALOG LEVEL IS V13R1M501
BMC50660I DB2 HIGHEST ACTIVATED FUNCTION LEVEL IS V13R1M501
BMC50661I DB2 CODE LEVEL IS V13R1M501
BMC50471I BMC_BMCUTIL ='BMCUTIL.CMN_BMCUTIL'
BMC50471I BMC_BMCSYNC ='BMCUTIL.CMN_BMCSYNC'
BMC50471I BMC_BMCHIST ='BMCUTIL.CMN_BMCHIST'
BMC50471I BMC_BMCDICT ='BMCUTIL.CMN_BMCDICT'
BMC50471I BMC_BMCSMARTSWITCH='BMCUTIL.CMN_BMCSWITCH'
BMC50471I BMC_BMCSSTRACKING ='BMCUTIL.CMN_BMCSSTRACK'
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
BMC54000I SMARTSWITCH NOT SUPPORTED - NO BMC AMI UTILITIES VERSION FOUND
BMC54003I SMARTSWITCH RULE: FORCE_NO_SWITCH COMMENT: SMARTSWITCH IS ACTIVATED, BUT NO RULE APPLIES. PLUS UTILITY WILL BE USED
BMC50004I NGTUTIL PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50199I LOAD PLUS PROCESSING CONTINUES
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
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 = BMCJXS
BMC50425I &RESUME = Y &REPLACE = N &DATE = 090222 &TIME = 070340 &SSID = DEMO
BMC50425I &UTIL = AMUEX12 &UTILPFX = AMUEX12 &UTILSFX = &DATE8 = 09022022 &GRPNM = DEMO
BMC50425I &VCAT = DEMOCAT &TIME4 = 0703 &DATEJ = 2022245 &JDATE = 22245
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 BMCJXS.RESUMEY.SORTWK01 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK02 BMCJXS.RESUMEY.SORTWK02 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK03 BMCJXS.RESUMEY.SORTWK03 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK04 BMCJXS.RESUMEY.SORTWK04 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK05 BMCJXS.RESUMEY.SORTWK05 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK06 BMCJXS.RESUMEY.SORTWK06 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK07 BMCJXS.RESUMEY.SORTWK07 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK08 BMCJXS.RESUMEY.SORTWK08 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK09 BMCJXS.RESUMEY.SORTWK09 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK10 BMCJXS.RESUMEY.SORTWK10 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK11 BMCJXS.RESUMEY.SORTWK11 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK12 BMCJXS.RESUMEY.SORTWK12 SYSALLDA 725 73 14 2 TRK
BMC50448I SYSDISC BMCJXS.RESUMEY.SYSDISC SYSALLDA 10218 1277 197 25 TRK
BMC50448I SYSERR BMCJXS.RESUMEY.SYSERR SYSALLDA 5160 2064 100 40 TRK
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8448K, ABOVE 16M = 1024884K, CPUS = 5
BMC50479I TOTAL PAGES: 11059589, ALLOWED: 3317877; AVAILABLE PAGES: 1317953, 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 3: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 4: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 6: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51576I 07:03:43 000 APT0000I High-speed Apply Engine V13.01.00
BMC51576I Copyright (c) 1999-2022 BMC Software, Inc. as an unpublished licensed work. All rights reserved.
BMC51576I 07:03:43 000 APT0001I Date: Fri Sep 2, 2022
BMC51576I 07:03:43 000 APT0215I MAINT: High-speed Apply Engine V13.01.00 SPE2210
BMC51576I 07:03:43 000 APT0215I MAINT: BQU4146
BMC51576I 07:03:43 000 APT0215I MAINT: SOLUTION COMMON CODE V13.01.00 BASE
BMC51576I 07:03:43 000 APT0215I MAINT: BPJ2315
BMC51576I 07:03:43 000 APT0215I MAINT: BMCSORT ENGINE V02.04.01
BMC50486I 2: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51576I 07:03:43 000 APT0215I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922 BPJ0996 BPJ1164 BPJ1309
BMC51576I 07:03:43 000 APT0215I MAINT: BPJ1386 BPJ1497 BPJ1594 BPJ1724 BPJ1809 BPJ1833 BPJ1891
BMC51576I 07:03:43 000 APT0215I MAINT: BPJ1905 BPJ2109 BPJ2232 BPJ2297
BMC51576I 07:03:43 000 APT0272I Main thread started - TCB: 008A7B88
BMC50486I 5: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51576I 07:03:43 000 APT0085I /STARTUP/
BMC51576I SSID=DEMO
BMC51576I INPUTTYPE={3895D640-0BF1-11D4-8027-00104B39B10F}
BMC51576I PLANNAME=APTBBLD
BMC51576I BINDQUALIFIER=APTTEST
BMC51576I DBMSTYPE=DB2
BMC51576I DISTRIBUTIONTYPE=OBJECT
BMC51576I LARGESTATEMENTSUPPORT=NO
BMC51576I 07:03:43 000 APT0085I /CONFIGURATION/
BMC51576I FILENAME=NONE
BMC51576I 07:03:43 000 APT0085I /SQL/
BMC51576I FORMAT=PACKED72
BMC51576I 07:03:43 000 APT0085I /COMMITTRIGGERS/
BMC51576I STATEMENTCOUNT=2500
BMC51576I COMMITONDEMAND=NO
BMC51576I 07:03:43 000 APT0085I /OBJECTMAP/
BMC51576I SOURCETABLE=0X0599.0X0003
BMC51576I TARGETTABLE="EXAMPLEC"."TBL1"
BMC51576I 07:03:43 000 APT0085I /AGENT/
BMC51576I MAXAGENTS=10
BMC51576I INITIALAGENTS=5
BMC51576I MAXPREPARES=50
BMC51576I 07:03:43 000 APT0085I /TEMPORARYFILES/
BMC51576I UNIT=SYSALLDA
BMC51576I 07:03:43 000 APT0085I /DIAGNOSTICOUTPUT/
BMC51576I FILENAME=APTDIAG
BMC51576I 07:03:43 000 APT0085I /RESTART/
BMC51576I RESTARTID=AMUEX12
BMC51576I RESTARTTYPE=NEW
BMC51576I CHECKPOINTFREQUENCY=0
BMC51576I TABLENAME=BMCAPT_APTRSCL
BMC51576I RETAINTIME=7
BMC51576I RETRY=3
BMC51576I 07:03:43 000 APT0085I /DISTRIBUTIONTUNING/
BMC51576I SIMPLETSCLUSTERING=NO
BMC51576I RICLUSTERING=NO
BMC51576I PARTITIONCLUSTERING=NO
BMC51576I URCHECKRI=YES
BMC51576I 07:03:43 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 07:03:43 000 APT0085I /INSERTCONFLICT/
BMC51576I CODE=MULTIROWCONFLICT
BMC51576I ACTION=RETRY
BMC51576I 07:03:43 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 07:03:43 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 07:03:43 000 APT0085I /BIND/
BMC51576I FREEOPTION=ALL
BMC51576I PLANPREFIX=APT
BMC51576I 07:03:43 000 APT0085I /BINDTUNING/
BMC51576I STATEMENTCOUNT=1
BMC51576I MAXPACKAGES=25
BMC51576I MAXFAILEDBINDS=5
BMC51576I MAXRETRIES=5
BMC51576I PACKAGEUSAGE=500
BMC51576I STATEMENTUSAGE=200
BMC51576I 07:03:43 000 APT0085I /MULTIROWINSERT/
BMC51576I MULTIROWINSERT=YES
BMC51576I MAXROWS=100
BMC51576I 07:03:43 000 APT0085I /LOGICALLOG/
BMC51576I 07:03:43 001 APT0262I OS Release = SP7.2.4 , OS PID = HBB77C0 , DF/SMS Release = DFP 2.4.0
BMC51576I 07:03:43 001 APT0263I Available region below 16M = 8096K, Available region above 16M = 1024012K, MEMLIMIT = NOLIMIT
(74560M)
BMC51576I 07:03:43 001 APT0270I CPU = 001CA498-3931(z16), Number of CPUs = 9 (GPs = 5, zIIPs = 4)
BMC51576I 07:03:43 001 APT0252I zIIP processing enabled using XBM SSID XBMB (v6.2.01)
BMC51576I 07:03:43 002 APT0272I Monitor thread started - TCB: 0088A6D8
BMC51576I 07:03:43 003 APT0272I Message thread started - TCB: 0088A448
BMC51576I 07:03:43 001 APT0238I Successful connect to DEMO (Release 131501 of DB2)
BMC51576I 07:03:43 001 APT0269I DB2 CURRENT FUNCTION LEVEL IS V13R1M501
BMC51576I 07:03:43 001 APT0269I DB2 HIGHEST ACTIVATED FUNCTION LEVEL IS V13R1M501
BMC51576I 07:03:43 001 APT0269I DB2 CATALOG LEVEL IS V13R1M501
BMC51576I 07:03:43 001 APT0269I DB2 CODE LEVEL IS V13R1M501
BMC51576I 07:03:43 001 APT0236I High-speed Apply starting with Multi-Row Inserts
BMC51576I 07:03:43 001 APT0097I Request ID: BERJ Restart ID: AMUEX12
BMC51576I 07:03:43 004 APT0272I Distribution(Object) thread started - TCB: 0088A008
BMC51576I 07:03:44 000 APT0019I File DBRMLIB :SYS22245.T070344.RA000.AMUEX12.R0861647 allocated - elapsed time: 00:00:00
BMC51576I 07:03:44 005 APT0272I Bind thread started - TCB: 00885C18
BMC51576I 07:03:44 001 APT0032I DSN output follows:
BMC51576I DSNT252I *DEMO DSNTBCM1 BIND OPTIONS FOR PLAN APTBERJ
BMC51576I ACTION ADD
BMC51576I OWNER BMCJXS
BMC51576I OWNERTYPE USER
BMC51576I VALIDATE RUN
BMC51576I ISOLATION CS
BMC51576I ACQUIRE USE
BMC51576I RELEASE COMMIT
BMC51576I EXPLAIN NO
BMC51576I DYNAMICRULES RUN
BMC51576I PROGAUTH DISABLE
BMC51576I DSNT253I *DEMO DSNTBCM1 BIND OPTIONS FOR PLAN APTBERJ
BMC51576I NODEFER PREPARE
BMC51576I CACHESIZE 4096
BMC51576I QUALIFIER BMCJXS
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 *DEMO BIND FOR PLAN APTBERJ SUCCESSFUL
BMC51576I 07:03:44 001 APT0032I DSN output follows:
BMC51576I DSNT254I *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
BMC51576I ACTION ADD
BMC51576I OWNER BMCJXS
BMC51576I QUALIFIER BMCJXS
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 V13R1M501
BMC51576I DESCSTAT YES
BMC51576I APREUSESOURCE
BMC51576I DSNT255I *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
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 *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
BMC51576I QUERYACCELERATION
BMC51576I GETACCELARCHIVE
BMC51576I ACCELERATOR
BMC51576I CONCENTRATESTMT
BMC51576I ACCELERATIONWAITFORDATA
BMC51576I RESTSERVICEDEFAULT
BMC51576I OWNERTYPE USER
BMC51576I DEPLEVEL
BMC51576I
BMC51576I DSNT232I *DEMO SUCCESSFUL BIND FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
BMC51576I 07:03:44 006 APT0272I Apply Engine thread started - TCB: 008858D0
BMC51576I 07:03:44 007 APT0272I Apply Engine thread started - TCB: 00885508
BMC51576I 07:03:44 008 APT0272I Apply Engine thread started - TCB: 008851E0
BMC51576I 07:03:44 009 APT0272I Apply Engine thread started - TCB: 00888E68
BMC51576I 07:03:44 010 APT0272I Apply Engine thread started - TCB: 008885C8
BMC51576I 07:03:44 001 APT0272I Request thread started - TCB: 0088AE68
BMC51576I 07:03:44 006 APT0079I High-speed Apply processing started - Agent: 1
BMC51576I 07:03:44 007 APT0079I High-speed Apply processing started - Agent: 2
BMC51576I 07:03:44 008 APT0079I High-speed Apply processing started - Agent: 3
BMC51576I 07:03:44 009 APT0079I High-speed Apply processing started - Agent: 4
BMC51576I 07:03:44 010 APT0079I High-speed Apply processing started - Agent: 5
BMC50481I 1: READ TASK COMPLETE. ELAPSED TIME = 00:00:02
BMC51510I 1: READ TASK, XBLK XFERS = 140, EMPTY WAITS = 33, FULL WAITS = 0
BMC51478I PRELOAD STATISTICS: 100000 PHYSICAL (100000 LOGICAL) RECORDS READ FROM SYSREC
BMC51576I 07:03:45 001 APT0148I Bind started for package BERJ0001 - Trigger statistics:
BMC51576I STATEMENTCOUNT...........................1
BMC51576I PACKAGEUSAGE.............................1
BMC51576I STATEMENTUSAGE...........................1
BMC51576I 07:03:45 001 APT0032I DSN output follows:
BMC51576I DSNT254I *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
BMC51576I ACTION ADD
BMC51576I OWNER BMCJXS
BMC51576I QUALIFIER BMCJXS
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 V13R1M501
BMC51576I DESCSTAT YES
BMC51576I APREUSESOURCE
BMC51576I DSNT255I *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
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 *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
BMC51576I QUERYACCELERATION
BMC51576I GETACCELARCHIVE
BMC51576I ACCELERATOR
BMC51576I CONCENTRATESTMT
BMC51576I ACCELERATIONWAITFORDATA
BMC51576I RESTSERVICEDEFAULT
BMC51576I OWNERTYPE USER
BMC51576I DEPLEVEL
BMC51576I
BMC51576I DSNT232I *DEMO SUCCESSFUL BIND FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
BMC51480I 2: DATA TASK COMPLETE. ELAPSED TIME = 00:00:03. 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 = 33, FULL WAITS = 0
BMC51480I 6: DATA TASK COMPLETE. ELAPSED TIME = 00:00:03. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51510I 6: SORT TASK, XBLK XFERS = 28, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 6: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 38, FULL WAITS = 0
BMC51576I 07:03:46 001 APT0118I Input statements processed: 100000 Statement ID: 000186A000004E200003000501000186A0
BMC51576I 07:03:46 001 APT0066I Input processing complete
BMC51576I 07:03:46 009 APT0080I High-speed Apply processing ended - Agent: 4
BMC51576I 07:03:46 006 APT0080I High-speed Apply processing ended - Agent: 1
BMC51576I 07:03:46 010 APT0080I High-speed Apply processing ended - Agent: 5
BMC51576I 07:03:46 007 APT0080I High-speed Apply processing ended - Agent: 2
BMC51576I 07:03:46 008 APT0080I High-speed Apply processing ended - Agent: 3
BMC51576I 07:03:46 001 APT0185I Statements committed: 100000
BMC51576I 07:03:47 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:01.243366
BMC51576I 07:03:47 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:00.
238582
BMC51576I 4 PARTITION 2 20000 0 0 0 0 20000 00:00:00.
242394
BMC51576I 5 PARTITION 3 20000 0 0 0 0 20000 00:00:00.
247112
BMC51576I 1 PARTITION 4 20000 0 0 0 0 20000 00:00:00.
249301
BMC51576I 3 PARTITION 5 20000 0 0 0 0 20000 00:00:00.
265973
BMC51576I 07:03:47 010 APT0273I Apply Engine thread ended - TCB: 008885C8 CPU Time: 00:00:00.151837
BMC51576I 07:03:47 009 APT0273I Apply Engine thread ended - TCB: 00888E68 CPU Time: 00:00:00.150998
BMC51480I 5: DATA TASK COMPLETE. ELAPSED TIME = 00:00:04. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51480I 4: DATA TASK COMPLETE. ELAPSED TIME = 00:00:04. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51480I 3: DATA TASK COMPLETE. ELAPSED TIME = 00:00:04. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51576I 07:03:47 008 APT0273I Apply Engine thread ended - TCB: 008851E0 CPU Time: 00:00:00.151225
BMC51510I 5: SORT TASK, XBLK XFERS = 28, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 5: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 43, FULL WAITS = 0
BMC51510I 3: SORT TASK, XBLK XFERS = 28, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 3: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 43, 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 = 43, FULL WAITS = 0
BMC51576I 07:03:47 007 APT0273I Apply Engine thread ended - TCB: 00885508 CPU Time: 00:00:00.153377
BMC51576I 07:03:47 006 APT0273I Apply Engine thread ended - TCB: 008858D0 CPU Time: 00:00:00.162316
BMC51576I 07:03:47 004 APT0273I Distribution(Object) thread ended - TCB: 0088A008 CPU Time: 00:00:00.029941
BMC51576I 07:03:47 001 APT0032I DSN output follows:
BMC51576I DSNT200I *DEMO FREE FOR PLAN APTBERJ SUCCESSFUL
BMC51576I 07:03:47 001 APT0032I DSN output follows:
BMC51576I DSNT232I *DEMO SUCCESSFUL FREE FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
BMC51576I DSNT232I *DEMO SUCCESSFUL FREE FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
BMC51576I 07:03:47 005 APT0273I Bind thread ended - TCB: 00885C18 CPU Time: 00:00:00.035619
BMC51576I 07:03:47 000 APT0020I File DBRMLIB :SYS22245.T070344.RA000.AMUEX12.R0861647 deallocated
BMC51576I 07:03:47 003 APT0273I Message thread ended - TCB: 0088A448 CPU Time: 00:00:00.005671
BMC51576I 07:03:47 001 APT0111I INPUT PROCESSING STATISTICS
BMC51576I INSERT UPDATE DELETE TRUNCATE DDL TOTAL
BMC51576I 100000 0 0 0 0 100000
BMC51576I 07:03:47 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 07:03:47 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 07:03:47 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 07:03:47 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 07:03:47 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 07:03:47 001 APT0206I PACKAGE STATISTICS
BMC51576I NAME STMTCNT USAGECNT RETRIES BIND ELAPSED TIME
BMC51576I BERJ0000 101 0 0 00:00:00.048277
BMC51576I BERJ0001 1 100000 0 00:00:00.028220
BMC51576I --------- --------- --------- --------- -----------------
BMC51576I TOTAL 102 100000 0 00:00:00.076498
BMC51576I 07:03:47 001 APT0182I OTHER STATISTICS
BMC51576I AGENT FAILPREPS RETRIES DBMS ELAPSED TIME
BMC51576I 1 0 0 00:00:00.281374
BMC51576I 2 0 0 00:00:00.279827
BMC51576I 3 0 0 00:00:00.306629
BMC51576I 4 0 0 00:00:00.280025
BMC51576I 5 0 0 00:00:00.286727
BMC51576I ----- --------- --------- -----------------
BMC51576I TOTAL 0 0 00:00:01.434586
BMC51576I 07:03:47 001 APT0183I Request elapsed time: 00:00:04.216319
BMC51576I 07:03:47 002 APT0273I Monitor thread ended - TCB: 0088A6D8 CPU Time: 00:00:00.005908
BMC51576I 07:03:47 001 APT0273I Request thread ended - TCB: 0088AE68 CPU Time: 00:00:00.338378
BMC51576I 07:03:47 000 APT0273I Main thread ended - TCB: 008A7B88 CPU Time: 00:00:00.079005
BMC51576I 07:03:47 000 APT0067I Request completed Return code: 0
BMC50481I 10: SQLAPPLY TASK COMPLETE. ELAPSED TIME = 00:00:04
BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC, I/OS = 20, I/O WAITS = 19, RDB LOCK WAITS = 0
BMC51507I XBLKS = 20, XFERS = 140, EMPTY WAITS = 33, 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 = 'SORTWK01', DSNAME = 'BMCJXS.RESUMEY.SORTWK01'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR ', DSNAME = 'BMCJXS.RESUMEY.SYSERR'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK02', DSNAME = 'BMCJXS.RESUMEY.SORTWK02'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK03', DSNAME = 'BMCJXS.RESUMEY.SORTWK03'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK04', DSNAME = 'BMCJXS.RESUMEY.SORTWK04'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK05', DSNAME = 'BMCJXS.RESUMEY.SORTWK05'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK06', DSNAME = 'BMCJXS.RESUMEY.SORTWK06'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK07', DSNAME = 'BMCJXS.RESUMEY.SORTWK07'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK08', DSNAME = 'BMCJXS.RESUMEY.SORTWK08'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK09', DSNAME = 'BMCJXS.RESUMEY.SORTWK09'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK10', DSNAME = 'BMCJXS.RESUMEY.SORTWK10'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK11', DSNAME = 'BMCJXS.RESUMEY.SORTWK11'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK12', DSNAME = 'BMCJXS.RESUMEY.SORTWK12'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSDISC ', DSNAME = 'BMCJXS.RESUMEY.SYSDISC'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I COMBINED PHASE COMPLETE. ELAPSED TIME = 00:00:05
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 - 2022 BMC SOFTWARE, INC.
LOADPLUS TECHNOLOGY IS PROTECTED BY U.S. PATENT NUMBERS 7,664,790 AND 7,930,291
-BMC50001I UTILITY EXECUTION STARTING 9/02/2022 7:03:40 ...
BMC50002I UTILITY ID = 'AMUEX12'. DB2 SUBSYSTEM ID = 'DEMO'. OPTION MODULE = 'AMU$OPTE'.
BMC50471I z/OS 2.4.0,PID=HBB77C0,DFSMS FOR Z/OS=2.4.0,DB2=13.1.501
BMC50471I REGION=0M,BELOW 16M=8.6M,ABOVE 16M=1,007.5M,IEFUSI=NO,CPUs=9,GPs=5,zIIPs=4
BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
BMC50471I SMFID=DB2B,JOBID=J0052461,JOB=AMUEX12,STEP=EXAMP12B,CPU=3931-612 (z16)/1.47,76.0G
0
BMC50471I LOADPLUS FOR DB2--V13.01.00 SPE2207
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V13.01.00 SPE2207
BMC50471I MAINT: BQU4035
BMC50471I SOLUTION COMMON CODE--V13.01.00 BASE
BMC50471I MAINT: BPJ2315
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922 BPJ0996 BPJ1164 BPJ1309 BPJ1386 BPJ1497 BPJ1594 BPJ1724 BPJ1809
BMC50471I BPJ1833 BPJ1891 BPJ1905 BPJ2109 BPJ2232 BPJ2297
BMC50471I BMC STATS API--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.02.01
BMC50471I MAINT: BPE0443 BPE0445 BPE0447 BPE0449 BPE0450 BPE0451 BPE0452 BPE0455 BPE0456 BPE0457 BPE0460 BPE0463
BMC50471I BPE0467 BPE0468 BPE0469 BPE0473 BPE0474 BPE0475 BPE0479 BPE0480 BPE0482 BPE0487 BPE0488 BPE0489
BMC50471I BPE0493 BPE0497 BPE0498 BPE0501 BPE0503 BPE0507 BPE0512 BPE0513 BPE0517 BPE0518 BPE0519 BPE0523
BMC50471I BPE0524 BPE0527 BPE0528 BPE0530 BPE0531 BPE0534 BPE0535 BPE0540 BPE0541 BPE0542 BPE0545 BPE0549
BMC50471I BPE0551 BPE0552 BPE0555 BPE0556 BPE0557 BPE0560 BPE0561
BMC50471I High-speed Apply Engine--V13.01.00 SPE2210
BMC50471I MAINT: BQU4146
0
BMC50471I APCOMMIT=2500 FORCE=NONE RULES=BMC
BMC50471I APDOPTS= IBUFFS=20 SDUMP=YES
BMC50471I APMULTIROW=100 IDCACHE=1000 SHORTMEMORY=CONTINUE
BMC50471I APMXAGNT=10 IDCDDN=SYSIDCIN SHRLEVEL=(NONE,NONE)
BMC50471I APRETLIM=COUNT IDERROR=DISCARD SMAX=16
BMC50471I APRETVAL=5 INDDN=SYSREC SMCORE=(0K,0K)
BMC50471I AUTOENUMROWS=YES INFORI=NO SORTDEVT=(,SYSALLDA)
BMC50471I AVAILPAGEPCT=0 INLINECP=YES SORTNUM=32
BMC50471I CBUFFS=30 INVALIDATECACHE=YES SQLDELAY=3
BMC50471I CENTURY=(1950,2049) KEEPDICTIONARY=NO SQLRETRY=100
BMC50471I CHEKPEND=YES LBUFFS=20 SSIGNRPAUSE=NO
BMC50471I COPYDDN=(BMCCPY,BMCCPZ) LOADDN=SORTOUT SSREPORT=REPORT_SWITCH
BMC50471I COPYLVL=FULL LOBAVGPCT=50 STOP@CMT=YES
BMC50471I COPYPEND=YES LOCKROW=YES STOPDELAY=1
BMC50471I COPYSUBSET=NO LONGNAMETRUNC=MIDDLE STOPRETRY=300
BMC50471I DELFILES=(YES,NO) MAPDDN=SYSMAP TAPEDISP=DELETE
BMC50471I DISCARDLIMRC=8 MAXP=5 TOTALPAGEPCT=30
BMC50471I DISCARDRC=0 MAXSORTMEMORY=0 TSSAMPLEPCT=100
BMC50471I DISCDDN=SYSDISC MAXTAPE=3 UPDMAXA_AUTHID=USER
BMC50471I DRNDELAY=1 MGEXTENT=CONTINUE UPDMAXA=NO
BMC50471I DRNRETRY=255 MINSORTMEMORY=0 UXSTATE=SUP
BMC50471I DRNWAIT=NONE MSGLEVEL=1 WBUFFS=(20,10)
BMC50471I DSNUEXIT=(NONE,ASM) OPNDB2ID=YES WORKDDN=SYSUT1
BMC50471I DSNUTILB=YES ORIGDISP=DELETE WORKUNIT=SYSALLDA
BMC50471I ENFORCE=CHECK PAUSEDISCARDRC=4 WRLOG=NO
BMC50471I ERRDDN=SYSERR PLAN=AMU1310I XBLKS=3
BMC50471I EXCLDUMP=(X37,X22,X06) PREFORMAT=NO XMLAVGSIZE=10240
BMC50471I FASTSWITCH=NO PRELOAD=LOAD ZEROROWRC=0
BMC50471I FILECHK=WARN RCVYDDN=(BMCRCY,BMCRCZ) ZIIP=ENABLED
BMC50471I FORCE_AT=(START,3) REDEFINE=YES
BMC50471I FORCE_RPT=NO RENMMAX=30
0
BMC50471I APCOLLECTION=
BMC50471I APOWNER=
0
BMC50470I DDTYPE = LOAD WORK SORTWORK
BMC50470I ACTIVE = 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 = NO NO NO
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 = NO NO NO
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.&UTILPFX.&DDNAME
BMC50483I WORK DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I SORTWORK DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I ERROR DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I DISCARD DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I SYSMAP DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50483I LOCPFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I LOCBFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMPFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMBFCPY DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50483I LOCPLCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I LOCBLCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMPLCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMBLCPY DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50483I LOCPXCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I LOCBXCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMPXCPY DSNPAT=&UID.&UTILPFX.&DDNAME
BMC50483I REMBXCPY DSNPAT=&UID.&UTILPFX.&DDNAME
0
BMC50471I DB2 DSNHDECP MODULE SETTINGS:
BMC50471I VERSION = 1310
BMC50471I SUBSYSTEM DEFAULT = DEMO
BMC50471I CHARACTER SET = ALPHANUM
BMC50471I DATE FORMAT = USA
BMC50471I TIME FORMAT = USA
BMC50471I LOCAL DATE LENGTH = 0
BMC50471I LOCAL TIME LENGTH = 0
BMC50471I DECIMAL POINT = PERIOD
BMC50471I DECIMAL ARITHMETIC = 15
BMC50471I DELIMITER = DEFAULT
BMC50471I SQL DELIMITER = DEFAULT
BMC50471I ENCODING SCHEME = EBCDIC
BMC50471I APPL. ENCODING SCHEME = EBCDIC
BMC50471I MIXED = NO
BMC50471I EBCDIC CCSID = (37,65534,65534)
BMC50471I ASCII CCSID = (819,65534,65534)
BMC50471I UNICODE CCSID = (367,1208,1200)
BMC50471I IMPLICIT TIME ZONE = CURRENT (-05:00)
BMC50658I DB2 CURRENT FUNCTION LEVEL IS V13R1M501
BMC50659I DB2 CATALOG LEVEL IS V13R1M501
BMC50660I DB2 HIGHEST ACTIVATED FUNCTION LEVEL IS V13R1M501
BMC50661I DB2 CODE LEVEL IS V13R1M501
BMC50471I BMC_BMCUTIL ='BMCUTIL.CMN_BMCUTIL'
BMC50471I BMC_BMCSYNC ='BMCUTIL.CMN_BMCSYNC'
BMC50471I BMC_BMCHIST ='BMCUTIL.CMN_BMCHIST'
BMC50471I BMC_BMCDICT ='BMCUTIL.CMN_BMCDICT'
BMC50471I BMC_BMCSMARTSWITCH='BMCUTIL.CMN_BMCSWITCH'
BMC50471I BMC_BMCSSTRACKING ='BMCUTIL.CMN_BMCSSTRACK'
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
BMC54000I SMARTSWITCH NOT SUPPORTED - NO BMC AMI UTILITIES VERSION FOUND
BMC54003I SMARTSWITCH RULE: FORCE_NO_SWITCH COMMENT: SMARTSWITCH IS ACTIVATED, BUT NO RULE APPLIES. PLUS UTILITY WILL BE USED
BMC50004I NGTUTIL PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50199I LOAD PLUS PROCESSING CONTINUES
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
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 = BMCJXS
BMC50425I &RESUME = Y &REPLACE = N &DATE = 090222 &TIME = 070340 &SSID = DEMO
BMC50425I &UTIL = AMUEX12 &UTILPFX = AMUEX12 &UTILSFX = &DATE8 = 09022022 &GRPNM = DEMO
BMC50425I &VCAT = DEMOCAT &TIME4 = 0703 &DATEJ = 2022245 &JDATE = 22245
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 BMCJXS.RESUMEY.SORTWK01 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK02 BMCJXS.RESUMEY.SORTWK02 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK03 BMCJXS.RESUMEY.SORTWK03 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK04 BMCJXS.RESUMEY.SORTWK04 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK05 BMCJXS.RESUMEY.SORTWK05 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK06 BMCJXS.RESUMEY.SORTWK06 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK07 BMCJXS.RESUMEY.SORTWK07 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK08 BMCJXS.RESUMEY.SORTWK08 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK09 BMCJXS.RESUMEY.SORTWK09 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK10 BMCJXS.RESUMEY.SORTWK10 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK11 BMCJXS.RESUMEY.SORTWK11 SYSALLDA 725 73 14 2 TRK
BMC50448I SORTWK12 BMCJXS.RESUMEY.SORTWK12 SYSALLDA 725 73 14 2 TRK
BMC50448I SYSDISC BMCJXS.RESUMEY.SYSDISC SYSALLDA 10218 1277 197 25 TRK
BMC50448I SYSERR BMCJXS.RESUMEY.SYSERR SYSALLDA 5160 2064 100 40 TRK
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8448K, ABOVE 16M = 1024884K, CPUS = 5
BMC50479I TOTAL PAGES: 11059589, ALLOWED: 3317877; AVAILABLE PAGES: 1317953, 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 3: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 4: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50486I 6: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51576I 07:03:43 000 APT0000I High-speed Apply Engine V13.01.00
BMC51576I Copyright (c) 1999-2022 BMC Software, Inc. as an unpublished licensed work. All rights reserved.
BMC51576I 07:03:43 000 APT0001I Date: Fri Sep 2, 2022
BMC51576I 07:03:43 000 APT0215I MAINT: High-speed Apply Engine V13.01.00 SPE2210
BMC51576I 07:03:43 000 APT0215I MAINT: BQU4146
BMC51576I 07:03:43 000 APT0215I MAINT: SOLUTION COMMON CODE V13.01.00 BASE
BMC51576I 07:03:43 000 APT0215I MAINT: BPJ2315
BMC51576I 07:03:43 000 APT0215I MAINT: BMCSORT ENGINE V02.04.01
BMC50486I 2: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51576I 07:03:43 000 APT0215I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922 BPJ0996 BPJ1164 BPJ1309
BMC51576I 07:03:43 000 APT0215I MAINT: BPJ1386 BPJ1497 BPJ1594 BPJ1724 BPJ1809 BPJ1833 BPJ1891
BMC51576I 07:03:43 000 APT0215I MAINT: BPJ1905 BPJ2109 BPJ2232 BPJ2297
BMC51576I 07:03:43 000 APT0272I Main thread started - TCB: 008A7B88
BMC50486I 5: BMCSORT STARTED, 384K BELOW 16M, 1408K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51576I 07:03:43 000 APT0085I /STARTUP/
BMC51576I SSID=DEMO
BMC51576I INPUTTYPE={3895D640-0BF1-11D4-8027-00104B39B10F}
BMC51576I PLANNAME=APTBBLD
BMC51576I BINDQUALIFIER=APTTEST
BMC51576I DBMSTYPE=DB2
BMC51576I DISTRIBUTIONTYPE=OBJECT
BMC51576I LARGESTATEMENTSUPPORT=NO
BMC51576I 07:03:43 000 APT0085I /CONFIGURATION/
BMC51576I FILENAME=NONE
BMC51576I 07:03:43 000 APT0085I /SQL/
BMC51576I FORMAT=PACKED72
BMC51576I 07:03:43 000 APT0085I /COMMITTRIGGERS/
BMC51576I STATEMENTCOUNT=2500
BMC51576I COMMITONDEMAND=NO
BMC51576I 07:03:43 000 APT0085I /OBJECTMAP/
BMC51576I SOURCETABLE=0X0599.0X0003
BMC51576I TARGETTABLE="EXAMPLEC"."TBL1"
BMC51576I 07:03:43 000 APT0085I /AGENT/
BMC51576I MAXAGENTS=10
BMC51576I INITIALAGENTS=5
BMC51576I MAXPREPARES=50
BMC51576I 07:03:43 000 APT0085I /TEMPORARYFILES/
BMC51576I UNIT=SYSALLDA
BMC51576I 07:03:43 000 APT0085I /DIAGNOSTICOUTPUT/
BMC51576I FILENAME=APTDIAG
BMC51576I 07:03:43 000 APT0085I /RESTART/
BMC51576I RESTARTID=AMUEX12
BMC51576I RESTARTTYPE=NEW
BMC51576I CHECKPOINTFREQUENCY=0
BMC51576I TABLENAME=BMCAPT_APTRSCL
BMC51576I RETAINTIME=7
BMC51576I RETRY=3
BMC51576I 07:03:43 000 APT0085I /DISTRIBUTIONTUNING/
BMC51576I SIMPLETSCLUSTERING=NO
BMC51576I RICLUSTERING=NO
BMC51576I PARTITIONCLUSTERING=NO
BMC51576I URCHECKRI=YES
BMC51576I 07:03:43 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 07:03:43 000 APT0085I /INSERTCONFLICT/
BMC51576I CODE=MULTIROWCONFLICT
BMC51576I ACTION=RETRY
BMC51576I 07:03:43 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 07:03:43 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 07:03:43 000 APT0085I /BIND/
BMC51576I FREEOPTION=ALL
BMC51576I PLANPREFIX=APT
BMC51576I 07:03:43 000 APT0085I /BINDTUNING/
BMC51576I STATEMENTCOUNT=1
BMC51576I MAXPACKAGES=25
BMC51576I MAXFAILEDBINDS=5
BMC51576I MAXRETRIES=5
BMC51576I PACKAGEUSAGE=500
BMC51576I STATEMENTUSAGE=200
BMC51576I 07:03:43 000 APT0085I /MULTIROWINSERT/
BMC51576I MULTIROWINSERT=YES
BMC51576I MAXROWS=100
BMC51576I 07:03:43 000 APT0085I /LOGICALLOG/
BMC51576I 07:03:43 001 APT0262I OS Release = SP7.2.4 , OS PID = HBB77C0 , DF/SMS Release = DFP 2.4.0
BMC51576I 07:03:43 001 APT0263I Available region below 16M = 8096K, Available region above 16M = 1024012K, MEMLIMIT = NOLIMIT
(74560M)
BMC51576I 07:03:43 001 APT0270I CPU = 001CA498-3931(z16), Number of CPUs = 9 (GPs = 5, zIIPs = 4)
BMC51576I 07:03:43 001 APT0252I zIIP processing enabled using XBM SSID XBMB (v6.2.01)
BMC51576I 07:03:43 002 APT0272I Monitor thread started - TCB: 0088A6D8
BMC51576I 07:03:43 003 APT0272I Message thread started - TCB: 0088A448
BMC51576I 07:03:43 001 APT0238I Successful connect to DEMO (Release 131501 of DB2)
BMC51576I 07:03:43 001 APT0269I DB2 CURRENT FUNCTION LEVEL IS V13R1M501
BMC51576I 07:03:43 001 APT0269I DB2 HIGHEST ACTIVATED FUNCTION LEVEL IS V13R1M501
BMC51576I 07:03:43 001 APT0269I DB2 CATALOG LEVEL IS V13R1M501
BMC51576I 07:03:43 001 APT0269I DB2 CODE LEVEL IS V13R1M501
BMC51576I 07:03:43 001 APT0236I High-speed Apply starting with Multi-Row Inserts
BMC51576I 07:03:43 001 APT0097I Request ID: BERJ Restart ID: AMUEX12
BMC51576I 07:03:43 004 APT0272I Distribution(Object) thread started - TCB: 0088A008
BMC51576I 07:03:44 000 APT0019I File DBRMLIB :SYS22245.T070344.RA000.AMUEX12.R0861647 allocated - elapsed time: 00:00:00
BMC51576I 07:03:44 005 APT0272I Bind thread started - TCB: 00885C18
BMC51576I 07:03:44 001 APT0032I DSN output follows:
BMC51576I DSNT252I *DEMO DSNTBCM1 BIND OPTIONS FOR PLAN APTBERJ
BMC51576I ACTION ADD
BMC51576I OWNER BMCJXS
BMC51576I OWNERTYPE USER
BMC51576I VALIDATE RUN
BMC51576I ISOLATION CS
BMC51576I ACQUIRE USE
BMC51576I RELEASE COMMIT
BMC51576I EXPLAIN NO
BMC51576I DYNAMICRULES RUN
BMC51576I PROGAUTH DISABLE
BMC51576I DSNT253I *DEMO DSNTBCM1 BIND OPTIONS FOR PLAN APTBERJ
BMC51576I NODEFER PREPARE
BMC51576I CACHESIZE 4096
BMC51576I QUALIFIER BMCJXS
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 *DEMO BIND FOR PLAN APTBERJ SUCCESSFUL
BMC51576I 07:03:44 001 APT0032I DSN output follows:
BMC51576I DSNT254I *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
BMC51576I ACTION ADD
BMC51576I OWNER BMCJXS
BMC51576I QUALIFIER BMCJXS
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 V13R1M501
BMC51576I DESCSTAT YES
BMC51576I APREUSESOURCE
BMC51576I DSNT255I *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
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 *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
BMC51576I QUERYACCELERATION
BMC51576I GETACCELARCHIVE
BMC51576I ACCELERATOR
BMC51576I CONCENTRATESTMT
BMC51576I ACCELERATIONWAITFORDATA
BMC51576I RESTSERVICEDEFAULT
BMC51576I OWNERTYPE USER
BMC51576I DEPLEVEL
BMC51576I
BMC51576I DSNT232I *DEMO SUCCESSFUL BIND FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
BMC51576I 07:03:44 006 APT0272I Apply Engine thread started - TCB: 008858D0
BMC51576I 07:03:44 007 APT0272I Apply Engine thread started - TCB: 00885508
BMC51576I 07:03:44 008 APT0272I Apply Engine thread started - TCB: 008851E0
BMC51576I 07:03:44 009 APT0272I Apply Engine thread started - TCB: 00888E68
BMC51576I 07:03:44 010 APT0272I Apply Engine thread started - TCB: 008885C8
BMC51576I 07:03:44 001 APT0272I Request thread started - TCB: 0088AE68
BMC51576I 07:03:44 006 APT0079I High-speed Apply processing started - Agent: 1
BMC51576I 07:03:44 007 APT0079I High-speed Apply processing started - Agent: 2
BMC51576I 07:03:44 008 APT0079I High-speed Apply processing started - Agent: 3
BMC51576I 07:03:44 009 APT0079I High-speed Apply processing started - Agent: 4
BMC51576I 07:03:44 010 APT0079I High-speed Apply processing started - Agent: 5
BMC50481I 1: READ TASK COMPLETE. ELAPSED TIME = 00:00:02
BMC51510I 1: READ TASK, XBLK XFERS = 140, EMPTY WAITS = 33, FULL WAITS = 0
BMC51478I PRELOAD STATISTICS: 100000 PHYSICAL (100000 LOGICAL) RECORDS READ FROM SYSREC
BMC51576I 07:03:45 001 APT0148I Bind started for package BERJ0001 - Trigger statistics:
BMC51576I STATEMENTCOUNT...........................1
BMC51576I PACKAGEUSAGE.............................1
BMC51576I STATEMENTUSAGE...........................1
BMC51576I 07:03:45 001 APT0032I DSN output follows:
BMC51576I DSNT254I *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
BMC51576I ACTION ADD
BMC51576I OWNER BMCJXS
BMC51576I QUALIFIER BMCJXS
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 V13R1M501
BMC51576I DESCSTAT YES
BMC51576I APREUSESOURCE
BMC51576I DSNT255I *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
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 *DEMO DSNTBCM2 BIND OPTIONS FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
BMC51576I QUERYACCELERATION
BMC51576I GETACCELARCHIVE
BMC51576I ACCELERATOR
BMC51576I CONCENTRATESTMT
BMC51576I ACCELERATIONWAITFORDATA
BMC51576I RESTSERVICEDEFAULT
BMC51576I OWNERTYPE USER
BMC51576I DEPLEVEL
BMC51576I
BMC51576I DSNT232I *DEMO SUCCESSFUL BIND FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
BMC51480I 2: DATA TASK COMPLETE. ELAPSED TIME = 00:00:03. 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 = 33, FULL WAITS = 0
BMC51480I 6: DATA TASK COMPLETE. ELAPSED TIME = 00:00:03. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51510I 6: SORT TASK, XBLK XFERS = 28, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 6: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 38, FULL WAITS = 0
BMC51576I 07:03:46 001 APT0118I Input statements processed: 100000 Statement ID: 000186A000004E200003000501000186A0
BMC51576I 07:03:46 001 APT0066I Input processing complete
BMC51576I 07:03:46 009 APT0080I High-speed Apply processing ended - Agent: 4
BMC51576I 07:03:46 006 APT0080I High-speed Apply processing ended - Agent: 1
BMC51576I 07:03:46 010 APT0080I High-speed Apply processing ended - Agent: 5
BMC51576I 07:03:46 007 APT0080I High-speed Apply processing ended - Agent: 2
BMC51576I 07:03:46 008 APT0080I High-speed Apply processing ended - Agent: 3
BMC51576I 07:03:46 001 APT0185I Statements committed: 100000
BMC51576I 07:03:47 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:01.243366
BMC51576I 07:03:47 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:00.
238582
BMC51576I 4 PARTITION 2 20000 0 0 0 0 20000 00:00:00.
242394
BMC51576I 5 PARTITION 3 20000 0 0 0 0 20000 00:00:00.
247112
BMC51576I 1 PARTITION 4 20000 0 0 0 0 20000 00:00:00.
249301
BMC51576I 3 PARTITION 5 20000 0 0 0 0 20000 00:00:00.
265973
BMC51576I 07:03:47 010 APT0273I Apply Engine thread ended - TCB: 008885C8 CPU Time: 00:00:00.151837
BMC51576I 07:03:47 009 APT0273I Apply Engine thread ended - TCB: 00888E68 CPU Time: 00:00:00.150998
BMC51480I 5: DATA TASK COMPLETE. ELAPSED TIME = 00:00:04. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51480I 4: DATA TASK COMPLETE. ELAPSED TIME = 00:00:04. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51480I 3: DATA TASK COMPLETE. ELAPSED TIME = 00:00:04. 20000 ROWS PASSED TO THE HIGH-SPEED APPLY ENGINE
BMC51576I 07:03:47 008 APT0273I Apply Engine thread ended - TCB: 008851E0 CPU Time: 00:00:00.151225
BMC51510I 5: SORT TASK, XBLK XFERS = 28, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 5: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 43, FULL WAITS = 0
BMC51510I 3: SORT TASK, XBLK XFERS = 28, EMPTY WAITS = 0, FULL WAITS = 0
BMC51510I 3: SORT TASK, APBUF XFERS = 43, EMPTY WAITS = 43, 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 = 43, FULL WAITS = 0
BMC51576I 07:03:47 007 APT0273I Apply Engine thread ended - TCB: 00885508 CPU Time: 00:00:00.153377
BMC51576I 07:03:47 006 APT0273I Apply Engine thread ended - TCB: 008858D0 CPU Time: 00:00:00.162316
BMC51576I 07:03:47 004 APT0273I Distribution(Object) thread ended - TCB: 0088A008 CPU Time: 00:00:00.029941
BMC51576I 07:03:47 001 APT0032I DSN output follows:
BMC51576I DSNT200I *DEMO FREE FOR PLAN APTBERJ SUCCESSFUL
BMC51576I 07:03:47 001 APT0032I DSN output follows:
BMC51576I DSNT232I *DEMO SUCCESSFUL FREE FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0000.()
BMC51576I DSNT232I *DEMO SUCCESSFUL FREE FOR
BMC51576I PACKAGE = DEMO.APTBERJ.BERJ0001.()
BMC51576I 07:03:47 005 APT0273I Bind thread ended - TCB: 00885C18 CPU Time: 00:00:00.035619
BMC51576I 07:03:47 000 APT0020I File DBRMLIB :SYS22245.T070344.RA000.AMUEX12.R0861647 deallocated
BMC51576I 07:03:47 003 APT0273I Message thread ended - TCB: 0088A448 CPU Time: 00:00:00.005671
BMC51576I 07:03:47 001 APT0111I INPUT PROCESSING STATISTICS
BMC51576I INSERT UPDATE DELETE TRUNCATE DDL TOTAL
BMC51576I 100000 0 0 0 0 100000
BMC51576I 07:03:47 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 07:03:47 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 07:03:47 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 07:03:47 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 07:03:47 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 07:03:47 001 APT0206I PACKAGE STATISTICS
BMC51576I NAME STMTCNT USAGECNT RETRIES BIND ELAPSED TIME
BMC51576I BERJ0000 101 0 0 00:00:00.048277
BMC51576I BERJ0001 1 100000 0 00:00:00.028220
BMC51576I --------- --------- --------- --------- -----------------
BMC51576I TOTAL 102 100000 0 00:00:00.076498
BMC51576I 07:03:47 001 APT0182I OTHER STATISTICS
BMC51576I AGENT FAILPREPS RETRIES DBMS ELAPSED TIME
BMC51576I 1 0 0 00:00:00.281374
BMC51576I 2 0 0 00:00:00.279827
BMC51576I 3 0 0 00:00:00.306629
BMC51576I 4 0 0 00:00:00.280025
BMC51576I 5 0 0 00:00:00.286727
BMC51576I ----- --------- --------- -----------------
BMC51576I TOTAL 0 0 00:00:01.434586
BMC51576I 07:03:47 001 APT0183I Request elapsed time: 00:00:04.216319
BMC51576I 07:03:47 002 APT0273I Monitor thread ended - TCB: 0088A6D8 CPU Time: 00:00:00.005908
BMC51576I 07:03:47 001 APT0273I Request thread ended - TCB: 0088AE68 CPU Time: 00:00:00.338378
BMC51576I 07:03:47 000 APT0273I Main thread ended - TCB: 008A7B88 CPU Time: 00:00:00.079005
BMC51576I 07:03:47 000 APT0067I Request completed Return code: 0
BMC50481I 10: SQLAPPLY TASK COMPLETE. ELAPSED TIME = 00:00:04
BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC, I/OS = 20, I/O WAITS = 19, RDB LOCK WAITS = 0
BMC51507I XBLKS = 20, XFERS = 140, EMPTY WAITS = 33, 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 = 'SORTWK01', DSNAME = 'BMCJXS.RESUMEY.SORTWK01'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR ', DSNAME = 'BMCJXS.RESUMEY.SYSERR'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK02', DSNAME = 'BMCJXS.RESUMEY.SORTWK02'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK03', DSNAME = 'BMCJXS.RESUMEY.SORTWK03'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK04', DSNAME = 'BMCJXS.RESUMEY.SORTWK04'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK05', DSNAME = 'BMCJXS.RESUMEY.SORTWK05'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK06', DSNAME = 'BMCJXS.RESUMEY.SORTWK06'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK07', DSNAME = 'BMCJXS.RESUMEY.SORTWK07'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK08', DSNAME = 'BMCJXS.RESUMEY.SORTWK08'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK09', DSNAME = 'BMCJXS.RESUMEY.SORTWK09'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK10', DSNAME = 'BMCJXS.RESUMEY.SORTWK10'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK11', DSNAME = 'BMCJXS.RESUMEY.SORTWK11'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK12', DSNAME = 'BMCJXS.RESUMEY.SORTWK12'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSDISC ', DSNAME = 'BMCJXS.RESUMEY.SYSDISC'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I COMBINED PHASE COMPLETE. ELAPSED TIME = 00:00:05
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
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*