1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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?

Question Posted / veena

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

what is plan? is plan executable or package?

4 Answers  

what is difference between Plan and Package

1 Answers   Syntel,

COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 Answers  

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,

What is difference between isnull and coalesce?

0 Answers  




How do I create a view in db2?

0 Answers  

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  

wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,

What is the meaning of -805 SQL return code?

3 Answers  

What are the isolation levels possible ?

3 Answers  

What is db2 isolation?

2 Answers  

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  

For more DB2 Interview Questions Click Here
Categories