Here is a useful IBM Technote that explains how to capture all SQL statements issued from Maximo/TPAE when using DB2 database. I think it may be useful to analyze users queries and performance bottlenecks.
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 […]
Troubleshooting Birt report performances
Sometimes I had the hard task to debug performance issues of specific Maximo reports. The main thing to understand here is that 95% of the times the problem is related to a long execution time of the underlying SQL query .What I typically do is the following: Look at the ‘Performance’ tab of the Report […]
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; logger.info(“Calling ” + procName + “(” + arg1 + “)”); MXServer mxServer = MXServer.getMXServer(); […]