title: DB2 restore command fails on Windows 10
body: <p>Installed DB2 Express C v10.5 and also v11.1 on Windows 10 PC.</p>
  
  <p>Database backup is successful but Restore ends with error with both versions.</p>
  
  <p>I also tried the same using Data Studio 4.1.2, but here also backup is successful but restore command is stuck.</p>
  
  <p>Backup and restore script from Data Studio-</p>
  
  <pre><code>CONNECT TO SAMPLEDB;
  QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
  CONNECT RESET;
  DEACTIVATE DATABASE SAMPLEDB;
  BACKUP DATABASE SAMPLEDB TO "E:\Database" COMPRESS EXCLUDE LOGS WITHOUT PROMPTING;
  CONNECT TO SAMPLEDB ;
  UNQUIESCE DATABASE;
  CONNECT RESET;
  
  RESTORE DATABASE SAMPLEDB FROM "E:\Database" TAKEN AT 20161020191200 INTO NEWDB WITHOUT PROMPTING;
  </code></pre>
  
  <p>This works fine on Windows 7 and 8.</p>
  
  <p>Is this problem specific to Db2 Express C on Windows 10?
  Can anyone suggest solution and/or where to read about the compatibilty status.</p>
  
  <p><strong>Added-</strong></p>
  
  <p>Restore from Data studio does not give any error, but is just stuck.</p>
  
  <p>Result of backup and restore script-</p>
  
  <pre><code>db2 =&gt; CONNECT TO CBL2010 USER db2admin USING *******
  
     Database Connection Information
  
   Database server        = DB2/NT 10.5.5
   SQL authorization ID   = DB2ADMIN
   Local database alias   = CBL2010
  
  db2 =&gt; QUIESCE DATABASE IMMEDIATE
  DB20000I  The QUIESCE DATABASE command completed successfully.
  
  db2 =&gt; CONNECT RESET
  DB20000I  The SQL command completed successfully.
  
  db2 =&gt; BACKUP DB CBL2010 USER db2admin USING ******* to E:\Backup COMPRESS WITHOUT PROMPTING
  
  Backup successful. The timestamp for this backup image is : 20161024162942
  
  db2 =&gt; CONNECT TO CBL2010 USER db2admin USING *******
  
     Database Connection Information
  
   Database server        = DB2/NT 10.5.5
   SQL authorization ID   = DB2ADMIN
   Local database alias   = CBL2010
  
  db2 =&gt; UNQUIESCE DATABASE
  DB20000I  The UNQUIESCE DATABASE command completed successfully.
  
  db2 =&gt; CONNECT RESET
  DB20000I  The SQL command completed successfully.
  
  db2 =&gt; RESTORE DB CBL2010 USER db2admin USING ******* FROM E:\Backup TAKEN AT 20161024162942 INTO CBLBKUP WITHOUT PROMPTING
  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: "XAXTRANET".  SQLSTATE=00000
  </code></pre>
  
  <p>Here, I am supplying 'db2admin' as the user, but surprisingly the error is for the logged in user 'XAXTRANET'.</p>
  
  <p>Both logged in and supplied user have PC admin rights.</p>
  
  <p>and as per 'get Dbm Cfg' command, the sysadm group is not set -</p>
  
  <pre><code> SYSADM group name                        (SYSADM_GROUP) =
   SYSCTRL group name                      (SYSCTRL_GROUP) =
   SYSMAINT group name                    (SYSMAINT_GROUP) =
   SYSMON group name                        (SYSMON_GROUP) =
  </code></pre>