when u bind , 5 queries has 5 sql statements in 1 DBRM, its regroup into

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?

Question Posted / lu

8 Answers
18120 Views
Accenture, I also Faced
E-Mail Answers

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

What is db2 bind process?

1232

What is package in cobol db2?

1113

Which is faster delete or truncate?

1121

How can you classify the locks in db2?

1085

What is a Foreign Key?

1090

What is runstats utility in db2?

1016

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

1103

Mention the various locks that are available in db2.

1031

Which component is used to execute the sql statements?

1089

Explain the benefits you can get from mainframe connect?

968

What is page size in db2?

970

What is a db2 collection?

1027

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?

2081

What are the contents of a dclmgen?

1117

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1096