Tablespaces on backup image (UDB v8.1)

[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

[Norbert Munkel]

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

[Roger]

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.

[Norbert Munkel]

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