Maximo is everywhere! It has been around for several decades and is in use by many different industries of all sizes. Client databases have grown in size and complexity over the years. Continued monitoring of database integrity is always recommended to make sure all your I’s are dotted and T’s are crossed. Just the other day I was talking to a client that was experiencing major slowness in performance while generating a handful of Work Orders from the Preventive Maintenance application. They were attempting to generate about 5 work... [More]
In a recent entry in the Process Automation blog, Barbara Ballard provides a set of tips for improving the performance of queries that start with " select * from doclinks. ". The information applies perfectly to #Maximo Asset Management. For details, see the original blog entry (http://ibm.co/qXlW1b).
So you and your team are ready to make the leap on to the next release of Maximo or SCCD but, there is that looming concern about what is going to happen when you flip the "ON" switch on your go-live date. Will it work? Will performance be acceptable? or will you have to find a safe house to hide from the angry mob of users that can not use the system? You are not alone. Those are the type of questions that keep every Project Manager and System Implementer up at night.
Through collaboration with some of our... [More]
When following the current Best Practices for Performance white paper, one of the Generic JVM arguments that is recommended is to set the -Xdisableexplicitgc parameter. Setting this parameter turns a System.gc() call into a no-op.
This parameter works well for the vast majority of our clients. However, there have been a few cases where JVM memory is fairly tight due to the specific workloads that the end users are generating. In some cases, requests for object memory grow faster than the Java virtual machines decides to... [More]
The other day, we encountered a problem during one of our performance tests. We observed from the database side that there is a steady increase of connections over time. Of course, we immediately suspected there is a newly introduced connection leak somewhere and started the hunt. The very first thing we did was to turn on the dbconnection logger to info level. We confirmed from the maximo logs that these connections indeed are recorded in the maximo connection pool as used connections and not released. The stacktrace did confirm that there... [More]
The database is central to the functionality of IBM Tivoli service management products. It stores all data that is collected and calculated by the applications. This database also stores metadata for configuring and maintaining the environment. Reporting also generates resource-intensive management reports. Because all functionality is based on database performance, the database can be a key focus for performance tuning. SQL query tuning and creating indexes against a database can help to obtain maximum performance from IBM Tivoli service... [More]
Note: Barb Ballard recently posted the following blog entry in the Process Automation Group. Since it equally applies to Asset Management, I thought I would post it here too. When debugging a problem or when looking to recycle a JVM, it is useful to
know which users are logged onto the system and what JVM they are working on.
If a JVM needs to be recycled, you could then notify the users on that JVM that they will
get an interruption in service. Or when debugging a problem it is useful to
know what a user was doing on a particular JVM... [More]
Maximo Activity Dashboard (PerfMon)
The Maximo Activity Dashboard commonly known as PerfMon is available as a UI Interface from Maximo version 7 onwards. It is normally used when debugging performance related problems in Maximo.
Here are some of the capabilities of PerfMon –
Provides information on Individual Request Processing Time on the server side including –
Overall response time
Average response time for similar kind of... [More]
In last week’s BiLog , we talked about report usage, and how
you can utilize a variety of mechanisms, including reports, KPIs or result sets
to monitor which reports your users are and are not using. Report usage information is also critical in identifying
your reports which take to longest time to execute, as you want to insure these
are optimized for report performance.
Why is this important?
Like so many things, reports follow the 80/20 rule, where 80% of your
report processing is done by only 20% of your reports. So as... [More]
Once in a while I'll get questions about performance problems. Specific scenarios can be resolved by applying Interim Fixes or adding indexes. Those critical and urgent problems often happen throughout the entire system.
Here is a collection of performance related recordings and technotes that might help:
SCCD 7.5.1 Performance Education Session
Correcting Slow User Queries
"Before you can race, you must qualify". As a fan of Motorsports (Formula 1 in particular) I hear this phrase on many weekends throughout the season. The phrase basically means that to have the highest chance of being successful in an endeavor you must prepare adequately. In this article I shall take this same idea and show you how to apply it to a successful Maximo installation.
If "qualifying" is preparing for a race then careful planning of your IBM Maximo Administrative Workstation is along the same lines. Many... [More]
I need to set limits when faced with these. Knows as Fluffernutters, smooth, decadent peanut butter and sticky marshmallow topping on plain white bread form the ultimate comfort sandwich. With a cold glass of milk, the number I can toss down is crazy high.
You may also need to stop your users from over-indulging by setting records limits when they create Ad Hoc or QBR (Query Based Reports.) The creation process of ad hoc reporting is where users select the fields, application query,... [More]
If you're looking for ways to optimize system performance, consider enabling data compression on the IBM HTTP server. You can use the Apache mod_deflate module to improve response time in
environments that have low bandwidth and high latency. The Apache
mod_deflate module compresses output from your server before the data is
sent to the client over the network.
Setting the compression level is to 3 provides minimal CPU usage and
a decent benefit from the compression. You can also set the compression
level to 6, which provides... [More]
Do you collect coins? In a gargantuan container that once held a supersize collection of cheese puffs? My mammoth 24 x 8 inch plastic container was so packed full of coins, it broke thru its bottom when I recently tried relocating it... Maybe relocating wasn’t the best plan for the coins….which is just one of the many collections I’ve shared with you this year. Others included post cards , National Park Stamps , photos , and BiLog entries! Yes! BiLogs are a collection of Maximo Business Intelligence Blogs detailing reporting... [More]
In a large scaled Maximo environment, some of us would use IBM DB2 pureScale database. As the more nodes you have, the more contentions there are on every kind of resources. Normally, Maximo is using Sequence object inside database to avoid the locking issues that are associated with other more heavier approaches In a standard database, Maximo usually cache some sequence values in memory to improve response time. While in a DB2 pureScale environment, if both CACHE and ORDER are specified, the specification of ORDER overrides the specification... [More]