DB2 恢复备份的数据库
create database unidb on d: using codeset utf-8 territory us;restore database unidb from c:\dbbackup into unidb REDIRECT WITHOUT ROLLING FORWARD;set TABLESPACE CONTAINERS for 0 USING (PATH 'D:\db2container\SQLT0000.0');set TABLESPACE CONTAINERS for 1 USING (PATH 'D:\db2container\SQLT0001.0');set TABLESPACE CONTAINERS for 2 USING (PATH 'D:\db2container\SQLT0002.0');set TABLESPACE CONTAINERS for 3 USING (FILE 'D:\db2container\regdat32k01' 16100,FILE 'D:\db2container\regdat32k02' 16100,FILE 'D:\db2container\regdat32k03' 16100,FILE 'D:\db2container\regdat32k04' 16100);set TABLESPACE CONTAINERS for 4 USING (FILE 'D:\db2container\regidx01' 16100,FILE 'D:\db2container\regidx02' 16100);set TABLESPACE CONTAINERS for 5 USING (FILE 'D:\db2container\regdat01' 16100,FILE 'D:\db2container\regdat02' 16100,FILE 'D:\db2container\regdat03' 16100,FILE 'D:\db2container\regdat04' 16100,FILE 'D:\db2container\regdat05' 16100,FILE 'D:\db2container\regdat06' 16100,FILE 'D:\db2container\regdat07' 19624,FILE 'D:\db2container\regdat08' 16100,FILE 'D:\db2container\regdat09' 16100,FILE 'D:\db2container\regdat10' 16100,FILE 'D:\db2container\regdat11' 16100);set TABLESPACE CONTAINERS for 6 USING (PATH 'D:\db2container\temptb32');set TABLESPACE CONTAINERS for 7 USING (PATH 'D:\db2container\TEMPSPACE4K');set TABLESPACE CONTAINERS for 8 USING (PATH 'D:\db2container\TEMPSPACE32K');set TABLESPACE CONTAINERS for 9 USING (PATH 'D:\db2container\USERSPACE4K');set TABLESPACE CONTAINERS for 10 USING (FILE 'D:\db2container\zonedata32k.0' 4096);restore db unidb continue;
页:
[1]