Features

Germain can be configured to perform basic availability monitoring, as well as more in-depth monitoring of DB2 database servers. 

For basic monitoring of a single instance, Germain uses a regular database user account with CONNECT permissions.

In order to perform more in-depth monitoring, the database user needs to be granted additional permissions to execute queries against a series of system views and tables.

Please note that Germain can monitor any other DB2 tables (system or data) i.e. the above requirements are the bare minimum requirements yet can be extended to any other tables. Germain User permissions:

Table / View

Permission

SYSIBMADM.TBSP_UTILIZATION

SELECT

SYSIBMADM.LOG_UTILIZATION

SELECT

SYSIBMADM.LOCKS_HELD

SELECT

SYSIBMADM.LOCKWAITS

SELECT

SYSIBMADM.APPL_PERFORMANCE

SELECT

SYSIBMADM.BP_HITRATIO

SELECT

SYSIBMADM.APPLICATIONS

SELECT

SYSIBMADM.LONG_RUNNING_SQL

SELECT

Configuration

Germain Workspace > Left Menu > Wizard > DB2 UDB