Provide configuration keywords
You can provide configuration keywords that the access method interrogates to tailor its behavior.
The user specifies one or more parameter choices in the USING clause of the CREATE TABLE statement. The access method calls the mi_tab_amparam() accessor function to retrieve the configuration keywords and values.
In the following example,
the access method checks the keyword value to determine if the user
wants mode set to the number of rows to store in a shared memory buffer.
The CREATE TABLE statement specifies the configuration keyword and
value between parentheses.
CREATE TABLE ...
IN sbspace
USING sbspace_access_method ("setbuffer=10")
In
the preceding statement, the mi_tab_amparam() function
returns
setbuffer=10
. The following figure shows
how the access method determines the value that the user specifies
and applies it to create the sbspace.Important: If the access method accepts parameters,
describe them in the user guide for the access method. For example,
a description of the action in Checking a configuration parameter
value would explain how to
set a value in the parameter string
"setbuffer="
and
describe how a buffer might improve performance.A user
can specify multiple configuration parameters separated by commas,
as the following syntax shows:
CREATE TABLE ...
...
USING access_method_name (keyword='string', keyword='string' ...)