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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only

  • 1.  Explain Plan for JDBC Adapters

    Posted 07/21/10 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 08/26/10 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