IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to resolve sqlcode of CALL ATTACH WAS UNABLE TO ESTABLIS


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
maxsubrat

Active User


Joined: 27 Feb 2008
Posts: 108
Location: india

PostPosted: Fri Feb 22, 2019 11:54 am
Reply with quote

Hi,
I am getting this sqlcode -991 CALL ATTACH WAS UNABLE TO ESTABLISH AN IMPLICIT CONNECT OR OPEN TO DB2.

Can anyone advise whether this is the connectivity issue with DB2 or some other application related error which can be fixed from application end?

Thanks
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2631
Location: NYC,USA

PostPosted: Fri Feb 22, 2019 7:42 pm
Reply with quote

Have you talked to DBAs yet? Please consult them first since they would know about your site insights.
Back to top
View user's profile Send private message
John Poulakos

Active User


Joined: 13 Jun 2012
Posts: 180
Location: United States

PostPosted: Fri Mar 08, 2019 1:12 am
Reply with quote

I am attempting to get my CAF interface to provide better diagnostic info, so I cause a 991 by specifying the wrong plan when I invoke CAF.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 702
Location: Whitby, ON, Canada

PostPosted: Wed Mar 13, 2019 11:33 pm
Reply with quote

Unless your CAF application issues an explicit CONNECT to a DB2 subsystem, it will attempt to connect to the default subsystem defined to your system. This is what is meant by an Implicit connection. And unless your CAF application issues an explicit OPEN to a DB2 Plan it will attempt to open the Plan that matches your program name.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Unable to retrieve Datasets Names usi... CLIST & REXX 5
No new posts Unable to display comp variable COBOL Programming 4
No new posts Call Natural program with rexx CLIST & REXX 2
No new posts Is SQLCODE -811 possible while fetchi... DB2 1
No new posts Unable to scroll in REXX panel CLIST & REXX 4
Search our Forums:

Back to Top