Congratulations to IBM Champion Frank!

Posted by Kim May on October 27, 2011 under DB2 Gold Consultants, DB2 Migrations, IBM Champion, Information on Demand Conference, Oracle, Q-Replication. Tags: , , , , .

Congratulations to Frank Fillmore for being recognized at the IOD Champions luncheon for his contributions to the Information Management community, specifically for blogging on the use of Q Replication to minimize the Oracle to DB2 migration outage window at JPMC.  Frank received an iPad as a reward for his efforts and more importantly the sincere congratulations of his peers, colleagues, Steve Mills, IBM Senior Vice President and Group Executive – Software & Systems, and Beth Flood, Champions Program Coordinator. Congratulations!!

The Fillmore Group CTO Innovation Award Finalist!

Posted by Kim May on October 11, 2011 under IBM DB2 Services, Netezza, Q-Replication. Tags: , .

The TFG Netezza and Data Event Publisher solution developed to enable a fast load of OLTP data into Netezza is one of the finalists for the 2011 IBM CTO Innovation award, to be announced at this year’s IOD Conference.  Many thanks to our IBM colleagues Serge Bourbonnais and Alex Olin, and the Netezza team that contributed sales and technical expertise – Mickey James, Rob Maglies, and Brian Baillod.   We hope IBM will select this solution to share with other customers as an integrated IBM Netezza solution for OLTP data.  Keeping my fingers crossed!!

Fall Classes – Back to School for DB2 Users

Posted by Kim May on September 8, 2011 under Authorized Training Partner, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, Q-Replication. Tags: , , , , , , , .

Get the back-to-school spirit and register for a fall class at The Fillmore Group.  The classes below are scheduled to run in our Towson, Maryland classroom, just north of Baltimore.  I can’t promise crunching leaves underfoot but I can assure you will enjoy state-of-the art classroom equipment and award winning instructors.  Click on the course code for details and registration on the IBM site.

Don’t see the course you are looking for?  The Fillmore Group also delivers private classes on a variety of Information Management topics. 

 

Start

#

  Course  

Date

Days

     Cost

Code Name

31-Oct

3

$2,475

KM000 Change Data Capture Essentials

3-Nov

2

$1,300

CE822 Using InfoSphere Data Architect

7-Nov

4

$2,600

CE243 Using Queue Replication 

14-Nov

4

$3,300

KM200 DataStage Essentials V8.1

28-Nov

4

$2,600

CF632 Advanced DB2 Connect 9 for DB2 for z/OS

5-Dec

2

$1,300

CL600 *NEW*Implementing DB2 9 Connect

12-Dec

4

$2,600

CL412 DB2 9 for LUW Performance Tuning

Read More…

Successful Oracle to DB2 Migration at a Top 50 Financial Services Firm

Posted by Frank Fillmore on July 25, 2011 under DB2 for Linux Unix Windows, DB2 Migrations, Information on Demand Conference, InfoSphere, Oracle, Q-Replication. Tags: , , .

Whew!  The last four months have been a whirlwind.  A colleague, Jim Herrmann, and I have been working since March on data migration from Oracle to DB2 for a worldwide Top 50 integrated financial services firm.  A team of specialists from IBM and The Fillmore Group – including Joe Geller, Teresa Wan, Rebecca Bond, and John Schatko – assisted the customer with all aspects of application performance testing and tuning, code remediation, and data migration.  On Sunday, July 17 the production cutover occurred – and it was a huge success.  Props especially to IBMers Jeff Richardson, Jay Lennox, and Christian Zentgraf for providing technology leadership.

One of the keys to the migration of the data was the need to limit the site outage into a window no longer than 12 hours, from midnight to around noon on Sunday.  For an earlier migration, smaller in terms of data volume, the customer had successfully used the IBM Data Movement Tool (IDMT).  Given the metrics of the latest migration, the IDMT approach alone would have required an outage of up to 5 days – unacceptable for an online banking system on which millions of customer rely to pay bills and check balances.

The Fillmore Group proposed using InfoSphere Replication Server (Q Replication) to copy updates to the live OLTP data from Oracle to DB2 while the batch IDMT was running asynchronously to move the data from Oracle to DB2 tables.  By using IDMT and Q Replication in combination, we were able to reduce the outage to a much more manageable 12 hours.

We followed a template The Fillmore Group had used in 2010 at Constant Contact for their no-outage upgrade from DB2 for Linux, Unix, Windows v8.2 to DB2 v9.5.  Dan Berry and Sankar Padhi delivered a detailed technical overview of that project at the IBM Information On Demand conference last year: Zero Downtime Upgrades Using Q-REP at Constant Contact  The Oracle migration was incrementally more complex, but not all that difficult.