RE: Restore SQL collection to a different name?

On Wed, 2005-04-06 at 17:14, Wilt, Charles wrote:

> Here's the hierarchy:
> 
> Instance
>   |__Database
>        |___Schema
>              |___Tables/Index/Views/procedures/ect...

and then on DB2 UDB for LUW, add SMS vs DMS tablespaces and containers.
They fall under Database and the DBA can manage those spaces to the
table level, or with enough effort, to the Schema level.


> You can do the same on the iSeries.  But as Bruce pointed too have multiple 
> databases on the iSeries you need to use independent disk pools.  Try saving 
> a schema on SQL Server or Oracle, ie. all objects owned by a particular user, 
> and restoring it to another schema....can't be done in either one AFAIK.
> 

and to further elaborate on the note someone posted about redirected
restores in DB2... the save/restore is Database and tablespace oriented.
On the iSeries, the save/restore is object oriented. The redierected
restore in DB2 is meant to restore to a system where a tablespace device
or container has been damaged or is otherwise unusable.

In other words, the redirected restore of DB2 is much more equivalent to
a SAVLIB *NONSYS operation on the iSeries.

 
-- 
"Bigamy is having one wife too many. Monogamy is the same."
-- Oscar Wilde