The Speedgain Module plug-in interface allows dynamic extension of standard database monitoring

New functionality can be dynamically added to Speedgain using the Plug-in Procedure module. This makes it possible, for example, to integrate your own monitoring scripts.

DB2 THREAD MONITOR

The internal threads of the DB2 Process Model are the "workers" of the database system. These threads are used to perform many different tasks. There are threads that write the log records (logos) to plate or others that write the changed pages (dirty pages) to the tablespaces. The activities and the resulting resource consumption of these workers are recorded by the DB2 THREAS module. The data is used to assess the effectiveness or configuration of a system.

DB2 LATCH MONITOR

Not all internal tasks of a database can be performed independently. The serialization of these activities is realized via latches (traffic light control). Errors within the traffic light control prevent the flowing data traffic. The Latch Monitor module makes bad traffic light control visible by logging blocking latches and waiting applications and indicates performance problems that are otherwise difficult to explain.

KERNEL SETTING MONITOR

Like any application, the database uses a variety of operating systems. The operation of many functions can be configured and optimized for the tasks of a database by kernel parameters.

The Kernel Setting Monitor logs the setting of the most important parameters at regular intervals - usually one log per day is sufficient. The time interval is configurable and can be shortened or extended according to the current requirements.