Archives of the TeradataForum

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

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

Thanks Ray!

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

But, my requirement is

     Abc.sh

     {
     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.

Thanks!

Sravan

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