IBM InfoSphere Data Replication (IIDR)

Posted by Frank Fillmore on April 10, 2013 under DB2 for i, DB2 for Linux Unix Windows, DB2 for z/OS, IBM Information Management Software Sales, Information on Demand Conference, InfoSphere, Q-Replication. Tags: , , .

IBM has bundled its replication technology into a single package: IBM InfoSphere Data Replication (IIDR).  IIDR combines three components:

  • SQL Replication (heritage DataPropagator- Relational)
    • Easy to set up
    • Staging tables
  • InfoSphere Replication Server (IRS – heritage Q Replication)
    • High volume, low latency
    • Native Oracle and DB2 sources and targets
    • WebSphere MQ transport layer
  • InfoSphere Change Data Capture (ICDC – heritage DataMirror)
    • Broadest set of heterogeneous sources and targets
    • TCP/IP transport layer

There are a few of important take-aways.

  1. IBM substituted an implementation decision for a buying decision.  For quite a while SQL Replication was bundled free with DB2 for LUW.  ICDC and IRS were separately purchasable technologies with a lot of functional overlap.  In 2010 my colleague, Kim May, delivered an IBM Information on Demand (IOD) presentation distinguishing between the three.  Now you purchase the IIDR bundle and determine which technology is best suited for a particular use case.  As with most IBM software on distributed platforms, the cost is based on Processor Value Units (PVUs).
  2. New feature/functionality will be built into IIDR rather than the former heritage ICDC and IRS packaging.
  3. There will be a convergence of the technologies over time.  Many of the prospective changes are still IBM Confidential, but IBM is looking to consolidate components where it makes sense to do so.  There is a long-term roadmap that I hope IBM be sharing shortly.
  4. Upgrading and migration paths are a work-in-progress.  If you currently own ICDC or IRS and want to move up to IIDR, contact The Fillmore Group for pricing and implementation assistance.

IBM IM Sellers: Partner to Win with The Fillmore Group in 4Q12

Posted by Frank Fillmore on November 28, 2012 under DB2 for Linux Unix Windows, DB2 Gold Consultants, DB2 Migrations, IBM Champion, IBM DB2 Services, IBM Information Management Software Sales, IBM Mid Market Customers, Information on Demand Conference, Oracle. Tags: , .

The fourth quarter of 2012 will close in just over one month.  What will you close between now and then?  If you attended the Break Free Forum at the IBM Information on Demand (IOD) conference in Las Vegas last month, you heard The Fillmore Group’s founder and principal, Frank Fillmore, give real-world perspectives on successful Oracle to DB2 migrations – including a project at a worldwide Top 50 integrated financial services firm.

Listen to a brief ten minute podcast discussion between Frank Fillmore and Kim May, TFG Vice President of Business Development, that provides an overview of a the steps involved in a successful migration – from intital validation to production cutover.

Oracle Takeout – Partner with TFG

If you have prospects that can benefit from these perspectives, contact Kim at or (001) 443-956-0288.

We Know You Deserve It, But…

Posted by Frank Fillmore on November 2, 2012 under DB2 Stars, IBM DB2 Services, Information on Demand Conference, Optim, Q-Replication, TFG Blog. Tags: , , .

I submitted this blog post to the IOD blog (IOD blog) as I was leaving the conference:

At this year’s Information On Demand conference I had the pleasure to catch up with three IBMers who have endorsed, supported and yes, tolerated The Fillmore Group in various ways for many years. Each of these three wonderful IBMers announced their participation in the IBM “Road to Retirement” program and shared some of their post-IBM plans. I wish them all the very best, while at the same time am saddened to see such talented and dedicated experts leave IBM.

Sandy Ovard has been working as Business Partner liaison to Lab Services and has helped us navigate the increasingly complex Lab Services partner engagement process. As we depend on Lab Services for a portion of our services business, Sandy has had the frequently unpleasant job of soliciting Business Partner feedback and addressing issues. Her patience and consistent willingness to pitch in will be missed.

Holly Hayes is one of the SVL development superstars who has worked with a number of technologies. Holly is one of the few “surf and turf” people who fully understand the most technical of technical subjects and has the communication skills to explain them to those non-techies, like me, who need analogies and pictures to understand. I am have been surprised – and amazed – on more than one occasion when I hear about a customer that struggled with a new product implementation and hear, “and then I got Holly involved,” and invariably, things smooth out.

