In the allpages locking scheme in Adaptive Server, locks are acquired on data and index pages. See the Performance and Tuning Guide: Locking for more information on locking schemes.
In Adaptive Server version 15.0, all system tables use datarow locking except for the following, which use allpages locking:
sysusermessages
sysslices
sysmessages
In addition, the following system tables are “fake”—or non-row-oriented—catalogs that give the appearance of using allpages locking:
syslogs
sysgams
sysprocesses
syslocks
syscurconfigs
syssecmechs
sysmonitors
sysengines
systestlog
syslisteners
syslogshold
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
