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


Please Help Members By Posting Answers For Below Questions

Mention the definition of cobol in varchar field.

776


On which levels locks can be applied?

750


What is host variable?

683


Define data page.

714


can we view the access paths created by dbrm ? how ? thx

6439






What is db2 connect?

691


Is db2 a mainframe database?

646


How can you find out the # of rows updated after an update statement?

731


What is the role of union all and union

727


What is the difference between cursor and select statement?

714


When reorg is used?

761


What is difference between alias and synonym in db2?

726


What is database manager in db2?

635


What kind of database is db2?

662


Where do you specify them?

770