performance

Attribute validation not triggered immediately

Have you ever experienced a delay when entering data on a field and validation is triggered after several seconds? The asyncronous data validation has been introduced in Maximo 7.5 to improve responsiveness of the user interface. However there are some situations where this is really annoying. For example, if you have developed your own scripts […]

Avoiding FetchResultStopLimit errors in Java or scripts

Today I had to face an issue deleting a large set of records from a Maximo table using an automation script. My script was something like this. mboSet = MXServer.getMXServer().getMboSet(“MYTABLE”, mbo.getUserInfo())mboSet.deleteAll()mboSet.save() Unfortunately the table I had to purge (MYTABLE in the example) was having more than 5000 rows so when I launched the script I […]

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 […]

Maximo performances and network latency

Maximo and other IBM service management products based on TPAE (like SmartCloud Control Desk) can be seen as sitting at the apex of a pyramid that consists of network, hardware, and software services. As you can see, network performance are the foundation of the pyramid.The simplest way of measuring network performances and speed is the […]

How to improve DocLinks performances in Maximo/TPAE applications

During a performance assessment of a production customer environment I have set the mxe.db.logSQLTimeLimit system property to 2000 to log all long-running SQL statements (see this TechNote for details). Looking at the system logs I have noticed many entries like this. select * from doclinks where (ownertable=’WORKORDER’ and ownerid=1065680) or (ownertable=’WORKORDER’ and ownerid in (select […]

Find large Maximo tables on DB2

I this article I have explained how to list the larger database tables and indexes on Oracle.On DB2 you can use the following one. SELECT name, card, npages, fpages, stats_timeFROM sysibm.systablesWHERE creator = ‘MAXIMO’ AND type=’T’ORDER BY card DESC; The returned columns are: NAME: Name of the table CARD: Number of rows NPAGES: Total number of pages […]

Find large Maximo tables and indexes on Oracle

When you have to assess the system performance of a Maximo server it may be useful to have a quickly see what are the larger database tables and indexes. This can quickly spot some performance issues in your system.Large tables generates heavy database I/O workloads when are nor accesses through an index. Large indexes are also inefficient. Creating indexes with too […]

Analyze and troubleshoot Maximo performances with Maximo Activity Dashboard (MAD)

Maximo Activity Dashboard (also known as MAD or PerfMon) is a useful tool to analyze and troubleshoot Maximo performances and is available starting from TPAE 7.1.1.6. This great tool tracks execution times for each browser request (user-click) including the time spent querying DB with a great detail about executed queries and time spent for each sub-step […]

MBO Performance Tip N.8 – If there is no other way… use JDBC

This entry is part of the Java MBO performance optimization golden rules series. Sometimes you have to perform some complex logic or you have to join several tables to retrieve a piece of data. In other cases there is a piece of code where performance is critical. In such cases it may be hard to […]

Scroll to top