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 Informix® to automatically expand the space.

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--"--modify space expand--"---->


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.


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, Informix 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.


The following command expands dbspace5 by 10 megabytes:

EXECUTE FUNCTION task("modify space expand", "dbspace5", "10 MB");

Copyright© 2018 HCL Technologies Limited