David t's Blog Posts Tagged 'SQL Replication' (11)

A Fast Way to Get Started Auditing DB2 Changed Data

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…

Continue

Added by david t on July 18, 2012 at 5:00pm — No Comments

Data Replication and Federation at IOD Past and Present

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

Continue

Added by david t on October 13, 2011 at 9:43pm — 1 Comment

IBM's New Data Replication Product

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…

Continue

Added by david t on August 16, 2011 at 8:30am — No Comments

Should You Switch from IBM's SQL Replication to Q Replication?

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…

Continue

Added by david t on May 13, 2011 at 8:00pm — No Comments

2010's 10 Most Popular Data Replication Topics for DB2

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…

Continue

Added by david t on January 8, 2011 at 1:00am — No Comments

Data Replication for the IBM Smart Analytics System 7700

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…

Continue

Added by david t on August 20, 2010 at 12:00pm — No Comments

Data Replication for the IBM Smart Analytics System 5600 and 7600

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…

Continue

Added by david t on July 2, 2010 at 1:00pm — No Comments

Distributing Data to a Large Number of DB2 Servers

Once you get past the simple case of copying changed data from one system to another, the next most common replication solution is data distribution. In this scenario, you distribute data from a central database to two or more databases, maybe even 100's, that are likely remote. An example is sending changes from a corporate headquarters to branch offices or retail locations. You may only need the data to flow one way - from a central database to others. Or, you may also need some data to…

Continue

Added by david t on February 15, 2010 at 4:00pm — No Comments

2009's 10 Most Popular Replication Features for DB2

While preparing for what's likely to be coming my way in 2010, I thought about the topics I spent the most time on in 2009. I eventually wound up with a list of 10 that I felt were the most popular with the sales teams and customers I worked with. I thought I had a pretty good list :) so I emailed it to my collegues to get their impression. Naturally, everyone had at least a slightly different list and, when there was overlap, everyone wanted a slightly different order. Go… Continue

Added by david t on January 17, 2010 at 10:00pm — No Comments

Replicating Changed Data From DB2 to PostgreSQL

In my previous post, I showed how federated database technology can make PostgreSQL tables appear as though they're DB2 tables to DB2 users. Naturally, one of the first follow-on questions I get about this is, if these look like DB2 tables, can they be used with DB2's built-in change data capture technology called SQL… Continue

Added by david t on January 11, 2010 at 1:49pm — No Comments

A Fast Way to Get Started with DB2's SQL Replication

SQL Replication is a database replication technology built into DB2 and InfoSphere Warehouse. People often ask me what's the fastest way to get started with it. I think it's best just to set up a simple configuration and go from there. That's what I'm going to show in this post. It should take about 5-10 minutes. You can then extend that…

Continue

Added by david t on November 13, 2009 at 12:30pm — 1 Comment