ChannelDB2

David t's Blog (37)

A Fast Way to Get Started with WebSphere MQ for DB2

You may already know that you can use DB2 and MQ together. For example, through Q Replication, by using DB2's MQ UDFs, or by…
Continue

Added by david t on April 23, 2011 at 1:00am — No Comments

Using Data Federation with solidDB

I hadn't actually thought of using federation with an in-memory database, but someone asked and I decided to give it a try. Turns out it's very easy. I also discovered two things that can be useful to a DB2 person like me who's just getting started with solidDB. I'll use this post to talk about those and show you how you to try solidDB federation yourself. Of course, if you've never done anything with IBM's data…
Continue

Added by david t on April 2, 2011 at 11: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

Disaster Recovery, High Availability, and Continuous Availability - What's the Difference?

Last month I posted a video that gave a brief overview of how data replication is used for continuous availability. I then got ask why I used the term continuous availability instead of high availability or disaster recovery. "What's the difference?" Well, while these solutions have a lot of overlap and can usually be built from some of the same components, they can have different objectives. Different objects can…
Continue

Added by david t on September 7, 2010 at 12:30am — 1 Comment

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

Tips for Using Data Replication to Do Database Migration

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


Continue

Added by david t on June 18, 2010 at 9:00pm — No Comments

A Fast Way to Get Started with DB2 Federation

Data federation (or virtualization) 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…
Continue

Added by david t on May 13, 2010 at 9:30pm — No Comments

Compare the Rows of Two Tables

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,…
Continue

Added by david t on April 2, 2010 at 12:30am — 4 Comments

Transforming Data as You Replicate

When replicating data, a very common requirement is to modify or 'transform' changed data before it reaches its final destination. Two simple examples:



-- Combine two columns of source data into a single value for a column at the target.

-- Change a numeric code at the source into a descriptive string for the target.


Many other transformations are possible, including those that are more… Continue

Added by david t on March 8, 2010 at 1:15pm — 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

A Fast Way to Get Started with Cache Tables (Distributed Caching)

I often get asked if it's easy to set up IBM cache tables and whether they can be set up with scripts instead of a GUI  The answer I give is yes to both questions.  Cache tables, a form of distributed caching, are very easy to set up and you can do it with scripts. The challenges are that (1) IBM's documentation could be better and (2) a good sample is needed. I'm hoping a few pictures, a little text, and a small sample are all that's needed to improve the situation…

Continue

Added by david t on February 5, 2010 at 9:00pm — No Comments

Federating DB2 and IMS

At last year's IOD conference, I learned more about two recently announced JDBC tools that had piqued my curiousity:



- InfoSphere Federation Server 9.7's "JDBC wrapper"

-… Continue

Added by david t on January 24, 2010 at 9:30pm — 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

Federating DB2 and PostgreSQL

In its 9.7 release, InfoSphere Federation Server added a "JDBC wrapper." This is an interface that lets the Federation Server access a database through that database's JDBC driver. Someone asked me if I thought PostgreSQL could be accessed this way and then federated with DB2.… Continue

Added by david t on January 7, 2010 at 8:00pm — 4 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

Featured Downloads

Try BLU Acceleration on Cloud

© 2018   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service