ChannelDB2

David t's Blog (37)

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

Q Replication Dashboard Updated for 2012

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…

Continue

Added by david t on June 18, 2012 at 1:45pm — 1 Comment

IBM Data Replication Updated for DB2 10 on UNIX and Windows

Along with today's announcement about the new version of DB2 and InfoSphere Warehouse, IBM also announced an updated release of …

Continue

Added by david t on April 3, 2012 at 2:00pm — 1 Comment

The New Android and iOS UI for Q Replication

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

Continue

Added by david t on December 26, 2011 at 9:00pm — No Comments

Accessing Oracle, Netezza, and Microsoft Excel from DB2 z/OS

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…

Continue

Added by david t on December 20, 2011 at 8:14pm — No Comments

Using Q Replication with DB2's HADR

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…

Continue

Added by david t on December 15, 2011 at 1:00pm — No Comments

Cracking the Active/Active Data Warehouse Dilemma

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

Continue

Added by david t on November 15, 2011 at 9:30pm — No Comments

Data Replication and Data Federation (Virtualization) at IOD 2011

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…

Continue

Added by david t on October 19, 2011 at 12:00pm — No Comments

Give IBM Your Feedback About Mobile Apps

If you use Twitter, you may have seen @Merv's (Merv Adrian's) tweets today about the projected number of tablets to be in use by 2016 and the ratio of mobile-to-PC…

Continue

Added by david t on October 14, 2011 at 6:30pm — 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

Active-Active Databases: IBM 5710 vs the Oracle Database Appliance

 

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…

Continue

Added by david t on October 6, 2011 at 12:30pm — 1 Comment

IBM Updates its New Data Replication Product

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…

Continue

Added by david t on September 19, 2011 at 12:17pm — No Comments

High Availability for DB2 DPF

DB2 LUW partitioned databases haven't been called DPF, the Database Partitioning Feature, since 2007.  However, a lot of people still use the term.  That's not a bad thing, but they tend to search…

Continue

Added by david t on August 29, 2011 at 2:06pm — No Comments

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

Building Time-Delayed Targets with Data Replication

 

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…

Continue

Added by david t on August 10, 2011 at 10:30pm — No Comments

Why Data Replication and Federation Are a Good Match

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…

Continue

Added by david t on July 29, 2011 at 1:00pm — No Comments

New developerWorks Article About DB2 AESE's Federation and Q Replication

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…

Continue

Added by david t on July 18, 2011 at 12:00pm — 4 Comments

IBM's New Active-Active Solution for DB2 and IMS on z/OS

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…

Continue

Added by david t on May 24, 2011 at 6:00pm — 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

pureScale, Q Replication, and Active-Active Databases

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

Continue

Added by david t on May 11, 2011 at 6:00pm — No Comments

Featured Downloads

Try BLU Acceleration on Cloud

© 2017   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service