Versions Compared

Old Version 1

changes.mady.by.user Corby Nagel

Saved on

compared with

New Version Current

changes.mady.by.user Corby Nagel

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

GroupOptionDescription
DirectoriesTransaction Log PathSpecifies 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.

The 3 dot image.pngImage RemovedImage Added button to the right of the prompt allows for the selection of the location.

 Commit Log PathSpecifies the location of the commit log.

The 3 dot image.pngImage RemovedImage Added button to the right of the prompt allows for the selection of the location.

Consistency Lock Type The consistency level of locking used by the workstation during Transaction processing.
 NoneDisables implicit locking. In order to lock records and tables, you must lock them explicitly using BASIC+ commands.
 UpdateExclusive locks during updates of tables or records. The lock is held for the duration of the update operation. No locking takes place during queries.
 TransactionExclusive 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.
 QueryExclusive 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.
Deadlock Resolution 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.
Ungrouped ItemsUnlock all at CommitTo enable the release of locks at commit, check this item.
 Co-ordinated LockingTo coordinate table and row locks, check this item.
 Autotransaction StartTo begin transactions automatically, check this item.
 Commit ProtectionTo control queuing for data integrity, check this item.
 Maximum LocksYou 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 TimeoutThe number of seconds before the transaction times out in a wait situation.
 DeadlockThe number of seconds before deadlock checking is begun and locks are posted.
 Deadlock CheckThe number of seconds for checking deadlocks after the deadlock process has been started.

...