Example 22 — Running a DSNUTILB load
This example illustrates requirements and output when you use a feature that requires LOADPLUS to invoke DSNUTILB.
As shown in this example, LOADPLUS displays the DSN messages, including the TEMPLATE statements, in the job SYSPRINT.
In this case, LOADPLUS is loading a partitioned table space that has a unique index that contains keys with random ordering. The options module specifies YES for the DSNUTILB installation option.
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 completion code for the load job.
The following figure shows the JCL for example 22:
//RESUME EXEC PGM=AMUUMAIN,
// PARM='&SSID,AMUEX22,NEW ,,MSGLEVEL(1),AMU$OPTI'
//STEPLIB DD DISP=SHR,DSN=product.libraries
// DD DISP=SHR,DSN=DB2.DSNEXIT
// DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSREC DD DISP=SHR,DSN=AMU.VQA920.FEATURES.V552292.CLOB1
//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 'IOA.AMURI102.XLOAD.SORTOUT'
UNIT SYSDA
DDTYPE WORK ACTIVE YES DSNPAT 'IOA.AMURI102.XWORK.SYSUT1'
UNIT SYSDA
DDTYPE SORTWORK ACTIVE YES
DSNPAT 'IOA.AMURI102.SORT.&DDNAME'
SPACE (20,20) CYL
UNIT SYSDA
DDTYPE DISCARD ACTIVE YES DSNPAT 'IOA.AMURI102.DISCS'
UNIT SYSDA
DDTYPE ERROR ACTIVE YES DSNPAT 'IOA.AMURI102.XERR'
UNIT SYSDA
DDTYPE LOCPFCPY ACTIVE YES DSNPAT 'IOA.AMURI102.BMCCPY'
UNIT SYSDA
DDTYPE LOCBFCPY ACTIVE YES DSNPAT 'IOA.AMURI102.BMCCPZ'
UNIT SYSDA
DDTYPE REMPFCPY ACTIVE YES DSNPAT 'IOA.AMURI102.RCYCPY'
UNIT SYSDA
DDTYPE REMBFCPY ACTIVE YES DSNPAT 'IOA.AMURI102.RCYCPZ'
UNIT SYSDA
DDTYPE SYSMAP ACTIVE YES
DSNPAT 'IOA.AMURI102.SYSMAP'
SPACE (90,30) TRK
UNIT SYSDA
/*
// PARM='&SSID,AMUEX22,NEW ,,MSGLEVEL(1),AMU$OPTI'
//STEPLIB DD DISP=SHR,DSN=product.libraries
// DD DISP=SHR,DSN=DB2.DSNEXIT
// DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSREC DD DISP=SHR,DSN=AMU.VQA920.FEATURES.V552292.CLOB1
//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 'IOA.AMURI102.XLOAD.SORTOUT'
UNIT SYSDA
DDTYPE WORK ACTIVE YES DSNPAT 'IOA.AMURI102.XWORK.SYSUT1'
UNIT SYSDA
DDTYPE SORTWORK ACTIVE YES
DSNPAT 'IOA.AMURI102.SORT.&DDNAME'
SPACE (20,20) CYL
UNIT SYSDA
DDTYPE DISCARD ACTIVE YES DSNPAT 'IOA.AMURI102.DISCS'
UNIT SYSDA
DDTYPE ERROR ACTIVE YES DSNPAT 'IOA.AMURI102.XERR'
UNIT SYSDA
DDTYPE LOCPFCPY ACTIVE YES DSNPAT 'IOA.AMURI102.BMCCPY'
UNIT SYSDA
DDTYPE LOCBFCPY ACTIVE YES DSNPAT 'IOA.AMURI102.BMCCPZ'
UNIT SYSDA
DDTYPE REMPFCPY ACTIVE YES DSNPAT 'IOA.AMURI102.RCYCPY'
UNIT SYSDA
DDTYPE REMBFCPY ACTIVE YES DSNPAT 'IOA.AMURI102.RCYCPZ'
UNIT SYSDA
DDTYPE SYSMAP ACTIVE YES
DSNPAT 'IOA.AMURI102.SYSMAP'
SPACE (90,30) TRK
UNIT SYSDA
/*
SYSPRINT for example 22The 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 V11R2.00 ************
(C) COPYRIGHT 1990 - 2015 BMC SOFTWARE, INC.
LOADPLUS TECHNOLOGY IS PROTECTED BY U.S. PATENT NUMBERS 7,664,790 AND 7,930,291
-BMC50001I UTILITY EXECUTION STARTING 3/09/2015 15:36:53 ...
BMC50002I UTILITY ID = 'AMUEX22'. DB2 SUBSYSTEM ID = 'DEHJ'. OPTION MODULE = 'AMU$OPTI'.
BMC50471I z/OS 2.1.0,PID=HBB7790,DFSMS FOR Z/OS=2.1.0,DB2=11.1.0
BMC50471I REGION=0M,BELOW 16M=8828K,ABOVE 16M=1309056K,IEFUSI=NO,CPUS=3
BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040302M,MEMLIMIT SET BY:REGION=0
0
BMC50471I LOADPLUS FOR DB2--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I SOLUTION COMMON CODE--V11.01.00
BMC50471I MAINT: BPJ0661 BPJ0667 BPJ0671 BPJ0674 BPJ0675 BPJ0676 BPJ0682 BPJ0686 BPJ0689 BPJ0697 BPJ0700 BPJ0702
BMC50471I BPJ0703 BPJ0706 BPJ0712 BPJ0715 BPJ0729 BPJ0773 BPJ0786 BPJ0794 BPJ0806 BPJ0830 BPJ0833 BPJ0839
BMC50471I BPJ0845 BPJ0866 BPJ0892 BPJ0913 BPJ0914 BPJ0916 BPJ0930 BPJ0944 BPJ0946
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922
BMC50471I BMC STATS API--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.01.00
BMC50471I MAINT: BPE0401 BPE0403 BPE0405 BPE0407 BPE0410 BPE0412 BPE0416 BPE0420 BPE0422 BPE0423 BPE0426 BPE0428
BMC50471I BPE0430 BPE0433 BPE0435 BPE0438 BPE0439
BMC50471I HIGH-SPEED APPLY ENGINE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
0
BMC50471I APCOMMIT=2500 FORCE_RPT=NO REDEFINE=YES
BMC50471I APDOPTS= FORCE=NONE RENMMAX=30
BMC50471I APMULTIROW=100 IBUFFS=20 RULES=BMC
BMC50471I APMXAGNT=10 IDCACHE=1000 SDUMP=YES
BMC50471I APRETLIM=COUNT IDCDDN=SYSIDCIN SHORTMEMORY=CONTINUE
BMC50471I APRETVAL=5 IDERROR=DISCARD SHRLEVEL=(NONE,NONE)
BMC50471I AUTOENUMROWS=YES INDDN=SYSREC SMAX=16
BMC50471I AVAILPAGEPCT=0 INFORI=NO SMCORE=(0K,0K)
BMC50471I CBUFFS=30 INLINECP=YES SORTDEVT=(,SYSALLDA)
BMC50471I CENTURY=(1950,2049) KEEPDICTIONARY=NO SORTNUM=32
BMC50471I CHEKPEND=YES LBUFFS=20 SQLDELAY=3
BMC50471I COPYDDN=(BMCCPY,BMCCPZ) LOADDN=SORTOUT SQLRETRY=100
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 OPTMSGS=YES WORKUNIT=SYSALLDA
BMC50471I ENFORCE=NO ORIGDISP=DELETE XBLKS=3
BMC50471I ERRDDN=SYSERR PAUSEDISCARDRC=4 XMLAVGSIZE=10240
BMC50471I EXCLDUMP=(X37,X22,X06) PLAN=AMUQA ZEROROWRC=0
BMC50471I FASTSWITCH=NO PREFORMAT=NO ZIIP=ENABLED
BMC50471I FILECHK=WARN PRELOAD=LOAD
BMC50471I FORCE_AT=(START,3) RCVYDDN=(BMCRCY,BMCRCZ)
0
BMC50471I APCOLLECTION=
BMC50471I APOWNER=
0
BMC50470I DDTYPE = LOAD WORK SORTWORK
BMC50470I ACTIVE = YES YES NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) N/A
BMC50470I VOLCNT = (25,25) (25,25) N/A
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) N/A
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) N/A
BMC50470I EXPDT = N/A N/A N/A
BMC50470I RETPD = N/A N/A N/A
BMC50470I GDGLIMIT = N/A N/A N/A
BMC50470I GDGEMPTY = N/A N/A N/A
BMC50470I GDGSCRAT = N/A N/A N/A
0
BMC50470I DDTYPE = ERROR DISCARD LOCPFCPY
BMC50470I ACTIVE = YES YES YES
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = N/A N/A 5
BMC50470I GDGEMPTY = N/A N/A NO
BMC50470I GDGSCRAT = N/A N/A NO
0
BMC50470I DDTYPE = LOCBFCPY REMPFCPY REMBFCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = SYSMAP LOCPLCPY LOCBLCPY
BMC50470I ACTIVE = YES YES NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT = N/A
BMC50470I RETPD = N/A
BMC50470I GDGLIMIT = N/A 5 5
BMC50470I GDGEMPTY = N/A NO NO
BMC50470I GDGSCRAT = N/A NO NO
0
BMC50470I DDTYPE = REMPLCPY REMBLCPY LOCPXCPY
BMC50470I ACTIVE = NO NO YES
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = LOCBXCPY REMPXCPY REMBXCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50483I LOAD DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I WORK DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I SORTWORK DSNPAT=NONE
BMC50483I ERROR DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I DISCARD DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I SYSMAP DSNPAT=&UID..BMC.&TS.&DDNAME
0
BMC50483I LOCPFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I LOCBFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMPFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMBFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
BMC50483I LOCPLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I LOCBLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I REMPLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I REMBLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
0
BMC50483I LOCPXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I LOCBXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMPXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMBXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
BMC50471I DB2 DSNHDECP MODULE SETTINGS:
BMC50471I VERSION = 1110
BMC50471I SUBSYSTEM DEFAULT = DEHJ
BMC50471I CHARACTER SET = ALPHANUM
BMC50471I DATE FORMAT = USA
BMC50471I TIME FORMAT = USA
BMC50471I LOCAL DATE LENGTH = 0
BMC50471I LOCAL TIME LENGTH = 0
BMC50471I DECIMAL POINT = PERIOD
BMC50471I DECIMAL ARITHMETIC = 15
BMC50471I DELIMITER = DEFAULT
BMC50471I SQL DELIMITER = DEFAULT
BMC50471I ENCODING SCHEME = EBCDIC
BMC50471I APPL. ENCODING SCHEME = EBCDIC
BMC50471I MIXED = NO
BMC50471I EBCDIC CCSID = (37,65534,65534)
BMC50471I ASCII CCSID = (819,65534,65534)
BMC50471I UNICODE CCSID = (367,1208,1200)
BMC50471I IMPLICIT TIME ZONE = CURRENT (-05:00)
BMC50028I DB2 MODE = NFM
BMC50471I BMC_BMCUTIL ='BMCUTIL.CMN_BMCUTIL'
BMC50471I BMC_BMCSYNC ='BMCUTIL.CMN_BMCSYNC'
BMC50471I BMC_BMCHIST ='BMCUTIL.CMN_BMCHIST'
BMC50471I BMC_BMCDICT ='BMCUTIL.CMN_BMCDICT'
0
0
BMC50102I LOAD DATA 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
BMC50182I DSNUTILB REQUIRED: INDEX CONTAINS RANDOM KEYS INDEX 'AMU'.'I1IXE102'
BMC50004I UTILINIT PHASE COMPLETE. ELAPSED TIME = 00:00:00
1DSNU000I 068 15:36:54.63 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = AMUEX22
DSNU1044I 068 15:36:54.76 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 068 15:36:54.77 DSNUGUTC - TEMPLATE BMC00001 DSN 'IOA.AMURI102.SYSMAP' UNIT SYSDA VOLCNT 25 DISP(NEW,
DELETE, CATLG) SPACE(90, 30) TRK PCTPRIME 100
DSNU1035I 068 15:36:54.77 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 068 15:36:54.77 DSNUGUTC - TEMPLATE BMC00002 DSN 'IOA.AMURI102.XERR' UNIT SYSDA VOLCNT 25 PCTPRIME 100
DSNU1035I 068 15:36:54.78 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 068 15:36:54.78 DSNUGUTC - TEMPLATE BMC00003 DSN 'IOA.AMURI102.DISCS' UNIT SYSDA VOLCNT 25 PCTPRIME
100
DSNU1035I 068 15:36:54.78 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 068 15:36:54.78 DSNUGUTC - TEMPLATE BMC00004 DSN 'IOA.AMURI102.XWORK.SYSUT1' UNIT SYSDA VOLCNT 25
PCTPRIME 100
DSNU1035I 068 15:36:54.78 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 068 15:36:54.78 DSNUGUTC - TEMPLATE BMC00005 DSN 'IOA.AMURI102.XLOAD.SORTOUT' UNIT SYSDA VOLCNT 25
PCTPRIME 100
DSNU1035I 068 15:36:54.78 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 068 15:36:54.78 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 *DEHJ 068 15:36:54.79 DSNURWI - INTO TABLE AMU.TBIXE102 IGNOREFIELDS YES
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - (DSN_NULL_IND_00001 POSITION(1) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_SMALL POSITION(2:3) SMALLINT NULLIF DSN_NULL_IND_00001=X'FF',
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - DSN_NULL_IND_00002 POSITION(4) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_INTEGER POSITION(5:8) INTEGER NULLIF DSN_NULL_IND_00002=X'FF',
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - DSN_NULL_IND_00003 POSITION(9) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_FLOAT POSITION(10:17) FLOAT(53) NULLIF DSN_NULL_IND_00003=X'FF',
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - DSN_NULL_IND_00004 POSITION(18) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_CHAR POSITION(19:28) CHAR(10) NULLIF DSN_NULL_IND_00004=X'FF',
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - DSN_NULL_IND_00005 POSITION(29) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_VCHAR POSITION(30) VARCHAR NULLIF DSN_NULL_IND_00005=X'FF',
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - DSN_NULL_IND_00006 POSITION(*) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_DATE POSITION(*) DATE EXTERNAL NULLIF DSN_NULL_IND_00006=X'FF',
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - DSN_NULL_IND_00007 POSITION(*) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_TIME POSITION(*) TIME EXTERNAL NULLIF DSN_NULL_IND_00007=X'FF',
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - DSN_NULL_IND_00008 POSITION(*) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_TIMESTAMP POSITION(*) TIMESTAMP EXTERNAL NULLIF
DSN_NULL_IND_00008=X'FF',
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - DSN_NULL_IND_00009 POSITION(*) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_CHAR2 POSITION(*) CHAR(14))
DSNU320I *DEHJ 068 15:36:54.87 DSNURWI - RESUME(YES) WAS SPECIFIED FOR EMPTY TABLESPACE
DSNU1038I 068 15:36:54.98 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00004
DDNAME=SYS00006
DSN=IOA.AMURI102.XWORK.SYSUT1
DSNU1038I 068 15:36:55.01 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00005
DDNAME=SYS00007
DSN=IOA.AMURI102.XLOAD.SORTOUT
DSNU1038I 068 15:36:55.03 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00003
DDNAME=SYS00008
DSN=IOA.AMURI102.DISCS
DSNU1038I 068 15:36:55.06 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00002
DDNAME=SYS00009
DSN=IOA.AMURI102.XERR
DSNU1038I 068 15:36:55.08 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00001
DDNAME=SYS00010
DSN=IOA.AMURI102.SYSMAP
DSNU395I 068 15:36:55.16 DSNURPIB - INDEXES WILL BE BUILT IN PARALLEL, NUMBER OF TASKS = 4
DSNU3345I 068 15:36:55.16 DSNURPIB - MAXIMUM UTILITY PARALLELISM IS 5 BASED ON NUMBER OF PARTITIONS AND INDEXES
DSNU397I 068 15:36:55.16 DSNURPIB - NUMBER OF TASKS CONSTRAINED BY CPUS TO 5
DSNU304I *DEHJ 068 15:36:55.27 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=6 FOR TABLE AMU.TBIXE102
DSNU1147I *DEHJ 068 15:36:55.27 DSNURWT - (RE)LOAD PHASE STATISTICS - TOTAL NUMBER OF RECORDS LOADED=6 FOR TABLESPACE
DBIXE102.TSIXE102
DSNU302I 068 15:36:55.27 DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=6
DSNU300I 068 15:36:55.27 DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED TIME=00:00:00
DSNU394I *DEHJ 068 15:36:56.34 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=6 FOR INDEX AMU.I2IXE102
DSNU394I *DEHJ 068 15:36:56.36 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=6 FOR INDEX AMU.I1IXE102
DSNU391I 068 15:36:56.86 DSNURPTB - SORTBLD PHASE STATISTICS. NUMBER OF INDEXES = 2
DSNU392I 068 15:36:56.86 DSNURPTB - SORTBLD PHASE COMPLETE, ELAPSED TIME = 00:00:01
DSNU010I 068 15:36:56.96 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=4
BMC50004I DSNUTILB PHASE COMPLETE. ELAPSED TIME = 00:00:02
BMC50004I UTILTERM PHASE COMPLETE. ELAPSED TIME = 00:00:00
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 4
(C) COPYRIGHT 1990 - 2015 BMC SOFTWARE, INC.
LOADPLUS TECHNOLOGY IS PROTECTED BY U.S. PATENT NUMBERS 7,664,790 AND 7,930,291
-BMC50001I UTILITY EXECUTION STARTING 3/09/2015 15:36:53 ...
BMC50002I UTILITY ID = 'AMUEX22'. DB2 SUBSYSTEM ID = 'DEHJ'. OPTION MODULE = 'AMU$OPTI'.
BMC50471I z/OS 2.1.0,PID=HBB7790,DFSMS FOR Z/OS=2.1.0,DB2=11.1.0
BMC50471I REGION=0M,BELOW 16M=8828K,ABOVE 16M=1309056K,IEFUSI=NO,CPUS=3
BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040302M,MEMLIMIT SET BY:REGION=0
0
BMC50471I LOADPLUS FOR DB2--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I SOLUTION COMMON CODE--V11.01.00
BMC50471I MAINT: BPJ0661 BPJ0667 BPJ0671 BPJ0674 BPJ0675 BPJ0676 BPJ0682 BPJ0686 BPJ0689 BPJ0697 BPJ0700 BPJ0702
BMC50471I BPJ0703 BPJ0706 BPJ0712 BPJ0715 BPJ0729 BPJ0773 BPJ0786 BPJ0794 BPJ0806 BPJ0830 BPJ0833 BPJ0839
BMC50471I BPJ0845 BPJ0866 BPJ0892 BPJ0913 BPJ0914 BPJ0916 BPJ0930 BPJ0944 BPJ0946
BMC50471I BMCSORT ENGINE--V02.04.01
BMC50471I MAINT: BPJ0691 BPJ0718 BPJ0881 BPJ0922
BMC50471I BMC STATS API--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
BMC50471I EXTENDED BUFFER MANAGER--V06.01.00
BMC50471I MAINT: BPE0401 BPE0403 BPE0405 BPE0407 BPE0410 BPE0412 BPE0416 BPE0420 BPE0422 BPE0423 BPE0426 BPE0428
BMC50471I BPE0430 BPE0433 BPE0435 BPE0438 BPE0439
BMC50471I HIGH-SPEED APPLY ENGINE--V11.02.00
BMC50471I NO MAINTENANCE TO REPORT
0
BMC50471I APCOMMIT=2500 FORCE_RPT=NO REDEFINE=YES
BMC50471I APDOPTS= FORCE=NONE RENMMAX=30
BMC50471I APMULTIROW=100 IBUFFS=20 RULES=BMC
BMC50471I APMXAGNT=10 IDCACHE=1000 SDUMP=YES
BMC50471I APRETLIM=COUNT IDCDDN=SYSIDCIN SHORTMEMORY=CONTINUE
BMC50471I APRETVAL=5 IDERROR=DISCARD SHRLEVEL=(NONE,NONE)
BMC50471I AUTOENUMROWS=YES INDDN=SYSREC SMAX=16
BMC50471I AVAILPAGEPCT=0 INFORI=NO SMCORE=(0K,0K)
BMC50471I CBUFFS=30 INLINECP=YES SORTDEVT=(,SYSALLDA)
BMC50471I CENTURY=(1950,2049) KEEPDICTIONARY=NO SORTNUM=32
BMC50471I CHEKPEND=YES LBUFFS=20 SQLDELAY=3
BMC50471I COPYDDN=(BMCCPY,BMCCPZ) LOADDN=SORTOUT SQLRETRY=100
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 OPTMSGS=YES WORKUNIT=SYSALLDA
BMC50471I ENFORCE=NO ORIGDISP=DELETE XBLKS=3
BMC50471I ERRDDN=SYSERR PAUSEDISCARDRC=4 XMLAVGSIZE=10240
BMC50471I EXCLDUMP=(X37,X22,X06) PLAN=AMUQA ZEROROWRC=0
BMC50471I FASTSWITCH=NO PREFORMAT=NO ZIIP=ENABLED
BMC50471I FILECHK=WARN PRELOAD=LOAD
BMC50471I FORCE_AT=(START,3) RCVYDDN=(BMCRCY,BMCRCZ)
0
BMC50471I APCOLLECTION=
BMC50471I APOWNER=
0
BMC50470I DDTYPE = LOAD WORK SORTWORK
BMC50470I ACTIVE = YES YES NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) N/A
BMC50470I VOLCNT = (25,25) (25,25) N/A
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) N/A
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) N/A
BMC50470I EXPDT = N/A N/A N/A
BMC50470I RETPD = N/A N/A N/A
BMC50470I GDGLIMIT = N/A N/A N/A
BMC50470I GDGEMPTY = N/A N/A N/A
BMC50470I GDGSCRAT = N/A N/A N/A
0
BMC50470I DDTYPE = ERROR DISCARD LOCPFCPY
BMC50470I ACTIVE = YES YES YES
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = N/A N/A 5
BMC50470I GDGEMPTY = N/A N/A NO
BMC50470I GDGSCRAT = N/A N/A NO
0
BMC50470I DDTYPE = LOCBFCPY REMPFCPY REMBFCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = SYSMAP LOCPLCPY LOCBLCPY
BMC50470I ACTIVE = YES YES NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT = N/A
BMC50470I RETPD = N/A
BMC50470I GDGLIMIT = N/A 5 5
BMC50470I GDGEMPTY = N/A NO NO
BMC50470I GDGSCRAT = N/A NO NO
0
BMC50470I DDTYPE = REMPLCPY REMBLCPY LOCPXCPY
BMC50470I ACTIVE = NO NO YES
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50470I DDTYPE = LOCBXCPY REMPXCPY REMBXCPY
BMC50470I ACTIVE = NO NO NO
BMC50470I IFALLOC = USE USE USE
BMC50470I SMS = NO NO NO
BMC50470I SMSUNIT = NO NO NO
BMC50470I SIZEPCT = (100,100) (100,100) (100,100)
BMC50470I UNIT = (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA) (SYSALLDA,SYSALLDA)
BMC50470I UNITCNT = (0,0) (0,0) (0,0)
BMC50470I VOLCNT = (25,25) (25,25) (25,25)
BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK)) ((30000,TRK),(30000,TRK))
BMC50470I DSNTYPE = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I DATACLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I MGMTCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I STORCLAS = (NONE,NONE) (NONE,NONE) (NONE,NONE)
BMC50470I THRESHLD = 0 0 0
BMC50470I MAXEXTSZ = ((0,K),(0,K)) ((0,K),(0,K)) ((0,K),(0,K))
BMC50470I EXPDT =
BMC50470I RETPD =
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
0
BMC50483I LOAD DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I WORK DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I SORTWORK DSNPAT=NONE
BMC50483I ERROR DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I DISCARD DSNPAT=&UID..BMC.&TS.&DDNAME
BMC50483I SYSMAP DSNPAT=&UID..BMC.&TS.&DDNAME
0
BMC50483I LOCPFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I LOCBFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMPFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMBFCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
BMC50483I LOCPLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I LOCBLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I REMPLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
BMC50483I REMBLCPY DSNPAT=&UID.&DDNAME.&TS..T&TIME
0
BMC50483I LOCPXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I LOCBXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMPXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
BMC50483I REMBXCPY DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
BMC50471I DB2 DSNHDECP MODULE SETTINGS:
BMC50471I VERSION = 1110
BMC50471I SUBSYSTEM DEFAULT = DEHJ
BMC50471I CHARACTER SET = ALPHANUM
BMC50471I DATE FORMAT = USA
BMC50471I TIME FORMAT = USA
BMC50471I LOCAL DATE LENGTH = 0
BMC50471I LOCAL TIME LENGTH = 0
BMC50471I DECIMAL POINT = PERIOD
BMC50471I DECIMAL ARITHMETIC = 15
BMC50471I DELIMITER = DEFAULT
BMC50471I SQL DELIMITER = DEFAULT
BMC50471I ENCODING SCHEME = EBCDIC
BMC50471I APPL. ENCODING SCHEME = EBCDIC
BMC50471I MIXED = NO
BMC50471I EBCDIC CCSID = (37,65534,65534)
BMC50471I ASCII CCSID = (819,65534,65534)
BMC50471I UNICODE CCSID = (367,1208,1200)
BMC50471I IMPLICIT TIME ZONE = CURRENT (-05:00)
BMC50028I DB2 MODE = NFM
BMC50471I BMC_BMCUTIL ='BMCUTIL.CMN_BMCUTIL'
BMC50471I BMC_BMCSYNC ='BMCUTIL.CMN_BMCSYNC'
BMC50471I BMC_BMCHIST ='BMCUTIL.CMN_BMCHIST'
BMC50471I BMC_BMCDICT ='BMCUTIL.CMN_BMCDICT'
0
0
BMC50102I LOAD DATA 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
BMC50182I DSNUTILB REQUIRED: INDEX CONTAINS RANDOM KEYS INDEX 'AMU'.'I1IXE102'
BMC50004I UTILINIT PHASE COMPLETE. ELAPSED TIME = 00:00:00
1DSNU000I 068 15:36:54.63 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = AMUEX22
DSNU1044I 068 15:36:54.76 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 068 15:36:54.77 DSNUGUTC - TEMPLATE BMC00001 DSN 'IOA.AMURI102.SYSMAP' UNIT SYSDA VOLCNT 25 DISP(NEW,
DELETE, CATLG) SPACE(90, 30) TRK PCTPRIME 100
DSNU1035I 068 15:36:54.77 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 068 15:36:54.77 DSNUGUTC - TEMPLATE BMC00002 DSN 'IOA.AMURI102.XERR' UNIT SYSDA VOLCNT 25 PCTPRIME 100
DSNU1035I 068 15:36:54.78 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 068 15:36:54.78 DSNUGUTC - TEMPLATE BMC00003 DSN 'IOA.AMURI102.DISCS' UNIT SYSDA VOLCNT 25 PCTPRIME
100
DSNU1035I 068 15:36:54.78 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 068 15:36:54.78 DSNUGUTC - TEMPLATE BMC00004 DSN 'IOA.AMURI102.XWORK.SYSUT1' UNIT SYSDA VOLCNT 25
PCTPRIME 100
DSNU1035I 068 15:36:54.78 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 068 15:36:54.78 DSNUGUTC - TEMPLATE BMC00005 DSN 'IOA.AMURI102.XLOAD.SORTOUT' UNIT SYSDA VOLCNT 25
PCTPRIME 100
DSNU1035I 068 15:36:54.78 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 068 15:36:54.78 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 *DEHJ 068 15:36:54.79 DSNURWI - INTO TABLE AMU.TBIXE102 IGNOREFIELDS YES
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - (DSN_NULL_IND_00001 POSITION(1) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_SMALL POSITION(2:3) SMALLINT NULLIF DSN_NULL_IND_00001=X'FF',
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - DSN_NULL_IND_00002 POSITION(4) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_INTEGER POSITION(5:8) INTEGER NULLIF DSN_NULL_IND_00002=X'FF',
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - DSN_NULL_IND_00003 POSITION(9) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_FLOAT POSITION(10:17) FLOAT(53) NULLIF DSN_NULL_IND_00003=X'FF',
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - DSN_NULL_IND_00004 POSITION(18) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_CHAR POSITION(19:28) CHAR(10) NULLIF DSN_NULL_IND_00004=X'FF',
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - DSN_NULL_IND_00005 POSITION(29) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_VCHAR POSITION(30) VARCHAR NULLIF DSN_NULL_IND_00005=X'FF',
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - DSN_NULL_IND_00006 POSITION(*) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_DATE POSITION(*) DATE EXTERNAL NULLIF DSN_NULL_IND_00006=X'FF',
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - DSN_NULL_IND_00007 POSITION(*) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_TIME POSITION(*) TIME EXTERNAL NULLIF DSN_NULL_IND_00007=X'FF',
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - DSN_NULL_IND_00008 POSITION(*) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_TIMESTAMP POSITION(*) TIMESTAMP EXTERNAL NULLIF
DSN_NULL_IND_00008=X'FF',
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - DSN_NULL_IND_00009 POSITION(*) CHAR(1),
DSNU650I *DEHJ 068 15:36:54.79 DSNURWI - COL_CHAR2 POSITION(*) CHAR(14))
DSNU320I *DEHJ 068 15:36:54.87 DSNURWI - RESUME(YES) WAS SPECIFIED FOR EMPTY TABLESPACE
DSNU1038I 068 15:36:54.98 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00004
DDNAME=SYS00006
DSN=IOA.AMURI102.XWORK.SYSUT1
DSNU1038I 068 15:36:55.01 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00005
DDNAME=SYS00007
DSN=IOA.AMURI102.XLOAD.SORTOUT
DSNU1038I 068 15:36:55.03 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00003
DDNAME=SYS00008
DSN=IOA.AMURI102.DISCS
DSNU1038I 068 15:36:55.06 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00002
DDNAME=SYS00009
DSN=IOA.AMURI102.XERR
DSNU1038I 068 15:36:55.08 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=BMC00001
DDNAME=SYS00010
DSN=IOA.AMURI102.SYSMAP
DSNU395I 068 15:36:55.16 DSNURPIB - INDEXES WILL BE BUILT IN PARALLEL, NUMBER OF TASKS = 4
DSNU3345I 068 15:36:55.16 DSNURPIB - MAXIMUM UTILITY PARALLELISM IS 5 BASED ON NUMBER OF PARTITIONS AND INDEXES
DSNU397I 068 15:36:55.16 DSNURPIB - NUMBER OF TASKS CONSTRAINED BY CPUS TO 5
DSNU304I *DEHJ 068 15:36:55.27 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=6 FOR TABLE AMU.TBIXE102
DSNU1147I *DEHJ 068 15:36:55.27 DSNURWT - (RE)LOAD PHASE STATISTICS - TOTAL NUMBER OF RECORDS LOADED=6 FOR TABLESPACE
DBIXE102.TSIXE102
DSNU302I 068 15:36:55.27 DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=6
DSNU300I 068 15:36:55.27 DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED TIME=00:00:00
DSNU394I *DEHJ 068 15:36:56.34 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=6 FOR INDEX AMU.I2IXE102
DSNU394I *DEHJ 068 15:36:56.36 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=6 FOR INDEX AMU.I1IXE102
DSNU391I 068 15:36:56.86 DSNURPTB - SORTBLD PHASE STATISTICS. NUMBER OF INDEXES = 2
DSNU392I 068 15:36:56.86 DSNURPTB - SORTBLD PHASE COMPLETE, ELAPSED TIME = 00:00:01
DSNU010I 068 15:36:56.96 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=4
BMC50004I DSNUTILB PHASE COMPLETE. ELAPSED TIME = 00:00:02
BMC50004I UTILTERM PHASE COMPLETE. ELAPSED TIME = 00:00:00
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 4
Related topics
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*