What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

What are the three lock types?

2 Answers  

---

What is correlation names?

1 Answers  

---

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

3 Answers   Tech Mahindra,

---

Give some example of statistics collected during RUNSTATS?

1 Answers  

---

why we go for SPUFI for creating tables or for sql queries?

4 Answers  

---

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

---

What is a root page?

1 Answers  

---

select 100 records from million records ?

2 Answers   Verizon,

---

What are types of indexes?

0 Answers  

---

Define db2 and its databases?

0 Answers  

---

What does db2 mean?

0 Answers  

---