Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 13 May 2008 @ 12:37:13 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: (WM) Utility Throttle
From:   mark.dodgson


Although you can use Teradata applications to control utility invocation - as the good people of the Forum have already outlined - you could always rely upon old fashioned scheduling to control this for you. Well, in your production system anyway.

For example: you can create special resources in TWS for the number of utilities you want to permit (don't forget about MaxLoadTasks, obviously). If you assign a requirement for one of these SRs to each utility job in your production schedule, then jobs will not be invoked until a SR is available. Once the limit has been hit, i.e. the special resources have been grabbed by running utilities, then the next one in the queue will wait until one of the running utilities has completed, and released its SR.

Note : this only applies to your production jobs. If you allow your users to run utilities in this environment at the same time as your production workload, then you may still encounter problems as the user jobs won't be SR constrained.



Mark Dodgson
Barclays Bank Plc,
GRCB Technology - GASG (Global Architecture and Strategy Group)

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020