disk resize

Description

Dynamically increases the size of the device used by Adaptive Server.

Syntax

disk resize
	name = “device_name”,
	size = additional_space

Parameters

name

Is the name of the device whose size you are increasing.

additional_space

Is the additional space you are adding to the device.

Examples

Example 1

To increase the size of testdev by 4MB, enter:

disk resize 
name = "test_dev", 
size = "4M"

Usage

Standards

ANSI SQL – compliance level: Transact-SQL extension

Permissions

Only a user with the sa_role can execute the disk resize command.

Auditing

Values in event and extrainfo columns of sysaudits are:

Event

Audit option

Command or access audited

Information in extrainfo

100

disk

disk resize

  • 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

See also

Commands create database, disk init, drop database, load database

System procedures sp_addsegment, sp_dropsegment, sp_helpdb, sp_helpsegment, sp_logdevice, sp_renamedb, sp_spaceused