I am beginer in db2 , why r using bind ,plan & packge?

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
Posts: 1
Joined: Sun Jan 06, 2008 11:19 pm

I am beginer in db2 , why r using bind ,plan & packge?

Post by venkatesh12 » Sat Jan 12, 2008 1:45 pm


Posts: 12
Joined: Tue Dec 11, 2007 4:51 pm

Post by vanithaaraju » Wed Jan 16, 2008 11:31 am



Bind is a process which provides access path to the db2 tables.In other words it establishes a relationship between the application program and its relational data.


A plan is an executable module containing the access path logic produced by the DB2 optimizer. It can be composed of one or more DBRMs and packages. Before a DB2 for z/OS program can be run, it must have a plan associated with it.Plans are created by the BIND command. The plan is stored in the DB2 directory and accessed when its program is run.


A package is a single, bound DBRM with optimized access paths. To execute a package, you first must include it in the package list of a plan. Packages are not directly executed, they are only indirectly executed when the plan in which they are contained executes.

Post Reply


Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Mainframe Interview questions

Other References
Mainframe Tools and others