Why use RUNSTAT Utility?

Answers were Sorted based on User's Feedback



Why use RUNSTAT Utility?..

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

Why use RUNSTAT Utility?..

Answer / elavarasi

to provide statistical info. abt table,tablespace and index

Is This Answer Correct ?    20 Yes 3 No

Why use RUNSTAT Utility?..

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

Post New Answer

More DB2 Interview Questions

what is Static and dynamic linking

1 Answers   Virtusa,


What is the default page size of buffer pools?

0 Answers  


Explain the use of the WHERE clause?

1 Answers  


how we will do null data selection in cobol-db2 program

2 Answers   Wipro,


How to create db2 table in mainframe?

0 Answers  






how to fetch first 100 rows in db2

2 Answers   IBM,


Give the name of some fields form sqlca.

0 Answers  


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  


What is sqlca’s maximum length?

0 Answers  


What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  


Explain the use of the WHERE clause.

2 Answers   IBM,


what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,


Categories