BIND & REBIND in DB2

最新推荐文章于 2023-07-09 17:46:59 发布

转载最新推荐文章于 2023-07-09 17:46:59 发布 · 4k 阅读

文章标签：

#db2 #parameters #access #object #path #sql

DB2 专栏收录该内容

18 篇文章

订阅专栏

本文详细解释了DB2中BIND和REBIND两种选项在访问路径评估中的作用，包括它们的功能、检查点以及如何在不同场景下选择使用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

BIND & REBIND are the two options provided in DB2 for the re-evaluation of access path.

REBIND searches the catalog,takes the information found there and re-evaluates the access path.
BIND being more enhanced operation performs a lots of checks (correct syntax,whether all tables are existing or not ,proper grants are provided or not) and then re-evaluates the access path.

Both BIND & REBIND basically checks for the dependency of the objects referenced in the package.
In a package suppose n number of objects are referenced and any one of them is dropped,then the package will be consequently marked as invalid.
When Someone executes the package then DB2 will perform an automatic rebind and if the object is still not available then that package is marked as inoperative and no further automatic rebinds are performed for the same and the execution will fail.

A BIND permits us to use new BIND parameters but the REBIND uses the already specified parameters.

Further if you want to specify new parameters for the execution of your Package and if the whole SQL has been changed (like referencing to new objects) then a BIND is required .
And if you simply want to redo the evaluation of the access path for the package then being cost efficient and optimized,the REBIND is the best option.