Just a short post to highlight the difference between the implementation of a similar sounding isolation level, namely REPEATABLE READ (RR), of DB2 and SQLServer.
In SQLServer, RR allows phantom reads, whereas DB2's RR does not allow phantom read.
Just because they have the same term, it does not *guarantee* they are the same ;)
As the saying goes:
*Assumption is the mother of all screw-ups*
In SQLServer, RR allows phantom reads, whereas DB2's RR does not allow phantom read.
Just because they have the same term, it does not *guarantee* they are the same ;)
As the saying goes:
*Assumption is the mother of all screw-ups*
