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

Is db2 relational database?

1044

---

Define sqlca.

1172

---

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1322

---

What is the maximum size of a char data type in db2?

1052

---

Explain about rct in db2?

1163

---

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11745

---

What is the role of the data page in the db2 database?

1082

---

What is drop table?

1067

---

What is bind in db2?

1096

---

What is cursor in dbms?

1113

---

What is the maximum number of columns in a db2 table?

1348

---

What is a system catalog table in db2?

1244

---

How to check sequence on a table in db2?

1116

---

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

1206

---

If I have a view which is a join of two or more tables, can this view be updateable?

1184

---