I am beginer in db2 , why r using bind ,plan & packge?
Moderators: Kalicharan, Moderator Group
-
- Member
- Posts: 1
- Joined: Sun Jan 06, 2008 11:19 pm
-
- Member
- Posts: 12
- Joined: Tue Dec 11, 2007 4:51 pm
Hi,
Bind
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.
Plan
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.
Package
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.
Bind
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.
Plan
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.
Package
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.
vanithaa
FREE TUTORIALS
Tutorials
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.
Interview
Mainframe Interview questions
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page