Archives of the TeradataForum
Message Posted: Fri, 27 Mar 2009 @ 10:12:55 GMT
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<
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|