ACQUIRE bind option

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 ) Start of change(deprecated)End of change
On: BIND and REBIND PLAN

Start of changeThis behavior is the default, regardless of whether you specify ACQUIRE(USE), ACQUIRE(ALLOCATE), which has been deprecated, or neither option.End of change

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)
Start of changeThis option has no effect. ALLOCATE is deprecated. If you specify ACQUIRE(ALLOCATE) DB2® issues a warning and uses ACQUIRE(USE).End of change

Defaults:

Process Default value
BIND PLAN USE
BIND PACKAGE N/A
REBIND PLAN Start of changeUSEEnd of change
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).

Catalog record: Column ACQUIRE of table SYSPLAN.