7.38 Transactions Configuration Metrics

Lists the Transactions configuration metrics and provides a brief description of each.

Table 7.38 Transactions Configuration Metrics

Name	Description
Autocommit Enabled	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	Affects transactions that begin with START TRANSACTION or BEGIN and end with COMMIT or ROLLBACK. Sets whether the server starts a new transaction immediately after a COMMIT/ROLLBACK (by setting to CHAIN), or disconnect after completing a COMMIT/ROLLBACK (by setting to RELEASE), otherwise do not implicitly start a new transaction (by setting to NO_CHAIN, the default).
Isolation	The default transaction isolation level.
Read Only Enabled	The default transaction access mode. The value can be OFF (read/write, the default) or ON (read only).