SUCCESS STORY

Client

Bruce Power

Industry

Energy / Nuclear Power

Estuate Expertise

IBM Maximo | Data Archiving | Enterprise Asset Management

About the Client

Bruce Power is a major power generation organization that relies on enterprise asset management systems to support critical operational processes. With years of accumulated Work Order and Audit data, the organization needed to manage growing data volumes while maintaining system performance, data integrity, and secure access to historical information.

Download
Case Study

Click Here

Business Challenge

Bruce Power faced growing database and storage requirements due to years of accumulated Audit and Work Order data. The increasing volume of historical data also affected system performance and created the need for a secure archiving approach that could preserve data integrity and accessibility.

The key challenges included:

  • Massive Legacy Data Volumes – Years of accumulated Audit and Work Order data resulted in significant database growth and storage requirements.
  • System Performance Impact – The growing volume of historical data affected query performance, reporting, and overall Maximo system performance.
  • Secure Archiving & Data Accessibility – Bruce Power needed to archive large volumes of data while preserving data integrity, relationships, and accessibility without operational disruption.

Estuate Solution

Estuate implemented IBM Optim for Maximo Archive and IBM Optim Archive Viewer to securely archive legacy Maximo data while maintaining data integrity and access to historical information.
The solution included:

  • IBM Optim for Maximo Archive: Installed & configured to archive legacy Work Order & Audit data, significantly reducing database storage.
  • IBM Optim Archive Viewer: Installed to enable seamless, secure user access to historical data when required.
  • Referential Integrity: Maintained across related Maximo data ensuring no orphan Work Order records were created.
  • “Split and Run” Processing: Implemented to handle high volumes of Audit data within operational constraints.
  • Technology Environment: Implemented within an environment comprising MAS 9.1, Oracle 19c, Red Hat Enterprise Linux (RHEL) 8.10, and Windows Server 2022 Standard, with IBM Optim 11.7 Fix Pack 03 and IBM Optim Archive Viewer 11.7 Fix Pack 13.

Business Impact

The solution helped Bruce Power reduce its primary database footprint, improve system performance, and maintain secure access to historical data.

  • Millions of legacy records archived cleanly to secondary storage
  • TBs of storage reclaimed, significantly reducing primary database footprint.
  • 0 orphan records created during complex multi-table archiving routines.
  • Restored peak system performancewhile maintaining fully secure & compliant access.

Get in touch to know us better.

Talk to our experts today.

Contact Us

Estuate is now a Certified Claude Partner. Discover how we help enterprises build secure, scalable, and responsible AI solutions. Read More