"User USERNAME does not have the proper authority to monitor the DB2 instance. A minimum of SYSMON authority is required."The user already has the SYSMON authority.
select sum(case when d_group = 'Y' then 1 else 0 end) from table(AUTH_LIST_AUTHORITIES_FOR_AUTHID(cast('USERNAME' as varchar(128)),'U')) where authority in ('SYSMON','SYSCTRL','SYSMAINT','SYSADM')The result will be a 0 (zero) if user does not have the valid authorization or a number greater than 0 (zero) if the user has sufficient authorization.
select substr(AUTHORITY,1,30) as Authority , D_GROUP , D_PUBLIC from table(auth_list_authorities_for_authid('USERNAME','U'))
To grant SYSMON authority to a user
db2 update dbm cfg using sysmon_group <os_group>
For example, to grant the SYSMON privilege to the DB2Users group in our example, issue the following command so that the users in the specified group are granted the proper authority to perform data collection.
db2 update dbm cfg using sysmon_group DB2Users
Then, restart the DB2 instance by issuing the following commands, one after another:
db2stop force db2start
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center