Troubleshoot Maximo BIRT Report Performance

Recently have was tasked to troubleshoot a custom BIRT report performance issue for a client for Maximo 7.1  The problem was that the report, which normally ran fine, was now taking over 30 minutes to run and eventually never ran at all, which then … Read More

Advanced Date SQL Queries in Maximo

Date queries in general can be difficult to handle in SQL.  Not only do you have to think about the syntax for both SQL Server and Oracle but to do "simple" queries like "get all approved work orders this week" isn't that easy.  Hopefully these will … Read More

Delete a custom Maximo application

This tip on  how to delete a Maximo application from Bruno is a a lifesaver and perfect timing because I was wondering how to this exact thing the other day. … Read More

Maximo SQL Injection

This is an interesting property that applies to Maximo 7.1 This is when users manipulate data entry fields to execute malicious SQL statements. Maximo dynamically prepares SQL statements so in almost every attribute this is not an issue. There are a … Read More

Create MAXDEMO database for Maximo 7

Here are the steps to create a MAXDEMO database: The automated installation selected from the Launchpad defaults to creating an 'empty' maximo database. There are 2 ways to create a maxdemo database during the installation of Maximo 7. 1. … Read More

Best practices for Maximo performance

Here are some links to help with tuning your Maximo application. Search Methodologies (best practices for minimizing dat WebSphere Tuning (These parameters can cause Maximo to Browser Caching (Helps with Wide Area Network -WAN- per GZip for … Read More

Improve Maximo performance with SQL Server and Page Locking

Turning off Page Locking in SQL Server will improve performance and prevent slow transactions or hanging.  This applies to Maximo 6 and 7.  Since Page Locking is already turned on unless it has been modified by the Configure utility.  Therefore it is … Read More