Starting a transaction with SNAPSHOT TABLE STABILITY isolation level

Go Up to Isolation Level

To start a SNAPSHOT TABLE STABILITY transaction, the isolation level must be specified. For example, the following statement starts a named transaction, t1, for READ WRITE access and sets isolation level to SNAPSHOT TABLE ­STABILITY:

EXEC SQL
SET TRANSACTION NAME t1 READ WRITE SNAPSHOT TABLE STABILITY;

Isolation level always follows the optional access mode and lock resolution parameters, if they are present.

Important: Use SNAPSHOT TABLE STABILITY with care. In an environment where multiple transactions share database access, SNAPSHOT TABLE STABILITY greatly increases the likelihood of lock conflicts.