Maximo server crashes when fetching large number of records
Maximo7.5 server crashes with Out Of Memory exceptions when fetching a large number of records from SQL Server.
When fetching a large number of records ( eg: around a million ) , the Maximo server freezes and eventually crashes and one can see Out of Memory exceptions and SQL Server jdbc exceptions in the application server logs.
This has so far been reported from Maximo 7.5 environments using SQL Server only.
This is caused by the way the new SQL Server jdbc driver used in Maximo 7.5 handles the records fetched from the database.
Resolving the problem
There is an APAR created for this issue - APAR IV12954. Please contact IBM Support for a
Source : http://www-01.ibm.com/support/docview.wss?uid=swg21592711