Sybase ADDICT

To know when the last full backup of your database occurred you can look at the backupserver logfile, of course. But you don’t have to. Indeed you can find this information with Sybase ASE using the command “dbcc dbtable”.
Read more…

To list the tables that use datapages or datarows locking scheme, use:

select name,sysstat2
from sysobjects
where type = 'U'
and (sysstat2 & 16384 = 16384 or sysstat2 & 32768 =32768)

To list tables that use allpages locking scheme, use:

select name,sysstat2
from sysobjects
where type = 'U'
and sysstat2 & 8192 = 8192