Transaction Table

• Stores for each transaction:

  • TransID, State
  • LastLSN (LSN of last record written by txn)
  • UndoNxtLSN (next record to be processed in rollback)

• During recovery:

  • initialized during analysis pass from most recent checkpoint
  • modified during analysis as log records are encountered, and during undo

Notes: