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

How to run db2 command in windows?

0 Answers  


1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,


What are the disadvantages of using VARCHAR?

3 Answers  


What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,


What happens in bind step in a db2 program?

0 Answers  






In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  


Is db2 free?

0 Answers  


What do you mean by commit and rollback?

0 Answers  


Mention the definition of cobol in varchar field.

0 Answers  


How do you run JCL in cobol program

1 Answers   IBM, Syntel,


I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  


a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  


Categories