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

Teradata® Unity™ User Guide

Continuous Availability
Teradata Unity
Release Number
September 2020
English (United States)
Last Update
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.