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
 

 

SQLCODE -991. Help need in solving this error

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

Active User


Joined: 04 Oct 2006
Posts: 118
Location: NJ, USA

PostPosted: Thu Feb 07, 2008 8:58 pm    Post subject: SQLCODE -991. Help need in solving this error
Reply with quote

Hi,
I am running Cobol/Db2 program. I am trying to run the prod version in development region.
I got access to the plan and did bind on the package.
When I try to execute the program, I am getting this error.
Code:
-991   CALL ATTACH WAS UNABLE TO ESTABLISH AN IMPLICIT CONNECT OR OPEN TO DB2.


I had a look at this discussion:
http://ibmmainframes.com/viewtopic.php?t=8550&highlight=sqlcode+991
It says no authorization to execute the plan. I spoke to my DBA, but he said its not access issue and asked me to check the application.
I even ran the program thru viasoft (debugging tool like xpeditor) and it fails at the first SQL statement its trying to execute.

Can anyone please tell me which SYSIBM table to look at to confirm tht I dont have access.?
I checked SYSIBM.SYSPLANAUTH table - it says my userid has execute access.
But I am bind this plan as package. I checked in SYSPPACKAUTH table, but no row exits.

can someone throw some light on it?

Hope I made myself clear. Thanks for your help.
-Viji
Back to top
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Fri Feb 08, 2008 4:01 am    Post subject:
Reply with quote

As in the link you provided, can you supply the RC1 & RC2?
Those will provide you anumition to shoot the DBA with (or not....grin...)....
Back to top
View user's profile Send private message
shekharmax

New User


Joined: 26 Dec 2007
Posts: 3
Location: hyderabad

PostPosted: Fri Feb 08, 2008 11:29 am    Post subject:
Reply with quote

hi,

it's a time out error , when u want to access the DB2 along with u r program at that moment db2 is unavailable but u r program wants to execute the SQL code.

ASK TO YOUR DBA for DB2 AVAILABILITY STATUS.
Back to top
View user's profile Send private message
vijikesavan

Active User


Joined: 04 Oct 2006
Posts: 118
Location: NJ, USA

PostPosted: Fri Feb 08, 2008 9:25 pm    Post subject: Reply to: SQLCODE -991. Help need in solving this error
Reply with quote

Hi,
Thanks for replies. The error code invokes a general abend routine and the message I see is user message from program.
Can you pls tell me what SQL variable to look for RC1 and RC2 so tht I can capture the values while running in smarttest(xpeditor).

Regarding, the availability of the tables, I am able to run the exact query outside in spufi.

Thanks,
Viji
Back to top
View user's profile Send private message
vijikesavan

Active User


Joined: 04 Oct 2006
Posts: 118
Location: NJ, USA

PostPosted: Sat Feb 09, 2008 2:43 am    Post subject: Reply to: SQLCODE -991. Help need in solving this error
Reply with quote

Hi,
I just figured the error. There was some improper compilation happened.
I tried compiling in endevor and it worked fine.
Previously I was compiling using a JCL outside endevor. Though tht Jcl was also taken from the availble ISPF options, not sure which Db2 module it used to link.

So its a compile and link issue!...One other DBA helped me in this.

Thanks,
Viji
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: Sat Feb 09, 2008 2:49 am    Post subject: Reply to: SQLCODE -991. Help need in solving this error
Reply with quote

Thank you for posting the solution icon_smile.gif

Good to hear that it is workng.

d
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 Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
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


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