Avatar of Jim Youmans
Jim YoumansFlag for United States of America

asked on 

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
DatabasesWindows OSDB2

Avatar of undefined
Last Comment
Karl
ASKER CERTIFIED SOLUTION
Avatar of Kent Olsen
Kent Olsen
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Jim Youmans
Jim Youmans
Flag of United States of America image

ASKER

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.
Avatar of Karl
Karl
Flag of United Kingdom of Great Britain and Northern Ireland image

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
Windows OS
Windows OS

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

129K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo