--- title: "Bind Vs Plan Vs Package in DB2" description: "Bind vs Plan vs Package in DB2 to read today" url: https://srinimf.com/2010/12/06/db2-bind-package-plan-package-rebind-free-plan-or-package/ date: 2010-12-06 modified: 2026-10-10 author: "Srini" image: https://i0.wp.com/srinimf.com/wp-content/uploads/2010/12/pexels-photo-1350789.jpeg?fit=1880%2C1202&ssl=1 categories: ["DB2", "DB2 V11"] tags: ["DB2 Bind Plan", "DB2 Free PLAN or Package", "DB2 Rebind"] type: post lang: en --- # Bind Vs Plan Vs Package in DB2 In DB2, some concepts confuse to many people. I [want to](https://srinimf.com/2016/02/09/want-to-excel-in-ims-dc-programming-read-this/) explain those: **BIND** [https://srinimf.com/](https://srinimf.com/)[2021](https://srinimf.com/2021/12/31/srinimfs-top-2021-blog-posts/)/07/31/db2-understand-the-real-use-of-package/ BIND is a command you can use to create package using DBRMs. [https://srinimf.com/](https://srinimf.com/)[2014](https://srinimf.com/2013/12/26/cloud-computing-trends-in-2013-and-future-in-2014/)/03/14/db2-optimization-hints/ **[Bind package](https://srinimf.com/2014/07/31/db2-remote-binding-a-package/)** Related[PLSQL: Early Vs Late Binding Concepts Simplified](https://srinimf.com/2015/04/20/plsql-architecture/) Binding a single [DBRM ](https://srinimf.com/2013/07/26/db2-bind-package-and-bind-plan/)is called bind package. However after bind package we need [to bind](https://srinimf.com/2016/09/08/how-to-bind-package-versions-in-db2/) with a PLAN. **PLAN** PLAN is a command to create a PLAN on Bind package. PLAN is a executable code. Without PLAN you cannot execute DB2 programs in mainframe. [https://srinimf.com/](https://srinimf.com/)[2014](https://srinimf.com/2014/04/06/13-best-2014-jobs/)/07/21/db2-5-frequently-asked-questions/ **Plan package** Binding single or multiple DBRMs into a Plan. Practically in real-time we do [Plan bind](https://srinimf.com/2014/10/24/db2-plan-bind-same-program-in-two-subsystems/).  Bind package has some benefits. We can give separate [Bind options](https://srinimf.com/2012/05/20/db2-bind-options-part-2/) for each Bind package. **Rebind** This is we do for existing components to update optimum access paths. **Free** We use free command  to Free [plan or Package](https://srinimf.com/2015/10/11/db2-open-cursor-unsuccessful-probable-reasons/). We all know that Bind does DB2 syntax check and provide optimum access paths. - [![textured orange paper with warm lighting](https://i0.wp.com/srinimf.com/wp-content/uploads/2026/10/pexels-photo-30972899.jpeg?resize=867%2C1300&ssl=1)](https://srinimf.com/2026/10/17/databricks-find-job-status/) ## [How to Find Databricks Job Status, Owner, and Active Runs Fast](https://srinimf.com/2026/10/17/databricks-find-job-status/) October 17, 2026 by [Srini](https://srinimf.com/author/moonrobot/) Need to audit Databricks workflows? Step-by-step guide to tracking job creators, service principal run identities, and current execution status in Databricks. - [![woman in black shirt sitting in front of a computer](https://i0.wp.com/srinimf.com/wp-content/uploads/2026/10/pexels-photo-5530473.jpeg?resize=867%2C1300&ssl=1)](https://srinimf.com/2026/10/01/30-sql-practice-queries-with-solutions-run-them-live/) ## [30 SQL Practice Queries with Solutions — Run Them Live](https://srinimf.com/2026/10/01/30-sql-practice-queries-with-solutions-run-them-live/) October 1, 2026 by [Srini](https://srinimf.com/author/moonrobot/) Practice 30 SQL queries with solutions, from SELECT and JOINs to subqueries and window functions. Run SQL queries live in an interactive SQL Playground. [View all posts](https://srinimf.com) ### 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%2F2010%2F12%2F06%2Fdb2-bind-package-plan-package-rebind-free-plan-or-package%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2010%2F12%2Fpexels-photo-1350789.jpeg%3Ffit%3D1200%252C767%26ssl%3D1&description=Bind%20Vs%20Plan%20Vs%20Package%20in%20DB2) - - [Share on Tumblr](https://www.tumblr.com/share) - [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2010/12/06/db2-bind-package-plan-package-rebind-free-plan-or-package/?share=jetpack-whatsapp) - [More](#) - - [Print (Opens in new window) Print](https://srinimf.com/2010/12/06/db2-bind-package-plan-package-rebind-free-plan-or-package/?share=print) - [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2010/12/06/db2-bind-package-plan-package-rebind-free-plan-or-package/?share=reddit) - [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2010/12/06/db2-bind-package-plan-package-rebind-free-plan-or-package/?share=telegram) - [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20Bind%20Vs%20Plan%20Vs%20Package%20in%20DB2&body=https%3A%2F%2Fsrinimf.com%2F2010%2F12%2F06%2Fdb2-bind-package-plan-package-rebind-free-plan-or-package%2F&share=email) - ### Like this: Like Loading…