What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

---

What is performance tuning db2?

0 Answers  

---

what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

---

What is a predicate?

1 Answers  

---

What is meant by explain?

0 Answers  

---

wht r the requirements for writing a cobol-db2 pgm ?

4 Answers   IBM,

---

What is cobol db2?

0 Answers  

---

What is SPUFI?

4 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,

---

What is a db2 package?

0 Answers  

---

How do you retrieve the data from a nullable column?

2 Answers  

---

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,

---