disk resize

Dynamically increases the size of the device used by the SAP ASE server.

Syntax

disk resize
	name = “device_name”,
	size = additional_space

Parameters

Examples

Usage

  • The disk resize command allows you to dynamically increase the size of your disks.

  • After you resize a device, dump the master device, which maintains the size of the device in the sysdevices table. If you attempt a recovery from an old dump of the master device, the information stored in sysdevices is not current.

  • Any properties that are set on the device continue to be set after you increase its size.

  • During the physical initialization of the disk, if any error occurs due to insufficient disk space, disk resize extends the database device to the point before the error occurs.

    For example, on a server that uses 4K logical pages, if you try to increase the size of the device by 40MB, but only 39.5MB is available, then the device is extended only by 39.5MB. From the extended size (39.5MB), only 39MB is used by the SAP ASE server. The last 0.5MB is allocated but not used, as 4K servers configure devices in one MB minimums.

    To utilize the last 0.5MB, make sure that there is at least another 1.5MB available for the device, then re-run disk resize, specifying 1.5MB as the incremental size.

  • You cannot use disk resize to decrease the size of the device.

  • device_name must have a valid identifier. The device is initialized using the disk init command and, it must refer to a valid SAP ASE device, not a dump or load device.

  • The following are example unit specifiers, using uppercase, lowercase, and single and double quotes interchangeably: ‘k’ or “K” (kilobytes), “m” or ‘M’ (megabytes), “g” or “G” (gigabytes), and ‘t’ or ‘T’ (terabytes). You should always include a unit specifier. Although it is optional, you should 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.

  • Permanently disable mirroring while the resize operation is in progress. You can reestablish mirroring when the resize operation is completed.

See also sp_addsegment, sp_dropsegment, sp_helpdb, sp_helpsegment, sp_logdevice, sp_renamedb, sp_spaceused in Reference Manual: Procedures.

Standards

ANSI SQL – compliance level: Transact-SQL extension.

Permissions

The permission checks for disk resize differ based on your granular permissions settings.

SettingDescription
Enabled

With granular permissions enabled, you must be a user with manage disk privilege.

Disabled

With granular permissions disabled, you must be a user with sa_role.

Auditing

Values in event and extrainfo columns of sysaudits are:

InformationValues
Event

100

Audit option

disk

Command or access audited

disk resize

Information in extrainfo
  • Roles – current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – index name

  • Proxy information – original login name, if a set proxy is in effect

Related reference
create database
disk init
drop database
load database