Answer Posted / harsha

check point and restart logic are mainly used when our
table has 1000 records and we are getting abend after 100
records and we want to start the execution after 100th
record we use this.for this we have to use check points for
every 100 records

What is runstats utility in db2?

1028

---

Mention some fields that are a part of sqlca.

1043

---

Can you tell me how can you find out the # of rows updated after an update statement?

1101

---

What is null indicator in db2?

1120

---

Comment whether the cursor is closed during commit or not.

1112

---

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

2071

---

What is innodb buffer pool?

1063

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1242

---

How many databases are there?

1061

---

What is temporal table in db2?

1047

---

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

1090

---

What is sqlca’s maximum length?

1197

---

Name the lockable units in DB2?

1133

---

What is dbrm? What it contains? When it will be created?

1053

---

What is meant by dclgen?

1116

---