Tuesday, February 19, 2013

Enable SQL Logging for MDM Server Transaction

When ever somethings behave unexpectedly on the MDM side especially when the performance of a trasnaction is bad, we often start thinking about grabbing the sql of a transaction.

There are mutiple ways to do so ,but the easiest one for developers seems to be enabling the Websphere trace logging.


How to do that?

In the Admin console :
Logging and Tracing > server1 > Diagnostic trace service > Change log detail levels

Under Runtime :
*=info: RRA=all: EJBContainer=all: com.ibm.ws.database.*=all: com.ibm.ws.db2.*=all

The above setting will make the JDBC adapter which connects your WAS to the DB2 or any database to log the sqls.

This is totally a WAS config and has nothign to do with MDM.

Please execute one of the MDM transactions.

Look for the trace.log file
It will be located in the log folder of your profile

Eg:C:\IBM\SDP\runtimes\base_v7\profiles\AppSrv01\logs\server1

Open the file and search for "prepareStatement Entry "

Hope this helps!


3 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. Definitely Nikkie, this would really help all the MDM'ers who can debug the OOTB sql.

    Keep sharing knowledge,
    Roshni

    ReplyDelete
  3. I can see that you are are genuinely passionate about this! great information.
    thank you...!


    http://www.sqlservermasters.com/

    ReplyDelete