Answer / s

Result table contains rows DB2 selects from one or more
base tables.

Explain in brief how does db2 determine what lock-size to use?

0 Answers  

---

Is Cursor exicutable ?

3 Answers   TetraSoft,

---

My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,

---

what is the name of the default db2 catalog database?

3 Answers   IBM,

---

What is load replace in db2?

0 Answers  

---

---

What is a DB2 access path?

1 Answers  

---

What is pagespace?

1 Answers  

---

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  

---

What is concurrency in db2?

1 Answers  

---

what is the use of bind parameter, Replace?

5 Answers   IBM,

---

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

---