Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 18 Mar 2003 @ 15:35:26 GMT

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

Subj:   Re: Max Load Tasks
From:   Julie Flanagan


We also run with the default of 5, but because of the way our overnight jobs were scheduled, until lately, we rarely ran 5 loads at the same time.

Recently, we made some schedule changes to run more jobs in parallel, and we were also considering increasing from 5. However, since the changes, we have experienced several unexplained deadlocks, always between different multiload jobs (with the jobs always loading to totally separate tables) - indicating that perhaps the problem is with a DBC table(s) 'behind the scenes' ...

We are about to raise an incident with NCR on this. But it has made us wary of increasing the default from 5 - as the problems only began when we started running more, seemingly unrelated, multiload jobs in parallel.

I'm interested to hear other people's comments on your question.


  <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