Archives of the TeradataForum

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

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

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