device

Find actual device numbers in Sybase

Wednesday, March 8th, 2006

select low/16777216 “vdevno”, name, phyname
from master..sysdevices
where status&2=2
order by 1

Warning! For vdevno>127 it could generate incorrect results.

Sybase sp_freedevice procedure

Thursday, February 2nd, 2006

Only the short info about Sybase database devices.
Parameters:
min_space - minimum of required space (i.e. 40 will display the devices with >=40M free space)
the_name - the template for the device name (i.e. %mast% will display only master device)
Warning! It was not tested for all possible configurations, so the result could be incorrect [...]