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.