31.
Briefly explain DBRM and PLAN?
DBRM: DBRM means DataBase Request Module,and it has the SQL statements extracted from the host language program by the pre-compiler.
PLAN: PLAN is a result of the BIND process, and 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.
|
|
||||||||||||||||||||||||||||
