How to determine the isolation level of incoming queries.

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Patrick Finnegan
    #1

    How to determine the isolation level of incoming queries.


    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.
    Tags: None
    • jefftyzzer
      #2
      Re: How to determine the isolation level of incoming queries.

      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="EXPLA IN
      ALL EXPLSNAP ALL" first.

      HTH,

      --Jeff

        Comment

        • Mark A
          #3
          Re: How to determine the isolation level of incoming queries.

          "Patrick Finnegan" <finnegan.patri ck@gmail.comwro te in message
          news:0338298b-6cbe-4da3-899c-a2b66aec109f@j2 2g2000hsf.googl egroups.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.


            Comment

            • Patrick Finnegan
              #4
              Re: How to determine the isolation level of incoming queries.

              On Oct 16, 10:17 pm, "Mark A" <some...@someon e.comwrote:
              "Patrick Finnegan" <finnegan.patr. ..@gmail.comwro te in message
              >
              news:0338298b-6cbe-4da3-899c-a2b66aec109f@j2 2g2000hsf.googl egroups.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.

                Comment

                Previous template Next
                Working...