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?
Answers were Sorted based on User's Feedback
Answer / lu
when u bind , 5 queries has 5 sql statements in 1 DBRM, its
regroup into 1 package, 1 plan...Plan is a collection of
packages..
correct me if i'm wrong..
Is This Answer Correct ? | 23 Yes | 0 No |
Answer / satish k
One correction to the above. DBRM is DataBase Request
Module and not DataBase Replacement Module.
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / ankur bhalla
1 DBRM(DATABASE REQUEST MODULE), 1 PACKAGE AND 1 PLAN.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
What is bind in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How is the value function used?
Plan has the optimized access path in it. But is that optimized access path is attained or known
What is dclgen in db2?
What are the Isolation levels possible ?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
What is the role of the data page in the db2 database?
when does the SQL statement gets executed when you use cursor in the application programming ?
what are bind concepts in db2 cobol?
How to connect to db2 database from windows command line?
can any one expalin check point with an example?