How can deadlocks be resolved?

0 Answers  

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

---

What is the use of reorg in db2?

0 Answers  

---

Why do we use cursor?

0 Answers  

---

Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  

---

---

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

2 Answers   Accenture,

---

What does the RUNSTATS Utility do?

4 Answers  

---

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---

Are views updatable ?

4 Answers  

---

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,

---

How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---