Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Posts
    60

    Unanswered: db2 isolation level

    Hi all,

    this is for udb ver 8.1 on aix

    I have been reading some db2 documentation and its confusing on default isolation level. some documents say its CS and some says RR.
    If i do explains on some sipmple select I see it shows CS as isolation level.

    In our installation we are using ver 8.1 without changing isolation level anywhere. So i suppose its CS as per db2explain output.

    Client application is connecting this db2 server using websphere/JDBC without changing any isolation related parameters. I am not sure whats the default isolation level for websphere/JDBC installtions. Application is also not changing isolation level in any java codes.

    Does that mean we are using default isolation level of database.

    Can someone confirm whats the default isolation level for udb ver 8.1 and what isolation level are we using in out set up?

    Why is db2 documentation so confusing?

    Thanks,
    j

  2. #2
    Join Date
    Jan 2005
    Location
    Rio de Janeiro - Brazil
    Posts
    28

    Cursor Stability

    JFKUSER

    Please, correct me if Im wrong.

    But from everything Ive read and saw the default Isolation Level for DB2 is CS.

  3. #3
    Join Date
    Mar 2003
    Posts
    60
    hi fohana,

    thanks for the quick reply. I also think default is CS. but i am confused with some of db2 documentation. for example :
    http://publib.boulder.ibm.com/infoce...e/r0001941.htm

    Also see my today's other thread where Sathya and Marcus specified conflicting default isolation levels. Both are highly respected members on this forum.

    thanks,
    j

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I was probably incorrect when I said awhile back that the default is RR. I believe that at one time it was the default (I have been using DB2 LUW since 1989 when it was called OS/2 Database Manager). But I think that CS is the default now. But it is confusing, espcially with the link you provided regarding the default = RR for AUTOCONFIGURE.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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