What is the use of db2 optimizer?

0 Answers  

---

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

---

Describe the elements of the SELECT query syntax?

3 Answers  

---

What does reorg do in db2?

0 Answers  

---

What is the use of runstats in db2?

0 Answers  

---

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  

---

How many databases are there?

0 Answers  

---

Request to database but database is not available so what is was abend is raised?

2 Answers   UST,

---

What is a buffer in memory?

0 Answers  

---

Explain what a plan is?

3 Answers   CTS,

---

what is cursor stability?

2 Answers   IBM,

---

What is the use of reorg in db2?

0 Answers  

---