Explain Plan for JDBC Adapters

, ,
1

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

2

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