Hello,

I'm using Sybase 11.5.1 with quite a lot of users. It seems that data are
locked by block and when a user is trying to use the same block, he is
locked. So there are more and more to be blocked and finally the server must
be restarted to free the connections.

Is there any parameter to change so that data can be locked by row or
something else ?


Laurent

On Tue, 10 Feb 2004 14:06:07 +0100, Laurent RUHLMANN wrote:

Well - you shouldn't necessarily have to restart the server. My guess is
that you have some transactions that are holding locks for a very long
time, and that this blocks other users.

You can't change the locking scheme in 11.5.x - though you could (should?)
update to a more recent version (12.0 or 12.5.x), in which case you could
use a different locking scheme.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html

To simulate row level locking on a pre 11.9.2 database, you can set
max_rows_per_page = 1.

HTH
abhay

Michael Peppler <mpeppler (AT) peppler (DOT) org> wrote