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

Speedgain's monitor modules can be used to determine the reasons for performance deficits.

The standard database monitoring information sources are often not sufficient to determine the weaknesses of a database server system. Database performance depends on many factors and resources. This variety of possible performance influencing factors is taken into account by the universal expandability of the Speedgain module plug-in interface. The monitoring options range from monitoring the internal DB2 latches, the number of dirty pages of a buffer pool to analyzing the Ethernet traffic of a network adapter. The monitor modules are a necessary extension of the standard database monitoring. Within the database standard monitoring the performance deficits are detected. The reasons for this can be determined by the targeted use of monitor modules.

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.


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.


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.


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.

Request trial license
Order for a trial.
Technical advice
Phone +49 (0) 511 5151 3700