Oracle to DB2 Migration: Why and How

Posted by Frank Fillmore on May 15, 2012 under DB2 for Linux Unix Windows, DB2 Migrations, International DB2 Users Group (IDUG), Oracle, Q-Replication. Tags: .

I’m headed out the door to attended the 2012 International DB2 Users Group Technical Conference in Denver.  But first, I wanted to post two related items:

Please post you comments on the blog.  I welcome the feedback.

IDUG NA DB2 Tech Conference 2012 – Replication Topics

Posted by Frank Fillmore on May 9, 2012 under DB2 for Linux Unix Windows, DB2 Gold Consultants, DB2 Migrations, IBM Champion, InfoSphere, International DB2 Users Group (IDUG), Oracle, Q-Replication. Tags: , .

The International DB2 Users Group (IDUG) DB2 Tech Conference will be held in Denver, USA from May 14 – 18 (that’s next week at the time of this post).  There are two events in which I am involved that touch on Replication.

  • On Wednesday, May 16 from 4:00 p.m. to 5:00 p.m. a Replication Special Interest Group (SIG) will be held in Room 110.  Senthil Chandramohan of IBM will be co-leading the SIG with me.  Jenny Pang of Nationwide will be the moderator.  The purpose of the session:

“Meet industry experts and develop a better understanding of the best practices to support a replicated environment.  Are you faced with monitoring replication or determining the latency in replication?  Are your sources and targets in sync?  When problems occur, how do you resolve them?  Come and share your questions and experience with other professionals and other experts in the field of replication.”

  • On Thursday, May 17 from 8:30 a.m. to 9:30 a.m. I will deliver “Zero Outage Oracle to DB2 Migrations” (Session G09) in Room 112.  Replication figures prominently in reducing a migration outage window.  The abstract:

“IBM has enabled the Oracle PL/SQL API’s in DB2 for Linux, Unix, and Windows v9.7; 97% of Oracle application code will work unmodified. So, how best to migrate the Oracle data to DB2? The IBM Data Migration Tool (IDMT) fosters a batch migration which requires an application outage – backup, IDMT, restore, SET INTEGRITY – which can last for hours or days depending on the volume of data and complexity of the data model. What if my website, eCommerce, OLTP application can’t be down that long? Learn how a world-wide Top 50 financial institution migrated data from Oracle to DB2 with a minimal application outage using InfoSphere Replication Server’s heterogeneous replication from Oracle to DB2.”

I hope to see you in Denver.  Safe travel!

SmarterQuestions Video on Oracle to DB2 Migration

Posted by Frank Fillmore on February 21, 2012 under DB2 for Linux Unix Windows, DB2 Migrations, Oracle. Tags: .

My colleague, Kim May, and I were interviewed at last year’s IBM Information on Demand Conference (IOD) regarding an Oracle to DB2 migration project on which The Fillmore Group was engaged in 2011.  We gave a brief overview of the motivations for the customer to undertake such a significant change to their IT infrastructure and the success that they achieved.

The full interview available here.