31.
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.
32.
What is ACQUIRE/RELEASE in BIND?
Determine the point at which DB2 acquires or releases locks against table and tablespaces, including intent locks.
33.
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.
34.
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.
35.
What are PACKAGES?
They contain executable code for SQL statements for one DBRM.
|
|
||||||||||||||||||||||||||||
