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
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 |
What is ibm db2 connect?
how can you access index
What is a thread?
How to resolve -504 sql code in DB2?
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 ?...
How can we define a table? How can we apply SEARCH ALL on it ?
What is copy pending and check pending in db2?
where can we use index and subscript ? with example ?
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..
How can you compare table column after update and before update?
Explain the contents that are a part of dclgen.