The importance of ‘sameas’ in Database Configuration

An often misused feature of Maximo Database Configuration is the ‘Same as Object’ and ‘Same as Attribute’ fields when defining custom database attributes. To understand how this works lets consider the ASSET.LOCATION attribute. As you can see from the screenshot below, the LOCATION column of the ASSET table is defined ‘same as’ LOCATIONS.LOCATION’ field. The […]

Ensure Asset’s serial number uniqueness

Sometimes you need to ensure the uniqueness of a certain database column in the Maximo database. A common example of this scenario is to ensure that asset’s serial numbers are not duplicated. This can prevent the creation of duplicate assets. In this post I describe two techniques to achieve this using a unique database index […]

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

Find all custom triggers on Maximo tables

Before Maximo 6 it was a common practice to implement customizations using database triggers. Although Conditional Expressions, SigOptions, Java coding and scripting are now available in Maximo 7, I still see many Maximo environments with a lot of database triggers.In a recent project I have found a Maximo system with more than 30 triggers and […]

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

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

How to set the default value of a field in Maximo

There are five ways to set the default value of a field in Maximo. Database Configuration The first way is to set the default value at the database level using Database Configuration.All you have to do is the object and then the attribute for which the default is to be set. In the right hand side of the […]

Scroll to top