If you will be in Baltimore on May 6th please join us!

Do you know the cost of capturing a change in your production database systems?  Does it cost an extra $100,000 per month to capture that change - and then is the change moved to a data warehouse that’s left many users dissatisfied?  We have a solution, InfoSphere Change Data Capture.

The Fillmore Group is teaming with IBM for a *free* lunch session at Orioles Park at Camden Yards, from 11am to 1pm, where we will explain how InfoSphere Change Data Capture can do an intelligent capture on heterogeneous databases to:  1) create an audit trail detailing who did what and when, 2) replace inefficient staging of changes on your mainframe, 3) eliminate the overhead and instability of ad hoc queries, 4) remove the inefficiency of triggers and message queues, and 5) reduce mainframe costs by $1 million per year - reliably feed downstream ETL, MDM, or SOA applications.

If you are interested in attending, click here for more information.  See you at the Yard!

In doing some co-marketing planning with the local IBM team there is clearly a lot of energy behind the push to move Oracle users to DB2.  With V9.7 the claim is that 95% of all Oracle application code will run - untouched - in DB2 V9.7.  So the IBM teams (and me) are looking at customers using both DB2 and Oracle as targets to move to 100% DB2 in 2010. 

I am accumulating information on the migration process and trying to figure out how to accomplish it quickly - and therefore as inexpensively as possible.  I want the ROI to show a return fast!  There is a tool to estimate the migration effort which can then be used to estimate the cost.  It’s 2010 - it’s so much easier than these things used to be…in fact, in looking at older migration plans, Frank dug up a white paper comparing Oracle and DB2 V6.1 that includes migration information.  It’s 148 pages long…take a look (at the link below) if you have absolutely nothing else to do.

Of course, in the world of new reseller programs, ValueNet and Software Advantage Plus, and so on, I must mention The Fillmore Group has a competitive migration VAP in place to enable us to sell DB2 to Oracle users for the best prices anywhere.  Call me if you want to make the change.  Go DB2!

http://eval.symantec.com/mktginfo/products/White_Papers/Application_Performance/indepth_db2_migration_wp.pdf

Just announced - The Fillmore Group will host four Optim sessions with the IBM team, featuring Paul Westfall, on Thursday, January 7th, from 9am - 3:30.  If you are “local” and interested in learning more about Optim (regardless of your database of choice), I hope you will join us.  More info below:

Enterprise applications and databases don’t just help run your business - they ARE your business.  And every year, they grow in size and complexity - making them harder and more complicated to manage.

IBM® Optim™ gives you the power to manage enterprise application data through every stage of its lifecycle – regardless of the relational database your organization uses.  These sessions will introduce the Optim products that can enable you to meet your service level agreements, decrease maintenance costs and protect data privacy and security, reducing your legal liability exposure, whether you use Oracle, SQL Server, Sybase, DB2 – any or all! Read More…

Most of you are aware that DB2 9 for LUW delivers PL/SQL APIs in v9.7.  That is, you can run Oracle applications against DB2 for LUW databases with little or no modification.  What you might not have heard is that IBM’s high availability, low-latency replication product - Q Replication - will now natively capture changes natively in Oracle logs.  That is, you can replication your Oracle Financials to a InfoSphere Warehouse.  Q Replication is a feature of IBM’s InfoSphere Replication Server, so you might not have noticed the new functionality with all of the name changes.

Two links describe the enhancement.  David Tolleson and Ed Lynch of IBM have both provided good information on the specifications and details.