Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746

    Unanswered: How can I see the isolation level of a connection?

    The WebSphere people approached me with the request to check the isolation level of their connections.....

    I tried "list applications show detail"
    I tried db2pd -apinfo all
    I tried "snapshot for applications"
    I asked google..

    Now I try this forum because I cannot find it.

    (LUW9.5.5 on win2003)

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You can see the isolation level with db2pd -dynamic, but I believe that is on a SQL statement basis, not connection basis.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    In case you want to determine the isolation level within the current session/connection, you can query the CURRENT ISOLATION special register.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •