I am trying to get DB2 to work with the DB2ADMN group on a windows server. I want any account in the DB2ADMN group to have sysadmin rights on DB2. From everything I have read and from other questions I have posted here, this should work, but it does not.
Here is what I have done.
Create the windows group DB2ADMNS and add my domain1\AITDB2Service account to it. This is a domain account and it runs the DB2 service under Windows and it is a local admin on the windows server.
SYSADM group name (SYSADM_GROUP) = DB2ADMNS
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) = xxx
SYSMON group name (SYSMON_GROUP) = xxx
I can log into DB2 using AITDB2Service no issue, even though when I look at the SECURITY tab in TOAD, the AITDB2Service user is not there. I can do selects and updates and such on tables, but I can't do CREATE TABLE or run a backup. When I try to run a backup I get...
SQL1092N The requested command or operation failed because the user ID does
not have the authority to perform the requested command or operation. User
If I try to grant privileges using AITDB2Service I get this.
GRANT DBADM WITH DATAACCESS WITH ACCESSCTRL ON DATABASE TO USER ANYUSER;
ERROR  [IBM][DB2/NT64] SQL0552N "AITDB2SERVICE" does not have the privilege to perform operation "GRANT".
So what am I doing wrong? There does not seem to be an account on this database that has SYSADMIN rights, so I can't use it to grant rights to AITDB2Service. This is a test database that I copied from production, did I do something wrong when I restored it?
Any help would be greatly appreciated.
Windows OSWindows Server 2012DB2Windows Server 2016Databases