troubleshooting Question

DB2 Add User to SYSMON group

Avatar of Jim Youmans
Jim YoumansFlag for United States of America asked on
DatabasesDB2Windows OS
3 Comments1 Solution632 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Kent Olsen
Data Warehouse / Database Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros