DB2 Version 10.1 for Linux, UNIX, and WindowsDatabase monitoring
The term database monitoring refers to the tasks associated with examining the operational status of your database.
Database monitoring is a vital activity for the maintenance of
the performance and health of your database management system. To
facilitate monitoring, DB2® collects
information from the database manager, its databases, and any connected
applications. With this information you can perform the following
types of tasks, and more:
- Forecast hardware requirements based on database usage patterns.
- Analyze the performance of individual applications or SQL queries.
- Track the usage of indexes and tables.
- Pinpoint the cause of poor system performance.
- Assess the impact of optimization activities (for example, altering database manager configuration parameters, adding indexes, or modifying SQL queries).