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



If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created an..

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

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created an..

Answer / shailesh

1 DBRM only.
Correct me if I am wrong !

Is This Answer Correct ?    15 Yes 0 No

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created an..

Answer / sampath

1 DBRM, 1 Package & 1 plan

Is This Answer Correct ?    13 Yes 0 No

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created an..

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

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created an..

Answer / satish

yes only 1 DBRM will create

Is This Answer Correct ?    8 Yes 0 No

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created an..

Answer / ankur bhalla

1 DBRM(DATABASE REQUEST MODULE), 1 PACKAGE AND 1 PLAN.

Is This Answer Correct ?    5 Yes 0 No

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created an..

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

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created an..

Answer / sunil a

1 DBRM , 1 PACKAGE and 1 PLAN

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More DB2 Interview Questions

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  


Is db2 a programming language?

0 Answers  


Where would you find information about the type of database authority held by the user?

2 Answers  


What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  


quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  






What is an alias and how does it differ from a synonym?

3 Answers  


What is the function of buffer manager?

1 Answers  


Why do we use cursor?

0 Answers  


how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,


4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,


define clustering index.

0 Answers  


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

0 Answers  


Categories