MX-Archiving is the native application that automates archiving of historical data from your IBM Maximo — with zero service interruption, no data loss, and zero effort for your teams.
IBM Maximo accumulates millions of rows: work orders, job plans, inspections, inventory transactions. Without an archiving strategy, the database keeps growing until it becomes an operational — then financial — burden.
Queries take longer, data entry screens slow down, and reports take minutes where they used to take seconds. Your technicians are left waiting.
Every year, your DBA has to add disk space to absorb data that is no longer accessed in daily operations 80% of the time. Backups and restores take proportionally longer.
Finding a specific work history among millions of work orders becomes time-consuming — and risky during an ISO 55000 or regulatory audit.
Developed by Sinorfi after 20 years of Maximo projects, MX-Archiving installs as a native application in System Configuration and automates the entire lifecycle of your data.
MX-Archiving installs as a native application in System Configuration. Your administrators configure, run, and monitor everything from within Maximo — no third-party tools.
A single SQL job drives the entire process: copying data to the archive tables, then deleting it from the active tables. Schedulable to fit your maintenance windows.
Define coherent groups (e.g. INTERVENTIONS = work orders + linked child objects). Archiving preserves referential integrity and archives the parent object along with all its child records.
Archive tables (e.g. IPO_ARCHI_WORKORDER) remain queryable from within Maximo. Your teams can retrieve any historical record without any special handling.
A complete solution, from configuration to real-time processing monitoring — with no compromise on the integrity of your Maximo data.
Define, for each Maximo object, its source table (WORKORDER) and its archive table (IPO_ARCHI_WORKORDER) with a configurable prefix.
Create parent-child groups to archive a work order together with all its linked child objects, while preserving referential integrity.
Enable or disable archiving table by table, independently. An inactive table is skipped on the next cycle without changing the overall configuration.
Choose the periodic task, frequency, and time window. Archiving can run at night, on weekends, or on demand — without impacting production.
Status of each archiving run (success / failure), detailed error messages, execution date, and the trend in the number of records archived per table and per year.
4 stored procedures cover every case: InsertSourceToDest_E, _ENS, _U, _Unit — to properly handle each type of Maximo object.
Parent-child groups ensure a work order is never archived without its child objects: labtrans, matusetrans, woactivity, woservicerec…
Archive tables can be exported to lower-cost long-term storage, or replayed back into the active database if a business need justifies it.
Compatible with all supported IBM Maximo versions. Works on Oracle, SQL Server, and DB2 with no specific configuration.
Our IBM Maximo consultants handle the entire deployment. Your team is up and running within days, fully autonomous in managing the solution.
Analysis of data volume per table, identification of tables that are candidates for archiving, definition of priority archiving groups, and estimation of the expected performance gain.
Installation of the MX-Archiving application in Maximo, configuration of source / target tables, hierarchical groups, and archiving methods tailored to your business context.
Execution of a first archiving run in a staging environment, validation of the archived data, referential integrity checks, and measurement of the performance gains achieved.
Deployment to your production instance, scheduling of the SQL jobs, and knowledge transfer to your Maximo administrators so they can run the solution independently.
Figures observed at our utilities, industrial, and real estate clients — measured 3 months after going live.
Immediate reduction in the response time of data entry screens and reports. Your technicians get back to work without waiting — and productivity follows.
All historical data remains retained and traceable. In the event of a regulatory inspection, the complete history is available in a few clicks from Maximo.
A leaner database significantly reduces the time, risks, and costs of migrating to IBM Maximo Application Suite 9.
Our consultants analyze your Maximo instance free of charge and provide you with a concrete estimate of the volume and performance gains you can expect from MX-Archiving.