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 are the three DB2 date and time data types and their associated functions?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
What is ALTER ?
what is the name of the default db2 catalog database?
How many buffer pools are there in DB2?
What is syscat in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Explain in detail about buffer manager and its functionalities?
What is meant by the attachment facility?
What does an outer join do?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
What is an instance database?