DBA > Job Interview Questions > DB2 INTERVIEW QUESTIONS

What is RUNSTATS?

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

(Continued from previous question...)

What is RUNSTATS?

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.

(Continued on next question...)

Other Job Interview Questions