Nimesh

• Oct 4th, 2005

 

plan is generated when you compile the DB2-SQL program.

This plan is stored in the DBRM and  binded to database as packages. (stored in syscat.syspackages - pkgname)

umapathi

• Sep 6th, 2006

 

plan - it can contain packages and dbrms.

package- it contains only dbrms. it is advantageous and cost effective.

pinaki

• Dec 7th, 2006

 

a package/dbrm is binded to a plan after compilation of a cobol-db2 / cics-cobol-db2 program.

a dbrm is produced during precompile step.

usually dbrm is associated to a package and package is binded to a plan for cost effectiveness.

Plan is created separately and has no relation with compilation