Shut Down Unity | Teradata Unity - Deadlock Detection - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.50
Published
January 2020
Language
English (United States)
Last Update
2020-02-04
dita:mapPath
frp1571162435023.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

A deadlock happens when two or more transactions are waiting for each other to give up locks. Three different types of deadlocks can occur with Unity.

Deadlocks within Unity-Managed Sessions
Unity performs deadlock detection for all managed sessions (sessions associated with managed routing rules). Since Unity does its own locking for all requests of managed sessions, Unity detects deadlocks before they have a chance to happen on the underlying managed systems. Unity resolves the deadlock at the time of detection.
Deadlocks on Underlying Unity-Managed Systems
With passive sessions, deadlocks at the database are possible. Because passive sessions bypass Unity standard locking and deadlock detection and are sent straight to the system (through the dispatcher process), deadlocks can occur at the Teradata system. Once Teradata detects a deadlock, it automatically takes appropriate action to resolve the deadlock.
Deadlocks Between Teradata and Unity
With Unity passive routing, deadlocks may not occur on the managed server or within Unity independently, but the system as a whole deadlocks. Unity periodically obtains blocking locks information from the underlying systems, using the Teradata PMPC API. This lock information is combined with Unity lock information to detect deadlocks. If Unity finds a deadlock, Unity or the Teradata server takes action to resolve the deadlock.