modify chunk extendable off argument: Mark a chunk as not extendable (SQL administration API)

Use the modify chunk extendable off argument with the admin() or task() function to specify that a particular chunk cannot be extended.

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+---------------------------------->

>--(--"--modify chunk extendable off--"--,--"--chunk_number--"--)-- ;-><

Element Description Key Considerations
chunk_number The number of the chunk.  


The default status for chunks is not extendable. If you previously marked a chunk as extendable, you can change the status to not extendable.

If a chunk is marked as not extendable:

  • The server cannot automatically extend the chunk when the space containing the chunk runs low or out of free pages.
  • You cannot manually extend the size of the chunk.

If the storage pool contains entries, the server can extend a storage space by adding another chunk to the storage space.


The following example specifies that the you or the server cannot extend chunk 9:
EXECUTE FUNCTION task("modify chunk extendable off", "9");

Copyright© 2018 HCL Technologies Limited