HP 3000 Manuals HP 3000 Manuals
Table of Contents
Row Level Locking: Technical Addendum for ALLBASE/SQL Release F
Row Level Locking: Technical Addendum for ALLBASE/SQL Release F : COPYRIGHT NOTIC
Ch 1. Creating and Using Tables with Row Level Locking
Basics of Creating Database Objects (SQL)
Creating a Table
Choosing the Locking Mode and Default Access Authorities
Details on Creating Tables (DBA)
Table Type
Revoking and Granting Authorities on PUBLICROW and PUBLIC Tables
Altering Table Type
Maintaining Tables (DBA)
Changing a Table's Locking Behavior
Estimating Shared Memory Requirements (DBA)
Estimating Runtime Control Block Buffer Pages
Effects of Page and Row Level Locking
Running out of Shared Memory
Ch 2. Concurrency Control throughLocks and Isolation Levels (SQL)
Defining Transactions
Understanding ALLBASE/SQL Data Access
Use of Locking by Transactions
Basics of Locking
Locks and Queries
Locks on System Catalog Pages
Locks on Index Pages
Costs of Locking
Defining Isolation Levels between Transactions
Repeatable Read (RR)
Cursor Stability (CS)
Read Committed (RC)
Read Uncommitted (RU)
Details of Locking
Lock Granularities
Types of Locks
Lock Compatibility
Weak Locks
What Determines Lock Types
Type of SQL Statement
Locking Structure Implicit at CREATE TABLE Time
Use of the LOCK TABLE Statement
Choice of a Scan Type
Choice of Isolation Level
Updatability of Cursors or Views
Use of Sorting
Scope and Duration of Locks
Examples of Obtaining and Releasing Locks
Simple Example of Concurrency Control through Locking
Sample Transactions Using Isolation Levels
Example of Repeatable Read
Example of Cursor Stability
Example of Read Committed
Example of Read Uncommitted
Resolving Conflicts Among Concurrent Transactions
Lock Waits
Deadlocks
Table Type and Deadlock
Table Size and Deadlock
Avoiding Deadlock
Avoiding Deadlock by Using the Same Order of Execution
Avoiding Deadlock by Reading for Update
Avoiding Deadlock by Using the LOCK TABLE Statement
Avoiding Deadlock on Single Tables by Using PUBLICREAD and PRIVATE
Avoiding Deadlock by Using the KEEP CURSOR Option
Undetectable Deadlock
Ch 3. Syntax and System Catalog Changes for Row Level Locking
ALTER TABLE (SQL)
CREATE TABLE (SQL)
System.Table (DBA)
Ch 4. ALLBASE/SQL Messages (MSG)
INDEX
Index