to see the lock schema ot the user tables

[SergioCbo]

Hi,


can you help me to write one query that give me the information about the scheme lock of my user tables. I'm working with sybase 12.0 on unix.

Thanks in Advance,


Sergio

 

[sybaseguru]

Sergio,

In order to find out which tables have row level locking you can try the following:

use <DATABASE>
go
select name, objspare from sysobjects where type = 'U'
and sysstat2 & 57344 = 32768
order by name
go

Note that values sysstat2 & 57344 =0 or 8192 refer to all pages locks and 16384 is data pages locks.

Good luck