Re: Restore SQL collection to a different name?

[David Gibbs <david@xxxxxxxxxxxx>]

R Bruce Hoffman 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?
> 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.

Unfortunately, something like ErWin just isn't an option.  This is on a
customers system and we don't have the access that a tool like ErWin
would require (let alone the tool itself).

Strictly speaking, this kind of thing should be a basic OS400 ability.
A normal library with database files can be restored to a different
name, so long as you have all the dependent objects (PF's for all LF's,
etc).  Not being able to restore a database collection library to a
different name is a major defect IMHO.  Backing up a database and
restoring it to a new location is something that should be able to be
done without any extra effort.

david

-- 
David Gibbs
david@xxxxxxxxxxxx

Receipt of this message does not grant you permission to send me
Unsolicited Commercial Email