Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is alias in db2?
What is db2?
What is difference between rollback and commit?
What is db2 bind?
What is sqlca’s maximum length?
What is a plan and package in db2?
What is a bind card?
What is the use of predicate?
What is the syntax for FETCH in DB2 ?
What is the connection string to connect to the DB2 Database ?
How and when does the db2 enforces the unique key?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Which is faster delete or truncate?
What is release/acquire in bind?
How can you find out the # of rows updated after an update statement?
