Complete-Connection Level Settings

The SET ISOLATION statement supports complete-connection level settings. This means that values in the local session environment at the time of connection are propagated to all new or resumed transactions. These can include the following types of transactions:
  • transactions within the local database,
  • distributed transactions across databases of the same server instance,
  • distributed transactions across databases of two or more database server instances,
  • global transactions with XA-compliant data sources that are registered in the local database.
If you change the isolation level within a transaction, the new value is propagated back to the local environment and also to all subsequent new or resumed transactions.