How to determine the isolation level of incoming queries.

"Patrick Finnegan" <finnegan.patrick RemoveThis @gmail.com> wrote in message
news:0338298b-6cbe-4da3-899c-a2b66aec109f@j22g2000hsf.googlegroups.com...
>
> Is there any way of tracking the isolation level of incoming queries
> from the server; not the client? The client app is a third party
> black box application. Can't find anything in the snapshots or
> activity monitor.

You can see that using db2pd. I forgot which option it is, but it shows up
when looking at the packages. As I recall the are two sections in the report
and if you look close enough you can relate the part which shows the
isolation level back to the list of dynamic SQL statements.
 >> Stay informed about: How to determine the isolation level of incoming queries. 

On Oct 16, 10:17 pm, "Mark A" <some....TakeThisOut@someone.com> wrote:
> "Patrick Finnegan" <finnegan.patr....TakeThisOut@gmail.com> wrote in message
>
> news:0338298b-6cbe-4da3-899c-a2b66aec109f@j22g2000hsf.googlegroups.com...
>
>
>
> > Is there any way of tracking the isolation level of incoming queries
> > from the server;  not the client?  The client app is a third party
> > black box application.  Can't find anything in the snapshots or
> > activity monitor.
>
> You can see that using db2pd. I forgot which option it is, but it shows up
> when looking at the packages. As I recall the are two sections in the report
> and if you look close enough you can relate the part which shows the
> isolation level back to the list of dynamic SQL statements.

Thanks. Will chase that up.
 >> Stay informed about: How to determine the isolation level of incoming queries.