61) What is a DBRM, PLAN ?
DBRM: DataBase 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.
62) What is ACQUIRE/RELEASE in BIND?
Determine the point at which DB2 acquires or releases locks against table and
tablespaces, including intent locks.
63) What else is there in the PLAN apart from the access path? –
PLAN has the executable code for the SQL statements in the host
program
64) What happens to the PLAN if index used by it is dropped?
Plan is marked as invalid. The next time the plan is accessed, it is
rebound.
65) What are PACKAGES ? –
They contain executable code for SQL statements for one DBRM.
|