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 cursor in dbms?
What is the difference between cursor stability and repeatable read isolation levels?
What is cobol db2?
How does coalesce work?
What are db2 objects?
What is the use of reorg in db2?
How to check last update on table in db2?
How will you return the number of records in table?
What is cursor with hold option in db2?
What is reorg and runstats in db2?
What is difference between isnull and coalesce?
What is the syntax for creating a table in the db2 database?
What is the information associated with sysibm.syslinks table?
How does cobol compile db2 program?
What is an instance database?