Setting the Transaction Isolation Level

The syntax of Configure System to set the "Transaction Isolation Level" is

ConfigureSystem /TIL /S <SystemName> [/TO <IsolationLevelValue>] [/TR <IsolationLevelValue>][/ISP <IspecName>] [/ISV <IsolationLevelValue>] [/RPT <ReportName>] [/RPV <IsolationLevelValue>][/ ]

If you pass valid parameters to set the "Transaction Isolation Level", the message "Successfully updated the configuration" appears. The DBConfig.xml file available at the Data\Public folder is automatically updated with the values set in the arguments.

Note: If you are configuring AB Suite runtime with the Transaction Isolation Level settings for the first time, the DBConfig.xml file with the configuration is created in the Data\Public folder location.

Following are the five Transaction Isolation Level settings:

Read Uncommitted: In this setting, the SQL Server does not place any lock on the table and the table can be updated by any transactions while the Determine loop is in progress.
Read Committed: In this setting, the SQL Server places a lock on the entire table and the table remains locked until the Determine loop has exited.
Repeatable Read: In this setting, the SQL Server reads and commits a row of a table in a transaction, only if the row is not updated by another transaction.
Serializable: In this setting, the SQL Server ensures that all the rows are read while parsing the operations in a transaction. The SQL Server places a lock on the range of rows that is affected by a transaction.
Snapshot: In this setting, the Determine loop displays consistent data from a table that existed at the start of the transaction and returns an error if a table is updated by any transactions while the Determine loop is in progress.

Note: The default Transaction Isolation Level is "Read Committed".

Parameters

Argument	Description
/TIL	Specifies configuring a runtime system to set the "Transaction Isolation Level" while retrieving data. *Note:* This argument is mandatory. If you do not pass this argument, the error message "Mandatory Input Missing or Invalid: /TIL / S " appears.
/S <SystemName>	Specifies name of a deployed system for which Transaction Isolation Level is defined. *Notes:* This argument is mandatory. If you do not pass this argument, the error message "Mandatory Input Missing or Invalid: /TIL /S " appears. The system name is case-sensitive. The system name is the name of the Segment or else Alternate Name, if it has been defined. If you do not pass any value or pass an invalid value, the error message "Missing value for required parameter/s: System Name" appears. If you provide empty quotes, " ", or an invalid system name, an error message specifying that the system is not available appears.
/TO <IsolationLevelValue>	You can specify any of the five Transaction Isolation Level settings such as ReadUncommitted, ReadCommitted, RepeatableRead, Serializable, and Snapshot for a system. *Note:* If no value or an invalid value is passed with this argument, the error message Invalid argument<s> : /TO" appears. For example: To set the Transaction Isolation Level in all the read loops across a system including ispecs and reports, type ConfigureSystem /TIL /S Sample /TO Repeatable Read
/TR <IsolationLevelValue>	You can specify any of the five Transaction Isolation Level settings such as ReadUncommitted, ReadCommitted, RepeatableRead, Serializable, and Snapshot in all reports. *Note:* If no value or an invalid value is passed with this argument, the error message Invalid argument<s> : /TR" appears. For example: To set the Transaction Isolation Level in reports only, type ConfigureSystem /TIL /S Sample /TR Serializable
/ISP <IspecName>	Specifies a specific ispec name where the Transaction Isolation Level can be defined. *Note:* If you do not pass an ispec name for which the Isolation Level value is specified by setting the /ISV argument, the error message "Error: Ispec value/name is missing" appears.
/ISV <IsolationLevelValue >	You can specify any of the five Transaction Isolation Level settings such as ReadUncommitted, ReadCommitted, RepeatableRead, Serializable, and Snapshot for the ispec stated in the previous argument. *Notes:* If no value or an invalid value is passed with this argument, the error message Invalid argument<s> : /ISV" appears. If you do not pass any value for this argument for which the ispec name is stated previously, the error message "Error: Ispec value/name is missing" appears. For example: To set the Transaction Isolation Level in the SALE ispec, type: ConfigureSystem /TIL /S Sample /TO false /ISP SALE /ISV Serializable
/RPT <ReportName>	Specifies a specific report name where the Transaction Isolation Level can be defined. *Note:* If you do not pass a report name for which the Isolation Level Value is set through the /RPV argument, the error message "Error: Report value/name is missing" appears.
/RPV <IsolationLevelValue>	You can specify any of the five Transaction Isolation Level settings such as ReadUncommitted, ReadCommitted, RepeatableRead, Serializable, and Snapshot for the report stated in the previous argument. *Note:* If no value or an invalid value is passed with this argument, the error message Invalid argument<s> : /RPV" appears. If you do not pass any value for this argument for which the report name is stated previously, the error message "Error: Report value/name is missing" appears. For example: To set the Transaction Isolation Level in the PRODSTATS report, type: ConfigureSystem /TIL /S Sample /TO false /TR false /RPT PRODSTATS /RPV READ UNCOMMITTED
/TIL /	Displays command line syntax for setting the Transaction Isolation Level and arguments of the utility. If specified, a usage message displays, and the utility exits without starting the configuring process.