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. 


1  EXECUTE FUNCTION
1 admin
1 task
2  ( " modify chunk extendable
off "  , " chunk_number " )  ;
Element Description Key Considerations
chunk_number The number of the chunk.

Usage

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.

Example

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