Re: Restore SQL collection to a different name?

[R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>]

On Mon, 2005-04-04 at 10:12, David Gibbs wrote:
> Does anyone know if there is a way to restore, or copy, a SQL database
> collection (created with the sql command 'create collection') to a
> different library name and keep it fully operational?
> 
> Due to the journals that are created, the library name does not appear
> to be able to be changed.

It's not just the journals... the catalog tables have a LOT of
schema/library qualified descriptions in them for things like views,
triggers, RI constraints, etc.

and by now you know my answer here... products like ErWin help.

To copy... if you have the script, change the schema name (scan and
replace, in *nix, sed) generate the database, copy the data in. On other
platforms it's possible to have multiple instances. On the iSeries
(IIRC) you can do instances but they are on IASPs.


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