How to determine the isolation level of incoming queries.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Patrick Finnegan - 16 Oct 2008 13:40 GMT

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.

Reply to this Message

jefftyzzer - 16 Oct 2008 21:56 GMT

On Oct 16, 5:40 am, Patrick Finnegan <finnegan.patr...@gmail.com>
wrote:

> 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.

Patrick:

Off-hand, one place I can think of the isolation-level being visible
is in the SQL explains generated by db2exfmt.

You'd likely have to execute db2set DB2_SQLROUTINE_PREPOPTS="EXPLAIN
ALL EXPLSNAP ALL" first.

HTH,

--Jeff

Reply to this Message

Mark A - 16 Oct 2008 22:17 GMT

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.

Reply to this Message

Patrick Finnegan - 21 Oct 2008 19:48 GMT

> > 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
[quoted text clipped - 5 lines]
> 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.

Reply to this Message