The following scenario is present:
java.lang.RuntimeException: Failed to execute collection [DB2_Maintenance], reason=[Foglight][DB2 JDBC Driver][DB2]FGLAMUSER does not have the authority to perform the requested command., SQL-Parameters = [DATABASENAME],[0],
Failed to execute query on host hostname. Reason : [SQL10007N Message "-1390" could not be retrieved
When authentication mode is set to "Client", the DB2 agent will use the user running the Foglight Agent Manager process to establish the connection against the target database. The credentials set in the "Agent Status" properties will not be used.
RESOLUTION 1
The required privileges and authorities must be manually granted to the user running the Foglight Agent Manager process:
RESOLUTION 2
RESOLUTION 3
When DB2 authentication type is CLIENT, the login credentials provided during installing for the database agent are overwritten with the username running the FglAM service (Windows) or process (Unix/Linux). Ensure that the FglAM user can connect to the DB2 instance and has all the relevant permissions as described in the Permissions section.
RESOLUTION 4
On a Linux or Unix OS, the DB2 instance name may be case sensitive. For example when validating DB2INSTANCE=db2inst1(lowercase) and the user enters DB2INST1 (uppercase) for the Instance name instead, in the DB2 Agent configuration details it will produce the same error. The user should use the DB2 instance name that matches the server exactly.
For granting permissions, please review the following article:
Missing privileges after DB2 agent installation (116492)
Additional details on how to manually create a DB2 agent can be found in the following article:
"The provided db2home belong to another instance" when adding a new DB2 agent (155824)
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center