What Utility is used to migrate DB2 from one release to the next?

1 Answers  

---

What is the difference between static and dynamic SQL?

1 Answers  

---

What is null value in db2?

0 Answers  

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

2 Answers  

---

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

---

Explain how can you do the explain of a dynamic sql statement?

0 Answers  

---

Why might full image copies be faster to implement than an incremental image copy?

4 Answers  

---

Name the different types of Table spaces.

5 Answers   IBM,

---

Which components manage deadlocks in db2?

0 Answers  

---

wht r the requirements for writing a cobol-db2 pgm ?

4 Answers   IBM,

---