This section describes how Vantage processes transactions.
- Database Transactions
- Transactions, Requests, and Statements
- Transaction Semantics Differences in ANSI and Teradata Session Modes
- Comparison of Transactions in ANSI and Teradata Session Modes
- ANSI Session Mode Transaction Processing Case Studies
- Teradata Session Mode Transaction Processing Case Studies
- Rollback Processing
- Database Locks, Two-Phase Locking, and Serializability
- Lock Manager
- Database Locking Levels and Severities
- Client Utility Locks
- Default Lock Assignments and Lock Upgradeability
- Blocked Requests
- Proxy Locks
- Pseudo Table Locks
- Deadlock
- Minimizing Deadlock
- Example: Transaction without Deadlock
- Example: Transaction with Deadlock
- Example: Two Serial Transactions
- DDL and DCL Requests, Dictionary Access, and Locks
- DML Requests and Locks
- Locking Issues with Consume Mode SELECT Queries on a Queue Table
- Cursor Locking Modes
- Locking Issues with Tactical Queries