What does the RUNSTATS Utility do?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What does the RUNSTATS Utility do?

The RUNSTATS Utility collects statistical information for DB2 table spaces, partition, indexes, tables and columns and stores this data in the DB2 Catalog.

(Continued on next question...)

Other Job Interview Questions

• What is the difference between TYPE 1 index and TYPE 2 index?
• What are column-name qualifier used ?
• What is the difference between TYPE 1 index and TYPE 2 index?
• I need to view the number of tables existing under one particular OWNER
• Where besides the DB2 catalog is database object information stored by DB2?
• What is a host variable?
• What is the difference between Where and Having Clause ?
• How many sub queries can you combine together?
• How to see the structure of DB2 table?
• What is Maximum number of rows per page
• More...