How to resolve sqlcode of CALL ATTACH WAS UNABLE TO ESTABLIS

maxsubrat · Active User Joined: 27 Feb 2008 Posts: 110 Location: india

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

Rohit Umarjikar · Posted: Fri Feb 22, 2019 7:42 pm

Have you talked to DBAs yet? Please consult them first since they would know about your site insights.

John Poulakos · Posted: Fri Mar 08, 2019 1:12 am

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.

don.leahy · Posted: Wed Mar 13, 2019 11:33 pm

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.