July 19, 2012

How to log all Maximo SQL statements

Here is a useful IBM Technote that explains how to capture all SQL statements issued from Maximo/TPAE when using DB2 database.
I think it may be useful to analyze users queries and performance bottlenecks.

1 comment:

  1. Often it's not allowed to execute commands on DB2 server. In that case another approach to trace DB2 statements is to modify jdbc url used by Maximo (see "mxe.db.url" parameter in maximo.properties). This Technote describes how enable trace for a DriverManager connection: http://www-01.ibm.com/support/docview.wss?uid=swg21196160.