what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

---

Explain the contention situations caused by locks?

0 Answers  

---

What is innodb buffer pool?

0 Answers  

---

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,

---

Do we need cursor for Count(*)?

4 Answers   iGate,

---

---

What is the use of value function?

0 Answers  

---

What is multi row fetch in db2?

0 Answers  

---

List out the data types available.

0 Answers  

---

What are the three DB2 date and time data types and their associated functions?

1 Answers  

---

What is lock escalation?

2 Answers  

---

in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

1 Answers   IBM,

---

what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,

---