Posted in Database, Sybase on avr 10th, 2008 No Comments »
One of the main problem of sybase (and other database) is the way it handle disk space. You must create “disk devices”, which can be RAW or file on a filesystem. Then give some space of it to a database, and perhaps create or extend segments.
Of course, this may sound a good way to deal [...]
Read Full Post »
Posted in Sybase, UNIX on sept 26th, 2007 No Comments »
Strange, I wasn’t able to find a way to get the database page size in a Sybase (12.x) server.
Digging in sp_helpdb stored procedure gave me some more informations. To do this, or any stored proc, use this SQL command :
USE sybsystemprocs
go
sp_helptext sp_space_segment
go
You will get the stored proc as text.
Finaly, the solution to get [...]
Read Full Post »