---
title: "DB2 Bind Option ACQUIRE – The Real Purpose"
description: "ACQUIRE bind tetrameter real usages"
url: https://srinimf.com/2015/09/02/3-key-points-of-acquire-bind-option-in-db2/
date: 2015-09-02
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2015/09/pexels-photo-755280.jpeg?fit=1880%2C1255&ssl=1
categories: ["DB2"]
tags: ["ACQUIRE bind parameter", "DB2 Bind options"]
type: post
lang: en
---

# DB2 Bind Option ACQUIRE – The Real Purpose

The ACQUIRE bind option specifies that [resources for](https://srinimf.com/2015/12/27/5891/) the packages in the plan are to be acquired when the application first accesses them.

1. ACQUIRE ( USE )/( ALLOCATE )  **==> Deprecated**

Related[Bind Vs Plan Vs Package in DB2](https://srinimf.com/2010/12/06/db2-bind-package-plan-package-rebind-free-plan-or-package/)

## ACQUIRE Option

Related: **[Start Applying Jobs now](http://www.indeed.com/jobs?q=Mainframe&indpubnum=6634974704162507)**

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).

Related[DB2 Locks Helpful Points to Read now](https://srinimf.com/2017/01/15/the-best-db2-lock-technic-saves-valuable-resources/)

**Process Default value**

BIND PLAN:  USE
[BIND PACKAGE](https://srinimf.com/2013/07/26/db2-bind-package-and-bind-plan/):  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*

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2015%2F09%2F02%2F3-key-points-of-acquire-bind-option-in-db2%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2015%2F09%2Fpexels-photo-755280.jpeg%3Ffit%3D1200%252C801%26ssl%3D1&description=DB2%20Bind%20Option%20ACQUIRE%20-%20The%20Real%20Purpose)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2015/09/02/3-key-points-of-acquire-bind-option-in-db2/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2015/09/02/3-key-points-of-acquire-bind-option-in-db2/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2015/09/02/3-key-points-of-acquire-bind-option-in-db2/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2015/09/02/3-key-points-of-acquire-bind-option-in-db2/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20DB2%20Bind%20Option%20ACQUIRE%20-%20The%20Real%20Purpose&body=https%3A%2F%2Fsrinimf.com%2F2015%2F09%2F02%2F3-key-points-of-acquire-bind-option-in-db2%2F&share=email)
-

### Like this:

Like Loading…