Answer Posted / harish

yes, commit-it will save the changes that we done to db2
table

when operation is performed successfully table will be auto
committed its default,suppose if any abends occur all
changes will be rolled back , table will come to original
status

since while updating millions of records somewhere some
abend occurs that time its better to have commit ,so till
upto abend whatever changes occured in table will be
saved.....

pls let me know if u have any queries

HARISH POOMGAME SHIVAPPA
NIIT TECHNOLOGY
KOLKATA

What does sqlcabc has?

1058

---

How to fetch the last row from the table in SQL (db2)?

1657

---

Name the various locking levels available?

1099

---

Define declaration generator (dclgen).

1122

---

What is alias in db2?

1066

---

Which command is used to remove all rows from a table?

1114

---

What does a deadlock mean in DB2?

1169

---

What does db2 plan contain?

1029

---

Why cursor is used in db2?

1038

---

What is copy pending status in db2?

1127

---

What is the information associated with sysibm.syslinks table?

1126

---

What is a db2 package?

1065

---

What is phantom read in db2?

1163

---

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

1087

---

What is the difference between dbm cfg and db cfg file in db2 ?

1540

---