Pre-requisites
The workshop contains four tutorials. Refer to the list below and their pre-requisites.
- Using DB2 monitoring text reports :: Requires DB2 9.7 Fixpack 1 or higher
- Leveraging TE reports :: Requires DB2 9.7 GA or higher
- Problem determination with TE reports :: Requires DB2 9.7 GA or higher
Database monitoring
Database monitoring is a vital activity to ensure performance and
and health of your database management system. To facilitate monitoring, DB2 collects
information from the database manager, its databases, and any connected applications.
You can then take the appropriate actions based on this information. Examples are:
- 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 instance, altering database manager configuration parameters, adding indexes, or modifying SQL queries)
Starting with DB2 Version 9.7, you can access monitor data through a light-weight
alternative to the traditional system monitor. Use monitor table functions to collect
and view data for systems, activities, or data objects.
Data for monitored elements are continually accumulated in memory and available for querying.
You can choose to receive data for a single object (for example, service class A or
table TABLE1) or for all objects.
The tutorial demonstrates how few of these monitoring functions can be used
to determine the reason for the problem, in this case performance slowdown.