Set the Global Deadlock Detection Interval | Teradata Unity - Setting the Global Deadlock Detection Interval - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.51
Published
May 2020
Language
English (United States)
Last Update
2020-06-01
dita:mapPath
oic1588030762460.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 a Teradata system.

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