If I have 5 Queries in a DB2 Cobol program , while
precompiling how many DBRMs will get created and How many
Plans and Packages will get created while Bind Process?
Answer Posted / srinivas chennareddy
As the name indicates DBRM(Data Base Replacement Module) is
for one module...irrespective of the number of SQL's in a
module/program...one DBRM will be created and it will be
bound to one package,and collection of all calling/called
module packages forms an application PLAN,which will be
loaded into main memory and executed during run time.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What are packages in db2?
What is null in db2?
What are the rules for db2 programming?
What is the syntax for creating a table in the db2 database?
Explain the function done by data manager?
How can we read records for specific member in CL? AND rpg?
What is dpf in db2?
What is db2 plan table?
How to execute stored procedure in db2 command editor?
Discuss about db2 bind?
What is db2 command?
Which component is responsible for db2 startup and shutdown?
Explain about dbrm.
What is difference between alias and synonym in db2?
What is db2? Explain.