David t's Blog (37)

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…

A couple of months ago, IBM announced enhancements to its data replication in support of DB2 v10 for UNIX and Windows. This month, IBM released an update to its Q Replication Dashboard that supports those enhancements and much more. In fact, most the Dashboard's enhancements can be used with Q Replication for DB2 z/OS, too. This post takes a quick look at…

I regularly see people ask how to access data on UNIX or Windows from apps on IBM's z/OS (mainframe) operating system. However, I haven't been able to find anything that discusses the options. Therefore, I'm using this post to provide the basics about one solution - using IBM's InfoSphere Federation Server as an interface.

This solution is for people running DB2 on z/OS. It's probably best discussed with a simple example and a picture. So, my example is - let's say you…

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…

For those of you who weren't at IOD this year, you may be interested to know that some of the presentations are now available on ibm.com. The one about active-active data warehousing by Dwaine Snow, Linda Snow, and Enzo Cialini, all of IBM, is a good read that doesn't require you have a presenter handy. It's pdf format can can be viewed or downloaded from the following link:…

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…

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…

Last 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…

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…

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…

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…

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…

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…

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." :)

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. …