June 2, 2017

Is your Maximo database in good health?

We all know Maximo is a complex product. It has plenty of features and is very flexible but sometimes complex to manage especially when system performances are poor.
A lot of things may affect the perceived performances of Maximo and it may be hard to have an overview of the entire system configuration.

What are the largest tables in the database that may need archiving?
Are database statistics updated to optimize database queries?
How much data is stored for each site?
Has the workload of system increased over the last years?
What are the most heavy reports users execute?
What are the most resources-consuming crontasks and escalations?
How is the reports/crontasks/escalations workload spread across the day?

These and many other questions have an answer in the Maximo Health Check report.
Maximo Health Check report is a utility for IBM Maximo and IBM Control Desk that can help identify and analyze issues, errors, or incorrect configurations that can lead to unsatisfying system performances.

Adding more JVMs to your application server cluster seldom solves Maximo performance issues. In our experience, the most effective performance improvement techniques are on the database side.
For large Maximo systems data archiving may be needed. This is because, after several years of usage, large volume of data accumulated into some tables slowing down database inserts and updates. Moving unnecessary data out of those  tables can greatly improve overall system performances.
When specific application queries, reports or escalations have unsatisfying execution times database indexes optimization could be the answer. Adding the right indexes and removing the wrong ones is a complex activity that requires deep skills but can produce outstanding results in many cases.
Sometimes index optimization is not enough to fix a badly written SQL query. In this case SQL queries optimization is the right technique. SQL queries are everywhere in Maximo: start center portlets, application queries, escalations and reports. By simply refactoring those SQL statements I have obtained impressive results in many cases.
Database tuning is the last chance. Assuming IBM suggested settings have been applied, this is 'brute force' approach can bring some incremental improvement to overall performances.


Download and run the Maximo Health Check report and you may find interesting information about your Maximo system.


9 comments:

  1. Hello, nice to hear from you again Bruno. Our biggest issue at the organization is managers and supervisors wanting access to work orders related to asset history. I've suggested perhaps archiving work orders with only locations and no assets. Its been difficult because some still want a way to access the old data (even though I think this rarely happens if ever). Oracle has a partitioning feature but they want more money for this part of the license.

    ReplyDelete
    Replies
    1. Please send me a direct message via LinkedIn. We should be able to help with data archiving.

      Delete
  2. Hi Bruno,

    Great work as we already know from you. Just one question. I ran the report in eclipse, but it seems like the last pages did not complete. According to the first page I should generate as pdf. Does this mean I have to import it into Maximo itself?

    ReplyDelete
    Replies
    1. Nevermind. Found the installation guide.

      Delete
  3. Hi Bruno,
    Indeed - it's a great work and report looks really interesting. Chapeau bas!
    I have one question about one very interesting part of report - Data Volume. In my case when I've generated report - this part is completely empty, showing only table headers - there is no content (other sections above and below are ok). Is it something with privileges and access to sysdata, which should be configured? Are you aware of this?

    Thanks in advance!

    ReplyDelete
  4. I wanted to say that I have loved this blog.Very informative post with lots of information included in
    the posting.You have made some really good points here ! Please find our link ,if you may be interested
    in ,please refer to
    Orthopedic Mailing list & Email list

    ReplyDelete
  5. Hi,
    This is a nice website. I am very happy to visit your website.I will try to tell everybody to visit your website.Thanks

    rockymountain

    ReplyDelete