A DB2 agent was installed using a DB2 user with SYSADM permissions, but it is not the instance owner.
The permission check verified that user is sysadm and then skipped the permission check. When the DB2 agent was activated, missing permissions related errors were found in the agent log file and collections did not run.
In version DB2 10.1 and higher, SYSADM users do not automatically get DBADM or DATAACCESS permissions and hence cannot access data within the database.
WORKAROUND
Add DBADM and DATAACCESS permissions to the Foglight DB2 agent monitoring account.
STATUS
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center