Optimize SQL Server 2005 with Maximo 6.1 or above

To help improve performance on SQL Server 2005 with Maximo 6.1 or above use this settings in the maximo.properties file:

mxe.db.disableservercursor=Y
mxe.db.resultsettype=TYPE_FAST_FORWARD
mxe.db.fetchsizeuse=Y
mxe.db.fetchsize=40
mxe.db.optionuse = Y
mxe.db.optionnum=1000
mxe.db.sqlserverPrefetchRows=200

For more details, visit IBM Support.