Library Version 12.1.6.0

Enabling Transaction Snapshots in the SQL Layer
Prev | Chapter 11. Upgrading Berkeley DB 11.2.5.1 applications to Berkeley DB 11.2.5.2 | Next

## Enabling Transaction Snapshots in the SQL Layer

Read/write concurrency can now be enabled in the SQL API by using `PRAGMA multiversion=on` before accessing any tables in the database. After multiversion has been enabled, it can be temporarily disabled using the `PRAGMA transaction_snapshots=on/off`.

### New Pragmas

For more details on pragmas concerning Transaction Snapshots read Using Multiversion Concurrency Control in the Berkeley DB Getting Started with the SQL APIs guide.

- `PRAGMA multiversion=ON|OFF;`
- `PRAGMA snapshot_isolation=ON|OFF`

Prev | Up | Next
Heap Access Method | Home | 2SITE_STRICT Enabled by Default in Replication