Got a SQLCODE = -991

2.2k Views Asked by helication At 20 October 2024 at 21:47

After the sub of the exec JCL, i've got the following error :

SQLCODE = -991 Error = ALL ATTACH WAS UNABLE TO ESTABLISH AN IMPLICIT CONNECT OR OPEN TO DB2

This error is triggered when i call a module that allows to query a table.

PS : i have the necessary privileges for the table.

Thanks.

There are 3 best solutions below

Abacus On 06 April 2012 at 15:27 BEST ANSWER

From IBM's page: -991 CALL ATTACH WAS UNABLE TO ESTABLISH AN IMPLICIT CONNECT OR OPEN TO DB2. RC1= rc1 RC2= rc2

And some general links for SQL return code information:

Joe Zitzelberger On 02 May 2011 at 18:53

It is possible you are not running on the same LPAR as DB2 and you don't have sharing enabled.

cschneid On 01 May 2011 at 14:42

Ensure you included DSNALI in your program bind (aka link) step, and that you're running on the correct LPAR.