Archives of the TeradataForum
Message Posted: Wed, 08 Nov 2000 @ 21:48:52 GMT
Great input and examples. It sounds like you are using it fairly extensively.
One comment, however, we use the ABS policy regularly and haven't had a problem with it. In fact, we move problem queries into the performance group with an ABS policy so that we can limit it's impact on the system while we determine whether the query should be aborted or not. We don't want to inadvertently abort a long running update for example.
In that same light, you might want to consider changing the system setting to force rollbacks to occur in the same performance group in which they were submitted. The default setting is $R, which can severely impact your overall system performance.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|