david t's Page

Someday after you get through reading the outstanding highlights in this week's announcement of the 7700, you may want to know what your replication options are. The answer is pretty much the same as it is for the 7600. I'll use this post to give you a quic

With more companies looking into the IBM Smart Analytics Systems, one obvious question people ask is - what are my replication options? The answer is simple, but not easy to find. I'm going to use this post to provide one for the 5600 and 7600.

Both of these systems are built on a base

Yes, it's true - all database vendors offer ways to migrate their databases from version to version. However, I see more and more people choosing data replication instead. Why? I'll answer that in this post. More importantly, I'll provide tips for those just starting out.

So... the most common reasons I hear for choosing replication are these:

Federation is a data integration technology that lets you build what some people think of as a database cloud. It's found in DB2, InfoSphere Warehouse, and a few other IBM products. It can be extended or used stand-alone through IBM's InfoSphere Federation Server.

However, even with it available many different ways, I regularly meet people who know little about it and are under the impression that it's difficult to learn. It's not :) That got me thinking about th

I regularly hear of people who want to compare the contents of two tables. For example, they have one table that is supposed to be a copy of another. Maybe it should be an identical copy. Or, maybe it contains a transformed version of the other's data. Whatever the case, they want to know if differences exist and they need more than just a simple count of rows from "select count(*)".

You can search the web and find all sorts of SQL query techniques to do this. Therefore, I'm