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

Read syntax diagramSkip visual syntax diagram
>>-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");

Copyright© 2019 HCL Technologies Limited