ChannelDB2

David t's Blog Posts Tagged 'fast start' (10)

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

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

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

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

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

Try BLU Acceleration on Cloud

© 2014   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service