Permissions check fails for DB2 version 10.1 and higher (4226737)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Permissions check fails for DB2 version 10.1 and higher
Beschreibung

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. Many permissions were reported to be missing.
Ursache

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.
Reference: http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.admin.sec.doc/doc/c0005479.html?lang=en
Lösung

WORKAROUND
Add DBADM and DATAACCESS permissions to the Foglight DB2 agent monitoring account.
STATUS
A defect ID DB2FOG-74 has been logged to change the check permissions to identify if the DB2 agent monitoring account has DBADM and DATAACCESS instead of sysadm. This will be done separately for each database and not at the instance level.
Fehler-ID

DB2FOG-74

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Produkt(e):: Foglight
6.1.0, 6.0.0, 5.9.8, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2, 5.7.5, 5.7.1, 5.6.11; Foglight for Databases
6.1.0, 6.0.0, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2; Foglight for Virtualization Enterprise Edition
8.7.5, 8.7, 8.6, 8.5.5, 8.5

Titel