What is a DBRM, PLAN ?
DBRM: Data Base Request Module, has the SQL statements extracted from the host language program by the pre-compiler. PLAN: A result of the BIND process. It has the executable code for the SQL statements in the DBRM.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is a bind? 25.08.08
Binding is a process that creates the access path logic for the sql statements within a cobol program. after precompilation of a cobol program a dbrm(has all th...DB2 What is the difference between a package and a plan? How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem? 03.04.08
Package and plan are usually used synonymously, as in this site. Both contain optimized code for SQL statements - a package for a single program, module or subr...What are the advantages of using a PACKAGE ? 16.03.08
The advantages of using PACKAGE are: 1. Avoid having to bind a large number of DBRM members into a plan 2. Avoid cost of a large bind 3. Avoid the entire tra...What happens to the PLAN if index used by it is dropped ? 16.03.08
Plan is marked as invalid. The next time the plan is accessed, it is rebound....What else is there in the PLAN apart from the access path ? 16.03.08
PLAN has the executable code for the SQL statements in the host program...Where are plans stored ? 10.03.08
Each plan is defined uniquely in the SYSIBM.SYSPLANS table to correspond to the transaction (s) that are to execute that plan....What will the FREE command do to a plan ? 09.03.08
It will drop(delete) that existing plan....What is a DB2 bind? 07.03.08
Bind is a process that builds “access paths” to DB2 tables. A bind uses the Database Request Modules(s) (DBRM(s)) from the DB2 pre-compile step as input an...Explain what a plan is? 07.03.08
Plan is a DB2 object (produced during the bind process) that associates one or more database request modules with a plan name....How would you go about generating an EXPLAIN plan? 06.08.06
Create a plan table with utlxplan.sql. Use the explain plan set statement_id = ‘tst1′ into plan_table for a SQL statement. Look at the explain plan with utl...