Pre-requisites


The workshop contains four tutorials. Refer to the list below and their pre-requisites.

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:

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.