About IBM DB2 LUW Database Replication

Why You Should Consider IBM DB2 Database Replication

• You want to augment your backup strategy : In conjunction with your routine backup, replication provides alternative levels of data protection and integrity, while minimizing user disruptions. Replication creates a point-in-time copy of the data to be used as the backup source.
• You want to distribute data: Data distribution allows you to make critical data available to local decision makers while maintaining firm central control over the data.  With replication, data can be shared and replicated between databases allowing you to put the data where it's needed.
• You want to create a high availability fail-over system: DB2 High Availability Disaster Recovery (HADR) is a database replication feature that provides a high- availability solution for both partial and complete site failures. HADR protects against data loss by replicating data changes from a source database, called the primary, to a target database, called the standby. In case of a failure the takeover by the standby database requires just seconds because the standby database server is already up and running.  HADR also lets you manage planned downtime like routine maintenance and software upgrades between connected servers.

Here’s How We Helped One Client with Database Replication

One of our clients had a problem with heavy load and poor performance on their production database servers. We discovered that most of the load came from reporting tools and the long running, complex queries they used. Our Xtivia DB2 experts implemented a new database on another server to use specifically for reporting, lessening the load on the production database. The new database contains a subset of 20 production tables and data is loaded into the reporting database nightly. 

This was possible because the DB2 SQL Replication feature is built into DB2. There is no need for additional software or licenses. DB2 SQL Replication is based on the database transaction logs so it is very efficient. DB2 SQL Replication has minimal impact as compared to other methods of moving data. Another great feature is that SQL Replication can be set up between different hardware and operating system platforms.

Our client achieved a fully functioning reporting database that could be configured and tuned specifically for a complex query workload. This freed up resources on the production database server and enabled us to tune it for a very high transaction, OLTP workload.

What You Can Expect from Xtivia

Our certified DB2 engineers will provide recommendations and strategies to set up replication environments to meet your organizational objectives. If you like, we can also provide Virtual-DBA services that can monitor your replication server activities.

Xtivia delivers:

• Initial assessments and review requirements
• Design replication system
• Approach  and plan details
• Schedule and  cost estimates
• Installation
• Testing and validation
• Training to administer replication server
• Replication server monitoring using Virtual-DBA when requested

Request More Information