Why use RUNSTAT Utility?

Question Posted / guest

3 Answers
23957 Views
Merrill Lynch, I also Faced
E-Mail Answers

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

Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 Answers

What is reorg?

0 Answers

What is page size in db2?

0 Answers

How many clustering indexes can be defined for a table?

2 Answers

What is a Cartesian product?

2 Answers

What is collection in db2 bind?

0 Answers

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?