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.
| Command option | Option values | Used with |
|---|---|---|
| ACQUIRE |
|
This behavior 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.
Option descriptions for ACQUIRE
- ACQUIRE(USE)
- Acquires table space locks only when the application program first uses them.
- ACQUIRE(ALLOCATE)
- This option has no effect. ALLOCATE is deprecated. If you specify ACQUIRE(ALLOCATE) Db2 issues a warning and uses ACQUIRE(USE).
Default values for ACQUIRE
| 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).
Catalog records for ACQUIRE
See the ACQUIRE column of the SYSPLAN catalog table.