sybase question

[Ragni Singh]

Hey guys,
I need to come up with some space on a server but my delimma here is I have sybase running on my server as well. Running the lvm commands doesn't tell me how much disk is being utilized by sybase. I do know that sybase uses raw devices. How can I look that up to see how much space is being taken by sybase. All yout time and help is greatl appreciated.

[Sanjay_6]

Hi Sanman,

vgdisplay -v /dev/vg_name should list the space being used by the logical volumes in that VG. Even if sybase is using the raw device, if you are using lvm, the info would be there in vgdisplay. How are the raw devices configured. don't suppose you are using full disks for that. Are you?.

hope this helps.

Regds

[harry d brown jr]

sanman,

if sybase is using raw devices, as in a logical volume, then that whole logical volume is in use. If you have one logical volume per physical disk, then unless you have free disks, you really don't have any "free" space. You'll have to use sybase utilities to tell you how much space on the raw volumes are in use.


live free or die
harry

[Johan Bergwitz]

You would have to issue a query to Sybase to find out how much space it really has occupied of the device.

isql -Usa
1>sp_helpdevice
2>go

This will give you the ouput for all logical devices. You must be aware of that Sybase makes its own devices on the raw partitions and it doesn't need to allocate all the space of the device to a database. You can therefore also have free space on a Sybase device.

Regards

Johan Bergwitz