DB2 10.5 on Windows
So I am trying to teach myself how to install DB2 and restore a dev database. So I install DB2 10.5 on windows without issue. I then run the sample database setup and I can connect to it no problem.
When I copy over the DEV database backup and try to restore it, problem. I get this.
C:\Windows\system32>db2 restore database DEV FROM X:\dbbackups
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: "xxx". SQLSTATE=00000
Now XXX is in the Admin group on the windows server and it is running the DB2 instance service. It should have full control of the server. I looked at the sys roles (sysmon, sysadm,sysctrl, and sysmaint group names and set them all to Administrators which is the admin group name on the windows server. I just don't get it. What am I missing?
FRUSTRATED IN STL