|Transaction Log Path
|Specifies the location of the temporary files used for a workstation's transactions. The default setting is the TRANSACT directory residing in the default OpenInsight directory.
|Commit Log Path
|Specifies the location of the commit log.
|Consistency Lock Type
|The consistency level of locking used by the workstation during Transaction processing.
|Disables implicit locking. In order to lock records and tables, you must lock them explicitly using BASIC+ commands.
|Exclusive locks during updates of tables or records. The lock is held for the duration of the update operation. No locking takes place during queries.
|Exclusive locks during updates for the duration of each transaction. When the transaction is committed or rolled back the locks are released. No locking is done for queries.
|Exclusive locks during updates for the duration of each transaction. In addition, it sets shared locks during queries for the duration of each query.
|SQL Lock Type
|Specifies the type of locking that should occur during the transaction.
|When a deadlock situation is detected, one of the conflicting transactions must be rolled back. This option allows for the rollback of the Youngest (or most recent) transaction or the Least Active transaction.
|Unlock all at Commit
|To enable the release of locks at commit, check this item.
|To coordinate table and row locks, check this item.
|To begin transactions automatically, check this item.
|To control queuing for data integrity, check this item.
|You can limit the number of locks held by the workstation using this control. The default setting of zero (0) disables the lock limit.
|Transaction Fail Timeout
|The number of seconds before the transaction times out in a wait situation.
|The number of seconds before deadlock checking is begun and locks are posted.
|The number of seconds for checking deadlocks after the deadlock process has been started.