PACKAGE bind option

The PACKAGE option determines the packages to bind or rebind.

PACKAGE
  • (location-name.collection-id) (BIND PACKAGE)
  • (location-name.collection-id.package-id.(version-id)) (REBIND PACKAGE)
 On: BIND and REBIND PACKAGE
You cannot use the BIND PACKAGE subcommand to:
  • Bind a package with the same name as an existing trigger package
  • Copy a trigger package
The following options identify the location, collection, package name, and version of the package. You can identify a location and collection. For BIND, the DBRM supplies the package ID and version ID if you use the option MEMBER, or those IDs come from the option COPY. For REBIND, you must identify a package name, and you can also supply a version ID.
location-name
The location of the DBMS where the package binds or rebinds and where the description of the package resides. The location name must be defined in catalog table SYSIBM.LOCATIONS. If that table does not exist or if the DBMS is not in it, you receive an error message.

The default is the local DBMS.

collection-id or *
Specifies the collection to contain the package to bind, or that already contains the package to rebind. There is no default.

For REBIND, you can use an asterisk (*) to rebind all local packages with the specified package-id in all the collections for which you have bind privileges.

Start of changeFor REBIND PACKAGE, collection-id can be an undelimited or a delimited identifier. The delimiter for collection-id is double quotation marks ("). If collection-id is delimited, DB2® does not convert the value to uppercase.End of change

package-id or * (For REBIND only)
Specifies the name of the package to rebind, as listed in column NAME of catalog table SYSPACKAGE. There is no default.

You can use an asterisk (*) to rebind all local packages in collection-id for which you have bind privileges.

Start of changeFor REBIND PACKAGE, package-id can be an undelimited or a delimited identifier. The delimiter for package-id is double quotation marks ("). If package-id is delimited, DB2 does not convert the value to uppercase.End of change

version-id or * (For REBIND only)
Specifies the version of the package to rebind, as listed in column VERSION of catalog table SYSPACKAGE.

You can use an asterisk (*) to rebind all local versions of the specified package-id in collection-id for which you have bind privileges.

Using simply () rebinds the version of the package that is identified by the empty string.

If you omit version-id , the default depends on the how you specify package-id . If you use * for package-id , then version-id defaults to *. If you explicitly provide a value for package-id , then version-id defaults to the empty string version.

( * ) (For REBIND only)
Rebinds all local DB2 packages for which the applicable authorization ID has the BIND privilege. Specifying (*) is the same as specifying the package name as (*.*.(*)) or (*.*). The applicable authorization ID is:
  • The value of OWNER, if you use that option
  • The primary authorization ID of the process running the bind, if you do not use the option OWNER

Catalog record: Columns COLLID, NAME, and VERSION of table SYSPACKAGE.