Answer Posted / krishnan

-805 program is not present in the plan.
u need to compile,package and plan the program once

What is temporal table in db2?

1101

---

What action db2 takes when a program aborts in the middle of a transaction?

1196

---

How do I optimize a query in db2?

1150

---

Explain about open switch business continuity software?

1183

---

What is the physical storage length of date data type?

1308

---

What are concurrency issues?

1171

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2911

---

What is buffer pool?

1160

---

Is ibm db2 open source?

1132

---

Differentiate between cs and rr isolation levels? Where do you specify them?

1120

---

What is catalog database in db2?

1218

---

What is load utility in db2?

1229

---

What are the contents of a dclmgen?

1176

---

What do you mean by between and in? Is between inclusive of specified range values?

1140

---

What is universal database?

1118

---