Manage Massive Data Growth with Online Repartitioning

  • Copy link to clipboard
  • Email link
  • Print

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

Situation   

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

Problem

  1. The processor’s database queries are starting to time out and are becoming very inefficient.
  2. The growing database size and activity requires an online repartition (no application outage is allowed).
  3. The repartitioning impact needs to be minimized for homogeneous (same) and heterogeneous (different) file formats and table schemas.
  4. 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

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

Related Solution Brief: Zero Downtime Migrations HPE Shadowbase Zero Downtime Migration