Answer Posted / mainframe virumbi

the following functions ( Aggregate functions )applied on
the columns.

Count
Avg
Min
MAx
....

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

1034

---

What's The Error Code For Unique Index Voilation?

1224

---

Can we delete records from view?

962

---

How can you classify the locks in db2?

1085

---

How do I create a view in db2?

1015

---

What parameters are used to control the free space in DB2?

1049

---

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 ?

2321

---

What is check constraint in db2?

1072

---

What is deadlock in db2?

1062

---

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1181

---

Can you use max on a char column?

1089

---

What is the information associated with sysibm.syslinks table?

1120

---

Before you give the explain statement, what are the prerogatives?

1024

---

What is the function of logging in the db2 database?

1116

---

Why cursor is used in db2?

1031

---