Re: Restore SQL collection to a different name?

[Simon Coulter <shc@xxxxxxxxxxxxxxxxx>]

On 05/04/2005, at 3:25 AM, David Gibbs wrote:

> As journals have existed in the OS since S/38 days, I'm floored that
> this hasn't been an issue before.

It has always been an issue for those people using journalling. Given 
that it took at least 10 years from the time journalling was supported 
(CPF 7 I think) for people to actually start using it I am not 
surprised that most people haven't encountered the problem. Even now 
I'd wager that most OS/400 shops don't use journalling. A side-effect 
of the legendary stability of our favourite box.

How many of the main ERP vendors ship with journalling active? Probably 
zero.
How many use commitment control as a matter of course? Probably zero.
How many support the possibility? Possibly bugger all.

Any library with a journal (and/or receiver) cannot be renamed. The 
help text for RNMOBJ states this. There are a number of other object 
types that will also stop a library being renamed. If a library cannot 
be renamed it seems reasonable that it cannot be restored under a 
different name (or if it can, that some things aren't linked the way 
they used to be). I would expect some error messages during the restore 
explaining what didn't work.

It would certainly be possible to overcome this limitation (although I 
recall someone, George Timms (?), Bill Davidson (?), explaining why it 
was the way it was--something to do with object names being stored 
inside journals or journal receivers--but I can't find any reference to 
what I recall) but there would have to be a major amount of noise from 
customers before it happens.

Regards,
Simon Coulter.
--------------------------------------------------------------------
   FlyByNight Software         AS/400 Technical Specialists

   http://www.flybynight.com.au/
   Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
   Fax:   +61 3 9419 0175                                   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------