Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums 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: 101
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: 2113
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

New User


Joined: 13 Jun 2012
Posts: 97
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: 674
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 Call DB2 user defined function from C... Ziko13 DB2 5 Thu Mar 14, 2019 4:46 pm
No new posts Can we call QMF proc from REXX ? batu544 CLIST & REXX 6 Fri Aug 03, 2018 11:03 am
No new posts Sqlcode =-253 pkmurali DB2 6 Sun Jul 22, 2018 3:13 pm
No new posts using CALL PLIRETC(somevalu) Pedro PL/I & Assembler 1 Wed May 09, 2018 10:25 pm
No new posts Call COBOL or PLI with a click from w... vaibhav gs All Other Mainframe Topics 1 Mon Apr 16, 2018 7:29 pm

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