|
|
Archives of the TeradataForum
Message Posted: Fri, 25 Nov 2005 @ 16:07:17 GMT
Subj: | | Re: Queueing Jobs in a Disaster Recovery Scenario to Reduce Tape Contention |
|
From: | | reddiyar |
Hello Bill,
We had the same issue while designing the DR solution. The way we accomplished it was by writing a perl script which monitored the jobs that
get launched. The script basically looks to see if a drive is free, if it is free it reads the list of jobs that need to be run and find that one
that can be launched on that free drive. One of the criteria it uses to launch that job is to check to see if any cluster backups are being
restored, if they are then those jobs are not considered for launch(other clusters which don't have any jobs running are still considered). This
way the contention is avoided and we keep all the tape drives busy. Hope this helps.
-Hari
| |