IBM DB2 for i (AS/400 DB2) to PC Databases Real-Time Data Replication

Access your AS/400 data without impacting your production environment

QMirrorDB provides a seamless solution for businesses looking to synchronize data from IBM DB2 for i (AS/400s DB2) to a variety of PC databases, including MySQL, MS SQL Server, Azure SQL, Google Cloud SQL, Oracle, Postgres SQL, MariaDB, MaxDB, LUW DB2, and Tibero. With QMirrorDB, data synchronization is hassle-free and risk-free, ensuring that your data is always accurate and up-to-date. Our cutting-edge software provides a robust and efficient solution to help you optimize your business processes, reduce operating costs, harness open-source resources, make informed decisions based on real-time data, and improve overall efficiency.

Take advantage of the full capabilities of QMirrorDB and experience the benefits of real-time data syncing. Start your free trial today and discover how QMirrorDB can transform your business operations.

Read what our clients say >>

Increase Business Agility

Transform your business with increased agility through the power of real-time data syncing. With QMirror DB, you can access fresh, accurate data in seconds, empowering your organization to make informed decisions, enhance reporting, and elevate your services.

Improve Operational Efficiency

Enhance your operational efficiency with QMirror DB that streamlines data synchronization and eliminates labor-intensive, manual replication processes. Our software replaces traditional periodic replication with automated, real-time syncing that saves time and reduces administrative overhead.

Reduce Operating Costs

Say goodbye to excessive operating costs and optimize your IT infrastructure with QMirror DB. Our solution enables you to move analytics and reporting tasks off the AS/400 platform, saving valuable system resources and reducing operating costs.

Set Up Remote Offices At Ease

Setting up remote offices and distributing your AS/400 data to segmented PC database servers has never been easier. QMirror DB makes it simple to distribute your AS/400 data to segmented PC database servers, giving your organization the flexibility and agility it needs to stay competitive in today's fast-paced business environment.

Ensure Data Integrity

With QMirror DB, you can trust that your critical business data is always accurate and up-to-date. Our advanced data replication technology ensures continuous and reliable data delivery, while automated verification processes guarantee error-free synchronization between your AS/400 and target databases.

Boost Your Data Migration Plan

Transform your data migration plan with QMirror DB. Our fast and robust data download and replication capabilities make it easy to migrate from the AS/400 platform to PC databases and SQL servers, whether on PC servers or hosted in the cloud on platforms like AWS, Microsoft Azure, and Google Cloud. Move your data seamlessly and with confidence,

Utilize Open-Source Resources

With QMirror DB, you can fully utilize open-source resources and maximize the value of your data. Our software enables seamless data synchronization between IBM DB2 for i and a wide range of PC databases, allowing you to leverage open-source applications and fulfill your BI, DW, ERP, and OLAT needs at a much lower cost.

"QMirror has made it simple to access our data. It is fast with very low to no impact to our users. Support is quick to respond and resolve any issue you might have. It’s a great product and cost-effective. Thank you, QMirror."
Orlando Torres
Data Analytics Manager, Business Intelligence, Bay Ltd., USA
"QMirror has proven to be a viable solution for mirroring data from our AS/400 based ERP system into the Windows database. Middleware Technologies' product support has been operating at a prestigious level."
Jyri Myllymki
IT Manager, Reka Rubber Ltd., Finland

Industry: Construction

With $500 Million in annual revenue and over 65 years of experience completing complex infrastructure projects, Aldridge is widely recognized as one of the leading contractors in USA.

“QMirror far exceeded my expectations. The installation was very simple and quick. Your customer support is the best I have experienced.

Your staff is always there, and problems are usually resolved in less than twenty-four hours. We recently went through an upgrade to our core iSeries application, and it resulted in some problems with QMirror. I emailed your support staff at 10:30 PM and received a response by 11:15 PM.

Since its original installation, you have significant value-added changes to the application. Keep up the good work. It is greatly appreciated.”

Jim Okkerse
Sr. Application Systems Architect, Aldridge Inc. USA

Get Started in Minutes

QMirror DB is designed to be easy to implement, with no AS/400 specialty required. You can set up and configure the software on your own in just a few minutes, without the need for extensive training or technical expertise. Say goodbye to complex, time-consuming data syncing processes and hello to seamless, effortless data integration with QMirror DB.

Unicode and DBCS Support

QMirror DB supports Unicode and Double-Byte Character Set (DBCS) languages, ensures that you receive accurate data in all languages, including Chinese, Japanese, and Korean. This feature saves time and eliminates the need for manual data conversion, improving data quality and efficiency. Trust in QMirror DB to handle all of your data synchronization needs, and focus on what really matters for your business.

Tiny Footprint on AS/400 and PC Server

