Which components manage deadlocks in db2?

0 Answers  

---

Mention the different locking levels that are available in db2.

0 Answers  

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

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

3 Answers   CTS, IBM,

---

what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

---

what is load and unload in db2

1 Answers   IBM,

---

Is Cursor exicutable ?

3 Answers   TetraSoft,

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---

what is the Foreign key? explain?

2 Answers  

---

How do you run JCL in cobol program

1 Answers   IBM, Syntel,

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

What is lock escalation?

2 Answers  

---