Setting the Global Deadlock Detection Interval - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.20
Published
May 2019
Language
English (United States)
Last Update
2019-05-23
dita:mapPath
dzf1517499323110.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

A global deadlock refers to a deadlock between Unity and Teradata Database. A global deadlock may occur when Unity uses passive and managed routing at the same time with the option Passive Routing Allow Managed Writes selected.

You can change how often Unity attempts to detect a global deadlock between Unity and Teradata Database.

Because of performance degradation, enable Global Deadlock Detection only if you encounter deadlock issues.
  1. At the unityadmin prompt, enter the following command with the new time interval: CONFIG UPDATE globaldeadlockdetectioninterval <numberofseconds>;