Default Isolation Levels

The default isolation level for a particular database is established when you create the database according to database type. The following list describes the default isolation level for each database type.

Isolation Level

Database Type

Dirty Read

Default level in a database without logging

Committed Read

Default level in a logged database that is not ANSI compliant

Repeatable Read

Default level in an ANSI-compliant database

The default level remains in effect until you issue a SET ISOLATION statement. After a SET ISOLATION statement executes, the new isolation level remains in effect until one of the following events occurs:

• You enter another SET ISOLATION statement.
• You open another database that has a default isolation level different from the level that your last SET ISOLATION statement specified.
• The program ends.