Finally, David Tolleson. David has been the replication and federation Product Manager and a tireless promoter of these solutions. David has blogged, responded to endless emails, and enthusiastically supported a niche technology that enables some of the world’s largest IT shops to meet those 24X7 uptime SLA’s. He has worked with a team that is not only technically capable, but fun to work with.

Good luck to you all!

IBM PureData Systems @ #ibmiod

Posted by Frank Fillmore on October 22, 2012 under DB2 for Linux Unix Windows, IBM Smart Analytics System, Information on Demand Conference, Netezza. Tags: .

Announced on October 8, 2012 IBM PureData Systems were heavily featured in the Information on Demand conference opening keynote this morning.  There are three members of the PureData family:

I’m using the abbreviations for convenience and to save keystrokes.

PDST is built on IBM’s pureScale technology; pureScale is the shared-disk cluster technology for DB2 running on Power and Intel processors.  IBM based pureScale on the DB2 for z/OS Parallel Sysplex fault tolerance that mainframers have been using for years.  The relatively slow adoption of pureScale has been a puzzlement.  High-availability database solutions are being adopted by government and industry where the results of even a brief outage can range from bad for business to catastrophic.  One inhibitor to adoption has been removed, that of the InfiniBand requirement for cluster communications.  The PureData System for Transactions uses a simple Enternet connection for lashing together nodes in the cluster.

PDSOA is the next generation of the IBM Smart Analytics System (ISAS).  ISAS was arguably IBM’s first data “appliance” – a preconfigured, balanced processor/memory/storage stack bundled with InfoSphere Warehouse.  InfoSphere Warehouse employs the shared-nothing MPP functionality formerly known as Data Partioning Feature (DPF).  One prospective use of PDSOA would be near-real-time fraud detection.

PDSA is Netezza running under the covers.  Using innovative function-to-data Field-Programmable Gate Array (FPGA) integrated circuits, Netezza achieves orders-of-magnitude greater query performance for deep analytics like market-basket analysis.

The goal of the entire PureSystems portfolio – which includes offerings for WebSphere and custom applications – is to accelerate time-to-value and reduce or eliminate the repetitive, mundane tasks involved in infrastructure deployment.  IBM says that their PureData Systems go from door-stop to “load ready” in 4 hours.  Enterprises that provision database servers regularly commit weeks to these tasks.

One telling anecdote is that when the PureSystems plan was presented to then IBM CEO Sam Palmisano, Sam’s reply was that team was “building the AS/400”, a rock-solid platform known for its integration (hence the “i” in iSeries and System i), simplicity, and ease of maintenance and use.  Indeed, two of the PureData servers are manufactured in the AS/400 Rochester, MN IBM Lab.  PureSystems are nicknamed “AS/500”.

There’s lot’s more detail to come on the PureData varients.  Think of this as a cheat-sheet for telling the siblings apart.

IOD Blog Post

Posted by Frank Fillmore on October 16, 2012 under DB2 Education, IBM Champion, Information on Demand Conference, TFG Blog. Tags: , .

A bit of self-promotion – my apologies!

Crysta Anderson and David Pittman of the Information Management Social Media team are doing a range of activities to promote interaction at IOD this year.  One of which is hosting a guest blog at

I submitted a post and it’s on the site today!  A bit fluffy compared to the other posts, but if you are looking for some great recommendations from other conference attendees, I suggest you read through some of the posts.  There are some great ideas and suggestions.

And check out my post, too:


IOD Early Bird Special Ends Friday

Posted by Frank Fillmore on August 29, 2012 under DB2 Education, Information on Demand Conference. Tags: , , .

If you haven’t registered for this year’s Information on Demand (IOD) conference yet, Friday is the last day for the $300 early bird discount.  To register go to IOD. 

One note on this year’s conference:  I heard a rumor that certification testing would not be offered at this year’s conference.  I called the registration folks earlier today and was told that there WILL be testing available, but that the website with the testing details won’t be up for 3 to 5 more days.  Hmmmm….

2012 IOD Conference – Come Join Us!

Posted by Frank Fillmore on July 16, 2012 under DB2 Education, IBM Information Management Software Sales, Information on Demand Conference, TFG Blog. Tags: .

