Midrange Dynamics Midrange Dynamics

MDRapid

Intelligent Data Replication

Database Changes Shouldn’t Shut Down Your Business

MDRapid builds the new database table in the background and keeps it continuously synchronized using journal records.

All structures—indexes, views, constraints, and triggers—are added before go-live.

At implementation time, the new table is swapped into production in seconds with minimal disruption.

Keep Your IBM i Running

Popular Features

Simultaneous data transformation

Simultaneous data transformation.

Easily add and populate new fields or update field content. This includes masking, recasting, calculations and anything that can be achieved using SQL. All of this happens behind the scenes, into the new version of the table, while replication occurs.

Real-time monitoring dashboard during transformation

Real-Time Dashboard

Real-time monitoring dashboard during transformation of job status, total number of records, % complete, time estimated to complete, and actual time completed.

Manual or scheduled deployment automation

Manual or Scheduled Deployments

Deployments can be scheduled to run at a specific time or on a specific day of the week. This allows for controlled deployments during off-peak hours or during planned outages.

Status & Escalation Notifications

Status & Escalation Notifications

Receive messages, SMS, or Email notifications on configured events. Auto-escalation can be configured to send messages to a higher level of support as the issue progresses.

Pause & Resume for planned or uncontrolled outages

Pause & Resume for Planned or Uncontrolled Outages

Pause & Resume for planned or uncontrolled outages

Granular control minimizes error impact

Granular Control Minimizes Error Impact

MDRapid operates at a granular level, enabling precise control over database changes. By limiting the scope of errors and supporting object-level rollbacks, it delivers a more controlled and predictable deployment process while minimizing additional downtime during resolution.

Real World Scenarios

MDRAPID delivers tangible value in reducing production downtime to a minimum.

UK bank scenario See details...

Reorganize Large Table

A large UK bank needed to regularly reorganize a table with 788 million records. There are 101 logical files over the table, 30 joins to additional tables.

Solution

  • • Time Lock State without MDRapid: 15 hours (DOWNTIME)
  • • Data transform using MDRapid while application still active: 90 minutes
  • • Time lock state to move in new version of all files: 17 seconds
US logistics scenario See details...

Resize & Modernize Entire Database

A large US logistics services company needed to increase the length of their primary key in over 2000 tables and convert the tables from DDS to DDL (SQL). Over 900 billion records and 8000 changed programs in total.

Solution

  • • Time Lock State without MDRapid: 3 weeks (DOWNTIME)
  • • Time lock state to deploy all files and programs with MDRapid: 2 hours
  • • Reorganizing Large Files
  • • Database Modernization Implementation
  • • Field Resize Implementation
  • • Multiple System Database Rollout
  • • Test Data Automation
KEY BENEFITS | KEY BENEFITS | KEY BENEFITS
MDRapid key benefits

Speak To Our Experts

For more info, a live demonstration, or to discuss your business and technical needs with the Midrange Dynamics team.

Request Info