Program Preparation Objects

The program preparation process is composed of many objects. Each of these objects is described as follows :

Source	Every program starts as a series of host language statements, known as the application source . The source gets run through the DB2 precompiler to have its SQL statements removed and placed in a DBRM.
Modified source	The DB2 precompiler creates the modified source module by stripping the source module of all its SQL statements. The modified source is passed to the host language compiler.
Load module	The linkage editor creates a load module using the output of the host language compiler. The load module contains the executable form of the host language statements and is executable in conjunction with an application plan.
DBRM	The DBRM is created by the DB2 precompiler from the SQL statements stripped from the program source code.
Plan	A plan is created by the BIND statement. It consists of the access paths required to execute the SQL statements for all DBRMs bound into the plan (either explicitly or as packages). The plan is executable in conjunction with the corresponding program load module.
Package	A package also is created by the BIND statement. It contains the access paths for a single DBRM.
Collection	A collection is an identifier used to control the creation of multiple packages from the same DBRM. (Technically, a collection is not an object at all, but it is included in this list for completeness.)
Version	A version is a token specified to the DB2 precompiler that enables multiple versions of the same collection and package to exist.