What is DBRM?

DBRM stands for Database Request Module. It is a component inside DB2, which is created by the pre compiler of DB2. It contains SQL source statements that get extracted out of the application program. DBRMs form inputs that are helpful in the binding process.

In the context of IBM’s DB2 database management system, DBRM stands for Database Request Module. A DBRM is a compiled module that contains the executable code generated by the DB2 precompiler from the SQL statements in an application program.

When you write an application program that interacts with a DB2 database using SQL, you typically use embedded SQL statements in your code. These SQL statements need to be processed and converted into executable code that the database can understand. This is where the precompiler comes in. The precompiler takes your application program, processes the embedded SQL statements, and generates a DBRM.

The DBRM is then used by the bind process to create an access plan or package, which is the optimized and executable form of your SQL statements. The access plan or package is then stored in the database for later use by the SQL statement in your application program.

In summary, a DBRM is an intermediate step in the process of converting SQL statements in an application program into executable code that can be used by the DB2 database.