>On Fri, 28 Oct 2016 18:12:01 -0500, Janet Graff <[email protected]> wrote:
>>I have the program pre-compile, compile, pre-linking, linking and binding all
>>with return code zeros.
>Can we see the JCL, or better still, the entire job log?
>>
>>But when I try to RUN I get a -904 indicating that the resource is
>>unavailable because the package is in a non-executable state. Since the BIND
>>>output all says it completed successfully I must be misspecifying something.
>>
>Same thing: can we see the complete run?
>Cheers,
>Jantje.
Truncations on the right side of the JES output, let me know if you need that
data
J E S 2 J O B L O G -- S Y S T E M S 0 W 1 -- N O D E
14.00.14 JOB03255 ---- MONDAY, 31 OCT 2016 ----
14.00.14 JOB03255 IRR010I USERID JIG IS ASSIGNED TO THIS JOB.
14.00.14 JOB03255 ICH70001I JIG LAST ACCESS AT 13:59:56 ON MONDAY, OCTOBER
14.00.14 JOB03255 $HASP373 JIGDB2R STARTED - INIT 2 - CLASS A - SYS S0W1
14.00.16 JOB03255 - -----TIMINGS (MINS.)--
14.00.16 JOB03255 -STEPNAME PROCSTEP RC EXCP CONN TCB SRB C
14.00.16 JOB03255 -RUN 00 2757 528 .00 .00
14.00.16 JOB03255 -JIGDB2R ENDED. NAME- TOTAL TCB CPU TIM
14.00.16 JOB03255 $HASP395 JIGDB2R ENDED
------ JES2 JOB STATISTICS ------
31 OCT 2016 JOB EXECUTION DATE
31 CARDS READ
107 SYSOUT PRINT RECORDS
0 SYSOUT PUNCH RECORDS
7 SYSOUT SPOOL KBYTES
0.02 MINUTES EXECUTION TIME
1 //JIGDB2R JOB MSGCLASS=H,MSGLEVEL=(1,1),NOTIFY=&SYSUID,REGION=0M
//*
IEFC653I SUBSTITUTION JCL - MSGCLASS=H,MSGLEVEL=(1,1),NOTIFY=JIG,REGIO
2 //JOBLIB DD DSN=DSNA10.SDSNLOAD,DISP=SHR
3 // DD DSN=CEE.SCEERUN,DISP=SHR
//*
//* GRANT AND CREATE TABLE
//* SEPARATE FROM EXECUTION OF PROGRAM
//*
//*
4 //RUN EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT)
//*SYSLIB DD DISP=SHR,DSN=JIG.BASE710.LOAD
//* DD DISP=SHR,DSN=DSNA10.DBAG.RUNLIB.LOAD
5 //SYSLIB DD DISP=SHR,DSN=DSNA10.DBAG.RUNLIB.LOAD
6 //DBRMLIB DD DISP=SHR,DSN=JIG.DBAG.DBRMLIB.DATA
//*DBRMLIB DD DISP=SHR,DSN=DSNA10.DBAG.DBRMLIB.DATA
7 //SYSTSPRT DD SYSOUT=*
8 //SYSPRINT DD SYSOUT=*
9 //CEEDUMP DD SYSOUT=*
J E S 2 J O B L O G -- S Y S T E M S 0 W 1 -- N O D
E
14.00.14 JOB03255 ---- MONDAY, 31 OCT 2016 ----
14.00.14 JOB03255 IRR010I USERID JIG IS ASSIGNED TO THIS JOB.
14.00.14 JOB03255 ICH70001I JIG LAST ACCESS AT 13:59:56 ON MONDAY, OCTOBER
14.00.14 JOB03255 $HASP373 JIGDB2R STARTED - INIT 2 - CLASS A - SYS S0W1
14.00.16 JOB03255 - -----TIMINGS (MINS.)--
14.00.16 JOB03255 -STEPNAME PROCSTEP RC EXCP CONN TCB SRB C
14.00.16 JOB03255 -RUN 00 2757 528 .00 .00
14.00.16 JOB03255 -JIGDB2R ENDED. NAME- TOTAL TCB CPU TIM
14.00.16 JOB03255 $HASP395 JIGDB2R ENDED
------ JES2 JOB STATISTICS ------
31 OCT 2016 JOB EXECUTION DATE
31 CARDS READ
107 SYSOUT PRINT RECORDS
0 SYSOUT PUNCH RECORDS
7 SYSOUT SPOOL KBYTES
0.02 MINUTES EXECUTION TIME
1 //JIGDB2R JOB MSGCLASS=H,MSGLEVEL=(1,1),NOTIFY=&SYSUID,REGION=0M
//*
IEFC653I SUBSTITUTION JCL - MSGCLASS=H,MSGLEVEL=(1,1),NOTIFY=JIG,REGIO
2 //JOBLIB DD DSN=DSNA10.SDSNLOAD,DISP=SHR
3 // DD DSN=CEE.SCEERUN,DISP=SHR
//*
//* GRANT AND CREATE TABLE
//* SEPARATE FROM EXECUTION OF PROGRAM
//*
//*
4 //RUN EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT)
//*SYSLIB DD DISP=SHR,DSN=JIG.BASE710.LOAD
//* DD DISP=SHR,DSN=DSNA10.DBAG.RUNLIB.LOAD
5 //SYSLIB DD DISP=SHR,DSN=DSNA10.DBAG.RUNLIB.LOAD
6 //DBRMLIB DD DISP=SHR,DSN=JIG.DBAG.DBRMLIB.DATA
//*DBRMLIB DD DISP=SHR,DSN=DSNA10.DBAG.DBRMLIB.DATA
7 //SYSTSPRT DD SYSOUT=*
8 //SYSPRINT DD SYSOUT=*
9 //CEEDUMP DD SYSOUT=*
IEF285I JIG.JIGDB2R.JOB03255.D0000102.? SYSIN
IEF285I JIG.JIGDB2R.JOB03255.D0000103.? SYSIN
IEF373I STEP/RUN /START 2016305.1400
IEF032I STEP/RUN /STOP 2016305.1400
CPU: 0 HR 00 MIN 00.01 SEC SRB: 0 HR 00 MIN 00.01 SEC
VIRT: 464K SYS: 364K EXT: 8700K SYS: 12640K
IEF285I DSNA10.SDSNLOAD KEPT
IEF285I VOL SER NOS= VTDA1A.
IEF285I CEE.SCEERUN KEPT
IEF285I VOL SER NOS= VTMVSC.
IEF375I JOB/JIGDB2R /START 2016305.1400
IEF033I JOB/JIGDB2R /STOP 2016305.1400
CPU: 0 HR 00 MIN 00.01 SEC SRB: 0 HR 00 MIN 00.01 SEC
READY
DSN SYSTEM(DBAG)
DSN
RUN PROGRAM(ZPDB2) PLAN(DB2ZP) LIB('JIG.BASE710.LOAD')
DSN
END
READY
END
Insert into TESTDB2.
SQLCODE=446704536 -904
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00E30305, TYPE OF
RESOURCE 00000801, AND RESOURCE NAME DB2ZP.ZPDB2.1A320A2A009C519E
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXEAAL SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -160 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF60' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC
INFORMATION
rollback successful
Janet
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
