what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 Answers   Accenture,

---

What is a host variable?

3 Answers  

---

What is the purpose of using commit?

0 Answers  

---

How to find the maximum value in a column in the db2 database?

0 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

---

Explain the function done by data manager?

0 Answers  

---

Mention and explain the contention situations caused by locks?

1 Answers  

---

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 Answers  

---

how to get duplicate records from tables?write qurey for this?

4 Answers   ANZ,

---

How do I add a column to an existing table in db2?

0 Answers  

---

how to resolve -811

2 Answers   IBM,

---

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  

---