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
17868 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 buffer pool in the db2 database?

1057

Who uses db2?

990

Explain dclgen.

1152

What is commit in db2?

1004

What is the physical storage length of timestamp data type?

1035

What is isolation level in db2?

955

What is bind package and plan in db2?

1017

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1129

What is db2? Explain.

998

How do I add a column to a table in db2?

1062

Explain in detail about buffer manager and its functionalities?

1018

What is the role of data manager in the db2 database?

1065

i want to maintain uniqueness on pdf without make lf??????????

2116

What is the difference between drop table and delete table?

1138

How to create backup table in db2?

1056