IBM Support

My collection of Maximo 7.5 Performance Technotes

Technical Blog Post


Abstract

My collection of Maximo 7.5 Performance Technotes

Body

Once in a while I'll get questions about performance problems.  Specific scenarios can be resolved by applying Interim Fixes or adding indexes.  Those critical and urgent problems often happen throughout the entire system.

 

Here is a collection of performance related recordings and technotes that might help:

Install Performance Monitor

https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20Maximo%20Asset%20Management/page/Interactive%20Performance%20Analysis%20with%20Maximo%20Activity%20Dashboard%20%28MAD%29

Clustering with Maximo and WebSphere 8.5.5

Three part series with step by step instructions and screen shots

https://www.ibm.com/developerworks/community/blogs/a9ba1efe-b731-4317-9724-a181d6155e3a/entry/clustering_with_maximo_part_1_configuring_websphere_8_5_5?lang=en

SCCD 7.5.1 Performance Education Session

http://www-01.ibm.com/support/docview.wss?rs=0&uid=swg27038763

Correcting Slow User Queries

http://www-01.ibm.com/support/docview.wss?uid=swg27038272

/support/pages/node/243867

 

Maximo Performance Best Practices

/support/pages/node/611023

 

Best Practices for System Performanc​e 7.5

https://www.ibm.com/developerworks/mydeveloperworks/groups/service/html/communityview?communityUuid=a9ba1efe-b731-4317-9724-a181d6155e3a#fullpageWidgetId=W5f281fe58c09_49c7_9fa4_e094f86b7e98&file=c51d5f5b-dea3-4043-a81f-d5213fc10063

 

JVM Separation Process

/support/pages/node/462849

 

Out Of Memory errors on the systemout.log

 /support/pages/node/159105

 

Out of Memory blog

/support/pages/node/1129473

 

Database Connection leak

/support/pages/node/216327

 

Using System Instance Properties to Control Cron Tasks

/support/pages/node/195511

 

Parameters to improve Maximo performance using WebSphere

/support/pages/node/348001

 

Stopping Data from Auto-populating List Tab

/support/pages/node/219073

 

Configuring Autofill Properties

 

WebSphere 7.0 fixpack 27 or higher with Java SDK 1.6.0 SR12 Cumulative Fix

/support/pages/node/197777

 

Understanding Memory Requirements For 32 And 64 Bit Systems

/support/pages/node/127685

 

Understanding Search Methodologies

http://www-01.ibm.com/support/docview.wss?uid=swg21321289&lnk=uctug_tivoli_nwsltr_MAM

 

More performance technotes:

http://www-947.ibm.com/support/entry/portal/search_results/tivoli/maximo_asset_management?sn=spe&sortby=-dcdate&filter=&ibmprd=SCCDLP&q=tpaeperformance&productContext=-2077426143#q%3Dtpaeperformance%26sortby%3D-dcdate%26filter%3Dlanguage%3Aen

 

 SQL SPECIFIC Technotes:

Maximo Performance on SQL Server - Turning off Page Locking

/support/pages/node/350661

 

Maximo 7.5 on SQL Server out of memory and performance problems

/support/pages/node/473579
 

 

ORACLE SPECIFIC TUNING:

create indexes and use the recommended settings for Oracle 10g and 11g below:
 

  • cursor_sharing - We highly recommend that this be set to FORCE for optimal performance in Maximo. Currently, the value is set to EXACT
  • processes - make sure this value is high enough to handle all of the concurrent connections expected to the database. We generally recommend 4000
  • sessions - we generally recommend keeping this the same as processes, e.g. 4000
  • transactions - we recommend this be set to 2425
  • session_cached_cursors - the recommended value is 400
  • session_max_open_files - the recommended value is 300
  • nls_length_semantics - if you use Unicode or double-byte, then you would want to set this value to CHAR

[{"Business Unit":{"code":"BU005","label":"IoT"}, "Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11131963