Lists the Transactions configuration metrics and provides a brief description of each.
Table 5.33 Transactions Configuration Metrics
Name | Description |
---|---|
Autocommit Enabled (Total) | The autocommit mode. If set to 1, all changes to a table take effect immediately. If set to 0, you must use COMMIT to accept a transaction or ROLLBACK to cancel it. |
Completion Type (Total) | Affects transactions that begin with START TRANSACTION or BEGIN and end with COMMIT or ROLLBACK. Sets whether the server should start a newtransaction immediately after a COMMIT/ROLLBACK (by setting to CHAIN), or disconnect after completing a COMMIT/ROLLBACK (by setting to RELEASE), otherwisedo not implicity start a new transaction (by setting to NO_CHAIN, the default). |
Isolation (Total) | The default transaction isolation level. |
Read Only Enabled (Total) | The default transaction access mode. The value can be OFF (read/write, the default) or ON (read only). |