3 Key points of Acquire BIND option in DB2

  • The ACQUIRE bind option specifies that resources for the packages in the plan are to be acquired when the application first accesses them.

ACQUIRE
( USE )
( ALLOCATE )  ==> Deprecated

  • Usage is on BIND and REBIND PLAN

Related: Start Applying Jobs now

This behaviour is the default, regardless of whether you specify ACQUIRE(USE), ACQUIRE(ALLOCATE), which has been deprecated, or neither option. The ACQUIRE option does not affect page, row, LOB or XML locks.

(USE)
Acquires table space locks only when the application program first uses them.
(ALLOCATE)
This option has no effect. ALLOCATE is deprecated. If you specify ACQUIRE(ALLOCATE) DB2® issues a warning and uses ACQUIRE(USE).

Process Default value
BIND PLAN:  USE
BIND PACKAGE:  N/A
REBIND PLAN :USE
REBIND PACKAGE: N/A

  • There is no ACQUIRE option for packages. A package always acquires resources when it first uses them, as if you specified ACQUIRE(USE).

Ref: IBM

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.