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 are the various data types available in db2?

1011

---

What is the difference between cursor and select statement?

1051

---

What os does db2 run on?

923

---

What is buffer pool?

1028

---

What is the use of value function?

1073

---

How to create db2 table in mainframe?

1100

---

What is rebind in db2?

998

---

How to compare data between two tables in db2?

1029

---

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

990

---

What are bind parameters in db2?

979

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3142

---

What is dbrm? When it will be created?

956

---

What is a system catalog table in db2?

1100

---

How do I connect my db2 database to ibm?

984

---

What is db2 plan table?

991

---