Sybase ADDICT

Find out the dataserver’s page size without using global variables like @@pagesize or @@maxpagesize.

When you work with heterogeneous versions of Sybase Ase (12.0.x and 12.5.x or 15.x), this query can help you while coding your dba stored procedures…

declare @page_size int
select  @page_size = low /1024 from master.dbo.spt_values
where type = 'E' and number = 1
go

It will produce the result in Kb. This works with Sybase ASE from version 11.x to 15.x.