Archives of the TeradataForum
Message Posted: Tue, 13 May 2008 @ 12:37:13 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|