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.


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

>--"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.


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.


The following example adds a buffer pool with a page size of 8 KB:
EXECUTE FUNCTION task("add bufferpool","8");

Copyright© 2018 HCL Technologies Limited