Answer / 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.

Answer / elavarasi

to provide statistical info. abt table,tablespace and index

Answer / avinash

It provide the summary information about the
characteristics of data available in table, indexes etc.
DB2 records these information into the CATLOG table and use
this information to decide on the access path to data
during the bind process. To obtain the statistics you can
query the catalog table.

How to see the structure of db2 table??

4 Answers   IBM,

---

Name the lockable units in DB2?

0 Answers  

---

What do you mean by NOT NULL WITH DEFAULT? When will you use it?

3 Answers  

---

What is a cursor in programming?

0 Answers  

---

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  

---

how can we find nth max salary from A table

5 Answers   IBM,

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 Answers  

---

What is deadlock?

2 Answers  

---

What are delete-connected tables?

1 Answers  

---

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

---

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

0 Answers  

---

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,

---