-- Apr 8 In-Class Exercise Thread

    <START T1>
    <START T2>
    <T1, X, 6, 8>
    <COMMIT T1>
    The new value of X is not on disk
    X=8 is in memory
    <T2, Y, 10, 5>
    <START DUMP>
    <START CKPT T2>
    Flush Dirty blocks
    X=8, Y=5 are now the values on disk
    <END CKPT>
    <FLUSH LOG>
    Copy database on disk blocks to archive, so will get X=8, Y=5
    <END DUMP>
    Logs from the earliest transaction operations listed in the
    start checkpoint until end dump are preserved in the archive.
    This will allow us to roll back T2 when restoring from archive. 

Howdy, Here is an exammple of how I would have done it... <START T1> <START T2> <T1, X, 6, 8> <COMMIT T1> The new value of X is not on disk X=8 is in memory <T2, Y, 10, 5> <START DUMP> <START CKPT T2> Flush Dirty blocks X=8, Y=5 are now the values on disk <END CKPT> <FLUSH LOG> Copy database on disk blocks to archive, so will get X=8, Y=5 <END DUMP> Logs from the earliest transaction operations listed in the start checkpoint until end dump are preserved in the archive. This will allow us to roll back T2 when restoring from archive. Best, Chris