I am new to sybase ASE.

I would like to know what are all the databases that have been using a device in sybase instance. sp_helpdevice or sp_helpdb are just giving not enough information.

Is there any such way to know the information in the below format.

device_name   db_id   allocated used free
.             .       .         .    . 
.             .       .         .    .
.             .       .         .    .
  • What operating system is Sybase ASE running on? – Max Vernon Jun 25 '16 at 22:52
  • 1
    @MaxVernon: SunOS 5.10 – Uday Jun 26 '16 at 12:30

sp_helpdevice does list all allocated fragments on a device when you specify the device name. This includes the size of each fragment, but indeed not the free/used metrics. Those would not be difficult to write yourself however.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.