Blog

How to create Maximo demo database (MAXDEMO)

The Maximo contains an extremely useful command to create a demo database filled with a sample data. This can be really helpful when learning haw Maximo works. Tho create the demo database perform these steps. Stop the application server (MXServer) Open a command prompt Move to:[SMP_DIR]\maximo\tools\maximo Issue the following command:maxinst -s[INDEXTABLESPACE] -t[DATATABLESPACE] By default both […]

Custom condition Java class

Sometimes standard Conditional Expressions are not enough. Sometimes the logic to implement is too complex to be implemented using an SQL expression. In such cases Maximo allows to implement the condition logic in a custom condition class using Java. To implement a condition class you must extend psdi.common.condition.CustomCondition and override evaluateCondition and toWhereClause methods. Here is a […]

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

Scroll to top