Answer Posted / swetha dasari

the source for the above answer is :
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp
?topic=/com.ibm.db2.udb.doc/admin/r0002212.htm

i am not completely sure about the length

What is db2 look?

1019

---

What are union and union all?

976

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2322

---

What is a collection in db2?

1029

---

Define predicate?

1126

---

What is cloudant database?

1094

---

Mention the location where the output received from explain statement is stored.

1125

---

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1270

---

Explain about mirror activator disk mirroring?

1004

---

What is lock escalation in db2?

1029

---

Define data page.

1059

---

Mention some fields that are a part of sqlca.

1015

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9190

---

How would the varchar column remarks defined?

1086

---

How to compare data between two tables in db2?

1083

---