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 188.8.131.52. 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):
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! 🙂