What does the RUNSTATS Utility do?
The RUNSTATS Utility collects statistical information for DB2 table spaces, partitions, indexes, tables and columns and stores this data in the DB2 Catalog.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
You have a file called docs.Z but do not know what it is. What is the easiest way to look at the contents of the file? 08.11.08
The .Z extension indicates that this is a file that has been compressed using the compress utility. The zcat utility provides the ability to display the content...What Utility is used to migrate DB2 from one release to the next ? 12.04.08
The DUMPCAT Utility....What is the STOSPACE Utility used for ? 09.04.08
The STOSPACE Utility updates the DB2 catalog with the DASD utilization of the table space and index space data sets....What can the SET option of the Repair Utility accomplish ? 05.04.08
The set option of the Repair utility can reset a copy pending, check pending, and recover pending flags....What is the purpose of the QUIESE Utility ? 05.04.08
The QUIESE Utility prevents the start of any new table space activity while it gives active threads a chance to finish their tasks. Once all thread are inactive...What is meant by index cardinality ? 02.04.08
The number of distinct values for a column is called index cardinality. DB2's RUNSTATS utility analyzes column value redundancy to determine whether to use a...When will you chose to run RUNSTATS ? 17.03.08
After a load, or after mass updates, inserts, deletes, or after REORG....What is RUNSTATS ? 17.03.08
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 statisti...What is SQL*Loader? 16.11.06
SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. One can load data into an Oracle database by using the sq...What utility can you use to show a dynamic listing of running processes? 26.03.06
Top-The top utility shows a listing of all running processes that is dynamically updated...