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 node in db2?
What is dbrm library?
How do I start db2 in windows?
What do you mean by commit and rollback?
How can deadlocks be resolved?
What is explain plan in db2?
What is the clustering index in the db2 database?
How to execute stored procedures?
How to retrieve rows from a db2 table in embedded sql?
Explain about rct in db2?
How do I import a csv file into db2?
Which are the db2 tools to protect integrity of the database?
Why do chiropractors use drop table?
How is deadlock resolved?
How can you find out the # of rows updated after an update statement?