Locking Schemes Used for System Tables

In the allpages locking scheme in SAP ASE, locks are acquired on data and index pages.

See the Performance and Tuning Guide: Locking for more information on locking schemes.

All system tables use datarow locking except for the following, which use allpages locking:

In addition, the following system tables are “fake”—or non-row-oriented—catalogs that give the appearance of using allpages locking: