Can someone please help with the following:
What is row level locking -

all pages
data pages
data rows


Does row level locking = data rows?
and page level locking = all pages?

I'm getting confused, can someone please help, this is for sybase 12.0
Thank you

Maria wrote:
row level == data rows
page level == data pages
page level == data pages (and index pages)

--
Mark A. Parsons

Iron Horse, Inc.
iron_horse (AT) NOSPAM (DOT) compuserve.com

"Maria" <evoradba (AT) yahoo (DOT) ca> wrote

You're correct, page level locking locks pages, not rows. There's a
difference between allpages locking (the classic Sybase lock scheme) and
data pages locking (new since 11.9): allpages locks all data pages and all
index pages that are modified in a transaction; data pages locks only the
data pages -- modified index pages are not locked for the duration of the
transaction, but 'locked' internally in a different way that lasts only a
very short time. To the user, this has the effect that data pages locking
locks only data pages and no index pages -- hence the name 'data pages'
locking. Note that there is no functional difference between allpages and
datapages locking as far as transactional consistency is concerned; data
pages locking just provides better concurrency.

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of various Sybase books. New book (coming soon): "The
Complete Sybase Replication Server Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------