Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to resolve sqlcode of CALL ATTACH WAS UNABLE TO ESTABLIS

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

Active User


Joined: 27 Feb 2008
Posts: 106
Location: india

PostPosted: Fri Feb 22, 2019 11:54 am    Post subject: How to resolve sqlcode of CALL ATTACH WAS UNABLE TO ESTABLIS
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

Senior Member


Joined: 21 Sep 2010
Posts: 2300
Location: NY,USA

PostPosted: Fri Feb 22, 2019 7:42 pm    Post subject:
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: 161
Location: United States

PostPosted: Fri Mar 08, 2019 1:12 am    Post subject: Reply to: How to resolve sqlcode of CALL ATTACH WAS UNABLE TO ESTABLIS
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: 684
Location: Whitby, ON, Canada

PostPosted: Wed Mar 13, 2019 11:33 pm    Post subject:
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    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 Unable to delete dataset - VSAM datas... netcrawler JCL & VSAM 20 Fri Jul 26, 2019 2:06 pm
No new posts Difference between GE and GB return c... Poha Eater IMS DB/DC 8 Fri Jul 12, 2019 12:59 pm
No new posts Unable to offline device/Drive netcrawler All Other Mainframe Topics 1 Mon Jul 08, 2019 1:20 pm
This topic is locked: you cannot edit posts or make replies. Unable to allocate Message Library in... Learncoholic CLIST & REXX 13 Fri Jun 21, 2019 5:50 pm
No new posts SQLCODE -950 in PREPARE statement ... PeD DB2 2 Sat Apr 20, 2019 7:00 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us