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.
| Is This Answer Correct ? | 35 Yes | 2 No |
Post New Answer View All Answers
Explain db2.
What parameters are used to control the free space in DB2?
What does runstats do in db2?
Which isolation level provides highest data integrity?
How to rename a table in DB2 ?
How to resolve deadlock issue
What is database manager in db2?
What is node in db2?
What is collection in db2 bind?
How can the duplicate values be eliminated from db2 select?
What is runstats db2?
What is universal database?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is nvl in db2?
What is bind plan?