QMirror DB is designed to have a minimal footprint on both AS/400 and PC servers, with no agent installation required on the AS/400 server and pre-installation only required on the Windows server. With a size under 150 MB, QMirror DB is the only application you need to install, making it a hassle-free option for data synchronization.

QMirror DB, with a size of 150 MB, is the only application you need to install. Since it demands tiny system resources, you can install it on the target database server.

Industry: Telecommunications

SKY Cable Corporation is the pay television and broadband arm of ABS-CBN, the Philippines’ leading media and entertainment company. As of January 2017, the company had 1.4 million customers across the country.

“QMirror as a product is easy to configure. You just need to setup the journaling in iSeries and the tables to be mirrored, and you can forget about it since it can re-download and resync the tables automatically if it encounters an issue.

We have implemented it in all major DBs, such as MySQL, MariaDB, Oracle, and MS SQL.

For their support, we can easily get reply via email whenever we have inquiries.”

El Nino Estacio​
IT Manager, Sky Cable Corporation, Philippines

Auto-Buildup Indexes

With QMirror DB, you can easily build indexes for your PC databases from AS/400 logical files. Simply enter the AS/400 library name, and QMirror DB will retrieve all related logical files in the library to automatically build up indexes for tables on the target PC database. This powerful feature saves you time and effort by automating the indexing process, allowing you to focus on other critical tasks for your business.

Auto-Data Synchronization Verification

Our advanced data replication technology automatically performs synchronization checks between AS/400 DB2 and the target database. You can even schedule verification times for specified tables to ensure maximum data integrity. With QMirror DB, you can rest assured that your data is always reliable and up-to-date, allowing you to make informed business decisions with confidence.

Auto-Recovery After Connection Failure

With QMirror DB, you can rely on automatic recovery in case of interruptions, such as AS/400 maintenance or errors. The software will pause and switch to suspend mode during such events and automatically resume from the point where it left off once the maintenance is completed or the issue is resolved. This ensures minimal disruption to your replication process and eliminates the need for manual intervention.

Auto Performance Tuning

QMirror DB offers an advanced auto-tuning feature that automatically adjusts its operation based on the AS/400 performance. This ensures that QMirror DB operates at maximum efficiency while minimizing the impact on your AS/400 system. With QMirror DB's auto-tuning feature, you can trust that your data replication will be optimized for performance, without the need for manual tuning or intervention.

Auto Monitoring

QMirror DB is designed to provide hassle-free data replication for your business. Once it's set up, you can forget about it and trust that your data is being synced automatically without requiring your attention. QMirror DB's auto-monitoring feature ensures that you are alerted via email in the event of any errors or issues. This allows you to proactively address any problems before they become bigger issues, ensuring that your data is always accurate and up-to-date.

Data Consistency 100%

Flexible and Scalable Real-Time Replication

QMirror DB provides flexible and scalable replication options, including one-to-one, one-to-many, many-to-one, and many-to-many real-time replication between AS/400(s) DB2 and PC database(s). With QMirror DB, you can consolidate data from multiple AS/400s DB2 databases into a centralized PC database or data warehouse, or distribute segmented data to users or applications in real time. As your business grows, QMirror DB can scale with you, ensuring that your data integration needs are always met.

Standard Edition for One-Way Replication

Download/replicate data from AS/400 (iSeries/System i/IBM i) DB2 to PC database servers

Premium Edition for Bi-Directional Replication

Download/replicate data between AS/400 (iSeries/System i/IBM i) DB2 and PC databases servers

Clients Reviews

What Our Clients Say?

At QMirror, we're proud to have helped businesses from a wide range of industries and countries achieve their data replication goals with our reliable, cost-effective solutions. Our clients have consistently praised our easy-to-use software, which enables real-time replication from IBM i to a variety of other platforms, including PC databases and cloud servers.

But we're more than just a software provider - we're a team of IBM i experts who are committed to helping our clients succeed. When you choose QMirror, you can trust that you're backed by a team that cares about your success and satisfaction. With over 18 year of experience and a track record of happy clients, you can feel confident that QMirror is the right choice for your data replication or migration needs. Read more >>

0 +
0 +

Get Started Free


OS/400  OS400 V5, IBM i V5R4, 6.x, 7.1 and above

PC Database MySQL, MS SQL Server, Oracle, Google Cloud SQL, Azure SQL, MariaDB, Postgres SQL, LUW DB2, MaxDB, Tibero

Windows OS  Windows 7, 8, 10 and above, Windows Server 2012 and above

Hardware minimum CPU P5 / RAM 128MB / HD 200MB required

For support in FilipinoFrench, JapaneseIndonesian, Malay, or Thai, please note in the form. For support in Chinese, please visit Zh-TW | Zh-CN.

By submitting, you accept our Privacy Policy.

Scroll to Top