467,908 Members | 1,750 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,908 developers. It's quick & easy.

Restoring, can't redirect tablespaces

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
  • viewed: 1687
Share:
1 Reply
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by CK | last post: by
2 posts views Thread by Joseph McCarthy | last post: by
9 posts views Thread by db2inst2 | last post: by
10 posts views Thread by rAinDeEr | last post: by
4 posts views Thread by Troels Arvin | last post: by
5 posts views Thread by Troels Arvin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.