Give some example of statistics collected during RUNSTATS?

1 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 are simple, segmented and partitioned table spaces ?

1 Answers   TCS,

---

What are the 4 environments which can access DB2 ?

2 Answers  

---

What Utility is used to migrate DB2 from one release to the next?

1 Answers  

---

What is meant by AUTO COMMIT?

3 Answers  

---

What is the format (internal layout) of ?TIMESTAMP??

1 Answers  

---

What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

---

What do you do to keep the cursor from closing after a commit?

1 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

What is the physical storage length of the data types date, time, and timestamp?

0 Answers  

---

What is sqlcode -922 ?

2 Answers  

---