Troubleshooting
Problem
Login is slow and sometime it fails in IBM Manage application
Symptom
Application takes a few minutes to load
Cause
The problem appears when there are many records in the login tracking application. (order of millions)
Resolving The Problem
The problem appears when there are many records in the login tracking application. (order of millions)
1) Check how many records are in the logintracking table
Query to use:
select count(*) from maximo.logintracking;
If result is in order of millions proceed to 2)
2) Update the database statistics on maximo.logintracking table. If the statistics are not up to date, it has significant impact on the performance, especially to confirm the statistics on logintracking table. For example, you can run the following on DB2 server to make the statistics on logintracking table up to date:
db2 connect to (replace the correct DB name)
db2 "REORG TABLE MAXIMO.LOGINTRACKING ALLOW READ ACCESS"
db2 "RUNSTATS ON TABLE MAXIMO.LOGINTRACKING with distribution AND DETAILED INDEXES ALL ALLOW WRITE ACCESS"
If issue still present, you can try to truncate the table:
IMPORTANT Notes:
1) Back-up the logintracking table before running the truncate query.
2) As a second option, if you do not want to proceed with the truncate query you can use the DELETE query to delete only a specific number of rows from the table based on your selective criteria.
Query:
truncate table maximo.logintracking immediate;
Note: Same procedure can be applied for Oracle an Microsoft SQL databases.
If issue persists, open a case with support team.
Related Information
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"ARM Category":[{"code":"a8m3p000000F80hAAC","label":"Maximo Application Suite->MAS Applications->Administration"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
16 June 2022
UID
ibm16569493