Question: what are runstats in db2?
Answer: RUNSTATS is a DB2 utility that captures detailed information about the DB2 objects, tables, indexes, etc. and stores that information in the DB2 catalog. DB2 uses this data when trying to determine the best access path for getting the data requested by the SQL.