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?
Answer Posted / 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 |
Post New Answer View All Answers
Mention the definition of cobol in varchar field.
On which levels locks can be applied?
What is host variable?
Define data page.
can we view the access paths created by dbrm ? how ? thx
What is db2 connect?
Is db2 a mainframe database?
How can you find out the # of rows updated after an update statement?
What is the role of union all and union
What is the difference between cursor and select statement?
When reorg is used?
What is difference between alias and synonym in db2?
What is database manager in db2?
What kind of database is db2?
Where do you specify them?