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

What is ibm db2 connect?

0 Answers  


how can you access index

4 Answers   IBM, Tech Mahindra,


What is a thread?

3 Answers  


How to resolve -504 sql code in DB2?

2 Answers   Cap Gemini,


run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,






How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  


What is copy pending and check pending in db2?

0 Answers  


where can we use index and subscript ? with example ?

3 Answers   CTS,


what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,


if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,


How can you compare table column after update and before update?

5 Answers   Satyam,


Explain the contents that are a part of dclgen.

0 Answers  


Categories