COVID-19 Update — We are available to assist you during these trying times. Please contact us for assistance.

Manage Massive Data Growth with Online Repartitioning

Figure 1 — Original File or Table Structure (with N Partitions)

Situation   

One of the largest U.S. processor of credit card transactions provides 24×7 card management services on HPE NonStop Systems with HPE Shadowbase in an Active/Active (partitioned) business continuity architecture (data collisions are not possible).

Problem

The processor’s database queries are starting to time out and are becoming very inefficient. The growing database size and activity requires an online repartition (no application outage is allowed). The repartitioning impact needs to be minimized for homogeneous (same) and heterogeneous (different) file formats and table schemas. The processor required one tool and approach for all file and table types (Enscribe, SQL/MP, and SQL/MX).

Solution

Figure 2 — Open New File or Table (with M Partitions)

Outcomes

HPE Shadowbase Product of Interest


Contact us or your HPE Shadowbase representative, and learn how Shadowbase software will benefit you.

Further Reading

White Paper: Using HPE Shadowbase Software to Eliminate Planned Downtime via Zero Downtime Migration

Solution Brief:  HPE Shadowbase Zero Downtime Migration

  • Print
  • Email link
  • Copy link to clipboard