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 does db2 mean?

577


Mention the downsides of page level lock.

701


What is the difference between drop table and delete table?

541


What are catalog tables in db2?

601


How to take backup of table in db2?

591






How do you simulate the explain of an embedded sql statement in spufi/qmf?

625


What is catalog database in db2?

636


What is the physical storage length of time data type?

664


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

577


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2373


What is a cursor in programming?

587


Name the lockable units in DB2?

657


What is role in db2?

610


Explain in brief how does db2 determine what lock-size to use?

587


Which command is used to remove all rows from a table?

546