IBM Maximo consultant, geek, agile evangelist
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 […]
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 […]
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.
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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(); […]