IBM Maximo consultant, geek, agile evangelist
OmniEasyDataArchiving+ is a data archiving solution for Maximo delivered by OMNINECS. Supports any Maximo environment: Maximo 7.6 or MAS 8, DB2/Oracle/SqlServer database, on-premise and cloud deployments. Predefined archiving templates to start as fast as possible.
One of the first thing I always say to the new hires that are going to learn Maximo is how much important is to have a good knowledge of SQL language. It is really important to build application queries, Birt reports, database relationships, complex table domains, conditional expressions and many other Maximo configurations. The important […]
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 […]
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 […]
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 […]
You have probably noticed that once you have saved an object you are not allowed to change it’s ID. This is basically because each object stored on the database needs an immutable unique identifier that can be used to reference that object from other tables. Maximo prevents updating such identifiers to avoid loosing links between […]
In a previous post I have described how to correctly manage a child table in an application using the Application Designer. However, there are better ways of achieving the same goals so I will analyze all the available options to correctly link records in a parent-child relationship. If you are a creating custom objects and […]
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 […]
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 […]
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 […]