This chapter discusses basic locking concepts and the locking schemes and types of locks used for databases in Adaptive Server.
The following chapters provide more information on locking:
Chapter 3, “Locking Configuration and Tuning,” describes performance considerations and suggestions and configuration parameters that affect locking.
Chapter 4, “Using Locking Commands,”describes commands that affect locking: specifying the locking scheme for tables, choosing an isolation level for a session or query, the lock table command, and server or session level lock time-outs periods.
Chapter 5, “Locking Reports,” describes commands for reporting on locks and locking behavior, including sp_who, sp_lock, and sp_object_stats.
