Answer Posted / islam

RELEASE has two parametre : commit & deallocate
RELEASE specify when the the db2 resources has to be set
free
if you use RELEASE(commit) then at every commit point db2
resources will be set free
but if u use RELEASE(DEALLOCATE) then once the whole
transaction is terminated, the db2 resources will be set
free
ACQUIRE serves the purpose of maintaining data consistency.
It has two parametre : ALLOCATE & USE
ACQUIRE(USE) - Opens table spaces and acquires locks only
when the application program bound to the plan first
uses them.

ACQUIRE(ALLOCATE) - Opens all table spaces and
acquires all table space locks when the plan is
allocated.

ACQUIRE(USE) - Fixed for Packages

What is null indicator in db2?

1107

---

What is the difference between cursor and select statement?

1097

---

What is copy pending status in db2?

1120

---

define clustering index.

1023

---

What is a buffer in memory?

1058

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2840

---

What do you mean by cursor?

988

---

What is concurrency?

1228

---

What is plan in cobol db2?

1132

---

What is the difference between oracle and db2?

1099

---

How can you do the explain of a dynamic sql statement?

1069

---

What do you mean by storage group (stogroup)?

1039

---

How to run db2 command in windows?

1191

---

What is buffer pool and list some of them?

1025

---

What is data manager?

1046

---