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
How would the varchar column remarks defined?
What is the use of db2 optimizer?
What parameters are used to control the free space in DB2?
How do I optimize a query in db2?
What is a collection in db2?
Is db2 relational database?
What is meant by dclgen?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How do you eliminate duplicate values in db2?
What is db2 instance?
Explain various types of locks in db2?
What does reorg do in db2?
What is with ur in db2?
What is the physical storage length of timestamp data type?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
