the MVCC effect on migration from oracle to db2

Posted by Ryan Fernandes on Stack Overflow See other posts from Stack Overflow or by Ryan Fernandes
Published on 2010-05-14T10:44:29Z Indexed on 2010/05/17 5:20 UTC
Read the original article Hit count: 311

Filed under:

mvcc

|

db2

|

Oracle

|

migration

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.. ?

© Stack Overflow or respective owner

Related posts about mvcc

How Indices Cope with MVCC ?

as seen on Stack Overflow - Search for 'Stack Overflow'
Greetings Overflowers, To my understanding (and I hope I'm not right) changes to indices cannot be MVCCed. I'm wondering if this is also true with big records as copies can be costly. Since records are accessed via indices (usually), how MVCC can be effective ? Do, for e.g., indices keep track of… >>> More
the MVCC effect on migration from oracle to db2

as seen on Stack Overflow - Search for 'Stack Overflow'
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… >>> More
Any client libraries that implement MVCC over Amazon SimpleDB?

as seen on Stack Overflow - Search for 'Stack Overflow'
Now that Amazon's SimpleDB implements consistent reads and conditional update/delete it is possible to implement cross-domain transactions using MVCC. Are there any client libraries that provide it? >>> More
Learning PostgreSql: old versions of rows are stored right in the table

as seen on SQL Blog - Search for 'SQL Blog'
PostgreSql features multi-version concurrency control aka MVCC. To implement MVCC, old versions of rows are stored right in the same table, and this is very different from what SQL Server does, and it leads to some very interesting consequences. Let us play with this thing a little bit, but first… >>> More
does my js replace view?

as seen on Programmers - Search for 'Programmers'
I am writing a web application which is based on Codeigniter and jQuery. I primarily use ajax to call my controller functions and it turned out, that there are just 4 view*.php files, because most of my contoller functions return JSON data, which is processed in my jQuery. So my actual code is divided… >>> More

Related posts about db2

link DB2 AS/400 (system i) and DB2 AIX

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, everybody. I have two different database in DB2, a in DB2 AS400 and other in DB2 AIX, is possible link this database, similar to link by Oracle? Thank you in advance. erva. >>> More
Speed-start your Linux App: Using DB2 and the DB2 Control Center

as seen on Internet.com - Search for 'Internet.com'
This article guides you through setting up and using IBM DB2 7.2 with the Command Line Processor. You'll also learn to use the graphical Control Center, which helps you explore and control your databases, and the graphical Command Center, which helps you generate SQL queries. Other topics covered… >>> More
DB2 LUW Security - The DB2 DBA as a Locksmith

as seen on Internet.com - Search for 'Internet.com'
Database security should have multiple locks at multiple layers with multiple keys (and perhaps some barbed wire, an electric fence, a moat and a mean junkyard dog as well). With all these locks and keys, some locksmith skills are certainly useful. Rebecca Bond introduces some of her favorite DB2… >>> More
Why can't Perl's DBD::DB2 find dbivport.h during installation?

as seen on Stack Overflow - Search for 'Stack Overflow'
We are using a Perl utility to dump data from DB2 database. We installed DBI package and it is asking for DBD package also. We dont have root access and when we try to install DBD package we are getting the following error: ERROR BUILDING DB2.pm [lijumathew@intblade03 DBD-DB2-1.78]$ make make[1]:… >>> More
DBI::DBD package not getting installed for Perl?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, We are using a Perl utility to dump data from DB2 database. We installed DBI package and it is asking for DBD package also. We dont have root access and when we try to install DBD package we are getting the following error. ERROR BUILDING DB2.pm [lijumathew@intblade03 DBD-DB2-1.78]$ make make[1]:… >>> More