[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::dec_data_distributor

Title:The Replication Option for Rdb
Notice:Product renamed to Replication Option for Rdb
Moderator:BROKE::PROTEAU
Created:Wed Mar 02 1994
Last Modified:Wed Jun 04 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:287
Total number of notes:1231

228.0. "Moving the source database .. any problems ?" by ORAREP::VAXRIO::ABREU () Mon Jul 15 1996 15:43

    Hi,
    
       I have a customer who has a database with 100 transfers defined.
    This database is the source database. They have to move this database
    to another device . They are worried about the transfers.
    
       Does this copy work fine or the transfers will have problem because 
    the database moved to another physical location ?
       
       DDD 6.0
    
       Thanks .. Marcia
T.RTitleUserPersonal
Name		DateLines
228.1It dependsBROKE::PROTEAUJean-Claude ProteauMon Jul 15 1996 16:4119
    
    Marcia,
    
    Have your customer display the transfer definitions as stored in the
    transfer database.  The thing to look at is the file specifications for
    the source databases, the target databases, the log files, the prologue
    files and the epilogue files.  If the file specifications contain
    explicit information about the  old device name, then the transfer
    definitions will have to be changed.
    
    Assuming they do have such changes, some (but not all) of them can be done
    using SQL's ALTER TRANSFER statement.  They need DDAL 6.0 and Rdb 6.0
    in order to do that.  The one file spec that ALTER TRANSFER does not
    change is that of the source database.  If they have to change those,
    they'll have to do so using something like interactive SQL directly on
    the transfer database tables.  If I were them I'd keep the old device
    and old transfer database around long enough to make sure the changes work. 
    
    Claude
228.2Physical names in source database ORAREP::VAXRIO::ABREUTue Jul 16 1996 07:596
    Hi Claude,
    
       Unfortunately , that's the case . The source database is being
    referenced with physical names. So how do I change it ?
    
       Thks . Marcia
228.3WHat to changeBROKE::PROTEAUJean-Claude ProteauTue Jul 16 1996 08:0813
    Marcia,
    
    "So how do I change it?"
    
    I explained how in general terms in my previous reply.  Each one of the
    file specifications appears in a CHAR or VARCHAR column in one of the
    tables of the transfer database.  The transfer database location is
    defined by the logical name DDAL$TRANSFER_DATABASE when DDAL is
    running.  The transfer database tables are listed in appendix A of the
    Data Distributor handbook.  From that you should be able to determine
    which columns to change.  Let me know if you need more information.
    
    Claude
228.4I'll try to do it ORAREP::VAXRIO::ABREUTue Jul 16 1996 09:2611
    Hi Claude,
    
        Thanks .. I missed that info in your first reply. I'll try t
    identify the columns to change right now. 
    
        If  I need more info or when I have the results of this operation ,
    I update this note. 
    
        Thanks a lot ,
    
          Marcia