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

How do you pull up a query which was previously saved in qmf?

1149

---

Highlight all the advantages that are attached to a package.

1119

---

What is bind in db2?

1042

---

Is db2 a mainframe database?

1000

---

What is dbrm? When it will be created?

1029

---

What are host variables in db2?

1072

---

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1270

---

What is the purpose of rollback and commit?

1193

---

Why select is not preferred in embedded sql programs?

1299

---

What is a bind in db2?

1042

---

How do I delete a table in database?

1021

---

Can one database have multiple instances?

1054

---

What is the difference between db2 and oracle?

1131

---

How can you find out the # of rows updated after an update statement?

1116

---

What is buffer pool and list some of them?

1028

---