What Is a DBRM?

Confusion often arises about the definition of a DBRM and its relationship to programs, plans, and packages. A DBRM is nothing more than a module containing SQL statements extracted from a source program by the DB2 precompiler. It is stored as a member of a partitioned data set. It is not stored in the DB2 Catalog or DB2 Directory.

Although a DB2 Catalog table named SYSIBM.SYSDBRM exists, it does not contain the DBRM. It also does not contain every DBRM created by the precompiler. It consists of information about DBRMs that have been bound into application plans and packages. If a DBRM is created and never bound, it is not referenced in this table.

When a DBRM is bound into a plan, all its SQL statements are placed into the SYSIBM.SYSSTMT DB2 Catalog table. When a DBRM is bound into a package, all its SQL statements are placed into the SYSIBM.SYSPACKSTMT table.