Home | Previous Page | Next Page   Distributed Data >

Multiphase Commit Protocols

In This Chapter
Transaction Managers
Using the TP/XA Library With a Transaction Manager
Using Microsoft Transaction Server (MTS/XA)
Using Dynamic Server Transaction Support for XA-Compliant, External Data Sources
Using Loosely-Coupled and Tightly-Coupled Modes
Two-Phase Commit Protocol
When the Two-Phase Commit Protocol Is Used
Two-Phase Commit Concepts
Phases of the Two-Phase Commit Protocol
Precommit Phase
Postdecision Phase
How the Two-Phase Commit Protocol Handles Failures
Types of Failures That Automatic Recovery Handles
Administrator's Role in Automatic Recovery
Automatic-Recovery Mechanisms for Coordinator Failure
Automatic-Recovery Mechanisms for Participant Failure
Presumed-End Optimization
Independent Actions
Situations That Initiate Independent Action
Possible Results of Independent Action
Independent Actions That Allow Transactions to Complete Successfully
Independent Actions That Result in an Error Condition
Independent Actions That Result in Heuristic Decisions
The Heuristic Rollback Scenario
Conditions That Result in a Heuristic Rollback
Results of a Heuristic Rollback
The Heuristic End-Transaction Scenario
When to Perform a Heuristic End Transaction
How to Use onmode -Z
Action When the Transaction Is Ended Heuristically
Monitoring a Global Transaction
Two-Phase Commit Protocol Errors
Two-Phase Commit and Logical-Log Records
Logical-Log Records When the Transaction Commits
Logical-Log Records Written During a Heuristic Rollback
Logical-Log Records Written After a Heuristic End Transaction
Configuration Parameters Used in Two-Phase Commits
Function of the DEADLOCK_TIMEOUT Parameter
Function of the TXTIMEOUT Parameter
Heterogeneous Commit Protocol
Gateways That Can Participate in a Heterogeneous Commit Transaction
Enabling and Disabling of Heterogeneous Commit
How Heterogeneous Commit Works
Precommit Phase
Gateway Commit Phase
Heterogeneous Commit Optimization
Implications of a Failed Heterogeneous Commit
Database Server Coordinator Failure
Participant Failure
Interpretation of Heterogeneous Commit Error Messages
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]