BIND reads SQL statements from DBRMs and produces a code to access data as directed by SQL statements.
There are two types of BINDs ? BIND PLAN & BIND PACKAGE
BIND PLAN ? Accepts one or more DBRMs produced from previous DB2 pre-compilations, one or more packages produced from previous BIND PACKAGE commands or a combination of DBRMs and Package lists as input. The output of BIND PLAN is application plan
An application plan is executable only with the corresponding load module. Before running a DB2 program, an application plan must be specified.
BIND PACKAGE ? Accepts DBRM as input and produces a single package containing the optimized access path logic. The package then can be bound into application plan using BIND PLAN command. A package is not executable and cannot be specified when DB2 program is being run, the package must be bound into a plan before using it.