Why use RUNSTAT Utility?

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

(Continued from previous question...)

Why use RUNSTAT Utility?

Because the DB2 Optimizer need accurate data in order to formulate the most efficient access path given the state of the environment and because the information will help the DBA to monitor the condition of the object in the DB2 subsystem.

(Continued on next question...)

Other Job Interview Questions

• What is the Manimum Length SQLCA and what is the content of SQLCABC?
• Is it mandatory to use DCLGEN? If not, why would you use it at all ?
• What is the COBOL picture clause for a DB2 column defined
• What are the three DB2 date and time data types and their associated functions?
• What is subquery ?
• How will you delete duplicate records from a table ?
• What is the easiest way to find out which programs are affected by change in a table's structure ??
• Why use RUNSTAT Utility?
• How many Buffer pools are there in DB2 and what are they ?
• Usually, which is more important for DB2 system performance
• More...