I imported over 200000 (closed) tickets in Maximo.
Now Maximo is really slow.
CPU and memory usage are still very well not over 30%.
Default query for ticket app is to show only open but still working with application is to slow.
Do someone have experience working with large number of tickets in the system and slow performance?
What to do to make it faster?
I will really appreciate some help.
Pinned topic MAXIMO too slow after importing large number of tickets
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-10-03T16:42:26Z at 2012-10-03T16:42:26Z by SystemAdmin
gulfsoft 1000008G2Y72 Posts
Re: MAXIMO too slow after importing large number of tickets2012-09-27T08:23:44ZThis is the accepted answer. This is the accepted answer.Google "Maximo database tuning" to get links on tuning your database, depending on which DB and version you're using.
We can make Tivoli software work for you!www.gulfsoft.com
bportaluri 120000GS1X67 Posts
Re: MAXIMO too slow after importing large number of tickets2012-09-27T15:37:18ZThis is the accepted answer. This is the accepted answer.Lots of useful information in the Maximo IBM Wiki.
200000 (closed) tickets are not too many. I have seen few millions of work orders in Maximo environments working quite well.
If CPU consumption on the app server is not high the problem should be in the DB.
Keep in mind that you have to monitor each CPU core separately. Java cannot split the CPU workload across multiple cores for each user request. If you have a 4-core CPU and there is only one user connected you will never see CPU consumption higher than 25% (apart from background cron tasks and escalations).
VeljkoC 270003YA7D82 Posts
Re: MAXIMO too slow after importing large number of tickets2012-09-28T09:26:32ZThis is the accepted answer. This is the accepted answer.
- bportaluri 120000GS1X
I only found this.
I set them on ON.
Also I found this but my parameters are similar set as in link.
So do you please know some concrete more tuning stuff which I can do on database?
You are probably right it is problem with database because in DBVisualizer every time I want to connect to database it takes up to long 10 seconds (while in some other environments it takes only 1 second)
Thank you very much
swkim90049 270004FKBD437 Posts
Re: MAXIMO too slow after importing large number of tickets2012-10-01T23:08:55ZThis is the accepted answer. This is the accepted answer.Look at http://www-01.ibm.com/support/docview.wss?uid=swg21291250
When you review your maximo.log, you can possibly see which queries are taking a long time.
I'm not familiar with DB2, but you may want to review the query and if it is utilizing the current indexes optimally. If you have customer queries, you may see benefit from creating a new index... although when you update records, all indexes have to be touched during the update which is a performance lag.
SystemAdmin 110000D4XK5842 Posts
Re: MAXIMO too slow after importing large number of tickets2012-10-03T16:42:26ZThis is the accepted answer. This is the accepted answer.You might also want to check out the best practices for performance white papers that are available for download. They have information related to tuning the database as well as maintaining it for best performance.
The version for Maximo 7.1.1.x releases is located at:
And the version for Maximo 7.5.x releases is located at: