Teradata Concurrency Control: Locking and Transactions Explained
Learn how Teradata Concurrency Control uses locking and transactions to prevent simultaneous updates, deletions, or insertions in different sessions.
Transactions
Teradata Transient Journal: How It Protects Transactions Against Failures and Deadlocks
Learn about the Teradata Transient Journal, a crucial component for ensuring data integrity and protecting against system failures. This dictionary table is managed by each AMP, containing rows copied before changes are made to a transaction. If a transaction fails, the journal is used to roll back and restore the affected table rows. Discover ways to minimize journaling and improve performance, including BTEQ tricks and using load utilities. Find out how to avoid system-level errors and ensure there is always enough permanent space in the DBC database.
Teradata Data Loss Protection: Transient Journal, Fallback, RAID 1, and Clique
Learn how Teradata protects your data against potential loss with its various features. Each feature offers unique protection on different levels.