Creating a Special User for Monitoring DB2

All the tests that the eG agent runs on a DB2 UDB server (version 8.0 and above) or on a DB2 DPF server, should be configured with the credentials of a user who has any of the following privileges to the monitored DATABASE: SYSADM or SYSCTRL or SYSMAINT or SYSMON.

It is recommended that you create a special user for this purpose. The steps for creating such a user are detailed below:

1. Create a user group - say, eg_mon_grp - on the operating system hosting the DB2 server.
2. Create a user - say, eg_user - at the OS-level, and add this new user to the group created in step 1.

3. Next, you need to grant the SYSADM or SYSCTRL or SYSMAINT or SYSMON privilege to the group created in step 1. For instance, to grant the SYSMON privilege to the eg_mon_grp in our example, do the following:

   • Go to the DB2 prompt.

   • Issue the following command at the prompt:

     UPDATE DBM CFG USING SYSMON_GROUP eg_mon_grp;

   • Finally, restart the DB2 instance by issuing the following commands, one after another:

     db2stop force

     db2start