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.
How to log all Maximo SQL statements
IBM Maximo consultant, geek, agile evangelist
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.