DEPLOY bind option (deprecated)

The DEPLOY option deploys a compiled SQL function or a native SQL procedure.

Deprecated function: The DEPLOY bind option is deprecated. For best results, deploy compiled SQL functions and native SQL procedures to multiple environments by issuing the same CREATE or ALTER statements separately in each Db2 environment.
Command option Option values Used with
DEPLOY
  • (collection-id.package-id )
  • COPYVER(version-id)

Option descriptions for DEPLOY

(collection-id)
The name of the collection that contains the package to deploy, as listed in column COLLID of catalog table SYSPACKAGE.
(package-id)
The name of the package to deploy, as listed in column NAME of catalog table SYSPACKAGE.
COPYVER( version-id )
Determines the version of the package to deploy. The default for version-id is the empty string.

Start of changeversion-id is an undelimited identifier. Db2 does not convert the value to uppercase or change it in any other way.End of change

Specify BIND PACKAGE DEPLOY only when the target Db2 is a Db2 for z/OS® server. You can use the ADMIN_COMMAND_DSN or DSNACCTS procedure to submit this command from a remote requester environment.

Start of changeBIND PACKAGE DEPLOY must not be specified for the following:
  • A routine package that is obfuscated with the built-in WRAP function
  • FL 507 A package that is generated for a version of a procedure using a CREATE statement whose statement text contains an OR REPLACE or SPECIFIC clause
End of change

If you specify DEPLOY, the only other options that you can specify are PACKAGE, QUALIFIER, ACTION, OWNER, QUERYACCELERATION, and GETACCELARCHIVE. If you do not specify QUALIFIER or OWNER, their default values are the authorization ID that issues the BIND PACKAGE DEPLOY command.

Using DEPLOY with the ACTION option:
If you specify ACTION(ADD) for a version that does not exist at the target location, Db2 creates or adds a new version of the SQL function or a native SQL procedure and its associated package while keeping the logic from the source object. Db2 adds a new version if an SQL function or a native SQL procedure with the same target name already exists.

If you specify ACTION(REPLACE), Db2 replaces the version specified in COPYVER. If you specify REPLVER, the version ID must be the same as the COPYVER version ID or Db2 returns TSO error message, DSNE977E.

Defaults values for DEPLOY

Process Default value
BIND PLAN N/A
BIND PACKAGE None
REBIND PLAN N/A
REBIND PACKAGE N/A

DEPLOY has no default. If you do not use DEPLOY, you must use MEMBER or COPY.

Catalog records for DEPLOY

See the TYPE column in SYSPACKAGE catalog table.