1 J E S 2 J O B L O G -- S Y S T E M S T L 1 -- N O D E S T L V M 3 2 0 09.22.43 JOB00111 ---- TUESDAY, 30 JUL 2019 ---- 09.22.43 JOB00111 IRR010I USERID SYSADM IS ASSIGNED TO THIS JOB. 09.22.43 JOB00111 ICH70001I SYSADM LAST ACCESS AT 09:17:06 ON TUESDAY, JULY 30, 2019 09.22.43 JOB00111 $HASP373 SYSADM1 STARTED - INIT 8 - CLASS A - SYS STL1 09.22.44 JOB00111 SMF000I SYSADM1 CREATE IKJEFT1A 0000 09.22.44 JOB00111 SMF000I SYSADM1 INSERT IKJEFT1A 0000 09.22.45 JOB00111 SMF000I SYSADM1 SELECTA IKJEFT1A 0000 09.22.45 JOB00111 SMF000I SYSADM1 UNLOAD DSNUTILB 0000 09.22.45 JOB00111 $HASP395 SYSADM1 ENDED - RC=0000 0------ JES2 JOB STATISTICS ------ - 30 JUL 2019 JOB EXECUTION DATE - 78 CARDS READ - 307 SYSOUT PRINT RECORDS - 0 SYSOUT PUNCH RECORDS - 23 SYSOUT SPOOL KBYTES - 0.02 MINUTES EXECUTION TIME 1 //SYSADM1 JOB (THXXTXXT870220),'FACH 20',NOTIFY=&SYSUID, JOB00111 // CLASS=A,MSGLEVEL=(1,1),REGION=128M //*************************************************************** IEFC653I SUBSTITUTION JCL - (THXXTXXT870220),'FACH 20',NOTIFY=SYSADM,CLASS=A,MSGLEVEL=(1,1),REGION=128M 2 //CREATE EXEC PGM=IKJEFT1A 3 //STEPLIB DD DISP=SHR,DSN=DB2A.SDSNLOAD 4 //SYSTSPRT DD SYSOUT=* 5 //SYSPRINT DD SYSOUT=* 6 //SYSTSIN DD * 7 //SYSIN DD * //*************************************************************** 8 //INSERT EXEC PGM=IKJEFT1A 9 //STEPLIB DD DISP=SHR,DSN=DB2A.SDSNLOAD 10 //SYSTSPRT DD SYSOUT=* 11 //SYSPRINT DD SYSOUT=* 12 //SYSTSIN DD * 13 //SYSIN DD * //*************************************************************** 14 //SELECTA EXEC PGM=IKJEFT1A 15 //STEPLIB DD DISP=SHR,DSN=DB2A.SDSNLOAD 16 //SYSTSPRT DD SYSOUT=* 17 //SYSPRINT DD SYSOUT=* 18 //SYSTSIN DD * 19 //SYSIN DD * //********************************************************************* 20 //UNLOAD EXEC PGM=DSNUTILB,REGION=4096K, // PARM='DB2A,SZI1001' 21 //STEPLIB DD DSN=DB2A.SDSNLOAD,DISP=SHR 22 //SYSDISC DD SYSOUT=* 23 //SYSPUNCH DD SYSOUT=* 24 //SYSREC DD SYSOUT=* 25 //UTPRINT DD SYSOUT=* 26 //SYSPRINT DD SYSOUT=* 27 //SYSIN DD * ICH70001I SYSADM LAST ACCESS AT 09:17:06 ON TUESDAY, JULY 30, 2019 IEFA111I SYSADM1 IS USING THE FOLLOWING JOB RELATED SETTINGS: SWA=BELOW,TIOT SIZE=64K,DSENQSHR=DISALLOW,GDGBIAS=JOB IEF236I ALLOC. FOR SYSADM1 CREATE IEF237I 0E57 ALLOCATED TO STEPLIB IEF237I JES2 ALLOCATED TO SYSTSPRT IEF237I JES2 ALLOCATED TO SYSPRINT IEF237I JES2 ALLOCATED TO SYSTSIN IEF237I JES2 ALLOCATED TO SYSIN IEF237I 04B0 ALLOCATED TO SYS00001 IEF285I SYSADM.VC10.LOAD KEPT IEF285I VOL SER NOS= USER01. IEF142I SYSADM1 CREATE - STEP WAS EXECUTED - COND CODE 0000 IEF285I DB2A.SDSNLOAD KEPT IEF285I VOL SER NOS= ADBRSL. IEF285I SYSADM.SYSADM1.JOB00111.D0000108.? SYSOUT IEF285I SYSADM.SYSADM1.JOB00111.D0000109.? SYSOUT IEF285I SYSADM.SYSADM1.JOB00111.D0000101.? SYSIN IEF285I SYSADM.SYSADM1.JOB00111.D0000102.? SYSIN IEF373I STEP/CREATE /START 2019211.0922 IEF032I STEP/CREATE /STOP 2019211.0922 CPU: 0 HR 00 MIN 00.03 SEC SRB: 0 HR 00 MIN 00.01 SEC VIRT: 592K SYS: 428K EXT: 13616K SYS: 11696K ATB- REAL: 24K SLOTS: 0K VIRT- ALLOC: 12M SHRD: 0M IEF236I ALLOC. FOR SYSADM1 INSERT IEF237I 0E57 ALLOCATED TO STEPLIB IEF237I JES2 ALLOCATED TO SYSTSPRT IEF237I JES2 ALLOCATED TO SYSPRINT IEF237I JES2 ALLOCATED TO SYSTSIN IEF237I JES2 ALLOCATED TO SYSIN IEF237I 04B0 ALLOCATED TO SYS00002 IEF285I SYSADM.VC10.LOAD KEPT IEF285I VOL SER NOS= USER01. IEF142I SYSADM1 INSERT - STEP WAS EXECUTED - COND CODE 0000 IEF285I DB2A.SDSNLOAD KEPT IEF285I VOL SER NOS= ADBRSL. IEF285I SYSADM.SYSADM1.JOB00111.D0000110.? SYSOUT IEF285I SYSADM.SYSADM1.JOB00111.D0000111.? SYSOUT IEF285I SYSADM.SYSADM1.JOB00111.D0000103.? SYSIN IEF285I SYSADM.SYSADM1.JOB00111.D0000104.? SYSIN IEF373I STEP/INSERT /START 2019211.0922 IEF032I STEP/INSERT /STOP 2019211.0922 CPU: 0 HR 00 MIN 00.01 SEC SRB: 0 HR 00 MIN 00.01 SEC VIRT: 592K SYS: 428K EXT: 13616K SYS: 11700K ATB- REAL: 24K SLOTS: 0K VIRT- ALLOC: 12M SHRD: 0M IEF236I ALLOC. FOR SYSADM1 SELECTA IEF237I 0E57 ALLOCATED TO STEPLIB IEF237I JES2 ALLOCATED TO SYSTSPRT IEF237I JES2 ALLOCATED TO SYSPRINT IEF237I JES2 ALLOCATED TO SYSTSIN IEF237I JES2 ALLOCATED TO SYSIN IEF237I 04B0 ALLOCATED TO SYS00003 IEF285I SYSADM.VC10.LOAD KEPT IEF285I VOL SER NOS= USER01. IEF142I SYSADM1 SELECTA - STEP WAS EXECUTED - COND CODE 0000 IEF285I DB2A.SDSNLOAD KEPT IEF285I VOL SER NOS= ADBRSL. IEF285I SYSADM.SYSADM1.JOB00111.D0000112.? SYSOUT IEF285I SYSADM.SYSADM1.JOB00111.D0000113.? SYSOUT IEF285I SYSADM.SYSADM1.JOB00111.D0000105.? SYSIN IEF285I SYSADM.SYSADM1.JOB00111.D0000106.? SYSIN IEF373I STEP/SELECTA /START 2019211.0922 IEF032I STEP/SELECTA /STOP 2019211.0922 CPU: 0 HR 00 MIN 00.01 SEC SRB: 0 HR 00 MIN 00.01 SEC VIRT: 592K SYS: 428K EXT: 13516K SYS: 11704K ATB- REAL: 24K SLOTS: 0K VIRT- ALLOC: 12M SHRD: 0M IEF236I ALLOC. FOR SYSADM1 UNLOAD IEF237I 0E57 ALLOCATED TO STEPLIB IEF237I JES2 ALLOCATED TO SYSDISC IEF237I JES2 ALLOCATED TO SYSPUNCH IEF237I JES2 ALLOCATED TO SYSREC IEF237I JES2 ALLOCATED TO UTPRINT IEF237I JES2 ALLOCATED TO SYSPRINT IEF237I JES2 ALLOCATED TO SYSIN IEF142I SYSADM1 UNLOAD - STEP WAS EXECUTED - COND CODE 0000 IEF285I DB2A.SDSNLOAD KEPT IEF285I VOL SER NOS= ADBRSL. IEF285I SYSADM.SYSADM1.JOB00111.D0000114.? SYSOUT IEF285I SYSADM.SYSADM1.JOB00111.D0000115.? SYSOUT IEF285I SYSADM.SYSADM1.JOB00111.D0000116.? SYSOUT IEF285I SYSADM.SYSADM1.JOB00111.D0000117.? SYSOUT IEF285I SYSADM.SYSADM1.JOB00111.D0000118.? SYSOUT IEF285I SYSADM.SYSADM1.JOB00111.D0000107.? SYSIN IEF373I STEP/UNLOAD /START 2019211.0922 IEF032I STEP/UNLOAD /STOP 2019211.0922 CPU: 0 HR 00 MIN 00.01 SEC SRB: 0 HR 00 MIN 00.00 SEC VIRT: 132K SYS: 332K EXT: 2800K SYS: 11500K ATB- REAL: 28K SLOTS: 0K VIRT- ALLOC: 13M SHRD: 1015808M IEF375I JOB/SYSADM1 /START 2019211.0922 IEF033I JOB/SYSADM1 /STOP 2019211.0922 CPU: 0 HR 00 MIN 00.06 SEC SRB: 0 HR 00 MIN 00.03 SEC 1READY DSN SYSTEM(DB2A) DSN RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) LIB('SYSADM.VC10.LOAD') DSN END 1 1PAGE 1 ***INPUT STATEMENT: DROP DATABASE SZI10D ; RESULT OF SQL STATEMENT: DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION DSNT418I SQLSTATE = 00000 SQLSTATE RETURN CODE DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION DROP SUCCESSFUL 1PAGE 1 ***INPUT STATEMENT: COMMIT ; RESULT OF SQL STATEMENT: DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION DSNT418I SQLSTATE = 00000 SQLSTATE RETURN CODE DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION COMMIT SUCCESSFUL 1PAGE 1 ***INPUT STATEMENT: CREATE DATABASE SZI10D STOGROUP DB200G ; RESULT OF SQL STATEMENT: DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION DSNT418I SQLSTATE = 00000 SQLSTATE RETURN CODE DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION CREATE SUCCESSFUL 1PAGE 1 ***INPUT STATEMENT: CREATE TABLESPACE SZI10S IN SZI10D SEGSIZE 4 MAXPARTITIONS 4 --NUMPARTS 4 USING STOGROUP DB200G BUFFERPOOL BP0 LOCKSIZE ROW MAXROWS 1 COMPRESS NO --MEMBER CLUSTER --INSERT ALGORITHM 1 ; RESULT OF SQL STATEMENT: DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION DSNT418I SQLSTATE = 00000 SQLSTATE RETURN CODE DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION CREATE SUCCESSFUL 1PAGE 1 ***INPUT STATEMENT: CREATE TABLE SZI10T ( PNR DEC( 15 , 0) NOT NULL , WOHNORT CHAR(20) , COL3 CHAR(40) , COL_TZ TIMESTAMP WITH DEFAULT ) IN SZI10D.SZI10S ; RESULT OF SQL STATEMENT: DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION DSNT418I SQLSTATE = 00000 SQLSTATE RETURN CODE DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION CREATE SUCCESSFUL 1READY DSN SYSTEM(DB2A) DSN RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) LIB('SYSADM.VC10.LOAD') DSN END 1 1PAGE 1 ***INPUT STATEMENT: INSERT INTO SZI10T (PNR, WOHNORT , COL3, COL_TZ) VALUES ( 1 , 'TEST' , 'TEST' , DEFAULT) ; RESULT OF SQL STATEMENT: DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION DSNT418I SQLSTATE = 00000 SQLSTATE RETURN CODE DSNT416I SQLERRD = 0 0 1 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000000' X'00000000' X'00000001' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION SUCCESSFUL INSERT OF 1 ROW(S) 1READY DSN SYSTEM(DB2A) DSN RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) LIB('SYSADM.VC10.LOAD') DSN END 1 1PAGE 1 ***INPUT STATEMENT: SELECT * FROM SZI10T WHERE (COL_TZ BETWEEN '2019-07-30-06.00.00.000000' AND '2019-07-30-10.00.00.000000' ) WITH UR ; +-------------------------------------------------------------------------------------------------------------------+ ! PNR ! WOHNORT ! COL3 ! COL_TZ ! +-------------------------------------------------------------------------------------------------------------------+ 1_! 1 ! TEST ! TEST ! 2019-07-30-09.22.44.866385 ! +-------------------------------------------------------------------------------------------------------------------+ 0SUCCESSFUL RETRIEVAL OF 1 ROW(S) LOAD DATA INDDN SYSREC LOG NO RESUME YES EBCDIC CCSID(00037,00000,00000) INTO TABLE "SYSADM". "SZI10T" WHEN(00001:00002) = X'0003' NUMRECS 1 ( "PNR" POSITION( 00003:00010) DECIMAL , "WOHNORT" POSITION( 00012:00031) CHAR(00020) NULLIF(00011)=X'FF' , "COL3" POSITION( 00033:00072) CHAR(00040) NULLIF(00032)=X'FF' , "COL_TZ" POSITION( 00074:00099) TIMESTAMP EXTERNAL(026) NULLIF(00073)=X'FF' ) TEST TEST 2019-07-30-09.22.44.866385 1DSNU000I 211 09:22:45.25 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = SZI1001 DSNU1044I 211 09:22:45.26 DSNUGTIS - PROCESSING SYSIN AS EBCDIC 0DSNU050I 211 09:22:45.26 DSNUGUTC - UNLOAD DATA DSNU650I -DB2A 211 09:22:45.26 DSNUUGMS - FROM TABLE SZI10T WHEN DSNU650I -DB2A 211 09:22:45.26 DSNUUGMS - (COL_TZ BETWEEN '2019-07-30-06.00.00.000000' DSNU650I -DB2A 211 09:22:45.26 DSNUUGMS - AND '2019-07-30-10.00.00.000000') DSNU253I 211 09:22:45.28 DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=1 FOR TABLE SYSADM.SZI10T DSNU252I 211 09:22:45.28 DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=1 FOR TABLESPACE SZI10D.SZI10S DSNU250I 211 09:22:45.28 DSNUUNLD - UNLOAD PHASE COMPLETE, ELAPSED TIME=00:00:00 DSNU010I 211 09:22:45.29 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0