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 / satish
yes only 1 DBRM will create
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is syscat in db2?
What is buffer pool in the db2 database?
What is a storage group (stogroup)?
What is dbrm? When it will be created?
What is a db2 schema?
define clustering index.
What do you mean by between and in? Is between inclusive of specified range values?
How to find primary key of a table in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How can you classify the locks in db2?
What is runstats and reorg in db2?
Outputs of explain are with matchcols = 0. What does this signify?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How is the value function used?