Reputation: 1

Got a SQLCODE = -991

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.

Upvotes: -1

Answers (3)

Reputation: 10775

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

Upvotes: 0

Reputation: 2119

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:

Upvotes: 0

Reputation: 4263

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

Upvotes: 0