You may have seen the recent video here on ChannelDB2 that introduces auditing of DB2 changed data. If you're interested in giving it a quick try, it's easy set up a simple configuration and see what you get. That's what I'm going to show you how to do in this post. It should take about 5-10 minutes. We'll use DB2's SQL Replication. It's provided with all editions of DB2 and InfoSphere Warehouse…
ContinueAdded by david t on July 18, 2012 at 5:00pm — No Comments
Along with today's announcement about the new version of DB2 and InfoSphere Warehouse, IBM also announced an updated release of …
ContinueThis month, IBM released an update to the Q Replication Dashboard. The most significant enhancement is the addition of a simplified user interface that's designed for web browsers in small touch-screen devices. I've tried it on both an iPhone 4S running iOS 5.0.1 and a Google…
ContinueAdded by david t on December 26, 2011 at 9:00pm — No Comments
About two years ago, I posted a video showing how to use SQL Replication with HADR. Lately, I've gotten a bunch of requests to do something similar for Q Replication and HADR. The good news is that I don't have to :) there's now a white paper called…
ContinueAdded by david t on December 15, 2011 at 1:00pm — No Comments
As with I did for last year's IOD, I'm providing a consolidated list of sessions for Replication and Federation at this year's IOD as well. These sessions should be of interest to anyone with data integration needs. Session descriptions can be found in the on-line IOD agenda for registered participants. Hope…
Added by david t on October 19, 2011 at 12:00pm — No Comments

If you're going to be at this year's IOD conference in Las Vegas, you might be interested in reviewing some of IOD 2010's customer stories for data replication. I've got links to a couple of them here along with links to some of the IBM presentations for both replication and federation. You'll hear more stories like these this year. You'll also be able to see demos in the InfoSphere Demo Room. …
Last week, smarterquestions.org had a very good post comparing two new database offerings for SMB - the IBM Smart Analytics System 5710 and the Oracle Database Appliance (ODA). Naturally, the first thing I looked for was anything comparing options for…
ContinueLast month IBM announced a new Data Replication product that bundles its CDC, Q, and SQL Replication technologies. IBM's intent is to provide all replication enhancements through this new product. To go along with that direction, IBM just announced an update to the CDC technology in Data Replication. The new level is Data Replication 10.1.1. I'll list a few highlights in this…
ContinueAdded by david t on September 19, 2011 at 12:17pm — No Comments

Data Replication
Frequently Asked Questions
Today, IBM announced that it's packaging all of its relational database replication technologies into a single product called IBM InfoSphere Data Replication (IIDR). Naturally, people are bound to have questions, so I'm going to cover what I…
ContinueAdded by david t on August 16, 2011 at 8:30am — No Comments
Most replication products talk a lot about how great high-speed data replication is. Naturally, I agree :) It's great. However, if something ever corrupts your source data, you'll likely see an ugly side of speed - your target gets all the source's corrupt data with sub-second latency. What a pain. You have no time to prevent the mirrored corruption. That might leave both source and target unusable. And that's especially frustrating if your target is supposed to be a…
ContinueAdded by david t on August 10, 2011 at 10:30pm — No Comments
Years ago, IBM had a product called Information Integrator (II). It was IBM's first attempt at a data integration platform. While II is no longer around, one thing it got right was the approach of solving customer problems through a combination of data replication and data…
ContinueAdded by david t on July 29, 2011 at 1:00pm — No Comments
I get a lot of questions about what's included in DB2 Advance ESE where data federation (virtualization) and replication technologies are concerned. Some of them are simple licensing questions about what you get for no extra charge. However, many more are about basic functionality. developerWorks helps out in both cases. For the questions about function, there's…
Added by david t on July 18, 2011 at 12:00pm — 4 Comments
IBM has a new availability solution, GDPS active-active continuous availability (GDPS/A-A), that offers an unlimited distance between data centers, cross-site workload monitoring, automated workload balancing, and recovery time objectives measured in seconds. I have a few highlights here. Full details can be found in…
ContinueAdded by david t on May 24, 2011 at 6:00pm — No Comments
SQL Replication is a data replication technology that's been used with great success in many shops for over 20 years. Yet, IBM also provides the Q Replication technology that has developed an excellent reputation for high performance, continuous availability, and zero-downtime database migration. Naturally, that leads SQL Replication users to ask if they should switch from SQL to Q. The answer, like the answer to many other questions, is... "it depends." :)
You have your…
ContinueAdded by david t on May 13, 2011 at 8:00pm — No Comments
IBM has an excellent new white paper on developerWorks about using Q Replication for active-active databases with DB2 pureScale. It covers everything from basic terminology and set up to why WebSphere MQ adds value to active-active replication. I like this paper for two reasons. First, it's the most complete documentation IBM has for using Q Replication with DB2 puresScale. …
Added by david t on May 11, 2011 at 6:00pm — No Comments
Added by david t on April 23, 2011 at 1:00am — No Comments
Added by david t on April 2, 2011 at 11:00pm — No Comments
These are the ten topics that I felt were the most popular with the sales teams and customers I worked with in 2010. As with last year's list, this year's based solely on my own experience. No way I'm going to try to reconcile my colleagues' opinions and come up with a composite list :) There are just too many opinions around for that. I'll stick with mine, start at the top, and work…
ContinueAdded by david t on January 8, 2011 at 1:00am — No Comments
Added by david t on September 7, 2010 at 12:30am — 1 Comment
Added by david t on August 20, 2010 at 12:00pm — No Comments
Explore in-memory and columnar technologies through this active approach to exploring emerging technologies.
![]() |
FREE Book: Getting started with DB2 |
© 2013 Created by channeldb2.