Answer Posted / ashish kumar

A DB2 bind is a process that builds an access path to DB2
tables.

A BIND process establishes a relationship between an APPLICATION
PROGRAM and its RELATIONAL DATA.
A plan is an executable module containing the access path logic
produced by the Db2 optimizer. It can be composed of one or
more DBRMs and packages.
The plans are available in the Catalog table SYSIBM.SYSPLAN

DB2 Bind compiles all your sql statements(dbrm) into an
executable format.
It uses DB2 Optimizer to create the better access path.
Package is the executable access path code for the sql
statements in the DBRM

Plan contains package list which is nothing but pointers to
packages.

What is coalesce in db2?

1136

---

What is syscat in db2?

1014

---

What is deadlock in db2?

1071

---

What is dbrm library?

1065

---

What is the use of dclgen in db2?

1085

---

What is meant by explain?

1133

---

What are the bind parameters ibm db2?

1053

---

Can there be more than one cursor open for any program?

1169

---

Which command is used to connect to a database in DB2 ? Give the Syntax.

1104

---

Differentiate between cs and rr isolation levels? Where do you specify them?

1071

---

can all users have the privilage to use the sql statement select * (dml)?

1174

---

Why select is not preferred in embedded sql programs?

1302

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3581

---

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

7101

---

What is the usage of open cursor command?

1100

---