DSNT264I csect-name bind-type bind-subtype ERROR USING auth-id AUTHORITY PACKAGE package-name IS A package-type PACKAGE

Explanation

The explanation for this message depends on the type of package that it was issued for.

Trigger packages
  • A DSN subcommand other than REBIND TRIGGER PACKAGE was issued to rebind a trigger that was created prior to Db2 12 with new function activated, or a basic trigger. The REBIND PACKAGE command cannot be used for these triggers, issue the DSN subcommand REBIND TRIGGER PACKAGE instead.
  • A statement other than DROP TRIGGER was issued to free a trigger package. To free a trigger package, use the SQL statement DROP TRIGGER.
  • A DSN BIND subcommand was issued with the COPY option for a trigger. You cannot copy a package for a trigger.
Native SQL procedure packages

A statement other than the SQL statement DROP PROCEDURE was issued to free a package for a native SQL procedure. To free a native SQL procedure package, you must use the SQL statement DROP PROCEDURE.

REST service packages
  • To replace a REST SERVICE package, you must use the FREE SERVICE and BIND SERVICE commands.
  • Start of changeTo free the active REST service package, use the FREE SERVICE command. For more information, see Dropping a Db2 REST service.End of change
Any package not for a REST service

A package not for a REST service package was the object of the FREE SERVICE command. FREE SERVICE can only be used to free a REST SERVICE package.

If the error is issued for NON-REST SERVICE package:

The message tokens are:

bind-type
Type of bind subcommand: BIND, REBIND, or FREE
bind-subtype
Subtype of bind subcommand: REPLACE, TRIGGER, or DEPLOY
auth-id
Authorization ID of the user that attempted the prohibited action
package-name
Name of the package, in the following format:
collection.package
package-type
Type of package: TRIGGER, NATIVE SQL PROCEDURE, REST SERVICE.

System action

The package is not copied, rebound, freed, or replaced.

System programmer response

Check the SYSIBM.SYSPACKAGE catalog table for names of existing trigger packages or native SQL procedure packages. Invoke the bind subcommand again, with a 'collection.package' that is not a trigger or native SQL procedure package. To replace an existing REST SERVICE package, use the FREE SERVICE followed by the BIND SERVICE commands.