IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

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.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

Explain Plan for JDBC Adapters

  • 1.  Explain Plan for JDBC Adapters

    Posted Wed July 21, 2010 04:01 PM

    We need to review our database access schemes. All our SQL is in JDBC Adapters. Does anyone know how I can extract the SQL (not custom) so I can stuff it into an Oracle Explain Plan?

    Alternately is there a way to run Explain Plan against individual jdbc adapter services? Or is there some easier way to get to this information?

    Ideas greatly appreciated


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 2.  RE: Explain Plan for JDBC Adapters

    Posted Thu August 26, 2010 10:26 PM

    Hello
    The way we do it is that we mimic the adapter service onto a plain text and run DB2 explain on it
    Apart from that i don’t think we can run the explain directly on webMethods adapter service level

    thanks
    Anil


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


Related Content