DB2 10.5 on Windows
OK, this is killing me. It should be a simple thing but I have hit a wall and am not sure what is going on. On my development database, I am issuing the following command.
db2 backup db Database1 online to z:\db2backups compress without prompting
But after a minute or so I get this.
The requested command or operation failed because the user ID does not have the authority to perform the requested command or operation: User ID "MyUserID"
MyUserID should have SYSADM rights on that database. It is a domain user and it is an Admin on the windows server. So I don't understand what the issue is. I also made sure MyUserID has full privileges on the Z: drive.
How can I be sure MyUserID is SYSADM and what might I be missing? This is really killing me because it should not be this hard to backup my db. What am I doing wrong? This works fine on my production server, but it uses a different user.