modify space expand argument: Expand the size of a space (SQL administration API)
Use the modify space expand argument with the admin() or task() function to immediately expand the size of a space, when you do not want to wait for OneDB to automatically expand the space.
| Element | Description | Key Considerations |
|---|---|---|
| space_name | The name of the storage space. | |
| minimum_size | The minimum size by which you want to expand the space. | See admin() and task() Argument Size Specifications. |
Usage
The modify space expand SQL administration API command expands a storage space immediately, either by extending an extendable chunk in the space or by adding a new chunk. The create size and extend size settings for the space do not affect this operation.
The actual number of kilobytes added to the space might exceed your requested size, depending on factors such as the page size of the space and the chunk size settings for available entries in the storage pool.
The storage pool must contain entries (such as raw devices, cooked files, or directories) that the server can use to expand the space.
After you run a modify space expand SQL administration API command, OneDB first attempts to expand the space by extending an extendable chunk in the space. If the space does not contain any extendable chunks, the server uses entries in the storage pool to expand the space.
You cannot expand a mirrored storage space.
Examples
The following command expands dbspace5 by
10 megabytes:
EXECUTE FUNCTION task("modify space expand", "dbspace5", "10 MB");