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.
8 thoughts on “Is your Maximo database in good health?”
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.
Please send me a direct message via LinkedIn. We should be able to help with data archiving.
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?
Nevermind. Found the installation guide.
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!
Hi Sir, Thank you for sharing this information. Very informative. I am just wondering in doing health checks, are there activities you can suggest that can be executed by functional consultant ? I see that based bulk of activities are for technical .
The report runs for me in some environment, and in some environment it just says processing and never gives output.
I am trying to preview from report adminstration
For data archiving I suggest Eda+: https://www.omninecs.com/omnieasydataarchiving/