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 few exceptions so there is a property mxe.db.sqlinjection can be enabled to further limit [...]
Create MAXDEMO database for Maximo 7
November 1, 2009 By Leave a Comment
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. Launch the installation executable passing parameters. a. From a command prompt and change to the location [...]
Best practices for Maximo performance
August 9, 2009 By 1 Comment
Here are some links to help with tuning your Maximo application. These range from database configuration to websphere.
Optimize SQL Server 2005 with Maximo 6.1 or above
July 30, 2009 By Leave a Comment
To help improve performance on SQL Server 2005 with Maximo 6.1 or above use this settings in the maximo.properties file.
Improve Maximo performance with SQL Server and Page Locking
July 8, 2009 By Leave a Comment
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 suggested that you turn it off. Open SQL Server Query Analyzer and run [...]
How to fix “Assert statement failed” error in Actuate reports for Maximo 6
March 8, 2009 By 12 Comments
If you have developed or deployed Actuate 8 reports for Maximo 6, you have undoubtedly encountered this error many times. The problem is usually due to the fact that there is a connection problem to the database and it is the user account name that is causing this error. So when you try to run [...]
