文档介绍：DB2
Overview of Disaster Recovery Options
Sina Weibo ***@zhoushuoji
2012
April 16, 2012
Overview of Disaster Recovery Options
. Q Replication
. InfoSphere Change Data Capture (CDC)
. Storage Replication
. Geographically Dispersed pureScale Cluster (GDPC)
. Log Shipping
. HADR
. Comparison of DR Options
2012
2
Q Replication
. High-throughput, low latency logical data replication
– Distance between sites can be up to thousands of km
. Asynchronous replication
– No “zero data loss” guarantee
. Includes support for:
– Delayed apply
– Multiple targets
– Replicating a subset of data
– Data transformation
. DR site can be active
– Bi-directional replication is supported for updates on both primary and DR sites
2012
3
Q Replication
. Components include Q Capture, Q Apply, and WebSphere MQ
. Changes are captured from logs of source database and
placed into queues
. Highly parallel apply processing applies changes from queues
to the target database
– Multi-vendor targets supported (. DB2, pureScale, Oracle, etc.)
2012
4
Q Replication (cont.)
. Some database applications, certain database constructs, and
some types of SQL statements can require special treatment
– See the Information Center for details
./infocenter/db2luw/v9r7/..
. DB2 to DB2 replication included as part of Advanced
Enterprise Server Edition
2012
5
Q Replication: Active/Active DR Example
2012
6
InfoSphere Change Data Capture (CDC)
. Similar to Q Replication in that it supports high-throughput,
low-latency logical data replication
– Does not use MQ queues for data transport
. Supports bi-directional replication and active/active DR
. DB2 can be both source and target of replication
– Mix of multi-vendor sources and targets supported
2012