Re: Restore SQL collection to a different name?

[rob@xxxxxxxxx]

Well, I've created my DCR.  Will keep you posted.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





rob@xxxxxxxxx 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/06/2005 09:28 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
Re: Restore SQL collection to a different name?






Simon,

You are so right.  As customers we DO need to create noise, using DCR's, 
etc.
https://www-912.ibm.com/r_dir/ReqDesChange.nsf/Request_for_Design_Change?OpenForm


But I'll grant you that a bulk of the shops will use this limitation as 
yet another excuse to not adopt journals.  Just as they use any glitch or 
temporary limitation in a new technology as a reason to stay with the 
techniques they've learned 15 years ago.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





Simon Coulter <shc@xxxxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces+rob=dekko.com@xxxxxxxxxxxx
04/06/2005 05:54 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
Re: Restore SQL collection to a different name?







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  / \
--------------------------------------------------------------------


-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.