DB2 UDB
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