Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17857 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 |
How do you insert a record with a nullable column?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
What is the use of db2?
Is it possible using max on a char column?
What are the uses of db2 optimizer?
What does it mean if the null indicator has -1, 0, -2?
What is reorg and runstats in db2?
What do you mean by cursor?
What does db2 mean?
What is dbrm in db2 database?
What is a DBRM, PLAN ?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
COBOL 
