What is a DBRM, PLAN ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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.

(Continued on next question...)

Other Job Interview Questions

• How will you send data from a cobol file to DB2 table?
• How would you print the output of an SQL statement from SPUFI? –
• When is the access path determined for dynamic SQL? –
• How do you find the maximum value in a column in DB2?
• Can you use MAX on a CHAR column?
• Is it mandatory to use DCLGEN? If not, why would you use it at all?
• What is the difference between primary key and unique index ?
• At what stage DB2 must be up?
• What is a synonym? How is it used?
• What is RUNSTATS?
• More...