Answer Posted / guna

If there is no commit while closing cursor or a program,
processed records are lost when an abnormal end occurs.
Say, if due to the execution of the program some rows are
inserted/deleted/updated in a table, those changes will be
lost.
It is a better practice to give commit after every
insertion/updation queries and before terminating a
program.

What is syscat in db2?

959

---

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

1064

---

How do we specify index to include or not during bind process.

2087

---

What is the maximum size of varchar data type in db2?

1084

---

What is lock escalation in db2?

978

---

How does db2 sample database connect?

985

---

What is the difference between bind and rebind in db2?

1413

---

How would the varchar column remarks defined?

1041

---

What are db2 tables?

1067

---

How is deadlock resolved?

1093

---

Mention the location where the output received from explain statement is stored.

1080

---

Explain about rct in db2?

1056

---

Differentiate between cs and rr isolation levels? Where do you specify them?

1035

---

What is the use of runstats in db2?

1048

---

What is buffer pool in the db2 database?

1061

---