-807   ACCESS DENIED: PACKAGE package-name IS NOT ENABLED FOR ACCESS FROM connection-type connection-name

Explanation

Access is denied for one of the following reasons:
  • It is disabled, either from the 'connection-type' or from the 'connection-type' with the specific 'connection-name'.
  • The attach library that you are using is from a previous release of DB2® that does not support the ENABLE and DISABLE options of the bind operation.
The variables are:
package-name
The package name (collection.package-id).
connection-type
One of the following: BATCH, DB2CALL, REMOTE, IMSBMP, IMSMPP, CICS®, DLIBATCH, or UNKNOWN.
connection-name
Name of the connection that is restricted. If all connection names from a specific connection-type are restricted, this value is not specified.

System action

The statement is not executed and the package is not allocated.

System programmer response

One of the following:
  • Rebind the package to enable it to execute with the required connection type and name.
  • Check the SYSPLSYSTEM or SYSPKSYSTEM catalog table to find a connection from which the package can be executed.
  • Correct the attach library.

SQLSTATE

23509