Mention the different locking levels that are available in db2.

1188

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1165

---

Discuss about db2 bind?

1158

---

List out the data types available.

1206

---

Define sqlca.

1174

---

Explain packages.

1173

---

Mention the definition of cobol in varchar field.

1316

---

Explain the function done by data manager?

1338

---

Define buffer pool.

1103

---

Outputs of explain are with matchcols = 0. What does this signify?

1113

---

Explain in detail about buffer manager and its functionalities?

1146

---

Mention the various locks that are available in db2.

1089

---

Explain about dbrm.

1110

---

What does a deadlock mean in DB2?

1221

---

What is the advantage in De-normalizing tables in DB2?

1237

---