Need a larger master device with Sybase ASE?

For those of you that may not know, you can use the supported method to increase the size of any Sybase ASE database device starting with ASE Obviously, you will need to ensure that the filesystem or raw device the database device is pointing to is large enough:

For raw devices (unix/linux inspecific):

dd if=/dev/raw_device of=/dev/null bs=1M

For filesystems (unix/linux inspecific):

df -k

For Windows, use Windows Explorer.

If you don’t have enough space, you will need to increase the size of the filesystem or raw device. These can be easily done in Windows (i.e. Partition Magic is very handy) or Linux/Unix via a logical volume manager and/or gparted.

To increase the size of the database device, you will want to make a backup of any of the databases that reside on the device. Since we’re going to extend the master device, we would want to back up the master database:

dump database master to "/sybdump/master.dmp"

We are ready to extend the master device:

disk resize "master", size = "170M"

Once that completes, we might as well increase the master database from 12MBytes to 50MBytes:

alter database master on master = "38M"

That’s it! 🙂

Share Button

Mapping Linux LVM and Raw partitions


We need to determine what device a raw partition resides on and the size of the partition.  We know that this box uses the Linux Volume Manager (LVM).


Getting this information is easy if you are root or have the /usr/bin/raw binary set with the SUID bit.

Continue reading “Mapping Linux LVM and Raw partitions”

Share Button