By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,778 Members | 1,074 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,778 IT Pros & Developers. It's quick & easy.

Restoring, can't redirect tablespaces

P: n/a
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
Share this Question
Share on Google+
1 Reply

P: n/a
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

Sep 5 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.