IBM DB2 Question:
Download Job Interview Questions and Answers PDF
What is the diff bet plan,package,dbrm?
Answer:
Plan is generated when you compile the DB2-SQL program.
This plan is stored in the DBRM and binded to database as packages. (stored in syscat.syspackages - pkgname)
DBRM: Data base request module is generated by precompiler which contains the sql statements which are separated from the source program.
PACKAGE: By binding the DBRM package is generated.Package contains the internal structure of the original sql statements.
PLAN: It is the combination of packages that are bind to form a PLAN.
This plan is stored in the DBRM and binded to database as packages. (stored in syscat.syspackages - pkgname)
DBRM: Data base request module is generated by precompiler which contains the sql statements which are separated from the source program.
PACKAGE: By binding the DBRM package is generated.Package contains the internal structure of the original sql statements.
PLAN: It is the combination of packages that are bind to form a PLAN.
Download IBM DB2 Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is a precompiler? | Give the COBOL definition of a VARCHAR field. |