Maximo Open Forum

 View Only

Related Content

  • 1.  I need to do a purge on Maximo 7.6.1.2 with database Oracle 19c

    Posted 6 days ago

    Hello everybody!, as topic says I need to do a purge on Maximo data which use Oracle database 19c for better permonance, at least I need to delete data from 2012 to 2016, Does someone face this issue? How was resolved it?.

    I'll appreciate any suggestion/idea/help.

    Thanks for reading.


    #EverythingMaximo

    ------------------------------
    Pablo Condoleo
    Coop Tecso LTDA
    ------------------------------


  • 2.  RE: I need to do a purge on Maximo 7.6.1.2 with database Oracle 19c

    Posted 5 days ago

    I don't work for them but there are companies like Maxis (Archiving made easy… Just let Alchemize do it!) that specialize in archiving Maximo data. Most customers want to still be able to access & report on the historical data and their solution helps provide that capability while removing it from the main transactional database to improve performance. Even if you intend to delete without archiving, this could still be helpful because they have built processes to help ensure dependent tables are removed as well. And can help if you need different rules around the deletes such as keeping certain work orders longer depending on criticality. 



    ------------------------------
    Steven Shull
    Naviam
    ------------------------------

    Original Message


  • 3.  RE: I need to do a purge on Maximo 7.6.1.2 with database Oracle 19c

    Posted 5 days ago

    As Steven mentioned there are add-ons available for various business partners that allow to archive or purge data. I've used Omninecs easy data archiving  software that runs directly in Maximo https://www.omninecs.com/en/eda/



    ------------------------------
    Michael Marsonet
    MRM-EAM Consulting Inc.
    ------------------------------

    Original Message


  • 4.  RE: I need to do a purge on Maximo 7.6.1.2 with database Oracle 19c

    Posted 4 days ago

    Deleting old records can certainly improve performance - it is well worth reviewing any BMXAA6720W slow SQL warnings (http://www.linkedin.com/pulse/individual-bmxaa6720w-slow-sql-entries-maximo-logs-need-mark-robbins)

    I have investigated lots of performance problems and the slow SQL is important.

    Archiving/deleting data can help.

    This blog article discusses things to consider when archiving/deleting data:

    https://www.linkedin.com/pulse/thoughts-archiving-solutions-mark-robbins-opgke

    If you are writing your own queries to delete records then it is critical to ensure that the related records are deleted e.g. when deleting workorder records then it is important to delete the associated wostatus records..

    Cohesive have implemented archiving for customers.

    Cohesive offer consultancy to investigate performance problems.



    ------------------------------
    mark robbins
    Cohesive
    IBM Champion 2017-2024 Inclusive
    See my blog on Maximo support related topics here:
    https://www.linkedin.com/pulse/maximo-support-advice-from-non-ibm-engineer-article-mark-robbins/
    ------------------------------

    Original Message