Blog

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

Let’s celebrate the 100th post!!!

MaximoDev has now reached 100 posts of useful tips, tutorials and small guides to help the Maximo technical community.After more than 2 years of MaximoDev activity, I have achieved an incredible success becoming the most followed and visited free and ads-free web site about IBM Maximo features, configuration, customization and development topics.To explain you the […]

What’s new in Maximo Asset Management 7.5.0.3

Maximo Asset Management version 7.5.0.3 incorporates several new features, such as the ability to link Maximo Asset Management applications to external applications and the option to configure high availability for your environment. 7.5.0.3 also introduces email interaction, which enables a user to change the status of an object or workflow assignment by email. In addition […]

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

Navigating object relationship in MBO code

This entry is part of the Maximo Java Development series. When you are in an Mbo class or you already have a reference to an Mbo object is it possible to retrieve the related records using Maximo object relationships as defined in the Database Configuration application.For example the ASSET object has a relationship called ACTIVEASSETMETER to the […]

What Mbo/MboSet/MboValueAdapter method should I override?

This entry is part of the Maximo Java Development series. One of the biggest issues when implementing Java customizations in the Maximo Business Objects layer is to know what is the best method to override to achieve a specific goal.Here I have listed the most common usages of the the main methods in Mbo, MboSet and […]

Scroll to top