1.0

to disk. A single DML operation may affect multiple rows, and each row modification, insertion, and deletion
is considered a separate operation. The default QUEUESIZE value is 0, which specifies no limit.
dir-name
The dir-name element defines the host system directories to use for the disk store. It contains one or more
single dir-name elements, made up of:
•
The directory specification, provided as the text of the dir-name element.
• An optional integer value that specifies the maximum amount of space, in megabytes, to use for the disk store
in that directory. By default, there is no limit. The space used is calculated as the combined sizes of all oplog
files in the directory.
You can specify any number of dir-name subelements in a CREATE DISKSTORE statement. The data is
spread evenly among the active disk files in the directories, keeping within any limits you set.
Use different disk-dir specifications for different disk stores. You cannot use the same directory for the same
named disk store in two different members.
Example
This example uses the default base directory and parameter values to create a named disk
store:
CREATE DISKSTORE STORE1
This example configures disk store parameters and specifies a storage directory:
CREATE DISKSTORE STORE1
MAXLOGSIZE 1024
AUTOCOMPACT TRUE
ALLOWFORCECOMPACTION FALSE
COMPACTIONTHRESHOLD 80
TIMEINTERVAL 223344
WRITEBUFFERSIZE 19292393
QUEUESIZE 17374
'dir1'(456)
This example specifies multiple storage directories and directory sizes for oplog files:
CREATE DISKSTORE STORE1
WRITEBUFFERSIZE 19292393
QUEUESIZE 17374
('dir1' 456 , 'dir2', 'dir3' 532 )
CREATE FUNCTION
Creates java functions that can be invoked from other SQL expressions.
Syntax
CREATE FUNCTION
function-name on page 441
( [
function-parameter on page 441
[ ,
function-parameter on page 441
] ] * )
RETURNS data-type
[
vFabric SQLFire User's Guide440
vFabric SQLFire Reference