Restore database Vs Restore tablespace.....

[Raquel]

How are the following two commands different as far as the 'end
result' of the restores is concerned:

1. db2 RESTORE DB mydb
2. db2 RESTORE DB mydb TABLESPACE

In other words, in the above case, what is the difference between
'database restore (performed in point 1 above) Vs the 'tablespace
restore' (performed in point 2 above).

TIA
Raquel.

[Mark A]

"Raquel" <ra****************@yahoo.com> wrote in message
news:9a**************************@posting.google.c om...

How are the following two commands different as far as the 'end
result' of the restores is concerned:

1. db2 RESTORE DB mydb
2. db2 RESTORE DB mydb TABLESPACE

In other words, in the above case, what is the difference between
'database restore (performed in point 1 above) Vs the 'tablespace
restore' (performed in point 2 above).

TIA
Raquel.

The first restores the entire database, the second restores only the
specified tablespace.

If you restore a tablespace, you need archive logging turned on (before the
backup performed).

Note that you can restore a specific tablespace from a full database backup
or a tablespace backup.

[Raquel]

> The first restores the entire database, the second restores only the

specified tablespace.

If you restore a tablespace, you need archive logging turned on (before the
backup performed).

Note that you can restore a specific tablespace from a full database backup
or a tablespace backup.

I think you mis-understood my question. The statement "db2 RESTORE DB
mydb TABLESPACE" does not have any 'specific tablespace' mentioned. I
was wondering that in this specific case (where no specific tablespace
is mentioned), what is the difference between these two statements.

TIA
Raquel.

[David Mooney]

Raquel <ra****************@yahoo.com> wrote:

I think you mis-understood my question. The statement "db2 RESTORE DB
mydb TABLESPACE" does not have any 'specific tablespace' mentioned. I
was wondering that in this specific case (where no specific tablespace
is mentioned), what is the difference between these two statements.

"db2 restore db mydb tablespace" will restore whatever tablespaces happen
to be in the backup image that you're restoring. If it's a tablespace
backup, it might not contain all of the tablespaces that exist in the
database.

Furthermore, after the restore, the tablespaces that you restored will
be in rollforward-pending state, whereas after a database restore, it
is the database that is in rollforward-pending state.

There are a few other subtle cases where the two cases are different, but
they all come down to the idea that a tablespace restore is not the same
as a database restore.

dave

[Raquel]

Thanks Dave. Make things very clear now.

Regards,
Raquel.