Answer / s

I think you mean the three types of LOCK MODES.
S Share
U Update
E Exclusive

What is a clustering index ?

3 Answers  

---

What is bufferpool in db2?

1 Answers  

---

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

1 Answers   TATA,

---

What does an outer join do?

1 Answers   CTS,

---

How to view db2 table structure?

1 Answers  

---

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,

---

wht r the requirements for writing a cobol-db2 pgm ?

4 Answers   IBM,

---

how can u nderstand the sql stmts executed successfully or not ?

1 Answers   TCS,

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  

---

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,

---

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

---