Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 27 Mar 2009 @ 10:12:55 GMT


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


Subj:   Re: Restoring cluster backups to smaller system
 
From:   Ramisetty, Kishore

Hi,

Normally when we restore a table to different configuration database then restore will happen sequentially, If you want to get the restore completed fast then follow the below steps.

1. Create 10 restore jobs as below, these 10 jobs will have different FILE (files to which backup happened) and USERNAME.

     LOGON TDID/*username1*, *passwd*;
     COPY DATA TABLES
       (DB01.TABLE1),
     RELEASE LOCK,
     FILE=*FILENAME1*;
     LOGOFF;

2. Schedule a script to release lock on DB01.TABLE1 table by the accounts used for COPY(use CRON for UNIX or BAT file for windows)

Sample UNIX code: Releaselock.sh

     #

     username=$1
     bteq<


Run the script as

     ksh Releaselock.sh username1

     ksh Releaselock.sh username2

     ...

     ...

3. Start all the 10 jobs in parallel.

4. This process will allow the jobs to run in parallel and COPY will happen to the same table.

5. Once the restore is complete BUILD the table using BUILD DATA TABLES.


Thanks,

Kishore.

>R. Kishore Kumar
Oracle/Teradata DBA



     
  <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