View Single Post
  #8 (permalink)  
Old 01-08-09, 11:18
ak835 ak835 is offline
Registered User
 
Join Date: Apr 2008
Posts: 29
Thumbs up

here it is..
-----------------------------------------------------------------
db2 "restore db MYDB from <_path_to_backup_image_> into MYDB REDIRECT WITHOUT ROLLING FORWARD"
db2 "set tablespace containers for 0 using (FILE '<_path>'50000)"
db2 "set tablespace containers for 1 using (PATH '<_path_>')"
db2 "set tablespace containers for 2 using (PATH '<_path_')"
db2 "set tablespace containers for 3 using (PATH '<_path_>')"
db2 "set tablespace containers for 4 using (PATH '<_path_>')"
db2 "set tablespace containers for 5 using (FILE '<_path_>'131072)"
db2 "set tablespace containers for 6 using (PATH '<_path_>')"
db2 "restore database MYDB continue"
-------------------------------------------------------------

i had given ',' for FILE separating path & no of pages...

regards
abhi
Reply With Quote