add bufferpool argument: Add a buffer pool (SQL administration API)

Use the add bufferpool argument with the admin() or task() function to create a buffer pool.

Syntax


>>-EXECUTE FUNCTION--+-admin-+--(------------------------------->
                     '-task--'      

>--"add bufferpool"--,--"page_size"--)--;----------------------><

Element	Description	Key Considerations
`page_size`	The page size in KB.	The page size must be an integral multiple of the default page size, and cannot be greater than 16 KB. On Windows, the page size is always 4 KB.

Usage

Use add bufferpool argument to create a buffer pool for a page size that does not already have a buffer pool. All other characteristics of the buffer pool that you create are set to the values of the fields in the default line of the BUFFERPOOL configuration parameter.

This function is equivalent to the onparams -b -g command and the BUFFERPOOL configuration parameter.

Example

The following example adds a buffer pool with a page size of 8 KB:

EXECUTE FUNCTION task("add bufferpool","8");