Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 25 Nov 2005 @ 16:07:17 GMT

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

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.


  <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: 28 Jun 2020