Answer Posted / amarnadh reddy

hi,

Bind parameters are:
MEMBER - In bind package,
LIRARY - DBRM library name ,
ACTION(add/replace)- package or plan can be add or replace.
ISOLATION - Determines the duration of the page lock.
AQUIRE - Lock a tableon use
RELEASE - releases when the plan terminates
VALIDATE - It will be check about authorization.
EXPLAIN - loads the access path selected by the optimizer
in table

What is a db2 package?

1057

---

What do you mean by between and in? Is between inclusive of specified range values?

1092

---

How is the value function used?

1154

---

What are the full forms of spufi and dclgen and why are they used?

1087

---

What is db2 bind process?

1238

---

What is query_cache_limit?

970

---

Which are the db2 tools to protect integrity of the database?

1121

---

How to resolve deadlock issue

20126

---

Why do we bind in db2?

1210

---

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

1108

---

What is cursor stability in db2?

1356

---

Comment whether the cursor is closed during commit or not.

1105

---

How can deadlocks be resolved?

936

---

What is a db2 cursor?

1055

---

How does db2 sample database connect?

1029

---