How is deadlock resolved?

0 Answers  

---

What are some characteristics of columns that benefit from indexes?

1 Answers  

---

how 2 resolve the -311 sqlcode

1 Answers  

---

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,

---

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  

---

What is the syntax for creating a table in the db2 database?

0 Answers  

---

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  

---

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

---

What are concurrency issues?

0 Answers  

---

How can you do the explain of a dynamic sql statement?

0 Answers  

---

Can SQL statements/queries be included in a copybook?

2 Answers  

---

What is isolation level in db2?

0 Answers  

---