The disk resize command allows you to dynamically increase the size of your database devices, rather than initializing a new device. For example, if /sybase/testdev.dat requires an additional 10MB of space, you can run disk resize and allocate this amount of space to the device. The create and alter database commands can use this added space.
You can use disk resize to increase the size for both devices on raw partitions and for file systems. The minimum amount of space that you can increase a device is 1MB or an allocation unit, whichever is greater.
You cannot use disk resize on dump or load devices.
Any properties that are set on the device continue to be set after you increase its size. That is, if a device has dsync set before you increase its size, it will have dsync set afterwards. Also, any access rights that were set before you increased the size of the device remain set.
Only users with the sa role can execute the disk resize command.
You can use audit trails on disk resize to track the number of times a device is resized. The device being resized is always online and available for users during the resize operation.
See Chapter 7, “Commands” in the Reference Manual for syntax information about disk resize.
