Got a SQLCODE = -991

Question

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.

Answer 1

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:

• http://en.wikipedia.org/wiki/DB2_SQL_return_codes
• http://theamericanprogrammer.com/programming/sqlcodes.shtml
• http://www-01.ibm.com/support/docview.wss?rs=64&uid=swg27011656 - use the searches here to find lots of things
• http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp

Answer 2

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

Answer 3

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