Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Unanswered: Isolation Levels

    Hi,

    How do I see the Isolation Level for a db2 database ? I am running DB2 ESE 8 fix pack 3 on Win2k platform.

    I know you can change the same using the db2 change isloation command.

    Regards

    Nitin.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Isolation Levels

    Have a look at the discussion at
    http://www.dbforums.com/showthread.p...ange+isolation

    HTH

    Sathyaram

    Originally posted by nitingm
    Hi,

    How do I see the Isolation Level for a db2 database ? I am running DB2 ESE 8 fix pack 3 on Win2k platform.

    I know you can change the same using the db2 change isloation command.

    Regards

    Nitin.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    With Static SQL (programs with embedded SQL that get pre-compiled, compiled and the bound), the isolation level is an option on the pre-compile and bind commands.

    For Dynamic SQL, there is a default isolation level set for the database by the Create Database command. It can be changed with the AUTOCONFIGURE command (either during or after database creation). The default is RR unless it has been changed. Not sure how to see what it is (maybe a registry value). This affects ODBC and CLI interfaces to DB2.

    For a particular dynamic interface process into DB2, the isolation level can be changed dynamically with the CHANGE ISOLATION LEVEL command. This does not affect other process, but will apply to every connection made from the same command line processor back-end process.

    For JDBC and SQLJ the CLI interface default is used, but can be changed with the setTransactionIsolation method in the java.sql interface connection. In SQLJ, you run the db2profc SQLJ optimizer to create a package. The options that you can specify for this package include its isolation level.

    You can also override the isolation level with an SQL statement (at least certain statements) using the WITH clause (WITH UR, for example). This is valid on SELECT, SELECT INTO, Searched DELETE, INSERT, Searched UPDATE, and DECLARE CURSOR, SQL statements.

Posting Permissions

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