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: 108
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: 2425
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: 180
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: 690
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 statement in COBOL for VSE Kirthishine COBOL Programming 1 Fri Jun 26, 2020 12:12 pm
No new posts unable to compile module jzhardy PL/I & Assembler 6 Tue Jun 02, 2020 1:24 pm
No new posts Need example for CALL 'ISRSUPC' in COBOL Sue Adams COBOL Programming 2 Thu May 14, 2020 5:32 am
No new posts Unable to download the JDBC driver to... mrayandutta Java & MQSeries 1 Tue Apr 28, 2020 8:59 pm
No new posts trigger enter key automatically call ... Ziko13 CICS 17 Fri Apr 03, 2020 2:53 pm

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