Answer Posted / swetha

plan contains group of packages. plan is a pointer to
package.

What is bind and rebind in db2?

1186

---

What are the contents of a dclmgen?

1176

---

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1138

---

Can there be more than one cursor open for any program?

1223

---

what is diffrence b/w file-aid tool and file-aid utility???

4959

---

How can the duplicate values be eliminated from db2 select?

1156

---

How many databases are there?

1106

---

What is dbrm? What it contains?

1211

---

What is precompiler in db2?

1075

---

define clustering index.

1067

---

Is db2 a mainframe?

1093

---

How to find the maximum value in a column in the db2 database?

1125

---

What is a cursor in programming?

1112

---

What are catalog tables in db2?

1104

---

Explain in brief how does db2 determine what lock-size to use?

1086

---