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 is bufferpool in db2?
What is meant by dclgen?
What is collection in db2 bind?
What is load utility in db2?
How do I change the column size in db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Explain db2.
can we view the access paths created by dbrm ? how ? thx
How to find the number of rows in a db2 table?
What is view db2?
What is the difference between plan and package in db2?
What do you mean by rollback?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is nvl in db2?
How do I create a view in db2?