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.

"Raquel" <raquel_rodriguezus@yahoo.com> wrote in message
news:9a73b58d.0405132324.3229db68@posting.google.c om...[color=blue]
> 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.[/color]

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.

> The first restores the entire database, the second restores only the[color=blue]
> 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.[/color]


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.

Raquel <raquel_rodriguezus@yahoo.com> wrote:[color=blue]
> 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.[/color]

"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

Thanks Dave. Make things very clear now.

Regards,
Raquel.