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 the physical storage length of the data types date, time, and timestamp?
Which component is responsible for processing sql statements and selecting access paths?
What is the difference between plan and package in db2?
What are the uses of db2 optimizer?
What do you mean by cursor?
Define predicate?
What is the difference between db2 and oracle?
How is a typical db2 batch pgm executed?
What db2 400?
What is the picture clause of null indicator variable?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is db2 bind?
Which isolation level provides maximum concurrency?
What is the physical storage length of timestamp data type?
Explain about mirror activator disk mirroring?