Set the Global Deadlock Detection Interval | Teradata Unity - 17.00 - Setting the Global Deadlock Detection Interval - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval

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. From unityadmin, enter the following command with the new time interval:
    CONFIG UPDATE globaldeadlockdetectioninterval <numberofseconds> REASON 'Enabling global deadlock detection';