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
Is schema the same as database?
Outputs of explain are with matchcols = 0. What does this signify?
Can one database have multiple instances?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is db2 connect?
What is the use of value function?
How would you find out the total number of rows in a db2 table?
How many databases can be created inside an instance in db2 ?
How to connect to db2 database from windows command line?
What is innodb buffer pool?
Who uses db2?
What are the uses of db2 optimizer?
can we view the access paths created by dbrm ? how ? thx
Mention the different locking levels that are available in db2.