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 13, “Locking Configuration and Tuning,” describes performance considerations and suggestions and configuration parameters that affect locking.
Chapter 11, “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 12, “Reporting on Locks,” describes commands for reporting on locks and locking behavior, including sp_who, sp_lock, and sp_object_stats.