Transaction Table

This table is used during restart recovery to track the state of active transactions. It is initialized during the analysis pass from the most recent checkpoints record and is modified during the analysis of the log records written after the beginning of that checkpoint. It is also used during normal processing. Its fields are :

1. TransId : transaction identifier.
2. State : Commit state of the transaction : prepared ('P'- also called in-doubt) or unprepared ( 'U' ).
3. LastLSN : LSN of the latest log record written by the transaction.
4. UndoNxtLSN : LSN of the next record to be processed during rollback.