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

Retrieve JDBC connection to Maximo database

In some cases you need a JDBC connection to directly access Maximo database in order to perform some job. This is not common since all Maximo data can be accessed through standard MboSets. However, you may need to access non-Maximo tables, perform specific SQL statements or bypass Mbos for performance reasons. The two main approaches […]

Maximo Data Types

Here is the complete list of available data types in TPAE/Maximo. The most used are marked in bold. ALN – Alphanumeric characters, mixed case AMOUNT – Decimal number, used for currency BLOB – Binary large object CLOB – Character large object CRYPTO – Encrypted binary CRYPTOX – Encrypted binary (one-way) DATE – Date only, no […]

Set an attribute as required with no default value

This post describes how to set an object attribute as mandatory without providing a default value. This is to circumvent what it seems to be a TPAE limitation that prevents to do this from the standard Database Configuration application.Lets make an example. The out-of-the-box attribute PO.VENDOR (Purchase Order – Vendor) is not mandatory. Unfortunately if […]

Maximo Performance Best Practices White Papers

IBM has just released updated versions of Maximo Performance Best Practices White Papers. This papers provide useful information to improve the performance of all Maximo/TPAE based products wether they are deployed in small, medium, or large scale customer environments.They can be downloaded from IBM developerWorks: Best Practices for System Performance 7.5.x Best Practices for System […]

Listing existing Maximo/TPAE customizations

During my job assignments it often happens that I’m sent to a customer that already has Maximo in production with some customizations in place. One of the problems in such cases is to quickly get an overall picture of how many customizations have been made and what have been customized.One approach that I have found […]

How to execute an Oracle stored procedure from Java code

This is a working Java method that can be used to execute an Oracle stored procedure. It can be linked to standard Mbo methods, application beans, actions, toolbar buttons, etc. public int callOracleProcedure(String procName, int arg1) throws MXException, RemoteException{ int ret;“Calling ” + procName + “(” + arg1 + “)”); MXServer mxServer = MXServer.getMXServer(); […]

Scroll to top