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 with it, too :) That means they don't always find the answers they want. For example, how do I do HA for DB2 DPF? I get that one often enough that I'm going to provide some answers in this post.
First, understand that DB2's partitioned database function is now found in several products:
Next, know that built into all of these is the IBM Data Replication technology called Q Replication. Why does that matter? Q Replication is commonly used as a high availability solution for DB2. It works well with DPF. All you need to know is how to use it and whether you need to buy it. Let's start with cost.
Is Q Replication Free?
For many years, Q Replication has been available in the Homogeneous Replication Feature for DB2 and InfoSphere Replication Server. However, to provide Q as an HA option with DB2, IBM recently started making two-DB2 Q Replication available at no extra cost in several products, including the warehouse products. That means an HA solution comes with all DB2 partitioned databases (starting with 9.7.2). It also means you have an HA solution for IBM Smart Analytics Systems since their software stack includes InfoSphere Warehouse.
How Does It Work with DPF?
With Q Replication, you can choose to have any database partitioned - source, target, or both. I'm going to use a picture that has partitioned databases at both sites. It highlights the main points we want to discuss.
Notice the following:
All of this can be set up through a GUI or scripting.
The key ones are:
For More Information...
You can find more information several places:
If you have questions, see the Q Replication message board on developerWorks.