If you can be a bit more specific about:
OS, DB2 UDB level and what are your concerns.

I think from the EE in your subject, you are at V7.2 Extended Edition. This
has been out of service for over a year now.

You can restore a tablespace from any type of backup: Full DB, Tablespace
Backup, Tablespace backup with multiple tbsps. in the image.
If the backup was taken offline then you can restore it and decide to where
you will rollforward.
If the backup was taken online, you must rollforward at least to the
timestamp of the end of the backup.

This has been supported since V7 at least and has been done quite often in
many installations.

Regards, Pierre.
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
----- Original Message -----
From: "Pope John" <db2udbdba-ezmlmshield-x65695373.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, December 12, 2006 3:16 PM
Subject: UDB TABLESPACE Restore from offline backup on EE


> Does any one have experience with doing a tablespace restore.
>
> I have not done one and know I've heard negative comments about doing
> them.
>
> Any helpful hints would be appreciated.
>
> Thanks, John Pope
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>



DB2 & UDB email list listserv db2-l LazyDBA home page