Mention the different locking levels that are available in db2.

1183

---

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

1156

---

Discuss about db2 bind?

1150

---

List out the data types available.

1199

---

Define sqlca.

1164

---

Explain packages.

1163

---

Mention the definition of cobol in varchar field.

1313

---

Explain the function done by data manager?

1326

---

Define buffer pool.

1097

---

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

1106

---

Explain in detail about buffer manager and its functionalities?

1135

---

Mention the various locks that are available in db2.

1079

---

Explain about dbrm.

1101

---

What does a deadlock mean in DB2?

1215

---

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

1227

---