--- title: "DB2 top differences Bind Package Vs Bind Plan" description: "Bind package vs Bind plan all you need to know while working with DB2 programs" url: https://srinimf.com/2013/07/26/db2-bind-package-and-bind-plan/ date: 2013-07-26 modified: 2026-10-10 author: "Srini" image: https://i0.wp.com/srinimf.com/wp-content/uploads/2013/07/pexels-photo-3808181.jpeg?fit=1880%2C1253&ssl=1 categories: ["DB2"] tags: ["DB2 Package Vs Plan in bind", "DB2 Tips and Solutions"] type: post lang: en --- # DB2 top differences Bind Package Vs Bind Plan **[Bind Package](https://srinimf.com/2016/09/08/how-to-bind-package-versions-in-db2/):** A package is a single, bound DBRM with optimized access paths. By using packages, the table access logic is “packaged” at a **lower level of granularity **than a plan. Related[DB2 Bind: Step-by-step Guide to Use Package Versions](https://srinimf.com/2015/11/09/how-to-run-cobol-program-with-different-versions-of-db2-package/) Plan==> Package Related[DB2 Bind Option ACQUIRE – The Real Purpose](https://srinimf.com/2015/09/02/3-key-points-of-acquire-bind-option-in-db2/) As we all know “Bind Package” is not executable.  Exceptions: UDFs and Triggers. ![32 complex SQL Queries](https://i0.wp.com/srinimf.com/wp-content/uploads/2018/06/32-complexsql-queries.png?fit=500%2C500&ssl=1) 32 Complex SQL Queries Useful for interview and projects. $1.00 Related[6 Must Read DB2 PLAN Interview Questions](https://srinimf.com/2014/07/21/db2-5-frequently-asked-questions/) **Bind Plan:** A plan is an executable module containing the access path logic produced by the [DB2 optimizer](https://srinimf.com/2017/01/11/the-optimizer-in-db2-5-popular-functions-in-a-nutshell/). It can be composed of one or more DBRMs and packages. Related[DB2 Understand the Real Use of Package](https://srinimf.com/2021/07/31/db2-understand-the-real-use-of-package/) **So plan is higher in level than package.** Related[DB2- Optimization Hints](https://srinimf.com/2014/03/14/db2-optimization-hints/) A plan can consist of one or more DBRMs, one or more packages or, a combination of packages and DBRMs. Related Posts - [Bind Vs Plan Vs Package in DB2](https://srinimf.com/2010/12/06/db2-bind-package-plan-package-rebind-free-plan-or-package/)DateDecember 6, 2010 - [DB2 Bind Process: Top Differences Between APCOMPARE and APREUSE](https://srinimf.com/2023/02/06/bind-process-in-db2-how-to-decode-these-terms/)DateFebruary 6, 2023 - [DB2 Understand the Real Use of Package](https://srinimf.com/2021/07/31/db2-understand-the-real-use-of-package/)DateJuly 31, 2021 ### 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%2F2013%2F07%2F26%2Fdb2-bind-package-and-bind-plan%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2013%2F07%2Fpexels-photo-3808181.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=DB2%20top%20differences%20Bind%20Package%20Vs%20Bind%20Plan) - - [Share on Tumblr](https://www.tumblr.com/share) - [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2013/07/26/db2-bind-package-and-bind-plan/?share=jetpack-whatsapp) - [More](#) - - [Print (Opens in new window) Print](https://srinimf.com/2013/07/26/db2-bind-package-and-bind-plan/?share=print) - [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2013/07/26/db2-bind-package-and-bind-plan/?share=reddit) - [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2013/07/26/db2-bind-package-and-bind-plan/?share=telegram) - [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20DB2%20top%20differences%20Bind%20Package%20Vs%20Bind%20Plan&body=https%3A%2F%2Fsrinimf.com%2F2013%2F07%2F26%2Fdb2-bind-package-and-bind-plan%2F&share=email) - ### Like this: Like Loading…