Re: Restore SQL collection to a different name?

[rob@xxxxxxxxx]

Then what should happen is that if journals and receivers are in MYDATAJ 
and tables, views and indexes are in MYDATA and I restore MYDATA to 
MYDATA2 then they should continue to use the journals and receivers in 
MYDATAJ; right?

It's kind of a chicken and egg thing.  In your example of logicals and 
physicals, the physical creation comes before the logical creation, 
without exception.  Now, the order items should be built that use journals 
are:
- journal receiver
- journal
- files, etc that use these journals
Granted, you could create the tables first and add the constraints and 
journalling later but I wouldn't recommend starting a new system this way, 
(unless someone is pointing a gun to your head saying "You're too 
productive with DDL; use DDS instead.").

In summary, the restore, with journals, is currently working the way a 
restore with logicals in a different library from the physicals does. 
However, it doesn't work the way a restore would with logicals in the same 
library as physicals.  And that's the change we want, right?

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





David Gibbs <david@xxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/06/2005 01:57 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
midrange-l@xxxxxxxxxxxx
cc

Subject
Re: Restore SQL collection to a different name?






rob@xxxxxxxxx wrote:
> Now, IF, the journals and receivers were 
> in different libraries (which used to be, and might still be, the 
> recommendation) then what should happen? 

Similar behavior if you have physicals & logicals in different libraries.

david


-- 
David Gibbs
david@xxxxxxxxxxxx

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

-- 
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.