We help IT Professionals succeed at work.

DB2 Add User to SYSMON group

Jim Youmans
Jim Youmans asked
on
616 Views
Last Modified: 2018-04-06
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
Comment
Watch Question

Data Warehouse / Database Architect
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Jim YoumansSr Database Administrator

Author

Commented:
It was there when I checked it so I have to believe it was set up awhile ago and the server is rebooted once a month so that should not be an issue.
KarlSenior Technical Consultant
CERTIFIED EXPERT

Commented:
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

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.