Delay View for Teradata Database

Teradata® Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K
The Delay view displays details about all rules that are delaying a query. A scroll bar appears if there are more than two rules. This information is read-only.
Statistics Information Description
Blocking Count Number of consecutive times this session has blocked at least one other session
Delay Time Duration of time request has been delayed by utility, system throttle, workload throttle, or workload group throttle rules
Utility Throttle Indicates if request has been delayed by a utility throttle rule
System Throttle Indicates if request has been delayed by a system throttle rule
Workload Throttle Indicates if request has been delayed by a workload throttle rule
Workload Group Throttle Indicates if request has been delayed by a workload group throttle rule
Rule Information Description
Rule Name Name of rule causing request delay
Rule Type TASM type of rule causing request delay
Overridable Indicates if the Teradata Database Administrator can abort or release the request