What do you need to do before you do EXPLAIN?

1 Answers  

---

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers  

---

Mention the various locks that are available in db2.

0 Answers  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

What is db2 stogroup?

0 Answers  

---

---

What is an intent lock?

3 Answers  

---

B37 abend during spufi?

0 Answers   IBM,

---

What is the use of predicate?

0 Answers  

---

What db2 400?

0 Answers  

---

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

---

how to unload different table data into different gdg files/ vsam files.

3 Answers  

---

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  

---