Greg Stark wrote:
There are other solutions too. I never used DB2 but I was led to believe they used their transaction log to retrieve old versions of the records. Someone else here claimed DB2 didn't implement MVCC at all so perhaps that's wrong though.
I would be suprised giving this paper: ftp://ftp.software.ibm.com/software/data/pubs/papers/readconsistency.pdf ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend