DB2 top concepts Bind Vs Plan vs Package

In DB2, some concepts confuse to many people. I want to explain those:

BIND

BIND is a command you can use to create package using DBRMs.

Bind package

Binding a single DBRM is called bind package. However after bind package we need to bind 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.

Plan package

Binding single or multiple DBRMs into a Plan. Practically in real-time we do Plan bind.  Bind package has some benefits. We can give separate Bind options 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.

We all know that Bind does DB2 syntax check and provide optimum access paths.

  • Ansible Galaxy Top rules to Create a Role

    November 30, 2020 by

    In Ansible, role and playbook are superior. Multiple roles – role1, role2,etc present in a Playbook. Follow these rules to create a role.

View all posts

Related Posts

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.