This is an example
db2 -td;
RESTORE DATABASE SAMPLE FROM "C:\Program Files\IBM\SQLLIB\BIN" TAKEN AT
20070622115322 TO "C:" INTO newdatabasename
NEWLOGPAH "c:\dirlog" WITH 2 BUFFERS BUFFER 1024 REDIRECT PARALLELISM 1
WITHOUT PROMPTING;
after that command you should enter the locations of each tablespace.
One set for each tablespace:
SET TABLESPACE CONTAINERS FOR 0 IGNORE ROLLFORWARD CONTAINER OPERATIONS
USING (PATH "C:\dir1");
SET TABLESPACE CONTAINERS FOR 1 IGNORE ROLLFORWARD CONTAINER OPERATIONS
USING (PATH "c:\dir2");
SET TABLESPACE CONTAINERS FOR 2 IGNORE ROLLFORWARD CONTAINER OPERATIONS
USING (PATH "c:\dir3");
SET TABLESPACE CONTAINERS FOR 3 IGNORE ROLLFORWARD CONTAINER OPERATIONS
USING (PATH "C:\dir4");
when you finish with above commands
RESTORE DATABASE SAMPLE CONTINUE;
here starts the restore
or restore database sample abort;
to stop and start over
pinoy2ser wrote:
On Sep 25, 4:36 am, "stefan.albert" <stefan.alb...@spb.dewrote:
>Hi pinoy,
first of all: what you want to do works with version 9 (and above). If
you have a lower version, a simple tablespace restore into a(nother)
DB than the original one will fail.
You'll have to restore the tablespace you want together with the
catalog tablespace.
Please consider a redirected restore (container to another location)
when restoring on the same system.
If it is an offline backup no further logfiles are needed, if online
you'll need a rollforward and some (?) logfiles for this.
Please see also:http://publib.boulder.ibm.com/infoce...w/v9/index.jsp
"restore db"
Thank you for you feedback..
i have db2 ver 8.2 fix11.. not too familiar with redirected restore..
ill search on that thanks..