Enable SQL debug with IBM Smart Cloud Control Desk

Two methods to check the SQL statements executed. You can use both for troubleshooting purposes.

1) ref: http://www-01.ibm.com/support/docview.wss?uid=swg21291250

Set Logger to DEBUG value to logs the SQL statements:
property name: log4j.logger.maximo.sql                value: DEBUG

Set system property to decrease time limit to logs more statements:
property name: mxe.db.LogSQLTimeLimit

To check the SQL logged open the SystemOut.log on the Websphere profile.


2) ref: http://www-01.ibm.com/support/docview.wss?uid=swg21577811

 Enable Maximo Activity Dashboard:
property name: mxe.webclient.activitydashboard

Description: Maximo Activity Dashboard (PerfMon)
Global Value: true
Maximo Default: false
Online Changes Allowed?: CHECKED
Live Refresh?: CHECKED

To check the SQL executed open:
http://<host>:<port>/maximo/webclient/utility/profiler/PerfMon.jsp