Germain is configured to monitor Uptime and Performance 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 SQL SERVER 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
Script to grant these permissions: USE master;GRANT SELECT ON sys.dm_os_performance_counters TO germain-user;GRANT SELECT ON sys.dm_exec_sessions TO germain-user;GRANT VIEW SERVER STATE TO germain-user;
Log on to Germain Workspace > left menu > Wizards > Rules