Answer Posted / sajjan jindal

IT is a DB2 utility used to collect statistics about the
data values in tables which can be used by the optimizer to
decide the access path. It also collects statistics used
for space management. These statistics are stored in DB2
catalog tables.

The RUNSTAT is executed after a load, or after mass
updates, inserts, deletes, or after REORG.

Define predicate?

1103

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3185

---

What is the purpose of rollback and commit?

1167

---

Is schema the same as database?

1042

---

What is runstats and reorg in db2?

1282

---

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

1048

---

what are bind concepts in db2 cobol?

1070

---

What are the benefits of using the db2 database?

1208

---

Can we insert update delete in view?

948

---

What is the meaning concurrency in the db2 database?

1092

---

How to run db2 command in windows?

1175

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3562

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2042

---

How do you stop a db2 database in linux?

993

---

What are the uses of db2 optimizer?

1274

---