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

Tablespaces on backup image (UDB v8.1)

P: n/a
Lew
Hi,

I was wondering if there is a way to determine the tablespace id of
each tablespace on a backup image. I want to perform a redirected
restore pointing the tablespace containers to different locations
than the ones defined on the backup image.

While I haven't tried it yet I imagine that I could perform a
redirected restore of just the catalog table space and then look at
the catalog table info to determine the tablespaces.

1) Will the solution I detail above work
2) Is there another way to determine this information assuming that
I do not have the original system from which the backup was created

Thanks in advance

Lew
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Hi,

Lew wrote:
While I haven't tried it yet I imagine that I could perform a
redirected restore of just the catalog table space and then look at
the catalog table info to determine the tablespaces.


Do you mean something like "select from syscat....?". This is not going to
work as the database will be in "backup pending" state.

if you just want to find out which tablespaces are included in the
image-file i suggest to try kind of this:

db2 restore database foo from /dev/bar into test redirect

db2 list tablespaces show detail
db2 list tablespace containers for TBSCPID

db2 set tablespace containers for .....

db2 restore database foo continue
[db2 rollforward... ]

This should give you some advice, which tablespaces are included and how to
organize your storage.
Norbert
Nov 12 '05 #2

P: n/a
Hi Lew and Norbert.. Why dont you use db2ckbkp -T backupimage ? This
will show all tablespace details such as id, name of the tablespace,
name of the container(s) etc.
Nov 12 '05 #3

P: n/a
Hi Roger,

Roger wrote:

Thanks for the hint. You are right. This should be first if you don't know
what to expect from the image file.

Both should work.
Hi Lew and Norbert.. Why dont you use db2ckbkp -T backupimage ? This
will show all tablespace details such as id, name of the tablespace,
name of the container(s) etc.


--
BOFH Excuse #12:

dry joints on cable plug

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.