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

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3583

---

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

1290

---

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1112

---

How is a typical db2 batch pgm executed?

1183

---

How to check table size in db2 sap?

1045

---

What do you mean by storage group (stogroup)?

1043

---

What is db2 bind process?

1246

---

What is the maximum length of sqlca?

1533

---

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

1185

---

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1079

---

What is difference between alias and synonym in db2?

1149

---

What is meant by explain?

1138

---

How do I delete a table in db2?

1083

---

Before you give the explain statement, what are the prerogatives?

1044

---

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

1139

---