Modifying the sizes of an extendable storage space

You can control how an extendable storage space in the storage pool grows by modifying the create size and the extend size. By default, the maximum size of an extendable storage space is unlimited. You can limit the size of an extendable storage space by setting a maximum size.

To modify the create, extend, or maximum size of a storage space:

Run the admin() or task() SQL administration API function with the modify space sp_sizes argument, as follows:
EXECUTE FUNCTION task("modify space sp_sizes", "space_name",
 "new_create_size", "new_extend_size", "max_size");

The space_name is the name of the storage space.

The new_create_size is the minimum size that the server can use to create a new chunk in the specified dbspace, temporary dbspace, sbspace, temporary sbspace, or blobspace.

The new_extend_size is the minimum size that the server can use to extend a chunk in the specified unmirrored dbspace or temporary dbspace.

Specify either sizes with a number (for the number of KB) or a percentage (for a percentage of the total space).

The max_size is the maximum size, in KB, to which the server can expand the storage space. A value of 0 indicates unlimited.

The following command sets the create size to 60 MB, the extend size to 10 MB, and the maximum size to 200 MB for a space that is named dbspace3:

EXECUTE FUNCTION task("modify space sp_sizes", "dbspace3", "60000", 
   "10000", "200000");

The following command sets the create size to 20 percent and the extend size to 1.5 percent for a space that is named logdbs:

EXECUTE FUNCTION task("modify space sp_sizes", "logdbs", "20", "1.5");

Copyright© 2018 HCL Technologies Limited