Example 22 — Running a DSNUTILB load
The LOAD command includes DDTYPE statements with ACTIVE YES for all work files and for the copy data sets needed for this job. ACTIVE YES enables dynamic allocation for these data sets as required for a DSNUTILB load.
The return code 4 from DSNUTILB is passed on to LOADPLUS as the complete code for the load job.
The following figure shows the JCL for example 22:
// JOBCARD
//*
//********************** AMUEX22 ***********************************
//*=================================================================
//* Running a DSNUTILB load
//*=================================================================
//* Replace "DB2SYS" by your DB2 subsystem name. *
//* Use your DB2 product install libraries for STEPLIBS : *
//* PRODUCT.LIBRARIES *
//* DB2.DSNEXIT *
//* DB2.DSNLOAD *
//*******************************************************************
//RESUME EXEC PGM=AMUUMAIN,
// PARM='DB2SYS,AMUEX22,NEW,,MSGLEVEL(1),AMU$OPTI'
//STEPLIB DD DISP=SHR,DSN=PRODUCT.LIBRARIES
// DD DSN=DB2.DSNEXIT,DISP=SHR
// DD DSN=DB2.DSNLOAD,DISP=SHR
//*
//SYSPRINT DD DSN=AMU.EXAMPL22.SYSPRINT,
// UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG)
//SYSOUT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//X37IGN DD DUMMY
//SYSREC DD DISP=SHR,DSN=AMU.INPUT.EXAMPL22.SYSREC
//SYSIN DD *
LOAD DATA INDDN SYSREC RESUME YES
COPY NO COPYPEND NO
INTO TABLE AMU.TBIXE102
( DSN_NULL_IND_00001 POSITION( 00001) CHAR(1)
, COL_SMALL
POSITION( 00002:00003) SMALLINT
NULLIF DSN_NULL_IND_00001 =X'FF'
, DSN_NULL_IND_00002 POSITION( 00004) CHAR(1)
, COL_INTEGER
POSITION( 00005:00008) INTEGER
NULLIF DSN_NULL_IND_00002 =X'FF'
, DSN_NULL_IND_00003 POSITION( 00009) CHAR(1)
, COL_FLOAT
POSITION( 00010:00017) FLOAT(53)
NULLIF DSN_NULL_IND_00003 =X'FF'
, DSN_NULL_IND_00004 POSITION( 00018) CHAR(1)
, COL_CHAR
POSITION( 00019:00028) CHAR(00010)
NULLIF DSN_NULL_IND_00004 =X'FF'
, DSN_NULL_IND_00005 POSITION( 00029) CHAR(1)
, COL_VCHAR
POSITION( 00030) VARCHAR
NULLIF DSN_NULL_IND_00005 =X'FF'
, DSN_NULL_IND_00006 POSITION( *) CHAR(1)
, COL_DATE
POSITION( *) DATE EXTERNAL
NULLIF DSN_NULL_IND_00006 =X'FF'
, DSN_NULL_IND_00007 POSITION( *) CHAR(1)
, COL_TIME
POSITION( *) TIME EXTERNAL
NULLIF DSN_NULL_IND_00007 =X'FF'
, DSN_NULL_IND_00008 POSITION( *) CHAR(1)
, COL_TIMESTAMP
POSITION( *) TIMESTAMP EXTERNAL
NULLIF DSN_NULL_IND_00008 =X'FF'
, DSN_NULL_IND_00009 POSITION( *) CHAR(1)
, COL_CHAR2
POSITION( *) CHAR(14)
)
DDTYPE LOAD ACTIVE YES DSNPAT 'AMU.AMURI102.XLOAD.SORTOUT'
UNIT SYSDA
DDTYPE WORK ACTIVE YES DSNPAT 'AMU.AMURI102.XWORK.SYSUT1'
UNIT SYSDA
DDTYPE SORTWORK ACTIVE YES
DSNPAT 'AMU.AMURI102.SORT.&DDNAME'
SPACE (20,20) CYL
UNIT SYSDA
DDTYPE DISCARD ACTIVE YES DSNPAT 'AMU.AMURI102.DISCS'
UNIT SYSDA
DDTYPE ERROR ACTIVE YES DSNPAT 'AMU.AMURI102.XERR'
UNIT SYSDA
DDTYPE LOCPFCPY ACTIVE YES DSNPAT 'AMU.AMURI102.BMCCPY'
UNIT SYSDA
DDTYPE LOCBFCPY ACTIVE YES DSNPAT 'AMU.AMURI102.BMCCPZ'
UNIT SYSDA
DDTYPE REMPFCPY ACTIVE YES DSNPAT 'AMU.AMURI102.RCYCPY'
UNIT SYSDA
DDTYPE REMBFCPY ACTIVE YES DSNPAT 'AMU.AMURI102.RCYCPZ'
UNIT SYSDA
DDTYPE SYSMAP ACTIVE YES
DSNPAT 'AMU.AMURI102.SYSMAP'
SPACE (90,30) TRK
UNIT SYSDA
/*
//*
//********************** AMUEX22 ***********************************
//*=================================================================
//* Running a DSNUTILB load
//*=================================================================
//* Replace "DB2SYS" by your DB2 subsystem name. *
//* Use your DB2 product install libraries for STEPLIBS : *
//* PRODUCT.LIBRARIES *
//* DB2.DSNEXIT *
//* DB2.DSNLOAD *
//*******************************************************************
//RESUME EXEC PGM=AMUUMAIN,
// PARM='DB2SYS,AMUEX22,NEW,,MSGLEVEL(1),AMU$OPTI'
//STEPLIB DD DISP=SHR,DSN=PRODUCT.LIBRARIES
// DD DSN=DB2.DSNEXIT,DISP=SHR
// DD DSN=DB2.DSNLOAD,DISP=SHR
//*
//SYSPRINT DD DSN=AMU.EXAMPL22.SYSPRINT,
// UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG)
//SYSOUT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//X37IGN DD DUMMY
//SYSREC DD DISP=SHR,DSN=AMU.INPUT.EXAMPL22.SYSREC
//SYSIN DD *
LOAD DATA INDDN SYSREC RESUME YES
COPY NO COPYPEND NO
INTO TABLE AMU.TBIXE102
( DSN_NULL_IND_00001 POSITION( 00001) CHAR(1)
, COL_SMALL
POSITION( 00002:00003) SMALLINT
NULLIF DSN_NULL_IND_00001 =X'FF'
, DSN_NULL_IND_00002 POSITION( 00004) CHAR(1)
, COL_INTEGER
POSITION( 00005:00008) INTEGER
NULLIF DSN_NULL_IND_00002 =X'FF'
, DSN_NULL_IND_00003 POSITION( 00009) CHAR(1)
, COL_FLOAT
POSITION( 00010:00017) FLOAT(53)
NULLIF DSN_NULL_IND_00003 =X'FF'
, DSN_NULL_IND_00004 POSITION( 00018) CHAR(1)
, COL_CHAR
POSITION( 00019:00028) CHAR(00010)
NULLIF DSN_NULL_IND_00004 =X'FF'
, DSN_NULL_IND_00005 POSITION( 00029) CHAR(1)
, COL_VCHAR
POSITION( 00030) VARCHAR
NULLIF DSN_NULL_IND_00005 =X'FF'
, DSN_NULL_IND_00006 POSITION( *) CHAR(1)
, COL_DATE
POSITION( *) DATE EXTERNAL
NULLIF DSN_NULL_IND_00006 =X'FF'
, DSN_NULL_IND_00007 POSITION( *) CHAR(1)
, COL_TIME
POSITION( *) TIME EXTERNAL
NULLIF DSN_NULL_IND_00007 =X'FF'
, DSN_NULL_IND_00008 POSITION( *) CHAR(1)
, COL_TIMESTAMP
POSITION( *) TIMESTAMP EXTERNAL
NULLIF DSN_NULL_IND_00008 =X'FF'
, DSN_NULL_IND_00009 POSITION( *) CHAR(1)
, COL_CHAR2
POSITION( *) CHAR(14)
)
DDTYPE LOAD ACTIVE YES DSNPAT 'AMU.AMURI102.XLOAD.SORTOUT'
UNIT SYSDA
DDTYPE WORK ACTIVE YES DSNPAT 'AMU.AMURI102.XWORK.SYSUT1'
UNIT SYSDA
DDTYPE SORTWORK ACTIVE YES
DSNPAT 'AMU.AMURI102.SORT.&DDNAME'
SPACE (20,20) CYL
UNIT SYSDA
DDTYPE DISCARD ACTIVE YES DSNPAT 'AMU.AMURI102.DISCS'
UNIT SYSDA
DDTYPE ERROR ACTIVE YES DSNPAT 'AMU.AMURI102.XERR'
UNIT SYSDA
DDTYPE LOCPFCPY ACTIVE YES DSNPAT 'AMU.AMURI102.BMCCPY'
UNIT SYSDA
DDTYPE LOCBFCPY ACTIVE YES DSNPAT 'AMU.AMURI102.BMCCPZ'
UNIT SYSDA
DDTYPE REMPFCPY ACTIVE YES DSNPAT 'AMU.AMURI102.RCYCPY'
UNIT SYSDA
DDTYPE REMBFCPY ACTIVE YES DSNPAT 'AMU.AMURI102.RCYCPZ'
UNIT SYSDA
DDTYPE SYSMAP ACTIVE YES
DSNPAT 'AMU.AMURI102.SYSMAP'
SPACE (90,30) TRK
UNIT SYSDA
/*
SYSPRINT for example 22
The following figure shows the SYSPRINT output for example 22:
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 3/16/2022 0:26:13 ...
BMC50002I UTILITY ID = 'AMUEX22'. DB2 SUBSYSTEM ID = 'DEND'. OPTION MODULE = 'AMU$OPTI'.
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=997.4M,IEFUSI=NO,CPUs=7,GPs=5,zIIPs=2
BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
BMC50471I SMFID=DB2B,JOBID=J0193647,JOB=AMUEX22,STEP=RESUME,CPU=8561-615 (z15)/1.71,76.0G
0
BMC50471I LOADPLUS FOR DB2--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I SOLUTION COMMON CODE--V13.01.00 BASE
BMC50471I MAINT: BPJ1541 BPJ1713 BPJ2211
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922 BPJ0996 BPJ1164 BPJ1309 BPJ1386 BPJ1497 BPJ1594 BPJ1724 BPJ1809
BMC50471I BPJ1833 BPJ1891 BPJ1905 BPJ2109 BPJ2232 BPJ2297
BMC50471I BMC STATS API--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.02.01
BMC50471I MAINT: BPE0443 BPE0445 BPE0447 BPE0449 BPE0450 BPE0451 BPE0452 BPE0455 BPE0456 BPE0457 BPE0460 BPE0463
BMC50471I BPE0467 BPE0468 BPE0469 BPE0473 BPE0474 BPE0475 BPE0479 BPE0480 BPE0482 BPE0487 BPE0488 BPE0489
BMC50471I BPE0493 BPE0497 BPE0498 BPE0501 BPE0503 BPE0507 BPE0512 BPE0513 BPE0517 BPE0518 BPE0519 BPE0523
BMC50471I BPE0524 BPE0527 BPE0528 BPE0530 BPE0531 BPE0534 BPE0535 BPE0540 BPE0541 BPE0542 BPE0545 BPE0549
BMC50471I BPE0551 BPE0552 BPE0555 BPE0556 BPE0557 BPE0560
BMC50471I High-speed Apply Engine--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
0
BMC50471I APCOMMIT=2500 FORCE=NONE RULES=BMC
BMC50471I APDOPTS= IBUFFS=20 SDUMP=YES
BMC50471I APMULTIROW=100 IDCACHE=1000 SHORTMEMORY=CONTINUE
BMC50471I APMXAGNT=10 IDCDDN=SYSIDCIN SHRLEVEL=(NONE,NONE)
BMC50471I APRETLIM=COUNT IDERROR=DISCARD SMAX=16
BMC50471I APRETVAL=5 INDDN=SYSREC SMCORE=(0K,0K)
BMC50471I AUTOENUMROWS=YES INFORI=NO SORTDEVT=(,SYSALLDA)
BMC50471I AVAILPAGEPCT=0 INLINECP=NO SORTNUM=32
BMC50471I CBUFFS=30 INVALIDATECACHE=YES SQLDELAY=3
BMC50471I CENTURY=(1950,2049) KEEPDICTIONARY=NO SQLRETRY=100
BMC50471I CHEKPEND=YES LBUFFS=20 SSIGNRPAUSE=NO
BMC50471I COPYDDN=(BMCCPY,BMCCPZ) LOADDN=SORTOUT SSREPORT=REPORT_SWITCH
BMC50471I COPYLVL=FULL LOBAVGPCT=50 STOP@CMT=YES
BMC50471I COPYPEND=YES LOCKROW=YES STOPDELAY=1
BMC50471I COPYSUBSET=NO LONGNAMETRUNC=MIDDLE STOPRETRY=300
BMC50471I DELFILES=(YES,NO) MAPDDN=SYSMAP TAPEDISP=DELETE
BMC50471I DISCARDLIMRC=8 MAXP=5 TOTALPAGEPCT=30
BMC50471I DISCARDRC=0 MAXSORTMEMORY=0 TSSAMPLEPCT=100
BMC50471I DISCDDN=SYSDISC MAXTAPE=3 UPDMAXA_AUTHID=USER
BMC50471I DRNDELAY=1 MGEXTENT=CONTINUE UPDMAXA=NO
BMC50471I DRNRETRY=255 MINSORTMEMORY=0 UXSTATE=SUP
BMC50471I DRNWAIT=NONE MSGLEVEL=1 WBUFFS=(20,10)
BMC50471I DSNUEXIT=(NONE,ASM) OPNDB2ID=NO WORKDDN=SYSUT1
BMC50471I DSNUTILB=YES ORIGDISP=DELETE WORKUNIT=SYSALLDA
BMC50471I ENFORCE=CHECK PAUSEDISCARDRC=4 WRLOG=NO
BMC50471I ERRDDN=SYSERR PLAN=AMUQA XBLKS=3
BMC50471I EXCLDUMP=(X37,X22,X06) PREFORMAT=NO XMLAVGSIZE=10240
BMC50471I FASTSWITCH=NO PRELOAD=CONTINUE ZEROROWRC=0
BMC50471I FILECHK=WARN RCVYDDN=(BMCRCY,BMCRCZ) ZIIP=ENABLED
BMC50471I FORCE_AT=(START,3) REDEFINE=YES
BMC50471I FORCE_RPT=NO RENMMAX=30
0
BMC50471I APCOLLECTION=
BMC50471I APOWNER=
0
BMC50470I DDTYPE = LOAD WORK SORTWORK
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) N/A
BMC50470I VOLCNT = (25,25) (25,25) N/A
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) N/A
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) N/A
BMC50470I EXPDT = N/A N/A N/A
BMC50470I RETPD = N/A N/A N/A
BMC50470I GDGLIMIT = N/A N/A N/A
BMC50470I GDGEMPTY = N/A N/A N/A
BMC50470I GDGSCRAT = N/A N/A N/A
0
BMC50470I DDTYPE = ERROR DISCARD LOCPFCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = N/A N/A 5
BMC50470I GDGEMPTY = N/A N/A NO
BMC50470I GDGSCRAT = N/A N/A NO
0
BMC50470I DDTYPE = LOCBFCPY REMPFCPY REMBFCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = SYSMAP LOCPLCPY LOCBLCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT = N/A
BMC50470I RETPD = N/A
BMC50470I GDGLIMIT = N/A 5 5
BMC50470I GDGEMPTY = N/A NO NO
BMC50470I GDGSCRAT = N/A NO NO
0
BMC50470I DDTYPE = REMPLCPY REMBLCPY LOCPXCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = LOCBXCPY REMPXCPY REMBXCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50483I LOAD DSNPAT=&UID.&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 = DEND
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 INDDN SYSREC RESUME YES
BMC50102I COPY NO COPYPEND NO
BMC50102I INTO TABLE AMU.TBIXE102
BMC50102I ( DSN_NULL_IND_00001 POSITION( 00001) CHAR(1)
BMC50102I , COL_SMALL
BMC50102I POSITION( 00002:00003) SMALLINT
BMC50102I NULLIF DSN_NULL_IND_00001 =X'FF'
BMC50102I , DSN_NULL_IND_00002 POSITION( 00004) CHAR(1)
BMC50102I , COL_INTEGER
BMC50102I POSITION( 00005:00008) INTEGER
BMC50102I NULLIF DSN_NULL_IND_00002 =X'FF'
BMC50102I , DSN_NULL_IND_00003 POSITION( 00009) CHAR(1)
BMC50102I , COL_FLOAT
BMC50102I POSITION( 00010:00017) FLOAT(53)
BMC50102I NULLIF DSN_NULL_IND_00003 =X'FF'
BMC50102I , DSN_NULL_IND_00004 POSITION( 00018) CHAR(1)
BMC50102I , COL_CHAR
BMC50102I POSITION( 00019:00028) CHAR(00010)
BMC50102I NULLIF DSN_NULL_IND_00004 =X'FF'
BMC50102I , DSN_NULL_IND_00005 POSITION( 00029) CHAR(1)
BMC50102I , COL_VCHAR
BMC50102I POSITION( 00030) VARCHAR
BMC50102I NULLIF DSN_NULL_IND_00005 =X'FF'
BMC50102I , DSN_NULL_IND_00006 POSITION( *) CHAR(1)
BMC50102I , COL_DATE
BMC50102I POSITION( *) DATE EXTERNAL
BMC50102I NULLIF DSN_NULL_IND_00006 =X'FF'
BMC50102I , DSN_NULL_IND_00007 POSITION( *) CHAR(1)
BMC50102I , COL_TIME
BMC50102I POSITION( *) TIME EXTERNAL
BMC50102I NULLIF DSN_NULL_IND_00007 =X'FF'
BMC50102I , DSN_NULL_IND_00008 POSITION( *) CHAR(1)
BMC50102I , COL_TIMESTAMP
BMC50102I POSITION( *) TIMESTAMP EXTERNAL
BMC50102I NULLIF DSN_NULL_IND_00008 =X'FF'
BMC50102I , DSN_NULL_IND_00009 POSITION( *) CHAR(1)
BMC50102I , COL_CHAR2
BMC50102I POSITION( *) CHAR(14)
BMC50102I )
BMC50102I DDTYPE LOAD ACTIVE YES DSNPAT 'IOA.AMURI102.XLOAD.SORTOUT'
BMC50102I UNIT SYSDA
BMC50102I DDTYPE WORK ACTIVE YES DSNPAT 'IOA.AMURI102.XWORK.SYSUT1'
BMC50102I UNIT SYSDA
BMC50102I DDTYPE SORTWORK ACTIVE YES
BMC50102I DSNPAT 'IOA.AMURI102.SORT.&DDNAME'
BMC50102I SPACE (20,20) CYL
BMC50102I UNIT SYSDA
BMC50102I DDTYPE DISCARD ACTIVE YES DSNPAT 'IOA.AMURI102.DISCS'
BMC50102I UNIT SYSDA
BMC50102I DDTYPE ERROR ACTIVE YES DSNPAT 'IOA.AMURI102.XERR'
BMC50102I UNIT SYSDA
BMC50102I DDTYPE LOCPFCPY ACTIVE YES DSNPAT 'IOA.AMURI102.BMCCPY'
BMC50102I UNIT SYSDA
BMC50102I DDTYPE LOCBFCPY ACTIVE YES DSNPAT 'IOA.AMURI102.BMCCPZ'
BMC50102I UNIT SYSDA
BMC50102I DDTYPE REMPFCPY ACTIVE YES DSNPAT 'IOA.AMURI102.RCYCPY'
BMC50102I UNIT SYSDA
BMC50102I DDTYPE REMBFCPY ACTIVE YES DSNPAT 'IOA.AMURI102.RCYCPZ'
BMC50102I UNIT SYSDA
BMC50102I DDTYPE SYSMAP ACTIVE YES
BMC50102I DSNPAT 'IOA.AMURI102.SYSMAP'
BMC50102I SPACE (90,30) TRK
BMC50102I UNIT SYSDA
BMC50654I BIND OF PACKAGE AMUQA .AMUESER COMPLETED SUCCESSFULLY
BMC50182I DSNUTILB REQUIRED: INDEX CONTAINS RANDOM KEYS INDEX 'AMU'.'I1IXE102'
BMC50004I UTILINIT PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC54003I SMARTSWITCH RULE: ALLOW_SWITCH COMMENT: GAM CHANGED AFTER ACCIDENTAL CHANGE BY CAT
BMC50183I SMARTSWITCH PRECLUDED FROM SWITCHING. REASON SYSPRINT IS NOT ALLOCATED TO A JES DATA SET
BMC50004I NGTUTIL PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50199I LOAD PLUS PROCESSING CONTINUES
1DSNU000I 075 00:21:41.42 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = AMUEX22
DSNU1044I 075 00:21:41.43 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 075 00:21:41.44 DSNUGUTC - TEMPLATE BMC00001 DSN 'IOA.AMURI102.SYSMAP' UNIT SYSDA VOLCNT 25 DISP(NEW,
DELETE, CATLG) SPACE(90, 30) TRK PCTPRIME 100
DSNU1035I 075 00:21:41.44 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 075 00:21:41.44 DSNUGUTC - TEMPLATE BMC00002 DSN 'IOA.AMURI102.XERR' UNIT SYSDA VOLCNT 25 PCTPRIME 100
DSNU1035I 075 00:21:41.44 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 075 00:21:41.44 DSNUGUTC - TEMPLATE BMC00003 DSN 'IOA.AMURI102.DISCS' UNIT SYSDA VOLCNT 25 PCTPRIME
100
DSNU1035I 075 00:21:41.45 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 075 00:21:41.45 DSNUGUTC - TEMPLATE BMC00004 DSN 'IOA.AMURI102.XWORK.SYSUT1' UNIT SYSDA VOLCNT 25
PCTPRIME 100
DSNU1035I 075 00:21:41.45 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 075 00:21:41.45 DSNUGUTC - TEMPLATE BMC00005 DSN 'IOA.AMURI102.XLOAD.SORTOUT' UNIT SYSDA VOLCNT 25
PCTPRIME 100
DSNU1035I 075 00:21:41.45 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 075 00:21:41.45 DSNUGUTC - LOAD DATA INDDN SYSREC RESUME YES SHRLEVEL NONE LOG NO NOCOPYPEND WORKDDN(
BMC00004, BMC00005) EBCDIC CCSID(37, 65534, 65534) ENFORCE NO ERRDDN BMC00002 MAPDDN BMC00001 DISCARDDN BMC00003
SORTDEVT SYSALLDA SORTNUM 32
DSNU650I *DEND 075 00:21:41.45 DSNURWI - INTO TABLE AMU.TBIXE102 IGNOREFIELDS YES
DSNU650I *DEND 075 00:21:41.45 DSNURWI - (DSN_NULL_IND_00001 POSITION(1) CHAR(1),
DSNU650I *DEND 075 00:21:41.45 DSNURWI - COL_SMALL POSITION(2:3) SMALLINT NULLIF DSN_NULL_IND_00001=X'FF',
DSNU650I *DEND 075 00:21:41.45 DSNURWI - DSN_NULL_IND_00002 POSITION(4) CHAR(1),
DSNU650I *DEND 075 00:21:41.45 DSNURWI - COL_INTEGER POSITION(5:8) INTEGER NULLIF DSN_NULL_IND_00002=X'FF',
DSNU650I *DEND 075 00:21:41.45 DSNURWI - DSN_NULL_IND_00003 POSITION(9) CHAR(1),
DSNU650I *DEND 075 00:21:41.45 DSNURWI - COL_FLOAT POSITION(10:17) FLOAT(53) NULLIF DSN_NULL_IND_00003=X'FF',
DSNU650I *DEND 075 00:21:41.45 DSNURWI - DSN_NULL_IND_00004 POSITION(18) CHAR(1),
DSNU650I *DEND 075 00:21:41.45 DSNURWI - COL_CHAR POSITION(19:28) CHAR(10) NULLIF DSN_NULL_IND_00004=X'FF',
DSNU650I *DEND 075 00:21:41.45 DSNURWI - DSN_NULL_IND_00005 POSITION(29) CHAR(1),
DSNU650I *DEND 075 00:21:41.45 DSNURWI - COL_VCHAR POSITION(30) VARCHAR NULLIF DSN_NULL_IND_00005=X'FF',
DSNU650I *DEND 075 00:21:41.45 DSNURWI - DSN_NULL_IND_00006 POSITION(*) CHAR(1),
DSNU650I *DEND 075 00:21:41.45 DSNURWI - COL_DATE POSITION(*) DATE EXTERNAL NULLIF DSN_NULL_IND_00006=X'FF',
DSNU650I *DEND 075 00:21:41.45 DSNURWI - DSN_NULL_IND_00007 POSITION(*) CHAR(1),
DSNU650I *DEND 075 00:21:41.45 DSNURWI - COL_TIME POSITION(*) TIME EXTERNAL NULLIF DSN_NULL_IND_00007=X'FF',
DSNU650I *DEND 075 00:21:41.45 DSNURWI - DSN_NULL_IND_00008 POSITION(*) CHAR(1),
DSNU650I *DEND 075 00:21:41.45 DSNURWI - COL_TIMESTAMP POSITION(*) TIMESTAMP EXTERNAL NULLIF
DSN_NULL_IND_00008=X'FF',
DSNU650I *DEND 075 00:21:41.46 DSNURWI - DSN_NULL_IND_00009 POSITION(*) CHAR(1),
DSNU650I *DEND 075 00:21:41.46 DSNURWI - COL_CHAR2 POSITION(*) CHAR(14))
DSNU320I *DEND 075 00:21:41.85 DSNURWI - RESUME(YES) WAS SPECIFIED FOR EMPTY TABLESPACE
DSNU1038I 075 00:21:41.91 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00003
DDNAME=SYS00006
DSN=IOA.AMURI102.DISCS
DSNU1038I 075 00:21:41.93 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00002
DDNAME=SYS00007
DSN=IOA.AMURI102.XERR
DSNU1038I 075 00:21:41.94 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00004
DDNAME=SYS00008
DSN=IOA.AMURI102.XWORK.SYSUT1
DSNU1038I 075 00:21:41.95 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00005
DDNAME=SYS00009
DSN=IOA.AMURI102.XLOAD.SORTOUT
DSNU1038I 075 00:21:41.96 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00001
DDNAME=SYS00010
DSN=IOA.AMURI102.SYSMAP
DSNU395I 075 00:21:42.01 DSNURPIB - INDEXES WILL BE BUILT IN PARALLEL, NUMBER OF TASKS = 4
DSNU3345I 075 00:21:42.01 DSNURPIB - MAXIMUM UTILITY PARALLELISM IS 5 BASED ON NUMBER OF PARTITIONS AND INDEXES
DSNU397I 075 00:21:42.01 DSNURPIB - NUMBER OF TASKS CONSTRAINED BY CPUS TO 5
DSNU304I *DEND 075 00:21:42.58 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=6 FOR TABLE AMU.TBIXE102
DSNU1147I *DEND 075 00:21:42.58 DSNURWT - (RE)LOAD PHASE STATISTICS - TOTAL NUMBER OF RECORDS LOADED=6 FOR TABLESPACE
DBIXE102.TSIXE102
DSNU302I 075 00:21:42.59 DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=6
DSNU300I 075 00:21:42.59 DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED TIME=00:00:00
DSNU1383I *DEND 075 00:21:42.61 DSNURINV - DYNAMIC STATEMENT CACHE WAS INVALIDATED,
REASON = OBJECT IN RESTRICTIVE STATE
DSNU394I *DEND 075 00:21:42.61 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=6 FOR INDEX AMU.I1IXE102
DSNU1383I *DEND 075 00:21:42.61 DSNURINV - DYNAMIC STATEMENT CACHE WAS INVALIDATED,
REASON = OBJECT IN RESTRICTIVE STATE
DSNU394I *DEND 075 00:21:42.61 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=6 FOR INDEX AMU.I2IXE102
DSNU3350I 075 00:21:42.93 DSNUGSRP - SORT TASK SW02: 6 RECORDS SORTED, ESTIMATED 699, VARIATION 99 PERCENT
DSNU3352I 075 00:21:42.95 DSNUGSRP - SORT TASK SW02: USED DFSORT
DSNU3354I 075 00:21:42.95 DSNUGSRP - SORT TASK SW02: MEMORY BELOW THE BAR: OPTIMAL 6 MB, USED 6 MB
DSNU3350I 075 00:21:42.93 DSNUGSRP - SORT TASK SW01: 6 RECORDS SORTED, ESTIMATED 699, VARIATION 99 PERCENT
DSNU3352I 075 00:21:42.96 DSNUGSRP - SORT TASK SW01: USED DFSORT
DSNU3354I 075 00:21:42.96 DSNUGSRP - SORT TASK SW01: MEMORY BELOW THE BAR: OPTIMAL 6 MB, USED 6 MB
DSNU391I 075 00:21:42.97 DSNURPTB - SORTBLD PHASE STATISTICS. NUMBER OF INDEXES = 2
DSNU392I 075 00:21:42.97 DSNURPTB - SORTBLD PHASE COMPLETE, ELAPSED TIME = 00:00:00
DSNU3357I 075 00:21:43.06 DSNUGUTC - MAXIMUM SORT AMOUNT ESTIMATION VARIATION WAS 99 PERCENT
DSNU3355I 075 00:21:43.06 DSNUGUTC - TOTAL SORT MEMORY BELOW THE BAR: OPTIMAL 12 MB, USED 12 MB
DSNU010I 075 00:21:43.07 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=4
BMC50004I DSNUTILB PHASE COMPLETE. ELAPSED TIME = 00:00:01
BMC50004I UTILTERM PHASE COMPLETE. ELAPSED TIME = 00:00:00
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 4
(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 3/16/2022 0:26:13 ...
BMC50002I UTILITY ID = 'AMUEX22'. DB2 SUBSYSTEM ID = 'DEND'. OPTION MODULE = 'AMU$OPTI'.
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=997.4M,IEFUSI=NO,CPUs=7,GPs=5,zIIPs=2
BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
BMC50471I SMFID=DB2B,JOBID=J0193647,JOB=AMUEX22,STEP=RESUME,CPU=8561-615 (z15)/1.71,76.0G
0
BMC50471I LOADPLUS FOR DB2--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I SOLUTION COMMON CODE--V13.01.00 BASE
BMC50471I MAINT: BPJ1541 BPJ1713 BPJ2211
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922 BPJ0996 BPJ1164 BPJ1309 BPJ1386 BPJ1497 BPJ1594 BPJ1724 BPJ1809
BMC50471I BPJ1833 BPJ1891 BPJ1905 BPJ2109 BPJ2232 BPJ2297
BMC50471I BMC STATS API--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.02.01
BMC50471I MAINT: BPE0443 BPE0445 BPE0447 BPE0449 BPE0450 BPE0451 BPE0452 BPE0455 BPE0456 BPE0457 BPE0460 BPE0463
BMC50471I BPE0467 BPE0468 BPE0469 BPE0473 BPE0474 BPE0475 BPE0479 BPE0480 BPE0482 BPE0487 BPE0488 BPE0489
BMC50471I BPE0493 BPE0497 BPE0498 BPE0501 BPE0503 BPE0507 BPE0512 BPE0513 BPE0517 BPE0518 BPE0519 BPE0523
BMC50471I BPE0524 BPE0527 BPE0528 BPE0530 BPE0531 BPE0534 BPE0535 BPE0540 BPE0541 BPE0542 BPE0545 BPE0549
BMC50471I BPE0551 BPE0552 BPE0555 BPE0556 BPE0557 BPE0560
BMC50471I High-speed Apply Engine--V13.01.00 BASE
BMC50471I NO MAINTENANCE TO REPORT
0
BMC50471I APCOMMIT=2500 FORCE=NONE RULES=BMC
BMC50471I APDOPTS= IBUFFS=20 SDUMP=YES
BMC50471I APMULTIROW=100 IDCACHE=1000 SHORTMEMORY=CONTINUE
BMC50471I APMXAGNT=10 IDCDDN=SYSIDCIN SHRLEVEL=(NONE,NONE)
BMC50471I APRETLIM=COUNT IDERROR=DISCARD SMAX=16
BMC50471I APRETVAL=5 INDDN=SYSREC SMCORE=(0K,0K)
BMC50471I AUTOENUMROWS=YES INFORI=NO SORTDEVT=(,SYSALLDA)
BMC50471I AVAILPAGEPCT=0 INLINECP=NO SORTNUM=32
BMC50471I CBUFFS=30 INVALIDATECACHE=YES SQLDELAY=3
BMC50471I CENTURY=(1950,2049) KEEPDICTIONARY=NO SQLRETRY=100
BMC50471I CHEKPEND=YES LBUFFS=20 SSIGNRPAUSE=NO
BMC50471I COPYDDN=(BMCCPY,BMCCPZ) LOADDN=SORTOUT SSREPORT=REPORT_SWITCH
BMC50471I COPYLVL=FULL LOBAVGPCT=50 STOP@CMT=YES
BMC50471I COPYPEND=YES LOCKROW=YES STOPDELAY=1
BMC50471I COPYSUBSET=NO LONGNAMETRUNC=MIDDLE STOPRETRY=300
BMC50471I DELFILES=(YES,NO) MAPDDN=SYSMAP TAPEDISP=DELETE
BMC50471I DISCARDLIMRC=8 MAXP=5 TOTALPAGEPCT=30
BMC50471I DISCARDRC=0 MAXSORTMEMORY=0 TSSAMPLEPCT=100
BMC50471I DISCDDN=SYSDISC MAXTAPE=3 UPDMAXA_AUTHID=USER
BMC50471I DRNDELAY=1 MGEXTENT=CONTINUE UPDMAXA=NO
BMC50471I DRNRETRY=255 MINSORTMEMORY=0 UXSTATE=SUP
BMC50471I DRNWAIT=NONE MSGLEVEL=1 WBUFFS=(20,10)
BMC50471I DSNUEXIT=(NONE,ASM) OPNDB2ID=NO WORKDDN=SYSUT1
BMC50471I DSNUTILB=YES ORIGDISP=DELETE WORKUNIT=SYSALLDA
BMC50471I ENFORCE=CHECK PAUSEDISCARDRC=4 WRLOG=NO
BMC50471I ERRDDN=SYSERR PLAN=AMUQA XBLKS=3
BMC50471I EXCLDUMP=(X37,X22,X06) PREFORMAT=NO XMLAVGSIZE=10240
BMC50471I FASTSWITCH=NO PRELOAD=CONTINUE ZEROROWRC=0
BMC50471I FILECHK=WARN RCVYDDN=(BMCRCY,BMCRCZ) ZIIP=ENABLED
BMC50471I FORCE_AT=(START,3) REDEFINE=YES
BMC50471I FORCE_RPT=NO RENMMAX=30
0
BMC50471I APCOLLECTION=
BMC50471I APOWNER=
0
BMC50470I DDTYPE = LOAD WORK SORTWORK
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) N/A
BMC50470I VOLCNT = (25,25) (25,25) N/A
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) N/A
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) N/A
BMC50470I EXPDT = N/A N/A N/A
BMC50470I RETPD = N/A N/A N/A
BMC50470I GDGLIMIT = N/A N/A N/A
BMC50470I GDGEMPTY = N/A N/A N/A
BMC50470I GDGSCRAT = N/A N/A N/A
0
BMC50470I DDTYPE = ERROR DISCARD LOCPFCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = N/A N/A 5
BMC50470I GDGEMPTY = N/A N/A NO
BMC50470I GDGSCRAT = N/A N/A NO
0
BMC50470I DDTYPE = LOCBFCPY REMPFCPY REMBFCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = SYSMAP LOCPLCPY LOCBLCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT = N/A
BMC50470I RETPD = N/A
BMC50470I GDGLIMIT = N/A 5 5
BMC50470I GDGEMPTY = N/A NO NO
BMC50470I GDGSCRAT = N/A NO NO
0
BMC50470I DDTYPE = REMPLCPY REMBLCPY LOCPXCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = LOCBXCPY REMPXCPY REMBXCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50483I LOAD DSNPAT=&UID.&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 = DEND
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 INDDN SYSREC RESUME YES
BMC50102I COPY NO COPYPEND NO
BMC50102I INTO TABLE AMU.TBIXE102
BMC50102I ( DSN_NULL_IND_00001 POSITION( 00001) CHAR(1)
BMC50102I , COL_SMALL
BMC50102I POSITION( 00002:00003) SMALLINT
BMC50102I NULLIF DSN_NULL_IND_00001 =X'FF'
BMC50102I , DSN_NULL_IND_00002 POSITION( 00004) CHAR(1)
BMC50102I , COL_INTEGER
BMC50102I POSITION( 00005:00008) INTEGER
BMC50102I NULLIF DSN_NULL_IND_00002 =X'FF'
BMC50102I , DSN_NULL_IND_00003 POSITION( 00009) CHAR(1)
BMC50102I , COL_FLOAT
BMC50102I POSITION( 00010:00017) FLOAT(53)
BMC50102I NULLIF DSN_NULL_IND_00003 =X'FF'
BMC50102I , DSN_NULL_IND_00004 POSITION( 00018) CHAR(1)
BMC50102I , COL_CHAR
BMC50102I POSITION( 00019:00028) CHAR(00010)
BMC50102I NULLIF DSN_NULL_IND_00004 =X'FF'
BMC50102I , DSN_NULL_IND_00005 POSITION( 00029) CHAR(1)
BMC50102I , COL_VCHAR
BMC50102I POSITION( 00030) VARCHAR
BMC50102I NULLIF DSN_NULL_IND_00005 =X'FF'
BMC50102I , DSN_NULL_IND_00006 POSITION( *) CHAR(1)
BMC50102I , COL_DATE
BMC50102I POSITION( *) DATE EXTERNAL
BMC50102I NULLIF DSN_NULL_IND_00006 =X'FF'
BMC50102I , DSN_NULL_IND_00007 POSITION( *) CHAR(1)
BMC50102I , COL_TIME
BMC50102I POSITION( *) TIME EXTERNAL
BMC50102I NULLIF DSN_NULL_IND_00007 =X'FF'
BMC50102I , DSN_NULL_IND_00008 POSITION( *) CHAR(1)
BMC50102I , COL_TIMESTAMP
BMC50102I POSITION( *) TIMESTAMP EXTERNAL
BMC50102I NULLIF DSN_NULL_IND_00008 =X'FF'
BMC50102I , DSN_NULL_IND_00009 POSITION( *) CHAR(1)
BMC50102I , COL_CHAR2
BMC50102I POSITION( *) CHAR(14)
BMC50102I )
BMC50102I DDTYPE LOAD ACTIVE YES DSNPAT 'IOA.AMURI102.XLOAD.SORTOUT'
BMC50102I UNIT SYSDA
BMC50102I DDTYPE WORK ACTIVE YES DSNPAT 'IOA.AMURI102.XWORK.SYSUT1'
BMC50102I UNIT SYSDA
BMC50102I DDTYPE SORTWORK ACTIVE YES
BMC50102I DSNPAT 'IOA.AMURI102.SORT.&DDNAME'
BMC50102I SPACE (20,20) CYL
BMC50102I UNIT SYSDA
BMC50102I DDTYPE DISCARD ACTIVE YES DSNPAT 'IOA.AMURI102.DISCS'
BMC50102I UNIT SYSDA
BMC50102I DDTYPE ERROR ACTIVE YES DSNPAT 'IOA.AMURI102.XERR'
BMC50102I UNIT SYSDA
BMC50102I DDTYPE LOCPFCPY ACTIVE YES DSNPAT 'IOA.AMURI102.BMCCPY'
BMC50102I UNIT SYSDA
BMC50102I DDTYPE LOCBFCPY ACTIVE YES DSNPAT 'IOA.AMURI102.BMCCPZ'
BMC50102I UNIT SYSDA
BMC50102I DDTYPE REMPFCPY ACTIVE YES DSNPAT 'IOA.AMURI102.RCYCPY'
BMC50102I UNIT SYSDA
BMC50102I DDTYPE REMBFCPY ACTIVE YES DSNPAT 'IOA.AMURI102.RCYCPZ'
BMC50102I UNIT SYSDA
BMC50102I DDTYPE SYSMAP ACTIVE YES
BMC50102I DSNPAT 'IOA.AMURI102.SYSMAP'
BMC50102I SPACE (90,30) TRK
BMC50102I UNIT SYSDA
BMC50654I BIND OF PACKAGE AMUQA .AMUESER COMPLETED SUCCESSFULLY
BMC50182I DSNUTILB REQUIRED: INDEX CONTAINS RANDOM KEYS INDEX 'AMU'.'I1IXE102'
BMC50004I UTILINIT PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC54003I SMARTSWITCH RULE: ALLOW_SWITCH COMMENT: GAM CHANGED AFTER ACCIDENTAL CHANGE BY CAT
BMC50183I SMARTSWITCH PRECLUDED FROM SWITCHING. REASON SYSPRINT IS NOT ALLOCATED TO A JES DATA SET
BMC50004I NGTUTIL PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50199I LOAD PLUS PROCESSING CONTINUES
1DSNU000I 075 00:21:41.42 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = AMUEX22
DSNU1044I 075 00:21:41.43 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 075 00:21:41.44 DSNUGUTC - TEMPLATE BMC00001 DSN 'IOA.AMURI102.SYSMAP' UNIT SYSDA VOLCNT 25 DISP(NEW,
DELETE, CATLG) SPACE(90, 30) TRK PCTPRIME 100
DSNU1035I 075 00:21:41.44 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 075 00:21:41.44 DSNUGUTC - TEMPLATE BMC00002 DSN 'IOA.AMURI102.XERR' UNIT SYSDA VOLCNT 25 PCTPRIME 100
DSNU1035I 075 00:21:41.44 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 075 00:21:41.44 DSNUGUTC - TEMPLATE BMC00003 DSN 'IOA.AMURI102.DISCS' UNIT SYSDA VOLCNT 25 PCTPRIME
100
DSNU1035I 075 00:21:41.45 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 075 00:21:41.45 DSNUGUTC - TEMPLATE BMC00004 DSN 'IOA.AMURI102.XWORK.SYSUT1' UNIT SYSDA VOLCNT 25
PCTPRIME 100
DSNU1035I 075 00:21:41.45 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 075 00:21:41.45 DSNUGUTC - TEMPLATE BMC00005 DSN 'IOA.AMURI102.XLOAD.SORTOUT' UNIT SYSDA VOLCNT 25
PCTPRIME 100
DSNU1035I 075 00:21:41.45 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 075 00:21:41.45 DSNUGUTC - LOAD DATA INDDN SYSREC RESUME YES SHRLEVEL NONE LOG NO NOCOPYPEND WORKDDN(
BMC00004, BMC00005) EBCDIC CCSID(37, 65534, 65534) ENFORCE NO ERRDDN BMC00002 MAPDDN BMC00001 DISCARDDN BMC00003
SORTDEVT SYSALLDA SORTNUM 32
DSNU650I *DEND 075 00:21:41.45 DSNURWI - INTO TABLE AMU.TBIXE102 IGNOREFIELDS YES
DSNU650I *DEND 075 00:21:41.45 DSNURWI - (DSN_NULL_IND_00001 POSITION(1) CHAR(1),
DSNU650I *DEND 075 00:21:41.45 DSNURWI - COL_SMALL POSITION(2:3) SMALLINT NULLIF DSN_NULL_IND_00001=X'FF',
DSNU650I *DEND 075 00:21:41.45 DSNURWI - DSN_NULL_IND_00002 POSITION(4) CHAR(1),
DSNU650I *DEND 075 00:21:41.45 DSNURWI - COL_INTEGER POSITION(5:8) INTEGER NULLIF DSN_NULL_IND_00002=X'FF',
DSNU650I *DEND 075 00:21:41.45 DSNURWI - DSN_NULL_IND_00003 POSITION(9) CHAR(1),
DSNU650I *DEND 075 00:21:41.45 DSNURWI - COL_FLOAT POSITION(10:17) FLOAT(53) NULLIF DSN_NULL_IND_00003=X'FF',
DSNU650I *DEND 075 00:21:41.45 DSNURWI - DSN_NULL_IND_00004 POSITION(18) CHAR(1),
DSNU650I *DEND 075 00:21:41.45 DSNURWI - COL_CHAR POSITION(19:28) CHAR(10) NULLIF DSN_NULL_IND_00004=X'FF',
DSNU650I *DEND 075 00:21:41.45 DSNURWI - DSN_NULL_IND_00005 POSITION(29) CHAR(1),
DSNU650I *DEND 075 00:21:41.45 DSNURWI - COL_VCHAR POSITION(30) VARCHAR NULLIF DSN_NULL_IND_00005=X'FF',
DSNU650I *DEND 075 00:21:41.45 DSNURWI - DSN_NULL_IND_00006 POSITION(*) CHAR(1),
DSNU650I *DEND 075 00:21:41.45 DSNURWI - COL_DATE POSITION(*) DATE EXTERNAL NULLIF DSN_NULL_IND_00006=X'FF',
DSNU650I *DEND 075 00:21:41.45 DSNURWI - DSN_NULL_IND_00007 POSITION(*) CHAR(1),
DSNU650I *DEND 075 00:21:41.45 DSNURWI - COL_TIME POSITION(*) TIME EXTERNAL NULLIF DSN_NULL_IND_00007=X'FF',
DSNU650I *DEND 075 00:21:41.45 DSNURWI - DSN_NULL_IND_00008 POSITION(*) CHAR(1),
DSNU650I *DEND 075 00:21:41.45 DSNURWI - COL_TIMESTAMP POSITION(*) TIMESTAMP EXTERNAL NULLIF
DSN_NULL_IND_00008=X'FF',
DSNU650I *DEND 075 00:21:41.46 DSNURWI - DSN_NULL_IND_00009 POSITION(*) CHAR(1),
DSNU650I *DEND 075 00:21:41.46 DSNURWI - COL_CHAR2 POSITION(*) CHAR(14))
DSNU320I *DEND 075 00:21:41.85 DSNURWI - RESUME(YES) WAS SPECIFIED FOR EMPTY TABLESPACE
DSNU1038I 075 00:21:41.91 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00003
DDNAME=SYS00006
DSN=IOA.AMURI102.DISCS
DSNU1038I 075 00:21:41.93 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00002
DDNAME=SYS00007
DSN=IOA.AMURI102.XERR
DSNU1038I 075 00:21:41.94 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00004
DDNAME=SYS00008
DSN=IOA.AMURI102.XWORK.SYSUT1
DSNU1038I 075 00:21:41.95 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00005
DDNAME=SYS00009
DSN=IOA.AMURI102.XLOAD.SORTOUT
DSNU1038I 075 00:21:41.96 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00001
DDNAME=SYS00010
DSN=IOA.AMURI102.SYSMAP
DSNU395I 075 00:21:42.01 DSNURPIB - INDEXES WILL BE BUILT IN PARALLEL, NUMBER OF TASKS = 4
DSNU3345I 075 00:21:42.01 DSNURPIB - MAXIMUM UTILITY PARALLELISM IS 5 BASED ON NUMBER OF PARTITIONS AND INDEXES
DSNU397I 075 00:21:42.01 DSNURPIB - NUMBER OF TASKS CONSTRAINED BY CPUS TO 5
DSNU304I *DEND 075 00:21:42.58 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=6 FOR TABLE AMU.TBIXE102
DSNU1147I *DEND 075 00:21:42.58 DSNURWT - (RE)LOAD PHASE STATISTICS - TOTAL NUMBER OF RECORDS LOADED=6 FOR TABLESPACE
DBIXE102.TSIXE102
DSNU302I 075 00:21:42.59 DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=6
DSNU300I 075 00:21:42.59 DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED TIME=00:00:00
DSNU1383I *DEND 075 00:21:42.61 DSNURINV - DYNAMIC STATEMENT CACHE WAS INVALIDATED,
REASON = OBJECT IN RESTRICTIVE STATE
DSNU394I *DEND 075 00:21:42.61 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=6 FOR INDEX AMU.I1IXE102
DSNU1383I *DEND 075 00:21:42.61 DSNURINV - DYNAMIC STATEMENT CACHE WAS INVALIDATED,
REASON = OBJECT IN RESTRICTIVE STATE
DSNU394I *DEND 075 00:21:42.61 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=6 FOR INDEX AMU.I2IXE102
DSNU3350I 075 00:21:42.93 DSNUGSRP - SORT TASK SW02: 6 RECORDS SORTED, ESTIMATED 699, VARIATION 99 PERCENT
DSNU3352I 075 00:21:42.95 DSNUGSRP - SORT TASK SW02: USED DFSORT
DSNU3354I 075 00:21:42.95 DSNUGSRP - SORT TASK SW02: MEMORY BELOW THE BAR: OPTIMAL 6 MB, USED 6 MB
DSNU3350I 075 00:21:42.93 DSNUGSRP - SORT TASK SW01: 6 RECORDS SORTED, ESTIMATED 699, VARIATION 99 PERCENT
DSNU3352I 075 00:21:42.96 DSNUGSRP - SORT TASK SW01: USED DFSORT
DSNU3354I 075 00:21:42.96 DSNUGSRP - SORT TASK SW01: MEMORY BELOW THE BAR: OPTIMAL 6 MB, USED 6 MB
DSNU391I 075 00:21:42.97 DSNURPTB - SORTBLD PHASE STATISTICS. NUMBER OF INDEXES = 2
DSNU392I 075 00:21:42.97 DSNURPTB - SORTBLD PHASE COMPLETE, ELAPSED TIME = 00:00:00
DSNU3357I 075 00:21:43.06 DSNUGUTC - MAXIMUM SORT AMOUNT ESTIMATION VARIATION WAS 99 PERCENT
DSNU3355I 075 00:21:43.06 DSNUGUTC - TOTAL SORT MEMORY BELOW THE BAR: OPTIMAL 12 MB, USED 12 MB
DSNU010I 075 00:21:43.07 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=4
BMC50004I DSNUTILB PHASE COMPLETE. ELAPSED TIME = 00:00:01
BMC50004I UTILTERM PHASE COMPLETE. ELAPSED TIME = 00:00:00
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 4
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*