Hi Shrini,

You can make the restore in this way

RESTORE DATABASE MyDb FROM "MyBackupPath" TAKEN AT MyTimeStamp TO
"MyNewPath" INTO MyNewDB NEWLOGPATH "MyNewLogPath" WITH 2 BUFFERS
BUFFER 1024 REDIRECT PARALLELISM 1;

then DB2 prompting for the redirect, so you run the following command
for all the containers for all tablespaces.

SET TABLESPACE CONTAINERS FOR TBSPACEID REPLAY ROLLFORWARD CONTAINER
OPERATIONS USING (FILE "MyNewContainer" 4KpagesSize);

FOR EXAMPLE

SET TABLESPACE CONTAINERS FOR 0 REPLAY ROLLFORWARD CONTAINER
OPERATIONS USING (FILE
"/datos/instancias/desarrol/extracup/extracup/contenedores/cont_4k_dat_cat"
49371);

you can get the id using

db2 list tablespaces show detail

and the size in pages using

db2 list tablespace contaniners for mytablespaceid show detail


when you finish the redirect run

RESTORE DATABASE MyNewDB CONTINUE;

Hope this Helps


Regards,

Juan Gabriel Quintero Barbosa
IBM Certified Database Associate - DB2 UDB V8.1 for Linux, UNIX and Windows
ITConsultings
Movil: (57-310) 3014660
Email: [Email address protected]
Oficina Bogotá: Cra. 11 No.71-73 Of. 405 Tel: (57-1)3215753
Oficina Medellín: Cra. 43A No.1Sur-31 Of. 205 Tel: (57-4) 3522097
Web Site: www.itconsultings.net

Informix & DB2 Specialists
Business Intelligence Solutions
Information Integration Solutions




DB2 & UDB email list listserv db2-l LazyDBA home page