Results 1 to 5 of 5

Thread: isolation level

  1. #1
    Join Date
    Jan 2003
    Posts
    35

    Unanswered: isolation level

    Is there any way to find the current isolation level of any database. I can change the current isolation level to any level by using cjhange isolation command. But how can I find the currenet isolation level?

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    No

    Hi,

    Unfortunately there is no way as of now by which we can know the current isolation level in DB2.

    There has been a lot of discussion on this thread and I would advise you to search the archives for a lot of information on the same, especially posts from other members on this topic are really great.

    Please also make it a habit for posting your database level, i mean version and fixpack and the Operating System with everypost. That will make it easier for everyone to get a better hang of your scenario.
    HTH

    Nitin

    Ask the experienced rather than the learned

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I previously posted a list of various different ways that isolation level can be set in DB2. This was posted several months ago (or longer). Unfortuenately, I have heard that the search engine is not working very well since the last upgrade, but don't know if that is true.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Jan 2003
    Posts
    35
    database is db2 ubd eee v 7.2 and os is aix version 5.0.1

  5. #5
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by manish21
    Is there any way to find the current isolation level of any database. I can change the current isolation level to any level by using cjhange isolation command. But how can I find the currenet isolation level?
    If this is JDBC, con.getTransactionIsolation() will do it.
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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