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 / ankur bhalla

1 DBRM(DATABASE REQUEST MODULE), 1 PACKAGE AND 1 PLAN.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is db2 purescale?

556


What is the physical storage length of timestamp data type?

650


Explain about open switch business continuity software?

571


How do you concatenate the firstname and lastname from emp table to give a complete name?

610


What is dbrm library?

586






What is buffer pool?

626


What is db2 catalog database?

590


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1633


What is null indicator in cobol db2?

595


What is db2 command?

593


Mention some fields that are a part of sqlca.

609


What are concurrency issues?

635


What is bind and rebind in db2?

657


What types of tables are there in the db2 database?

562


When reorg is used?

685