1.

What is the RUN STATS that was mentioned in the previous answer?

Answer»

RUN STATS is a DB2 utility used to collect statistics about the data value in TABLES. It is used by the optimizer to decide the access PATH. RUN STATS ALSO collects statistics that are used for space management. These statistics are stored in the DB2 catalog tables.

Usually, the RUN STATS is run after the FOLLOWING:

  • After a load.
  • After a mass update.
  • After any MAJOR DELETIONS, insertions, or
  • After REORG the table.


Discussion

No Comment Found

Related InterviewSolutions