Specifying a logical device name with disk resize  Chapter 8: Setting Database Options

Chapter 7: Initializing Database Devices

Specifying the device size with disk resize

You can use the following unit specifiers to indicate the size of the device: “k” or “K” to indicate kilobytes, “m” or “M” to indicate megabytes, “g” or “G” to indicate gigabytes, and “t” or “T” to indicate terabytes.

Although it is optional, Sybase recommends that you always include the unit specifier with the disk resize command to avoid confusion in the actual number of pages allocated. You must enclose the unit specifier in single or double quotes. If you do not use a unit specifier, the size defaults to the number of disk pages.

To verify the new size, use sp_helpdevice.





Copyright © 2005. Sybase Inc. All rights reserved. Chapter 8: Setting Database Options

View this book as PDF