Bind Process in DB2: How to Decode These Terms

The prime activity during the Bind process is determining the access path for SQL. Here’s a sample JCL explaining the other BIND activities. Here’re the terms decoded that popularly use in the BIND process.

Static SQL Access path will not change since it determines during the BIND process. The PLAN_TABLE store information on the access path.


It’s a newly introduced SQL query that updates package details in PLAN_TABLE.

EXPLAIN PACKAGE package-scope-specification
Bind options


This option is now part of the BIND process. It compares the results of BIND PACKAGE and REBIND PACKAGE. The NO is the default. It means not for comparing. The scenario occurs when DB2 migrates to the new version and to decide whether REBIND is required or not, helpful to know.

The WARN option pops a warning message when the new access path differs. The ERROR option pops an error when the new access path mismatches and it will not BIND or REBIND.

APCOMPARE (Access path compare). APREUSE (Access path reuse).

  • NO or NONE
  • WARN

The APREUSE again has two options. The NO means no action. If it is the ERROR, and you set EXPLAIN(YES), then it replaces the stored access path with the new one.

  • NO or NONE


Author: Srini

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