Restoring, can't redirect tablespaces

Greg Nash

DB2 9.1.3 on Windows.

If I take a backup from a system where all DB2 data is on drive D: and
try to restore or "create from backup", onto drive E: of another system,
I find:
- System managed tablespaces can be redirected ok
- Database managed tablespaces cannot be redirected, but insist on using
drive D:. If drive D: doesn't exist, or is a CD, the restore fails.

Is this to be expected?

--Greg Nash

Sep 4 '07 #1

kavallin

Greg.. No this is not expected but I wonder how the restore command
looks like... You have to use REDIRECT and set tablespace containers
for x etc for all DMS tablespaces.. You can use db2ckbkp to check the
backup image and get info tablespaces etc
/roger

Sep 5 '07 #2