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?
- 8 Answers
- 16629 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What does the CHECK Utility do ?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
Give some example of statistics collected during RUNSTATS?
What is a bind in db2?
Is ibm db2 open source?
What r the comman abends in db2, jcl and cobol???????
What is cloudant database?
how do we solve soc 7 and soc4 ?
how to resolve -805 . how to see dbrm and package not found
What is meant by union and union all?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
COBOL 
