Example 18 — Unloading a table space and loading data as Unicode
Specifying UNLOAD TABLESPACE tells UNLOAD PLUS to generate a SELECT statement for each object in the table space. The functionality of this option is the same as if you had specified SELECT * FROM for every table in the table space. The AUTOTAG YES option adds a four-byte character constant value at the beginning of each output record for each generated SELECT statement. This tag identifies the table source when you use a single output data set.
In both jobs, message 50041I indicates the status of zIIP processing. For this example, the ZIIP installation option is ENABLED, but an SUF (also known as XBM) subsystem was not specified. UNLOAD PLUS and LOADPLUS automatically locate an available SUF (also known as XBM) subsystem to provide zIIP processing.
The following table describes the UNLOAD PLUS key command options for this job:
Command options used in JCL | Description |
|---|---|
UNLOAD TABLESPACE | Unloads table space BMCEXDB.BMCEXBTS and generates SELECT statements for the following tables (see message BMC51657I and BMC51658I in the SYSPRINT output):
|
UNICODE | Tells UNLOAD PLUS to use the Db2 installation default (DSNHDECP) CCSIDs to encode the unloaded data in Unicode |
AUTOTAG YES | Precedes each output record with a unique four-byte value for each generated SELECT statement |
CNTLCARDS 'REPLACE' | Tells UNLOAD PLUS to write Db2 LOAD control statements 'REPLACE' is added to the Db2 LOAD control statement. |
UNLOADDN SYSREC ACTIVE NO | Disables dynamic allocation for the primary unload data set, overriding the default in the installation options module |
The following table describes the LOADPLUS key command options for this job:
Command options used in JCL | Description |
|---|---|
REPLACE | Tells LOADPLUS to delete the existing data in the tables before loading |
UNICODE | Specifies that the data that you are loading from the SYSREC data set is in Unicode format |
CCSID | Specifies the three CCSIDs used to encode the data coming from UNLOAD PLUS |
INTO TABLE | Identifies the data to load by specifying the table name |
WHEN | Specifies the condition that must be true for LOADPLUS to select a row |
The SYSIN DD statement in the LOADPLUS JCL specifies the name of the SYSCNTL data set that contains the LOAD command options that UNLOAD PLUS created. Passing the options from UNLOAD PLUS to LOADPLUS in this way streamlines the data migration process by eliminating the need to manually modify options in your LOADPLUS JCL.
The following figure shows the UNLOAD PLUS JCL for example 18:
// JOBCARD
//**********************ADUEX18A ************************************
//*******************************************************************
//********* Unloading a table space and loading data as Unicode ***
//*******************************************************************
//* Replace "DB2SYS" by your DB2 subsystem name. *
//* Use your DB2 product install libraries for STEPLIBS : *
//* PRODUCT.LIBRARIES *
//* DB2.DSNEXIT *
//* DB2.DSNLOAD *
//********************************************************************
//* UNLOAD THE EBCDIC BMC EMPLOYEE TABLESPACE USING A
//* UNICODE ENCODING SCHEME
//*********************************************************************
//UNLOADZA EXEC PGM=ADUUMAIN,REGION=0M,
// PARM=(DB2SYS,'ADUEX18A','NEW ',,'MSGLEVEL(1)')
//STEPLIB DD DISP=SHR,DSN=PRODUCT.LIBRARIES
// DD DSN=DB2.DSNEXIT,DISP=SHR
// DD DSN=DB2.DSNLOAD,DISP=SHR
//SYSREC DD DSN=ADU.EXAMPL18.SYSREC,
// DISP=(NEW,CATLG),SPACE=(TRK,(5,1)),UNIT=SYSDA
//SYSCNTL DD DSN=ADU.EXAMPL18.SYSCNTL,
// DISP=(NEW,CATLG),SPACE=(TRK,(1,1)),UNIT=SYSDA
//SYSPRINT DD DSN=ADU.EXAMPL18.SYSPRNT,DISP=(NEW,CATLG),
// SPACE=(CYL,(1,1),RLSE),UNIT=SYSDA
//UTPRINT DD SYSOUT=*
//SYSIN DD *
*
UNLOAD
TABLESPACE BMCEXDB.BMCEXBTS
UNICODE
AUTOTAG YES
CNTLCARDS 'REPLACE'
UNLOADDN SYSREC ACTIVE NO
*
//**********************ADUEX18A ************************************
//*******************************************************************
//********* Unloading a table space and loading data as Unicode ***
//*******************************************************************
//* Replace "DB2SYS" by your DB2 subsystem name. *
//* Use your DB2 product install libraries for STEPLIBS : *
//* PRODUCT.LIBRARIES *
//* DB2.DSNEXIT *
//* DB2.DSNLOAD *
//********************************************************************
//* UNLOAD THE EBCDIC BMC EMPLOYEE TABLESPACE USING A
//* UNICODE ENCODING SCHEME
//*********************************************************************
//UNLOADZA EXEC PGM=ADUUMAIN,REGION=0M,
// PARM=(DB2SYS,'ADUEX18A','NEW ',,'MSGLEVEL(1)')
//STEPLIB DD DISP=SHR,DSN=PRODUCT.LIBRARIES
// DD DSN=DB2.DSNEXIT,DISP=SHR
// DD DSN=DB2.DSNLOAD,DISP=SHR
//SYSREC DD DSN=ADU.EXAMPL18.SYSREC,
// DISP=(NEW,CATLG),SPACE=(TRK,(5,1)),UNIT=SYSDA
//SYSCNTL DD DSN=ADU.EXAMPL18.SYSCNTL,
// DISP=(NEW,CATLG),SPACE=(TRK,(1,1)),UNIT=SYSDA
//SYSPRINT DD DSN=ADU.EXAMPL18.SYSPRNT,DISP=(NEW,CATLG),
// SPACE=(CYL,(1,1),RLSE),UNIT=SYSDA
//UTPRINT DD SYSOUT=*
//SYSIN DD *
*
UNLOAD
TABLESPACE BMCEXDB.BMCEXBTS
UNICODE
AUTOTAG YES
CNTLCARDS 'REPLACE'
UNLOADDN SYSREC ACTIVE NO
*
The following figure shows the LOADPLUS JCL for example 18:
// JOBCARD
//**********************ADUEX18B ************************************
//*******************************************************************
//********* Unloading a table space and loading data as Unicode ****
//*******************************************************************
//* Replace "DB2SYS" by your DB2 subsystem name. *
//* Use your DB2 product install libraries for STEPLIBS : *
//* PRODUCT.LIBRARIES *
//* DB2.DSNEXIT *
//* DB2.DSNLOAD *
//*******************************************************************
//* LOAD AN IDENTICAL EBCDIC TABLESPACE EXISTING ON ANOTHER DB2
//* USING THE UNICODE DATA SYSREC CREATED IN ADUXM18A
//*******************************************************************
//LODPLUS1 EXEC PGM=AMUUMAIN,
// PARM='DB2SYS,ADUEX18B,NEW,,MSGLEVEL(1)'
//STEPLIB DD DISP=SHR,DSN=PRODUCT.LIBRARIES
// DD DSN=DB2.DSNEXIT,DISP=SHR
// DD DSN=DB2.DSNLOAD,DISP=SHR
//SYSPRINT DD DSN=ADU.EXAMPL18.SYSPRNTL,
// DISP=(NEW,CATLG),SPACE=(CYL,(1,1),RLSE),UNIT=SYSDA
//SYSOUT DD SYSOUT=*
//SORTOUT DD DSN=&SORTOUT,
// DISP=(NEW,PASS),UNIT=WORK,SPACE=(CYL,(1,1))
//SYSUT101 DD DSN=&SYSUT1,
// UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,PASS)
//SORTWK01 DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK02 DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK03 DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK04 DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//*
//SYSERR DD DSN=&SYSERR,
// UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,PASS)
//*
//SYSDISC DD DSN=&SYSDISC,
// UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,DELETE)
//*
//SYSREC DD DSN=ADU.EXAMPL18.SYSREC,DISP=SHR
//*
//SYSIN DD DSN=ADU.EXAMPL18.SYSCNTL,DISP=SHR
//**********************ADUEX18B ************************************
//*******************************************************************
//********* Unloading a table space and loading data as Unicode ****
//*******************************************************************
//* Replace "DB2SYS" by your DB2 subsystem name. *
//* Use your DB2 product install libraries for STEPLIBS : *
//* PRODUCT.LIBRARIES *
//* DB2.DSNEXIT *
//* DB2.DSNLOAD *
//*******************************************************************
//* LOAD AN IDENTICAL EBCDIC TABLESPACE EXISTING ON ANOTHER DB2
//* USING THE UNICODE DATA SYSREC CREATED IN ADUXM18A
//*******************************************************************
//LODPLUS1 EXEC PGM=AMUUMAIN,
// PARM='DB2SYS,ADUEX18B,NEW,,MSGLEVEL(1)'
//STEPLIB DD DISP=SHR,DSN=PRODUCT.LIBRARIES
// DD DSN=DB2.DSNEXIT,DISP=SHR
// DD DSN=DB2.DSNLOAD,DISP=SHR
//SYSPRINT DD DSN=ADU.EXAMPL18.SYSPRNTL,
// DISP=(NEW,CATLG),SPACE=(CYL,(1,1),RLSE),UNIT=SYSDA
//SYSOUT DD SYSOUT=*
//SORTOUT DD DSN=&SORTOUT,
// DISP=(NEW,PASS),UNIT=WORK,SPACE=(CYL,(1,1))
//SYSUT101 DD DSN=&SYSUT1,
// UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,PASS)
//SORTWK01 DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK02 DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK03 DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//SORTWK04 DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=NEW
//*
//SYSERR DD DSN=&SYSERR,
// UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,PASS)
//*
//SYSDISC DD DSN=&SYSDISC,
// UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,DELETE)
//*
//SYSREC DD DSN=ADU.EXAMPL18.SYSREC,DISP=SHR
//*
//SYSIN DD DSN=ADU.EXAMPL18.SYSCNTL,DISP=SHR
SYSPRINT for example 18 - UNLOAD PLUS
The following figure shows the UNLOAD PLUS SYSPRINT for example 18:
1 ***** B M C U N L O A D P L U S F O R D B 2 V13R1.00 *****
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
-BMC50001I UTILITY EXECUTION STARTING 8/23/2022 11:16:06 ...
BMC50002I UTILITY ID = 'ADUX18A'. DB2 SUBSYSTEM ID = 'DEMO'. OPTION MODULE = 'ADU$OPTS'.
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.5M,ABOVE 16M=1,006.6M,IEFUSI=NO,CPUs=7,GPs=5,zIIPs=2
BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
BMC50471I SMFID=DB2B,JOBID=J0940231,JOB=ADUEX18,STEP=UNLOADZA,CPU=8561-615 (z15)/1.71,72.0G
0
BMC50471I UNLOAD PLUS 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 BPE0557 BPE0560
0
BMC50471I ANALYZE=(DB2STATS,NOLIMIT) FORCE_RPT=NO SMAX=16
BMC50471I CENTURY=(1950,2049) FORCE=NONE SMCORE=(0K,0K)
BMC50471I CHANGE_CONSISTENT=NO HISTORY=YES SORTNUM=32
BMC50471I CHANGE_QUIESCE=NO IBUFFS=25 SQLDELAY=3
BMC50471I CMAX=16 INLINE=NO SQLRETRY=100
BMC50471I CMRATIO=50 LOADDECP=NO SSREPORT=REPORT_SWITCH
BMC50471I CONSTRULES=BMC LOCKROW=YES TAPEDISP=DELETE
BMC50471I CURRENTDEGREE=NONE MAXP=5 TASKMAX=200%
BMC50471I DELFILES=YES MSGLEVEL=1 UBUFFS=25
BMC50471I DRNDELAY=1 NULLCHAR=X'6F' UNLDMAX=200%
BMC50471I DRNRETRY=255 NULLTYPE=T1 UNLOADDN_ACTIVE=(YES,NO)
BMC50471I DRNWAIT=NONE OPNDB2ID=YES UNLOADDN=(SYSREC,SYSRED)
BMC50471I DSPLOCKS=DRNFAIL PLAN=ADU1310T USELRECL=NO
BMC50471I EXCLDUMP=(X37,X22,X06) RECFM=AUTO UXSTATE=SUP
BMC50471I FILEREFDN=SYSREF ROWSETSZ=100 WORKUNIT=SYSALLDA
BMC50471I FILL=NO SDUMP=YES ZIIP=ENABLED
BMC50471I FORCE_AT=(START,3) SHRLEVEL=REFERENCE ZONEDDECOVP=(C,D)
0
0
BMC50471I TAPES=NONE
0
BMC50470I OUTPUT = SYSREC SYSRED SYSREF
BMC50470I UNIT = SYSALLDA SYSALLDA SYSALLDA
BMC50470I VOLCNT = 25 25 25
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
BMC50470I STORCLAS = NONE NONE NONE
BMC50470I DATACLAS = NONE NONE NONE
BMC50470I MGMTCLAS = NONE NONE NONE
BMC50470I UNITCNT = 0 0 0
BMC50470I SPACE = CYL CYL CYL
BMC50470I PCTPRIM = AUTO AUTO AUTO
BMC50470I MAXPRIM = 0 0 0
BMC50470I MAXSECD = 0 0 0
BMC50470I FILESZPCT 100 100 100
BMC50470I NBRSECD = AUTO AUTO AUTO
BMC50470I DISKRETN = NONE NONE NONE
BMC50470I DISKEXPD = NONE NONE NONE
BMC50470I RETPD = NONE NONE NONE
BMC50470I EXPDT = 99000 99000 99000
BMC50470I TRTCH = NONE NONE NONE
BMC50470I DSNTYPE = NONE NONE LIBRARY
BMC50483I SYSREC VOLUMES=NONE
BMC50483I SYSRED VOLUMES=NONE
BMC50483I SYSREF VOLUMES=NONE
0
BMC50483I SYSREC DSNAME=&USERID.&TYPE.S&SELNUM
BMC50483I SYSRED DSNAME=&USERID.&TYPE.S&SELNUM
BMC50483I SYSREF DSNAME=&USERID.&TYPE.S&SELNUM
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_BMCXCOPY ='BMCUTIL.CMN_BMCXCOPY'
BMC50471I BMC_BMCSMARTSWITCH='BMCUTIL.CMN_BMCSWITCH'
BMC50471I BMC_BMCSSTRACKING ='BMCUTIL.CMN_BMCSSTRACK'
0
0
BMC50102I *
BMC50102I UNLOAD
BMC50102I TABLESPACE BMCEXDB.BMCEXBTS
BMC50102I UNICODE
BMC50102I AUTOTAG YES
BMC50102I CNTLCARDS 'REPLACE'
BMC50102I UNLOADDN SYSREC ACTIVE NO
BMC50102I *
BMC51654I DIRECT YES IN EFFECT
BMC51687I ESTIMATED ROWS FOR TABLE SPACE BMCEXDB.BMCEXBTS PART 0 IS 1296 FROM HURBA
BMC51688I ESTIMATED ROWS FOR TABLE BMC.RET_EMPLS IS 1296 FROM TABLESPACE
BMC51688I ESTIMATED ROWS FOR TABLE BMC.HRLY_EMPLS IS 1296 FROM TABLESPACE
BMC51688I ESTIMATED ROWS FOR TABLE BMC.SAL_EMPLS IS 1296 FROM TABLESPACE
BMC51657I GENERATED SELECT STATEMENTS:
BMC51658I SELECT 1 OBID 8 TABLE 'BMC.RET_EMPLS'
BMC51658I SELECT 2 OBID 9 TABLE 'BMC.HRLY_EMPLS'
BMC51658I SELECT 3 OBID 10 TABLE 'BMC.SAL_EMPLS'
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 NOT ACTIVATED, TABLE/ALIAS DOES NOT EXIST
BMC50199I UNLOAD PLUS PROCESSING CONTINUES
BMC51689I ESTIMATED ROWS FOR SELECT 1 IS 1296
BMC51689I ESTIMATED ROWS FOR SELECT 2 IS 1296
BMC51689I ESTIMATED ROWS FOR SELECT 3 IS 1296
BMC51639I FOR DDNAME 'SYSREC' DSN=ADU.EXAMPL18.SYSREC,DCB=(RECFM=VB,BLKSIZE=27998,LRECL=145)
BMC50894I PAGE EXTERNALIZATION PROCESS STARTING AT 8/23/2022 11:16:06
BMC50651I SPACE BMCEXDB.BMCEXBTS PART(0) PSID(0007)
BMC50895I PAGE EXTERNALIZATION PROCESS COMPLETE. ELAPSED TIME = 00:00:00
BMC50877I POINT OF CONSISTENCY ESTABLISHED AT RBA/LRSN = 0000000023457592AB00
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8488K, ABOVE 16M = 1020876K, CPUS = 5
BMC51701I MAX TASKS = 1, MAX PARTITIONS PER TASK = 1, SORTWKS PER TASK = 0, MAX OPEN PARTITIONS PER TASK = 1
BMC50477I 1: PARTITION = 0, ROWS/KEYS = 40, I/O WAITS = 2 ,DDNAME = SYS00002
BMC50478I 1: RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC51686I UNLOADING OF DATASET 'DEMOCAT.DSNDBD.BMCEXDB.BMCEXBTS.I0001.A001' READ 1706 PAGES
BMC51670I UNLOAD STATISTICS: 20 ROWS PROCESSED FROM TABLE 'BMC.RET_EMPLS', 0 NOT SELECTED, 0 DISCARDED
BMC51670I UNLOAD STATISTICS: 11 ROWS PROCESSED FROM TABLE 'BMC.HRLY_EMPLS', 0 NOT SELECTED, 0 DISCARDED
BMC51670I UNLOAD STATISTICS: 9 ROWS PROCESSED FROM TABLE 'BMC.SAL_EMPLS', 0 NOT SELECTED, 0 DISCARDED
BMC51672I UNLOAD STATISTICS: 40 ROWS PROCESSED FROM SPACE 'BMCEXDB.BMCEXBTS', 0 NOT SELECTED, 0 DISCARDED
BMC51674I UNLOAD STATISTICS: 40 RECORDS WRITTEN TO DDNAME 'SYSREC'
BMC51675I UNLOAD STATISTICS: 0 RECORDS DISCARDED DUE TO ERRORS
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I UNLOAD PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC51639I FOR DDNAME 'SYSCNTL' DSN=ADU.EXAMPL18.SYSCNTL,DCB=(RECFM=FB,BLKSIZE=3120,LRECL=80)
BMC51801I LOAD TABLE STATEMENTS WRITTEN TO DDNAME 'SYSCNTL'
0
BMC51810I LOAD DATA INDDN SYSREC
BMC51809I REPLACE
BMC51940I UNICODE CCSID(367,1208,1200)
BMC51811I INTO TABLE
BMC51809I BMC.RET_EMPLS
BMC51941I WHEN (1:4) = X'30303031'
BMC51813I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
BMC51813I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
BMC51815I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR MIXED(3)
BMC51813I ,EMPL_SALARY_HRLY POSITION(*:*+4) DECIMAL
BMC51814I NULLIF BMC_NULL1=X'3F'
BMC51819I , BMC_NULL1 POSITION(*) CHAR(1)
BMC51815I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR MIXED(12)
BMC51815I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE EXTERNAL(10)
BMC51814I NULLIF BMC_NULL2=X'3F'
BMC51819I , BMC_NULL2 POSITION(*) CHAR(1)
BMC51815I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP EXTERNAL(26)
BMC51809I )
BMC51811I INTO TABLE
BMC51809I BMC.HRLY_EMPLS
BMC51941I WHEN (1:4) = X'30303032'
BMC51813I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
BMC51813I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
BMC51815I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR MIXED(3)
BMC51813I ,EMPL_HRLY_RATE POSITION(*:*+4) DECIMAL
BMC51814I NULLIF BMC_NULL1=X'3F'
BMC51819I , BMC_NULL1 POSITION(*) CHAR(1)
BMC51815I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR MIXED(12)
BMC51815I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE EXTERNAL(10)
BMC51814I NULLIF BMC_NULL2=X'3F'
BMC51819I , BMC_NULL2 POSITION(*) CHAR(1)
BMC51815I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP EXTERNAL(26)
BMC51809I )
BMC51811I INTO TABLE
BMC51809I BMC.SAL_EMPLS
BMC51941I WHEN (1:4) = X'30303033'
BMC51813I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
BMC51813I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
BMC51815I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR MIXED(3)
BMC51813I ,EMPL_SALARY POSITION(*:*+4) DECIMAL
BMC51814I NULLIF BMC_NULL1=X'3F'
BMC51819I , BMC_NULL1 POSITION(*) CHAR(1)
BMC51815I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR MIXED(12)
BMC51815I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE EXTERNAL(10)
BMC51814I NULLIF BMC_NULL2=X'3F'
BMC51819I , BMC_NULL2 POSITION(*) CHAR(1)
BMC51815I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP EXTERNAL(26)
BMC51809I )
0
BMC50476I DDNAME = SYSCNTL, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
-BMC50001I UTILITY EXECUTION STARTING 8/23/2022 11:16:06 ...
BMC50002I UTILITY ID = 'ADUX18A'. DB2 SUBSYSTEM ID = 'DEMO'. OPTION MODULE = 'ADU$OPTS'.
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.5M,ABOVE 16M=1,006.6M,IEFUSI=NO,CPUs=7,GPs=5,zIIPs=2
BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
BMC50471I SMFID=DB2B,JOBID=J0940231,JOB=ADUEX18,STEP=UNLOADZA,CPU=8561-615 (z15)/1.71,72.0G
0
BMC50471I UNLOAD PLUS 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 BPE0557 BPE0560
0
BMC50471I ANALYZE=(DB2STATS,NOLIMIT) FORCE_RPT=NO SMAX=16
BMC50471I CENTURY=(1950,2049) FORCE=NONE SMCORE=(0K,0K)
BMC50471I CHANGE_CONSISTENT=NO HISTORY=YES SORTNUM=32
BMC50471I CHANGE_QUIESCE=NO IBUFFS=25 SQLDELAY=3
BMC50471I CMAX=16 INLINE=NO SQLRETRY=100
BMC50471I CMRATIO=50 LOADDECP=NO SSREPORT=REPORT_SWITCH
BMC50471I CONSTRULES=BMC LOCKROW=YES TAPEDISP=DELETE
BMC50471I CURRENTDEGREE=NONE MAXP=5 TASKMAX=200%
BMC50471I DELFILES=YES MSGLEVEL=1 UBUFFS=25
BMC50471I DRNDELAY=1 NULLCHAR=X'6F' UNLDMAX=200%
BMC50471I DRNRETRY=255 NULLTYPE=T1 UNLOADDN_ACTIVE=(YES,NO)
BMC50471I DRNWAIT=NONE OPNDB2ID=YES UNLOADDN=(SYSREC,SYSRED)
BMC50471I DSPLOCKS=DRNFAIL PLAN=ADU1310T USELRECL=NO
BMC50471I EXCLDUMP=(X37,X22,X06) RECFM=AUTO UXSTATE=SUP
BMC50471I FILEREFDN=SYSREF ROWSETSZ=100 WORKUNIT=SYSALLDA
BMC50471I FILL=NO SDUMP=YES ZIIP=ENABLED
BMC50471I FORCE_AT=(START,3) SHRLEVEL=REFERENCE ZONEDDECOVP=(C,D)
0
0
BMC50471I TAPES=NONE
0
BMC50470I OUTPUT = SYSREC SYSRED SYSREF
BMC50470I UNIT = SYSALLDA SYSALLDA SYSALLDA
BMC50470I VOLCNT = 25 25 25
BMC50470I GDGLIMIT = 5 5 5
BMC50470I GDGEMPTY = NO NO NO
BMC50470I GDGSCRAT = NO NO NO
BMC50470I STORCLAS = NONE NONE NONE
BMC50470I DATACLAS = NONE NONE NONE
BMC50470I MGMTCLAS = NONE NONE NONE
BMC50470I UNITCNT = 0 0 0
BMC50470I SPACE = CYL CYL CYL
BMC50470I PCTPRIM = AUTO AUTO AUTO
BMC50470I MAXPRIM = 0 0 0
BMC50470I MAXSECD = 0 0 0
BMC50470I FILESZPCT 100 100 100
BMC50470I NBRSECD = AUTO AUTO AUTO
BMC50470I DISKRETN = NONE NONE NONE
BMC50470I DISKEXPD = NONE NONE NONE
BMC50470I RETPD = NONE NONE NONE
BMC50470I EXPDT = 99000 99000 99000
BMC50470I TRTCH = NONE NONE NONE
BMC50470I DSNTYPE = NONE NONE LIBRARY
BMC50483I SYSREC VOLUMES=NONE
BMC50483I SYSRED VOLUMES=NONE
BMC50483I SYSREF VOLUMES=NONE
0
BMC50483I SYSREC DSNAME=&USERID.&TYPE.S&SELNUM
BMC50483I SYSRED DSNAME=&USERID.&TYPE.S&SELNUM
BMC50483I SYSREF DSNAME=&USERID.&TYPE.S&SELNUM
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_BMCXCOPY ='BMCUTIL.CMN_BMCXCOPY'
BMC50471I BMC_BMCSMARTSWITCH='BMCUTIL.CMN_BMCSWITCH'
BMC50471I BMC_BMCSSTRACKING ='BMCUTIL.CMN_BMCSSTRACK'
0
0
BMC50102I *
BMC50102I UNLOAD
BMC50102I TABLESPACE BMCEXDB.BMCEXBTS
BMC50102I UNICODE
BMC50102I AUTOTAG YES
BMC50102I CNTLCARDS 'REPLACE'
BMC50102I UNLOADDN SYSREC ACTIVE NO
BMC50102I *
BMC51654I DIRECT YES IN EFFECT
BMC51687I ESTIMATED ROWS FOR TABLE SPACE BMCEXDB.BMCEXBTS PART 0 IS 1296 FROM HURBA
BMC51688I ESTIMATED ROWS FOR TABLE BMC.RET_EMPLS IS 1296 FROM TABLESPACE
BMC51688I ESTIMATED ROWS FOR TABLE BMC.HRLY_EMPLS IS 1296 FROM TABLESPACE
BMC51688I ESTIMATED ROWS FOR TABLE BMC.SAL_EMPLS IS 1296 FROM TABLESPACE
BMC51657I GENERATED SELECT STATEMENTS:
BMC51658I SELECT 1 OBID 8 TABLE 'BMC.RET_EMPLS'
BMC51658I SELECT 2 OBID 9 TABLE 'BMC.HRLY_EMPLS'
BMC51658I SELECT 3 OBID 10 TABLE 'BMC.SAL_EMPLS'
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 NOT ACTIVATED, TABLE/ALIAS DOES NOT EXIST
BMC50199I UNLOAD PLUS PROCESSING CONTINUES
BMC51689I ESTIMATED ROWS FOR SELECT 1 IS 1296
BMC51689I ESTIMATED ROWS FOR SELECT 2 IS 1296
BMC51689I ESTIMATED ROWS FOR SELECT 3 IS 1296
BMC51639I FOR DDNAME 'SYSREC' DSN=ADU.EXAMPL18.SYSREC,DCB=(RECFM=VB,BLKSIZE=27998,LRECL=145)
BMC50894I PAGE EXTERNALIZATION PROCESS STARTING AT 8/23/2022 11:16:06
BMC50651I SPACE BMCEXDB.BMCEXBTS PART(0) PSID(0007)
BMC50895I PAGE EXTERNALIZATION PROCESS COMPLETE. ELAPSED TIME = 00:00:00
BMC50877I POINT OF CONSISTENCY ESTABLISHED AT RBA/LRSN = 0000000023457592AB00
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8488K, ABOVE 16M = 1020876K, CPUS = 5
BMC51701I MAX TASKS = 1, MAX PARTITIONS PER TASK = 1, SORTWKS PER TASK = 0, MAX OPEN PARTITIONS PER TASK = 1
BMC50477I 1: PARTITION = 0, ROWS/KEYS = 40, I/O WAITS = 2 ,DDNAME = SYS00002
BMC50478I 1: RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC51686I UNLOADING OF DATASET 'DEMOCAT.DSNDBD.BMCEXDB.BMCEXBTS.I0001.A001' READ 1706 PAGES
BMC51670I UNLOAD STATISTICS: 20 ROWS PROCESSED FROM TABLE 'BMC.RET_EMPLS', 0 NOT SELECTED, 0 DISCARDED
BMC51670I UNLOAD STATISTICS: 11 ROWS PROCESSED FROM TABLE 'BMC.HRLY_EMPLS', 0 NOT SELECTED, 0 DISCARDED
BMC51670I UNLOAD STATISTICS: 9 ROWS PROCESSED FROM TABLE 'BMC.SAL_EMPLS', 0 NOT SELECTED, 0 DISCARDED
BMC51672I UNLOAD STATISTICS: 40 ROWS PROCESSED FROM SPACE 'BMCEXDB.BMCEXBTS', 0 NOT SELECTED, 0 DISCARDED
BMC51674I UNLOAD STATISTICS: 40 RECORDS WRITTEN TO DDNAME 'SYSREC'
BMC51675I UNLOAD STATISTICS: 0 RECORDS DISCARDED DUE TO ERRORS
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I UNLOAD PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC51639I FOR DDNAME 'SYSCNTL' DSN=ADU.EXAMPL18.SYSCNTL,DCB=(RECFM=FB,BLKSIZE=3120,LRECL=80)
BMC51801I LOAD TABLE STATEMENTS WRITTEN TO DDNAME 'SYSCNTL'
0
BMC51810I LOAD DATA INDDN SYSREC
BMC51809I REPLACE
BMC51940I UNICODE CCSID(367,1208,1200)
BMC51811I INTO TABLE
BMC51809I BMC.RET_EMPLS
BMC51941I WHEN (1:4) = X'30303031'
BMC51813I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
BMC51813I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
BMC51815I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR MIXED(3)
BMC51813I ,EMPL_SALARY_HRLY POSITION(*:*+4) DECIMAL
BMC51814I NULLIF BMC_NULL1=X'3F'
BMC51819I , BMC_NULL1 POSITION(*) CHAR(1)
BMC51815I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR MIXED(12)
BMC51815I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE EXTERNAL(10)
BMC51814I NULLIF BMC_NULL2=X'3F'
BMC51819I , BMC_NULL2 POSITION(*) CHAR(1)
BMC51815I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP EXTERNAL(26)
BMC51809I )
BMC51811I INTO TABLE
BMC51809I BMC.HRLY_EMPLS
BMC51941I WHEN (1:4) = X'30303032'
BMC51813I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
BMC51813I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
BMC51815I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR MIXED(3)
BMC51813I ,EMPL_HRLY_RATE POSITION(*:*+4) DECIMAL
BMC51814I NULLIF BMC_NULL1=X'3F'
BMC51819I , BMC_NULL1 POSITION(*) CHAR(1)
BMC51815I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR MIXED(12)
BMC51815I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE EXTERNAL(10)
BMC51814I NULLIF BMC_NULL2=X'3F'
BMC51819I , BMC_NULL2 POSITION(*) CHAR(1)
BMC51815I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP EXTERNAL(26)
BMC51809I )
BMC51811I INTO TABLE
BMC51809I BMC.SAL_EMPLS
BMC51941I WHEN (1:4) = X'30303033'
BMC51813I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
BMC51813I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
BMC51815I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR MIXED(3)
BMC51813I ,EMPL_SALARY POSITION(*:*+4) DECIMAL
BMC51814I NULLIF BMC_NULL1=X'3F'
BMC51819I , BMC_NULL1 POSITION(*) CHAR(1)
BMC51815I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR MIXED(12)
BMC51815I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE EXTERNAL(10)
BMC51814I NULLIF BMC_NULL2=X'3F'
BMC51819I , BMC_NULL2 POSITION(*) CHAR(1)
BMC51815I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP EXTERNAL(26)
BMC51809I )
0
BMC50476I DDNAME = SYSCNTL, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0
SYSPRINT for example 18 - LOADPLUS
The following figure shows the LOADPLUS SYSPRINT for example 18:
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 8/23/2022 11:18:06 ...
BMC50002I UTILITY ID = 'ADUXM18B'. DB2 SUBSYSTEM ID = 'DEMO'. OPTION MODULE = 'AMU$OPTS'.
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.5M,ABOVE 16M=1,008.1M,IEFUSI=NO,CPUs=9,GPs=5,zIIPs=4
BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
BMC50471I SMFID=DB2B,JOBID=J0925571,JOB=ADUEX18,STEP=LODPLUS1,CPU=3931-612 (z16)/1.47,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 BPE0561
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=YES WORKDDN=SYSUT1
BMC50471I DSNUTILB=YES ORIGDISP=DELETE WORKUNIT=SYSALLDA
BMC50471I ENFORCE=CHECK PAUSEDISCARDRC=4 WRLOG=NO
BMC50471I ERRDDN=SYSERR PLAN=AMU1310D 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 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.&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
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'
BMC50102I LOAD DATA INDDN SYSREC
BMC50102I REPLACE
BMC50102I UNICODE CCSID(367,1208,1200)
BMC50102I INTO TABLE
BMC50102I BMC.RET_EMPLS
BMC50102I WHEN (1:4) = X'30303031'
BMC50102I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
BMC50102I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
BMC50102I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR MIXED(3)
BMC50102I ,EMPL_SALARY_HRLY POSITION(*:*+4) DECIMAL
BMC50102I NULLIF BMC_NULL1=X'3F'
BMC50102I , BMC_NULL1 POSITION(*) CHAR(1)
BMC50102I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR MIXED(12)
BMC50102I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE EXTERNAL(10)
BMC50102I NULLIF BMC_NULL2=X'3F'
BMC50102I , BMC_NULL2 POSITION(*) CHAR(1)
BMC50102I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP EXTERNAL(26)
BMC50102I )
BMC50102I INTO TABLE
BMC50102I BMC.HRLY_EMPLS
BMC50102I WHEN (1:4) = X'30303032'
BMC50102I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
BMC50102I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
BMC50102I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR MIXED(3)
BMC50102I ,EMPL_HRLY_RATE POSITION(*:*+4) DECIMAL
BMC50102I NULLIF BMC_NULL1=X'3F'
BMC50102I , BMC_NULL1 POSITION(*) CHAR(1)
BMC50102I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR MIXED(12)
BMC50102I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE EXTERNAL(10)
BMC50102I NULLIF BMC_NULL2=X'3F'
BMC50102I , BMC_NULL2 POSITION(*) CHAR(1)
BMC50102I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP EXTERNAL(26)
BMC50102I )
BMC50102I INTO TABLE
BMC50102I BMC.SAL_EMPLS
BMC50102I WHEN (1:4) = X'30303033'
BMC50102I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
BMC50102I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
BMC50102I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR MIXED(3)
BMC50102I ,EMPL_SALARY POSITION(*:*+4) DECIMAL
BMC50102I NULLIF BMC_NULL1=X'3F'
BMC50102I , BMC_NULL1 POSITION(*) CHAR(1)
BMC50102I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR MIXED(12)
BMC50102I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE EXTERNAL(10)
BMC50102I NULLIF BMC_NULL2=X'3F'
BMC50102I , BMC_NULL2 POSITION(*) CHAR(1)
BMC50102I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP EXTERNAL(26)
BMC50102I )
BMC51424I ANALYZE PHASE WILL BE PERFORMED DUE TO DYNAMIC WORK FILE ALLOCATION
BMC51403I FOR FIELD 'EMPL_FNAME', END POSITION IGNORED
BMC51403I FOR FIELD 'EMPL_FNAME', END POSITION IGNORED
BMC51403I FOR FIELD 'EMPL_FNAME', END POSITION IGNORED
BMC51561I CALCULATED NUMBER OF INPUT RECORDS = 378 USING A SCALING FACTOR OF 100% BMC50004I UTILINIT PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I ANALYZE PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50425I &JOBNAME = ADUEX18B &STEPNAME = LODPLUS1 &DB = BMCEXDB &TS = BMCEXBTS &UID = RDAMZL3
BMC50425I &RESUME = N &REPLACE = Y &DATE = 102813 &TIME = 141709 &SSID = DEMO
BMC50425I &UTIL = ADUXM18B &UTILPFX = ADUXM18B &UTILSFX = &DATE8 = 10282013 &GRPNM = DEMO
BMC50425I &VCAT = DEMOCAT &TIME4 = 1417 &DATEJ = 2013301 &JDATE = 13301
BMC50445I LOAD PLUS DYNAMIC FILE ALLOCATION REPORT
BMC50466W TEMPORARY DATASET NOT RECOMMENDED FOR DDNAME = 'SYSERR'
BMC50466W TEMPORARY DATASET NOT RECOMMENDED FOR DDNAME = 'SYSDISC'
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8432K, ABOVE 16M = 1407456K, CPUS = 3
BMC50479I TOTAL PAGES: 3077826, ALLOWED: 923348; AVAILABLE PAGES: 180530, ALLOWED: 0
BMC51499I COMBINED OPTIMIZATION, RC=0, #SORTS=1, #READERS=1, #INDEX TASKS=1, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=85760
BMC51500I COMBINED ANALYZE, #SORTS=1, #READERS=1, #INDEX TASKS=1, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0
BMC50486I 3: BMCSORT STARTED, 424K BELOW 16M, 1448K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51453I EXISTING ROWS IN TABLESPACE 'BMCEXDB.BMCEXBTS' DELETED
BMC50486I 2: BMCSORT STARTED, 344K BELOW 16M, 1368K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50481I 1: READ TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 1: READ TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 0
BMC51478I PRELOAD STATISTICS: 40 PHYSICAL (40 LOGICAL) RECORDS READ FROM SYSREC
BMC50481I 2: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50482I 2: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.BMCEXDB.BMCEXBTS.I0001.A001'
BMC50477I 2: PARTITION = 0, ROWS/KEYS = 40, I/O WAITS = 5 ,DDNAME = SYS00010
BMC50481I 2: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 2: SORT TASK, XBLK XFERS = 2, EMPTY WAITS = 0, FULL WAITS = 0
BMC50481I 3: INDEX SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50482I 3: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.BMCEXDB.RETIX1.I0001.A001'
BMC50477I 3: PARTITION = 0, ROWS/KEYS = 20, I/O WAITS = 7 ,DDNAME = SYS00014
BMC50482I 3: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.BMCEXDB.HRLYIX1.I0001.A001'
BMC50477I 3: PARTITION = 0, ROWS/KEYS = 11, I/O WAITS = 7 ,DDNAME = SYS00018
BMC50482I 3: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.BMCEXDB.SALIX1.I0001.A001'
BMC50477I 3: PARTITION = 0, ROWS/KEYS = 9, I/O WAITS = 7 ,DDNAME = SYS00022
BMC51476I BUILD STATISTICS: 20 KEYS LOADED INTO INDEX 'BMC.RETIX1'
BMC51476I BUILD STATISTICS: 11 KEYS LOADED INTO INDEX 'BMC.HRLYIX1'
BMC51476I BUILD STATISTICS: 9 KEYS LOADED INTO INDEX 'BMC.SALIX1'
BMC50481I 3: INDEX TASK COMPLETE. ELAPSED TIME = 00:00:02
BMC51510I 3: INDEX TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 2
BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC51507I XBLKS = 8, XFERS = 2, EMPTY WAITS = 0, FULL WAITS =2
BMC50476I DDNAME = SYSDISC, I/OS = 0, I/O WAITS = 0, RDB LOCK WAITS = 0
BMC51472I COMBINED PHASE STATISTICS: 40 ROWS SELECTED FOR SPACE 'BMCEXDB.BMCEXBTS', 0 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
BMC51479I COMBINED PHASE STATISTICS: 0 PHYSICAL (0 LOGICAL) RECORDS DISCARDED TO SYSDISC
BMC51473I LOAD STATISTICS: 20 ROWS LOADED INTO TABLE 'BMC.RET_EMPLS'
BMC51473I LOAD STATISTICS: 11 ROWS LOADED INTO TABLE 'BMC.HRLY_EMPLS'
BMC51473I LOAD STATISTICS: 9 ROWS LOADED INTO TABLE 'BMC.SAL_EMPLS'
BMC51475I LOAD STATISTICS: 40 ROWS LOADED INTO TABLE SPACE 'BMCEXDB.BMCEXBTS'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK01', DSNAME = 'SYS13301.T141708.RA000.ADUEX18B.R0322579'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK02', DSNAME = 'SYS13301.T141708.RA000.ADUEX18B.R0322580'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK03', DSNAME = 'SYS13301.T141708.RA000.ADUEX18B.R0322581'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK04', DSNAME = 'SYS13301.T141708.RA000.ADUEX18B.R0322582'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I COMBINED PHASE COMPLETE. ELAPSED TIME = 00:00:03
BMC50501I DB2 OBJECT STATISTICS
BMC50515I TABLESPACE BMCEXDB.BMCEXBTS PARTS = 0 TABLES = 3 SEGSIZE = 32 DSSIZE = 0G PAGESIZE = 4K
BMC50516I PART NACTIVE CARD EXTENTS DBCARD PCOMP KSAVED PSAVED
BMC50517I 0 66 40 1 0 0 0 0
BMC50518I TABLE BMC.RET_EMPLS
BMC50519I ROWAVG NPAGES CARD PCTPAGES
BMC50520I 43 1 20 3
BMC50525I INDEX BMC.RETIX1
BMC50526I FIRST KEY COLUMN = EMPL_LNAME
BMC50527I CLUSTER = N UNIQUE = D COMPRESS = N PAGESIZE = 4K KEYLEN = 29 COLCOUNT = 2
BMC50528I PART NACTIVE CARD EXTENTS LEVELS
BMC50529I 0 5 20 1 2
BMC50518I TABLE BMC.HRLY_EMPLS
BMC50519I ROWAVG NPAGES CARD PCTPAGES
BMC50520I 43 1 11 3
BMC50525I INDEX BMC.HRLYIX1
BMC50526I FIRST KEY COLUMN = EMPL_LNAME
BMC50527I CLUSTER = N UNIQUE = D COMPRESS = N PAGESIZE = 4K KEYLEN = 29 COLCOUNT = 2
BMC50528I PART NACTIVE CARD EXTENTS LEVELS
BMC50529I 0 5 11 1 2
BMC50518I TABLE BMC.SAL_EMPLS
BMC50519I ROWAVG NPAGES CARD PCTPAGES
BMC50520I 42 1 9 3
BMC50525I INDEX BMC.SALIX1
BMC50526I FIRST KEY COLUMN = EMPL_LNAME
BMC50527I CLUSTER = N UNIQUE = D COMPRESS = N PAGESIZE = 4K KEYLEN = 29 COLCOUNT = 2
BMC50528I PART NACTIVE CARD EXTENTS LEVELS
BMC50529I 0 5 9 1 2
BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR LOAD UTILITY SUCCESSFUL FOR ALL OBJECTS
BMC50386W IMAGE COPY REQUIRED. TABLE SPACE BMCEXDB.BMCEXBTS REMAINS IN 'COPY PENDING' STATE BMC50004I UTILTERM PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50006I 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 8/23/2022 11:18:06 ...
BMC50002I UTILITY ID = 'ADUXM18B'. DB2 SUBSYSTEM ID = 'DEMO'. OPTION MODULE = 'AMU$OPTS'.
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.5M,ABOVE 16M=1,008.1M,IEFUSI=NO,CPUs=9,GPs=5,zIIPs=4
BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
BMC50471I SMFID=DB2B,JOBID=J0925571,JOB=ADUEX18,STEP=LODPLUS1,CPU=3931-612 (z16)/1.47,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 BPE0561
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=YES WORKDDN=SYSUT1
BMC50471I DSNUTILB=YES ORIGDISP=DELETE WORKUNIT=SYSALLDA
BMC50471I ENFORCE=CHECK PAUSEDISCARDRC=4 WRLOG=NO
BMC50471I ERRDDN=SYSERR PLAN=AMU1310D 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 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.&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
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'
BMC50102I LOAD DATA INDDN SYSREC
BMC50102I REPLACE
BMC50102I UNICODE CCSID(367,1208,1200)
BMC50102I INTO TABLE
BMC50102I BMC.RET_EMPLS
BMC50102I WHEN (1:4) = X'30303031'
BMC50102I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
BMC50102I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
BMC50102I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR MIXED(3)
BMC50102I ,EMPL_SALARY_HRLY POSITION(*:*+4) DECIMAL
BMC50102I NULLIF BMC_NULL1=X'3F'
BMC50102I , BMC_NULL1 POSITION(*) CHAR(1)
BMC50102I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR MIXED(12)
BMC50102I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE EXTERNAL(10)
BMC50102I NULLIF BMC_NULL2=X'3F'
BMC50102I , BMC_NULL2 POSITION(*) CHAR(1)
BMC50102I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP EXTERNAL(26)
BMC50102I )
BMC50102I INTO TABLE
BMC50102I BMC.HRLY_EMPLS
BMC50102I WHEN (1:4) = X'30303032'
BMC50102I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
BMC50102I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
BMC50102I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR MIXED(3)
BMC50102I ,EMPL_HRLY_RATE POSITION(*:*+4) DECIMAL
BMC50102I NULLIF BMC_NULL1=X'3F'
BMC50102I , BMC_NULL1 POSITION(*) CHAR(1)
BMC50102I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR MIXED(12)
BMC50102I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE EXTERNAL(10)
BMC50102I NULLIF BMC_NULL2=X'3F'
BMC50102I , BMC_NULL2 POSITION(*) CHAR(1)
BMC50102I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP EXTERNAL(26)
BMC50102I )
BMC50102I INTO TABLE
BMC50102I BMC.SAL_EMPLS
BMC50102I WHEN (1:4) = X'30303033'
BMC50102I (EMPL_LNAME POSITION(5:*) VARCHAR MIXED
BMC50102I ,EMPL_FNAME POSITION(*:*) VARCHAR MIXED
BMC50102I ,EMPL_SALARY_CODE POSITION(*:*+2) CHAR MIXED(3)
BMC50102I ,EMPL_SALARY POSITION(*:*+4) DECIMAL
BMC50102I NULLIF BMC_NULL1=X'3F'
BMC50102I , BMC_NULL1 POSITION(*) CHAR(1)
BMC50102I ,EMPL_DEPT_NO POSITION(*:*+11) CHAR MIXED(12)
BMC50102I ,EMPL_HIRE_DATE POSITION(*:*+9) DATE EXTERNAL(10)
BMC50102I NULLIF BMC_NULL2=X'3F'
BMC50102I , BMC_NULL2 POSITION(*) CHAR(1)
BMC50102I ,EMPL_REC_CREATED POSITION(*:*+25) TIMESTAMP EXTERNAL(26)
BMC50102I )
BMC51424I ANALYZE PHASE WILL BE PERFORMED DUE TO DYNAMIC WORK FILE ALLOCATION
BMC51403I FOR FIELD 'EMPL_FNAME', END POSITION IGNORED
BMC51403I FOR FIELD 'EMPL_FNAME', END POSITION IGNORED
BMC51403I FOR FIELD 'EMPL_FNAME', END POSITION IGNORED
BMC51561I CALCULATED NUMBER OF INPUT RECORDS = 378 USING A SCALING FACTOR OF 100% BMC50004I UTILINIT PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I ANALYZE PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50425I &JOBNAME = ADUEX18B &STEPNAME = LODPLUS1 &DB = BMCEXDB &TS = BMCEXBTS &UID = RDAMZL3
BMC50425I &RESUME = N &REPLACE = Y &DATE = 102813 &TIME = 141709 &SSID = DEMO
BMC50425I &UTIL = ADUXM18B &UTILPFX = ADUXM18B &UTILSFX = &DATE8 = 10282013 &GRPNM = DEMO
BMC50425I &VCAT = DEMOCAT &TIME4 = 1417 &DATEJ = 2013301 &JDATE = 13301
BMC50445I LOAD PLUS DYNAMIC FILE ALLOCATION REPORT
BMC50466W TEMPORARY DATASET NOT RECOMMENDED FOR DDNAME = 'SYSERR'
BMC50466W TEMPORARY DATASET NOT RECOMMENDED FOR DDNAME = 'SYSDISC'
BMC50041I 0: ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50474I BELOW 16M = 8432K, ABOVE 16M = 1407456K, CPUS = 3
BMC50479I TOTAL PAGES: 3077826, ALLOWED: 923348; AVAILABLE PAGES: 180530, ALLOWED: 0
BMC51499I COMBINED OPTIMIZATION, RC=0, #SORTS=1, #READERS=1, #INDEX TASKS=1, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0, TIME=85760
BMC51500I COMBINED ANALYZE, #SORTS=1, #READERS=1, #INDEX TASKS=1, #PROBE TASKS=0, #LOB TASKS=0, #XML TASKS=0
BMC50486I 3: BMCSORT STARTED, 424K BELOW 16M, 1448K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC51453I EXISTING ROWS IN TABLESPACE 'BMCEXDB.BMCEXBTS' DELETED
BMC50486I 2: BMCSORT STARTED, 344K BELOW 16M, 1368K TOTAL MEMORY, 0 PAGES HYPERSPACE
BMC50481I 1: READ TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 1: READ TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 0
BMC51478I PRELOAD STATISTICS: 40 PHYSICAL (40 LOGICAL) RECORDS READ FROM SYSREC
BMC50481I 2: SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50482I 2: LOAD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.BMCEXDB.BMCEXBTS.I0001.A001'
BMC50477I 2: PARTITION = 0, ROWS/KEYS = 40, I/O WAITS = 5 ,DDNAME = SYS00010
BMC50481I 2: DATA TASK COMPLETE. ELAPSED TIME = 00:00:00
BMC51510I 2: SORT TASK, XBLK XFERS = 2, EMPTY WAITS = 0, FULL WAITS = 0
BMC50481I 3: INDEX SORT COMPLETE. ELAPSED TIME = 00:00:00
BMC50482I 3: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.BMCEXDB.RETIX1.I0001.A001'
BMC50477I 3: PARTITION = 0, ROWS/KEYS = 20, I/O WAITS = 7 ,DDNAME = SYS00014
BMC50482I 3: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.BMCEXDB.HRLYIX1.I0001.A001'
BMC50477I 3: PARTITION = 0, ROWS/KEYS = 11, I/O WAITS = 7 ,DDNAME = SYS00018
BMC50482I 3: BUILD COMPLETE. ELAPSED TIME = 00:00:00 DSN = 'DEMOCAT.DSNDBD.BMCEXDB.SALIX1.I0001.A001'
BMC50477I 3: PARTITION = 0, ROWS/KEYS = 9, I/O WAITS = 7 ,DDNAME = SYS00022
BMC51476I BUILD STATISTICS: 20 KEYS LOADED INTO INDEX 'BMC.RETIX1'
BMC51476I BUILD STATISTICS: 11 KEYS LOADED INTO INDEX 'BMC.HRLYIX1'
BMC51476I BUILD STATISTICS: 9 KEYS LOADED INTO INDEX 'BMC.SALIX1'
BMC50481I 3: INDEX TASK COMPLETE. ELAPSED TIME = 00:00:02
BMC51510I 3: INDEX TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 2
BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC50476I DDNAME = SYSREC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
BMC51507I XBLKS = 8, XFERS = 2, EMPTY WAITS = 0, FULL WAITS =2
BMC50476I DDNAME = SYSDISC, I/OS = 0, I/O WAITS = 0, RDB LOCK WAITS = 0
BMC51472I COMBINED PHASE STATISTICS: 40 ROWS SELECTED FOR SPACE 'BMCEXDB.BMCEXBTS', 0 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
BMC51479I COMBINED PHASE STATISTICS: 0 PHYSICAL (0 LOGICAL) RECORDS DISCARDED TO SYSDISC
BMC51473I LOAD STATISTICS: 20 ROWS LOADED INTO TABLE 'BMC.RET_EMPLS'
BMC51473I LOAD STATISTICS: 11 ROWS LOADED INTO TABLE 'BMC.HRLY_EMPLS'
BMC51473I LOAD STATISTICS: 9 ROWS LOADED INTO TABLE 'BMC.SAL_EMPLS'
BMC51475I LOAD STATISTICS: 40 ROWS LOADED INTO TABLE SPACE 'BMCEXDB.BMCEXBTS'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK01', DSNAME = 'SYS13301.T141708.RA000.ADUEX18B.R0322579'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK02', DSNAME = 'SYS13301.T141708.RA000.ADUEX18B.R0322580'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK03', DSNAME = 'SYS13301.T141708.RA000.ADUEX18B.R0322581'
BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SORTWK04', DSNAME = 'SYS13301.T141708.RA000.ADUEX18B.R0322582'
BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
BMC50004I COMBINED PHASE COMPLETE. ELAPSED TIME = 00:00:03
BMC50501I DB2 OBJECT STATISTICS
BMC50515I TABLESPACE BMCEXDB.BMCEXBTS PARTS = 0 TABLES = 3 SEGSIZE = 32 DSSIZE = 0G PAGESIZE = 4K
BMC50516I PART NACTIVE CARD EXTENTS DBCARD PCOMP KSAVED PSAVED
BMC50517I 0 66 40 1 0 0 0 0
BMC50518I TABLE BMC.RET_EMPLS
BMC50519I ROWAVG NPAGES CARD PCTPAGES
BMC50520I 43 1 20 3
BMC50525I INDEX BMC.RETIX1
BMC50526I FIRST KEY COLUMN = EMPL_LNAME
BMC50527I CLUSTER = N UNIQUE = D COMPRESS = N PAGESIZE = 4K KEYLEN = 29 COLCOUNT = 2
BMC50528I PART NACTIVE CARD EXTENTS LEVELS
BMC50529I 0 5 20 1 2
BMC50518I TABLE BMC.HRLY_EMPLS
BMC50519I ROWAVG NPAGES CARD PCTPAGES
BMC50520I 43 1 11 3
BMC50525I INDEX BMC.HRLYIX1
BMC50526I FIRST KEY COLUMN = EMPL_LNAME
BMC50527I CLUSTER = N UNIQUE = D COMPRESS = N PAGESIZE = 4K KEYLEN = 29 COLCOUNT = 2
BMC50528I PART NACTIVE CARD EXTENTS LEVELS
BMC50529I 0 5 11 1 2
BMC50518I TABLE BMC.SAL_EMPLS
BMC50519I ROWAVG NPAGES CARD PCTPAGES
BMC50520I 42 1 9 3
BMC50525I INDEX BMC.SALIX1
BMC50526I FIRST KEY COLUMN = EMPL_LNAME
BMC50527I CLUSTER = N UNIQUE = D COMPRESS = N PAGESIZE = 4K KEYLEN = 29 COLCOUNT = 2
BMC50528I PART NACTIVE CARD EXTENTS LEVELS
BMC50529I 0 5 9 1 2
BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR LOAD UTILITY SUCCESSFUL FOR ALL OBJECTS
BMC50386W IMAGE COPY REQUIRED. TABLE SPACE BMCEXDB.BMCEXBTS REMAINS IN 'COPY PENDING' STATE BMC50004I UTILTERM PHASE COMPLETE. ELAPSED TIME = 00:00:00
BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 4
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*