Answer Posted / mahesh babu

select column_name,count(*) from table_name group by
column_name having count>1.

What is buffer pool in the db2 database?

1104

---

How to compare data between two tables in db2?

1088

---

Explain in brief how does db2 determine what lock-size to use?

1045

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1067

---

Explain dclgen.

1200

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1106

---

How do I connect my db2 database to ibm?

1050

---

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1081

---

How to create db2 table in mainframe?

1154

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2065

---

What is lock escalation in db2?

1032

---

How do I copy a table in db2?

1000

---

what is a corelated subquerry?

1122

---

What is an instance database?

1052

---

What is cursor with hold option in db2?

1072

---