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

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…

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…

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…

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…