Pre-requisites for Monitoring DB2 Server

Before monitoring a DB2 server, certain pre-requisites must be completed to ensure smooth and secure data collection. These configurations help establish proper authentication, permissions, and secure communication between the monitoring agent and the DB2 server. The pre-requisites are as follows:

  • A dedicated user for monitoring purpose created at the OS-level on the operating system hosting the target DB2 server is required. Next, to connect to the database, a user with certain privileges are required. If the target database is of DB2 UDB server version 10.5 and above or a DB2 DPF server, then, the user connecting to the database should possess either SECADM or SYSADM privileges. If the target DB2 UDB server is of version 8.0 to version 10.1 or a DB2 DPF server, then, the user group to which the newly created user is added should possess any one of the following privileges: SYSADM, SYSCTRL, SYSMAINT, or SYSMON. To know how to create a special user and grant the required privileges, refer to Creating a Special User for Monitoring DB2 Server.

  • If the DB2 server is SSL-enabled, you must configure SSL on the server beforehand. This involves creating and managing keystores, generating certificates, and enabling SSL communication to allow the eG agent to connect securely. For detailed steps, refer to Configuring SSL for Monitoring the DB2 Server.