DB2 Sample restore command using redirect option

The sample DB2 commands below shows you how to restore a database to a different server which doesn't have the tablespaces created (five in our example) or in case you need to change the tablespace directory structure. For more information, check the following URL http://www.ibm.com/developerworks/data/library/techarticle/0211melnyk/0211melnyk.html

db2 RESTORE DATABASE wc7dev FROM "D:\DatabaseBackup" TAKEN AT 20110624110215 ON "C:" INTO WCDEV REDIRECT

db2 list tablespaces show detail

mkdir C:\DB2\NODE0000\WCDEV\T0000003

mkdir C:\DB2\NODE0000\WCDEV\T0000004

mkdir C:\DB2\NODE0000\WCDEV\T0000005

mkdir C:\DB2\NODE0000\WCDEV\T0000006

mkdir C:\DB2\NODE0000\WCDEV\T0000007

db2 set tablespace containers for 3 using (path 'C:\DB2\NODE0000\WCDEV\T0000003')

db2 set tablespace containers for 4 using (path 'C:\DB2\NODE0000\WCDEV\T0000004')

db2 set tablespace containers for 5 using (path 'C:\DB2\NODE0000\WCDEV\T0000005')

db2 set tablespace containers for 6 using (path 'C:\DB2\NODE0000\WCDEV\T0000006')

db2 set tablespace containers for 7 using (path 'C:\DB2\NODE0000\WCDEV\T0000007')

db2 RESTORE DATABASE wc7dev continue