Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 29 Jul 2005 @ 16:27:51 GMT


     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 


Subj:   Restoring Dictionary information.
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, July 29, 2005 12:26 -->

We are migrating data from our old test system to new test system (configuration is different) . We are setting up the archive/restore/copy jobs to do that.

I have a question on copying dictionary /DBC information to new system.

We are going archive DBC data tables and Dictionary information of all databases underneath the DBC using Arcmain as below.

We need the DDLs available to users on new system before we copy the actual data. Once the system is available to users, we are planning to copy data for each database using COPY statement.

There is no way for us to test the process. Are the statements below correct?

Archive of DBC/dictionary information (Old system)

     ARCHIVE DATA TABLES (DBC),
     RELEASE LOCK,
     FILE=ARCHIVE;
     ARCHIVE DICTIONARY TABLES (DBC) ALL,
     RELEASE LOCK,
     FILE=ARCHIVE;

Restore of DBC/dictionary information (New system)

     RESTORE DATA TABLES (DBC),
     RELEASE LOCK,
     FILE=ARCHIVE;
     RESTORE DICTIONARY TABLES (DBC) ALL,
     RELEASE LOCK,
     FILE=ARCHIVE;

Thanks



     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016