How does eG Enterprise Monitor DB2 Active-Passive Cluster?

eG Enterprise collects metrics from the DB2 Active-Passive Cluster in an agentless manner only - i.e., using an eG remote agent deployed on a remote host in the environment. eG Enterprise uses the cluster IP to connect to the target cluster and retrieve the required metrics. To enable the eG agent to monitor and collect metrics from the target cluster, certain prerequisites must be fulfilled.

Pre-requisites for monitoring DB2 Active-Passive Cluster

To monitor DB2 Active-Passive Cluster using eG Enterprise, the following pre-requisites must be fulfilled.

  1. Create a user for monitoring purpose - say, eguser - at the OS-level on the operating system hosting the target DB2 server. Specify the name of this user in the USER text box while configuring the tests in the test configuration page. This user must be present on all nodes of the cluster to be monitored.

  2. Grant the required permissions to this user to allow the eG agent to collect monitoring data, by connecting to the database as the user with SECADM or SYSADM privilege using the following command: 

    CONNECT TO <dbname> USER <username> USING <password>;

    For example:

    CONNECT TO ProdDB USER db2admin USING p@ssword123;

    where,

    ProdDB: Name of the target database.

    db2admin: Admin user with SECADM or SYSADM privileges.

    p@ssword123: Password for the admin user.

    eGuser: Monitoring user to whom privileges are granted.

  3. To retrieve historical and real-time performance data, the user must be granted SELECT permissions on the following tables:

    SYSIBMADM.DB_HISTORY

    SYSIBMADM.MON_CURRENT_SQL

  4. To collect detailed insights into DB2 operations, activity, memory, and high availability status, grant the user EXECUTE permissions on the following functions:

    • SYSPROC.MON_GET_ACTIVITY

    • SYSPROC.MON_GET_CONNECTION

    • SYSPROC.MON_GET_DATABASE

    • SYSPROC.MON_GET_INSTANCE

    • SYSIBMADM.MON_CURRENT_SQL

    • SYSPROC.MON_GET_MEMORY_SET

    • SYSPROC.MON_GET_TABLESPACE

    • SYSPROC.MON_GET_TRANSACTION_LOG

    • SYSPROC.MON_GET_HADR