Informix Guide to SQL: Tutorial

Informix Guide to SQL: Tutorial
Chapter 7: Programming for a Multiuser Environment

Home Contents Index Master Index New Book

Programming for a Multiuser Environment

Concurrency and Performance

Locking and Integrity

Locking and Performance

Concurrency Issues

: Database Locks
: Table Locks
: Page, Row, and Key Locks

The Duration of a Lock

Locks While Modifying

Setting the Isolation Level

: Comparing SET TRANSACTION with SET ISOLATION
: ANSI Read Uncommitted and Informix Dirty Read Isolation
: ANSI Read Committed and Informix Committed Read Isolation
: Informix Cursor Stability Isolation
: ANSI Serializable, ANSI Repeatable Read, and Informix Repeatable Read Isolation

Controlling Data Modification with Access Modes

Setting the Lock Mode

: Waiting for Locks
: Not Waiting for Locks
: Waiting a Limited Time
: Handling a Deadlock
: Handling External Deadlock

Simple Concurrency

Locking with Other Database Servers

: Isolation While Reading
: Locking Updated Rows

Informix Guide to SQL: Tutorial, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.