How to determine the isolation level of incoming queries.

[Patrick Finnegan]

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.

[jefftyzzer]

On Oct 16, 5:40*am, Patrick Finnegan <[e-mail]>
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

[Mark A]

"Patrick Finnegan" <fi**************@gmail.comwrote in message
news:03**********************************@j22g2000 hsf.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.

[Patrick Finnegan]

On Oct 16, 10:17*pm, "Mark A" <[e-mail]:

"Patrick Finnegan" <[e-mail] in message

news:03**********************************@j22g2000 hsf.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.