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


Please Help Members By Posting Answers For Below Questions

What is query_cache_limit?

546


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

6262


List down the data types in the db2 database.

636


What is the use of db2?

588


Why do we bind in db2?

634






What is a db2 cursor?

626


Explain about rct in db2?

640


What is load utility in db2?

668


What is check constraint. Explain with example.

650


Explain various types of locks in db2?

693


What does runstats do in db2?

607


How many types of page locks can be held in db2?

593


How can the duplicate values be eliminated from db2 select?

633


what is utility for parm lib

1884


What is nvl in db2?

628