web analytics

Find actual device numbers in Sybase

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

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

Sybase sp_freedevice procedure

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 […]