DB2 Add User to SYSMON group
DB2 10.5 On Windows
I am trying to use CommVault to backup my DB2 databases and am having permission issues. When I run the backup through CommVault I get the following.
ERROR CODE [59:41]: Browse operation on database [xxx] could not be completed. Error [ ---- error report ---- app. message = db2GetSnapshotSize line = 783 file = Db2Browse.cpp SQLCODE = -1092 SQL1092N The requested command or operation failed because the user ID does not have the authority to perform the requested command or operation. User ID: "CVADMIN". --- end error report --- db2GetSnapshotSize() failed: Exit.]. Please check the database configuration, user privileges and ensure that the product's services are running on client, server, MediaAgent and then resume.
From what I have read, this means that the user CVADMIN does not have SYSMON permissions. So I did the following.
1. Check that the server has a group defined for SYSMON. It does. SYSMON group name (SYSMON_GROUP) = NAGIOS
2. On windows, I created a group name NAGIOS and added CVADMIN to it.
From what I read, that should grant CVADMIN SYSMON permission but it is not working. Still get the same error. Is there a specific GRANT I have to issue? IBM has a lot of information on this but none of it is clear to me.
Thank you.
Jim
I am trying to use CommVault to backup my DB2 databases and am having permission issues. When I run the backup through CommVault I get the following.
ERROR CODE [59:41]: Browse operation on database [xxx] could not be completed. Error [ ---- error report ---- app. message = db2GetSnapshotSize line = 783 file = Db2Browse.cpp SQLCODE = -1092 SQL1092N The requested command or operation failed because the user ID does not have the authority to perform the requested command or operation. User ID: "CVADMIN". --- end error report --- db2GetSnapshotSize() failed: Exit.]. Please check the database configuration, user privileges and ensure that the product's services are running on client, server, MediaAgent and then resume.
From what I have read, this means that the user CVADMIN does not have SYSMON permissions. So I did the following.
1. Check that the server has a group defined for SYSMON. It does. SYSMON group name (SYSMON_GROUP) = NAGIOS
2. On windows, I created a group name NAGIOS and added CVADMIN to it.
From what I read, that should grant CVADMIN SYSMON permission but it is not working. Still get the same error. Is there a specific GRANT I have to issue? IBM has a lot of information on this but none of it is clear to me.
Thank you.
Jim
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try running the check readiness report as that will highlight what is missing if anything
http://documentation.commvault.com/commvault/v11/article?p=39708.htm
http://documentation.commvault.com/commvault/v11/article?p=39708.htm
ASKER