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 db2 and what is the use of db2 optimizer?

1071

---

How to check last update on table in db2?

1063

---

How to find the maximum value in a column in the db2 database?

1084

---

How to fetch the last row from the table in SQL (db2)?

1657

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2073

---

What is a db2 schema?

1241

---

What is difference between rollback and commit?

1167

---

What is copy pending and check pending in db2?

1007

---

What is page size in db2?

983

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1110

---

What is runstats utility in db2?

1027

---

What are host variables in db2?

1075

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2860

---

What is drop table?

1020

---

What is temporal table in db2?

1047

---