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 alias in db2?
What is db2? Explain.
What is the purpose of rollback and commit?
List out the three types of page locks that can be held.
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?
What os does db2 run on?
What is blu acceleration in db2?
What is cobol db2?
What are concurrency issues?
define clustering index.
How connect db2 database to datastage?
What are the full forms of spufi and dclgen and why are they used?
Explain dclgen.
When do you specify the isolation level?
What is a storage group (stogroup)?