Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sun, 09 Dec 2012 @ 10:32:03 GMT

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

Subj:   Re: Restricting concurrent sessions using throttles in TASM
From:   Bodla, Sravan Kumar

Thanks Ray!

So, I have set the throttle for Sessions and not for the query?

But, my requirement is


     nohup sh BTEQ_CL05_1_01.sh BTEQ_CL05_1_01 > BTEQ_CL05_1_01_Part2.log &
     nohup sh BTEQ_CL05_1_02.sh BTEQ_CL05_1_02 > BTEQ_CL05_1_02_Part2.log &
     nohup sh BTEQ_CL05_1_15.sh BTEQ_CL05_1_15 > BTEQ_CL05_1_15_Part2.log &

I understand, the above abc.sh script will invoke 15 parallel sessions and not 15 queries.

Out of the above 15, I need only 10 to run in parallel and others needs to be moved to delayed state. As, when an active session get complted, the delayed will be moved to Active and provides more throughput (as it is running only 10 parallel at a time instead, 15).

Can you please tell me how can I set the throttle limits in this case.



  <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