What is db2 plan

 What is a plan? 

A DB2 plan is an executable module containing the access path logic produced by the DB2 optimizer.

It can be consist of

  1. One or more DBRM or
  2. One or more packages or
  3. Combination of DBRM and packages

A DB2 program needs a plan associated with it for it to be able to run.

; ; ; ;

Plans are the output of the Bind Plan command. The input of Bind Plan command is one of the three shown above (DBRM, Package or both).

The application plan is stored in the DB2 directory and accessed when its program is run. Information about the plan is stored in the DB2 catalog.

Plan can  be thought of as a list of packages.