-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You could mess around with the lock escalation mechanism (Sybase will
table lock once the number of pages locked goes over a threshold).

Steve

- --
(c) 2003 MirrorREMOVEANTISPAMData
h: http//www.mirrorREMOVEANTISPAMData.com
e: newsgroup@mirrorREMOVEANTISPAMData.com
Remove REMOVEANTISPAM for url/email

"Kapal Mo" <kapalmo@nospam.hotmail.com> wrote in message
news:68Zha.37729$cB3.229202@nnrp1.uunet.ca...
> Be forewarned not a Sybase DBA.
>
> In our Sybase 11.9.2 on AIX we have a small table about 10-20 rows,
> row length less than 500. This table is heavily updated.
>
> The first problem I encountered was that of page locking. Since
> multiple jobs trying to update different rows on the table, Sybase
> would lock the whole page blocking the other update jobs. Tried
> to resolve this by alter table lock datarows and also changing 1
> row per page. This has fixed the problem somewhat but the problem
> still occurs.
>
> I am thinking that Sybase will still do a table lock since it
> thinks table lock is more efficient than a row lock considering the
> number of rows involved.
>
> Basic question then is how can I ensure that Sybase will strictly
> do a row lock. Is there a setting in 11.9.2 or is this not an
> issue with future Sybase versions.
>
> Thank you.
>

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBP1w4wySQEiWATEdREQIR5QCeOZ8ytwOBTRnkqu2a8AUL0g o6zSIAoILF
sWGEt5uWBCfmrEVVTIb1OYSt
=BfMD
-----END PGP SIGNATURE-----