Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

ERROR -923 running IKJEFT01

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
knobi

New User


Joined: 16 Aug 2005
Posts: 46

PostPosted: Sun May 30, 2010 5:38 am    Post subject: ERROR -923 running IKJEFT01
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun May 30, 2010 5:48 am    Post subject:
Reply with quote

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)?

http://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
View user's profile Send private message
knobi

New User


Joined: 16 Aug 2005
Posts: 46

PostPosted: Sun May 30, 2010 6:02 am    Post subject:
Reply with quote

in this case .. i'm dba, scheduler and the security guy... icon_confused.gif
since this is a sandbox shop in my co. .... any clue what needs to be checked ?
Back to top
View user's profile Send private message
knobi

New User


Joined: 16 Aug 2005
Posts: 46

PostPosted: Sun May 30, 2010 6:03 am    Post subject:
Reply with quote

the subsystem is correct. ...
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun May 30, 2010 8:43 am    Post subject:
Reply with quote

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
View user's profile Send private message
satyender

New User


Joined: 05 Jan 2008
Posts: 50
Location: Olympia, WA, USA

PostPosted: Fri Jun 04, 2010 5:26 am    Post subject:
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Jun 04, 2010 9:49 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
No new posts INVOKE WEBSERVICE error danik56 CICS 11 Thu Mar 09, 2017 11:52 am
No new posts Row not found Sql error GaganGarg DB2 7 Tue Mar 07, 2017 6:29 am
No new posts Determine Region with max bandwidth f... seahawk789 COBOL Programming 3 Mon Feb 27, 2017 8:26 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us