IBM Db2 Replication

Your objectives are our objectives.

99% uptime isn’t a fantasy. At XTIVIA, it’s a standard. Our engineers provide unparalleled Db2 replication strategies for IBM Db2 environments. XTIVIA also provides the Virtual-DBA service that monitors your servers every hour of every day.

An Unmatched Solution—Powered by XTIVIA.

  • Initial assessments
  • Replication system plan
  • Schedule & cost estimation
  • Installation
  • Test and validation
  • Server administration training
  • Constant monitoring (optional)

Replication is the copying of data from one place to another. Data can be extracted by programs, transported to some other location, and then loaded at the receiving location. One replication method is to extract only the changes since the last processing cycle, then apply those to the receiving location.

Data may be filtered and transformed during replication. There may be other requirements for replication, such as time constraints. In most cases, replication shouldn’t interfere with existing applications, and should have minimal impact on production systems. Thus, replication processes must be managed and monitored.

Who uses IBM Db2 Replication and Why?
A business that’s building a distributed system
Data distribution helps companies put necessary data in the hands of local decision-makers while maintaining firm central control over it. With IBM Db2 replication, data can be shared and replicated between databases, allowing system designers to put the data only where it’s needed.
A business requiring an additional backup strategy
In conjunction with backup, IBM Db2 replication strategies seek to complement traditional approaches by providing 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
An organization setting up an HAFS (high availability failover 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 only takes seconds, since the standby database server is already up and running. HADR also lets you manage planned downtime such as routine maintenance and software upgrades between connected servers.

Assess your IBM Db2 replication and high availability

We provide value to your business with assessment and assistance for your IBM Db2 database and DBA team.

In Practice
An XTIVIA client had problems with heavy load and poor performance on their production database servers. Most of the load came from reporting tools and the long-running, complex queries they used. XTIVIA implemented a new database on another server (specifically for reporting) to remove this workload from the production database. This new database would contain a subset of 20 production tables and data would be loaded into the reporting database nightly.

Db2 SQL Replication is a feature that comes built into Db2 without the need for additional software or licenses. Db2 SQL Replication is based on database transaction logs, so it’s very efficient. Using Db2 SQL Replication, there’s much less performance impact compared to other data transfer methods. Another very useful feature is that SQL Replication can be set up between different hardware and operating system platforms.

The result was a fully functioning reporting database that was configurable and tuned specifically for a complex query workload. This freed up resources on the production database server and allowed XTIVIA to tune it for a high-volume online transaction workload.

w

What's Next?

We would love to help you with your database project or manage your environment, call us 888.685.3101 Ext. 2 or complete the form and start a conversation with Virtual-DBA today!