DEPLEVEL bind option

The DEPLEVEL option determines whether Db2 records statement-level dependencies in addition to package-level dependencies.

FL 502

Command option	Option values	Used with
DEPLEVEL	( PACKAGE ) (STATEMENT)	BIND PACKAGE BIND SERVICE REBIND PACKAGE ¹

Note:

The DEPLEVEL bind option is not valid for REBIND of packages for native SQL procedures or advanced triggers.

Option descriptions for DEPLEVEL

DEPLEVEL(PACKAGE)

Specifies that the package records package-level dependencies in the SYSIBM.SYSPACKDEP catalog table.

DEPLEVEL(STATEMENT)

Specifies that the package records statement-level dependencies in the SYSIBM.SYSPACKSTMTDEP catalog table and records package-level dependencies in the SYSIBM.SYSPACKDEP catalog table. Statement validity is recorded in the VALID column of the SYSIBM.SYSPACKSTMT catalog table.

FL 504 Db2 uses autobind phase-in for packages that are marked with statement-level invalidation. Packages with invalid statements can be allocated, and valid statements can execute without waiting for the rebind to complete. However, invalid statements must go through incremental bind before they execute. For more information, see Autobind phase-in for packages with statement-level invalidation and Enabling autobind phase-in for packages invalidated at the statement level.

Default values for DEPLEVEL

Process	Default value
BIND SERVICE	Value of the PACKAGE_DEPENDENCY_LEVEL subsystem parameter.
BIND PACKAGE	Value of the PACKAGE_DEPENDENCY_LEVEL subsystem parameter.
REBIND PACKAGE	The existing value. If there is no existing value, the default is the value of the PACKAGE_DEPENDENCY_LEVEL subsystem parameter.

Catalog records for DEPLEVEL

See the DEPLEVEL column in SYSPACKAGE catalog table and SYSPACKCOPY catalog table.