Transaction ID Time Action Record Updated Before Image After Image
1 8:00 Start
2 8:01 Start
2 8:02 Insert Client (521) (new values)
1 8:03 Update Tasks (WC19, $125.00) (old values) (new values)
2 8:04 Insert WorkOrders (69163) (new values)
1 8:05 Commit
3 8:06 Start
2 8:07 Insert OrderLine (69163, VR39) (new values)
2 8:08 Insert OrderLine (69163, UP38) (new values)
4 8:09 Start
2 8:10 Update Client (521, $275.00) (old values) (new values)
2 8:11 Update Consultant (19, $25.00) (old values) (new values)
2 8:12 Commit
3 8:13 Update Consultant (51, 40) (old values) (new values)
3 8:14 Commit
4 8:15 Delete Tasks (AC65) (old values)
4 8:16 Commit
FIGURE 7-11 Sample log in which all four transactions commit normally