If  you are planning to attend the IBM Information on Demand conference in October (October 21-25, in Las Vegas), I hope you will connect with us and attend one of our sessions or events.

Two suggestions:  1) register early to take advantage of the $300 discount for registrations received by August 31st, and 2) register with The Fillmore Group’s promotion code and get a personal invitation to our events – enter G12FILLMOR when you register for the conference HERE.

Finally, for those of you with feet (!) please be reminded to register and make your hotel reservations before all the rooms at the Mandalay Bay are gone…sounds kind of silly but believe me, the place is HUGE and every step you save WILL matter.

Go Ginni – Break that Glass (Ceiling)

Posted by Frank Fillmore on April 4, 2012 under Information on Demand Conference.

At the IOD Conference this past October, at the “Women in Technology” networking session, led by Debbie Landers and Alyse Passarelli, Alyse announced that Ginni Rometty would be succeeding Sam Palmisano as IBM CEO – IBM’s first woman CEO.  The women (and men) in attendance all toasted Ginni and the cell phones were flashing!!

I was on the phone with my son a few days later and told him about the toast, and how I’d gotten goosebumps.  My son is 19; he went to daycare with the same girls he sat with in school and played with in the soccer league.  How far we’ve come, I told him.  When I was in school girls could chose ballet or the swim team – the options were THAT limited.  Ginni Rometty comes from my generation – she wasn’t raised in a world that offered her the same opportunities as the boys.  In spite of it, she has been enormously successful.

We all recognize hard work and persistence.  They aren’t enough; it takes even more to enable others to take notice and to really reshape their opinions and beliefs.  Power is definitely a factor.  I hope the membership committee at Augusta recognizes that Ginni Rometty has earned the right to be invited to join.  I hope Ginni uses her power for positive change and breaks another glass ceiling!

Must-have iPad Apps for the DB2 DBA

Posted by Frank Fillmore on March 17, 2012 under DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, IBM Champion, Information on Demand Conference. Tags: .

At IBM’s Information on Demand (IOD) conference held in Las Vegas in October of 2011, I was awarded an iPad 2 at the IBM Champions luncheon for working on the “most significant” Oracle to DB2 migration to that date.  Although I had had a Kindle e-reader for a while, I was new to tablet computing.  Initially I used the iPad for personal productivity and communications (Skype, Twitter, GMail, etc.) and entertainment (Netflix, Kindle app for iPad, and so forth).

What surprised me was that I can use the iPad to actually do my job.  Here are a few iPad apps I have found useful.

  • TinyTERM ITX 3270 for iPad  Yes, you too can turn your iPad into a dumb terminal.  For the DB2 for z/OS DBA, TinyTERM 3270 provides a green-screen interface to TSO, CICS, and IMS.  For practical use, you will need a bluetooth keyboard.
  • IBM Cognos Mobile  Work with reports locally on your iPad or connect to a Cognos server to get your KPIs and dashboards.

At this point, you’re probably saying “Yeah, but any useful server is going to behind my company’s firewall.”  The Cisco Anyconnect VPN is available if, for example, you need to access IBM TECNet servers for a demonstration.  The iPad also comes with native VPN software which can be configured under Settings > Network.

There are some additional apps such as DB2 Mobile Database Client and iDB2Prog which I haven’t had a chance to test yet.  Any feedback from folks that are using them would be appreciated.

Kim May Named IBM Champion in 2012

Posted by Frank Fillmore on March 16, 2012 under Baltimore Washington DB2 Users Group, DB2 Connect, IBM Champion, Information on Demand Conference. Tags: , .

For four consecutive years, my colleague, Kim May – VP of Business Development for The Fillmore Group, has been named an IBM Champion.  Kim has

  • been on the board of the Baltimore/Washington DB2 Users Group since 2005
  • presented at the IBM Information on Demand (IOD) conference in 2010
  • run the DB2 Connect Virtual Users Group since 2010
  • hosted luncheons to help existing IBM customers understand the breadth of the IBM Information Management software portfolio since 2011
  • blogs and tweets on a regular basis

The Virtual Users Group (VUG) approach has been so successful in fostering community in the DB2 Connect domain that three new VUGs will debut in 2012.  Watch this space and, if you get a chance, extend congrats to Kim.