Sybase ADDICT

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

Wonder how to display or delete duplicate records ? Sometimes, under certain circumstances duplicate data may occur. Then it should be deleted.

In this example, we are going to create a dummy table with an identity column as a unique key, and with two varchar columns. Then we are going to insert data and duplicates manually. The script for the test comes as follow:

create table dummytable(
keycolumn   numeric(5,0) identity,
column1     varchar(10),
column2     varchar(10)
)
go

insert dummytable(column1,column2) values("AAA","AAA")
go 10
(1 row affected)
10 xacts:

insert dummytable(column1,column2) values("AAA","BBB")
go
(1 row affected)

insert dummytable(column1,column2) values("BBB","BBB")
go
(1 row affected)

insert dummytable(column1,column2) values("BBB","AAA")
go
(1 row affected)

Read more…

MDA tables are very useful to understand what’s going on within your dataserver, so you can carry out accurate and successful performance and tuning campaigns. In this post I publish few basic Sybase stored procedures to use with MDA tables that focus on databases objects activity only (but I may release more MDA stored procedures in the future).

If you haven’t installed yet MDA tables in your Sybase Adaptive Server, you can refer to my previous post HowTo install MonTables to install them. Read more…

This sql query tells you if Direct IO is supported on your platform:

select low from spt_values
where  type='io'

A value of 1 means “Yes, direct io is supported on this platform”.
A value of 0 means “No, direct io is NOT supported on this platform”.

Read this nice post from David Wein about Direct I/O device option.

Want to know what platform your Sybase Adaptive Server is running on ? No need to connect to the machine to find out, just run this little query:

select name from master..spt_values
where type = 'E' and number = 1
go

For me it shows:

name
--------------------------------------------------------
linux

Nice…