the MVCC effect on migration from oracle to db2
- by Ryan Fernandes
I have a simple (actually simplified :) ) scenario that is possibly the cause for the headache I've been having for the last few days...
My current application (that serves 100's of users) currently uses Oracle as the database. I have no stored procs (I wish actually).
Now, I've been asked if the product will work if I migrate to IBM DB2 as the database.
So, after taking Oracle for granted all this while.... and having re-read Tom's article on MVCC (Multiversion Concurrency Control) and going through this post stating that DB2 is not 'on the list' or 'just tip-toeing in the area' as it were... I know I can't be sure that the product will work with DB2 as is.
Is there no hope.. or is there a nice disclaimer I could use.. ?