Managing IBM DB2 Databases › Registering IBM DB2 Databases › Define a User with SYSMON or SYSMAINT Authority

Define a User with SYSMON or SYSMAINT Authority

To collect data from an IBM DB2 database, the user that you supply to the DB2 Registration Wizard must have SYSMON (DB2 version 8.2 and higher) or SYSMAINT (DB2 version 8.1) authority on the database. This authority is defined on the instance level using operating system user groups.

To grant SYSMON or SYSMAINT authority to a user

1. Create a user group on the operating system where the DB2 server is installed (for example, "DB2Users").
2. Create a user on the operating system (for example, "BrightStorSRM") and add this user to the group you just defined.
3. Open a DB2 command window and issue one of the following commands.

   For DB2 8.1

   	db2 update dbm cfg using sysmaint_group <os_group>
   

   For DB2 8.2 or higher

   	db2 update dbm cfg using sysmon_group <os_group>
   

   For example:

   db2 update dbm cfg using sysmon_group DB2Users
   

   The users in the specified group are granted the proper authority to perform data collection.