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


Please Help Members By Posting Answers For Below Questions

What is cursor in dbms?

699


What is the difference between cursor stability and repeatable read isolation levels?

776


What is cobol db2?

644


How does coalesce work?

669


What are db2 objects?

717






What is the use of reorg in db2?

697


How to check last update on table in db2?

708


How will you return the number of records in table?

595


What is cursor with hold option in db2?

707


What is reorg and runstats in db2?

794


What is difference between isnull and coalesce?

688


What is the syntax for creating a table in the db2 database?

719


What is the information associated with sysibm.syslinks table?

754


How does cobol compile db2 program?

707


What is an instance database?

694