View previous topic :: View next topic
|
Author |
Message |
knobi
New User
Joined: 16 Aug 2005 Posts: 54
|
|
|
|
Hello ... i'm receiving RC=08 when executing the job below.
Does anyone know how to fix this?
researches i've done until now point to a lack of authorizarion.. but so far no luck solving it. Appreciate any help !
error msg:
Code: |
***INPUT STATEMENT:
SELECT * FROM SYSIBM.SYSDATABASE
SQLERROR ON SELECT COMMAND, PREPARE FUNCTION
RESULT OF SQL STATEMENT:
DSNT408I SQLCODE = -923, ERROR: CONNECTION NOT ESTABLISHED: DB2 ACCESS, REASON 00E30301, TYPE 00000800, NAME DSNTEP2
DSNT418I SQLSTATE = 57015 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNAET03 SQL PROCEDURE DETECTING ERROR
READY
DSN SYSTEM(DB8G)
DSN
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) LIB('DSN810.RUNLIB.LOAD')
THE COMBINATION OF PLAN DSNTEP2, AUTH ID KNOB, AND SUBSYSTEM DB8G IS NOT VALID
FEEDBACK - REASON CODE X'00E30301' TYPE X'00000800' RESOURCE NAME- DSNTEP2
DSN
END
READY
|
JCL
Code: |
//STEP01 EXEC PGM=IKJEFT01
//STEPLIB DD DISP=SHR,DSN=DSN810.SDSNEXIT
// DD DISP=SHR,DSN=DSN810.SDSNLOAD
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB8G)
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) LIB('DSN810.RUNLIB.LOAD')
END
//SYSIN DD *
SELECT * FROM SYSIBM.SYSDATABASE
//
|
|
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
researches i've done until now point to a lack of authorizarion.. but so far no luck solving it. |
You will need the help of the dba or the security people to be given the permissions you need to execute this - if authorization is the problem . . .
Are you using the correct userid and subsystem? Have you looked at all of the things that can cause this return code (-923)?
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnmcj10/2.1.6.441
Suggest you become familiar/comfortable with the documentation available vie the "IBM Manuals" link at the top of the page. |
|
Back to top |
|
|
knobi
New User
Joined: 16 Aug 2005 Posts: 54
|
|
|
|
in this case .. i'm dba, scheduler and the security guy...
since this is a sandbox shop in my co. .... any clue what needs to be checked ? |
|
Back to top |
|
|
knobi
New User
Joined: 16 Aug 2005 Posts: 54
|
|
|
|
the subsystem is correct. ... |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
any clue what needs to be checked |
Everything mentioned in the -923 information.
It would probably help if the production dba took a look at things in your sandbox. . .
What can you do successfully in this subsystem?
As this is not "real", is there any chance that some datasets needed have been migrated? Sometimes this causes strange problems. . . |
|
Back to top |
|
|
satyender
New User
Joined: 05 Jan 2008 Posts: 50 Location: Olympia, WA, USA
|
|
|
|
knobi
Try this:
It is just a guess:
Inclue PARMS('/ALIGN(LHS)' in the lib statement:
LIB('DSN810.RUNLIB.LOAD' PARMS('/ALIGN(LHS)') |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
knobi,
Does the plan DSNTEP2 exist in that sub-system ? I think not.
Check and use the correct plan name.
Thanks,
Sushanth |
|
Back to top |
|
|
|