The disk resize command allows you to increase the size of your database devices dynamically, 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 by which 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 has dsync set afterwards. Also, any access rights that were set before you increased the size of the device remain set.
A user with the sa role can execute the disk resize command, which:
Updates the high value in master....sysdevices, and
Prepares the additional space for database storage.
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.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
