16.10 - Elapsed Time or Blocked Time Considerations - Teradata Workload Management

Teradata Database Workload Management User Guide

prodname
Teradata Workload Management
vrm_release
16.10
created_date
June 2017
category
Administration
User Guide
featnum
B035-1197-161K

The Change Workload to: action is not available for the Elapsed Time or Blocked Time exception criteria. The purpose of changing a workload is to put a request where it belongs in the priority hierarchy. Temporary system-wide conditions cause a request to be blocked or run too long. These exceptions do not occur because the request is out of character for the workload.

Elapsed Time or Blocked Time exceptions are better suited to an automated alert. Then the DBA can investigate the system-wide situation and resolve the problem by identifying the cause of the slowdown, rather than punishing the requests suffering from the situation.