What information does the Runstats utility collect in DB2?
- Bufferpool statistics
- Index statistics
- Locking statistics
- Table statistics
The Runstats utility collects table statistics such as the number of rows, number of pages, and other distribution statistics that help the DB2 optimizer make better decisions.
Loading...
Related Quiz
- An organization is considering upgrading its database management system. Explain how understanding the editions and versions of DB2 would influence their decision-making process.
- What is the purpose of monitoring in DB2?
- What is the primary function of DB2 Control Center?
- Scenario: Due to budget constraints, a small organization is exploring free IDE options for DB2 development. What open-source alternatives to IBM Data Studio would you recommend, and what considerations should they keep in mind?
- Scenario: A company wants to ensure that every time a new record is inserted into a specific table, an email notification is sent to the administrator. Which database object in DB2 can help achieve this requirement?