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 alias in db2?

585


What is db2? Explain.

611


What is the purpose of rollback and commit?

601


List out the three types of page locks that can be held.

693


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2059






What os does db2 run on?

580


What is blu acceleration in db2?

615


What is cobol db2?

574


What are concurrency issues?

636


define clustering index.

627


How connect db2 database to datastage?

780


What are the full forms of spufi and dclgen and why are they used?

666


Explain dclgen.

732


When do you specify the isolation level?

621


What is a storage group (stogroup)?

789