Prevent Mid-transaction Throttle Delays - Analytics Database - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Workload Management
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
aji1628112479055.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1197
Product Category
Teradata Vantage

The Do not delay queries within transactions that are holding locks higher than 'access' option on the Other tab of the General view overrides throttle limits when a request is part of a transaction that holds a lock higher than access level. Like the Blocker options, this option prevents a request in the delay queue from holding locks needed by active requests.

This option applies to all request throttles. Because it exempts certain requests from throttles, this option can cause the number of concurrent requests to exceed the throttle limit. Evaluate how use of this option affects your site. The TDWM Statistics API returns the number of active requests that are running solely due to this option. In addition, the following DBQLogTbl columns can help you to assess the impact of this feature on throttle limits.

DBQLogTbl Field Description
LockLevel The highest-level lock obtained when the request ran. This lock is from a previous request in the transaction.
ThrottleBypassed Indicates if this request ran solely due to the Prevent Mid-transaction Throttle Delays option. This flag is not set if running the request did not override the throttle limit.
TnxUniq Used in conjunction with the userid and procid to uniquely identify the transaction under which this request ran.