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.
A business that’s building a distributed system
A business requiring an additional backup strategy
An organization setting up an HAFS (high availability failover system)
Assess your IBM Db2 replication and high availability
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.
