Mention the different locking levels that are available in db2.

1127

---

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

1100

---

Discuss about db2 bind?

1094

---

List out the data types available.

1151

---

Define sqlca.

1105

---

Explain packages.

1109

---

Mention the definition of cobol in varchar field.

1247

---

Explain the function done by data manager?

1276

---

Define buffer pool.

1050

---

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

1051

---

Explain in detail about buffer manager and its functionalities?

1063

---

Mention the various locks that are available in db2.

1036

---

Explain about dbrm.

1042

---

What does a deadlock mean in DB2?

1161

---

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

1170

---