Archives of the TeradataForum

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

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

Donna,

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.

Cheers,

Mark

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

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