Why use RUNSTAT Utility?
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 35 Yes | 2 No |
Answer / elavarasi
to provide statistical info. abt table,tablespace and index
| Is This Answer Correct ? | 20 Yes | 3 No |
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.
| Is This Answer Correct ? | 8 Yes | 4 No |
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
What is database alias db2?
What is coalesce in db2?
How can you quickly find out the number of rows updated after an update statement?
How many databases can be created inside an instance in db2 ?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
I use CS and update a page. Will the lock be released after I am done with that page?
How do you check for a null value in a db2 column?
How does db2 sample database connect?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
What information is held in SYSIBM.SYSCOPY?
how do we solve soc 7 and soc4 ?