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 MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

---

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

---

What is UNION,UNION ALL?

2 Answers  

---

Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,

---

---

What is role in db2?

0 Answers  

---

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  

---

Is db2 a mainframe database?

0 Answers  

---

how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,

---

Compare a subselect to a join?

1 Answers  

---

Mention data types used in db2 ?

0 Answers  

---

what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

---