WebSphere Application Server & Liberty

WebSphere Application Server & Liberty

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  SQLID for transactions

    Posted 04/02/20 05:44 AM
    Dear all,
    Please can you let me know how to identify the SQLID for transactions in websphere logs?
    with trace log set to "all", I get log entries like this: 
    00000157 dynamic 2 JdbcData@942690a6 processSql Original SQL: SELECT PHONE_NUMBER_ID, CONTACT_ME

    Does 942690a6 represent a SQLID here? 

    ------------------------------
    ram v
    ------------------------------


  • 2.  RE: SQLID for transactions

    Posted 04/02/20 04:55 PM
    No, the 942690a6 represents the object id.   I am not familiar with this jdbc driver, but you likely would need to call a vendor specific api provided by the jdbc driver or database.

    Thanks,

    ------------------------------
    Jim Stephens
    ------------------------------



Related Content