1.1

Note: You can optionally install the AsyncEventListener configuration after you
associate a table with the listener name. Make sure that you use the same listener
name with both the CREATE ASYNCEVENTLISTNER command and the CREATE
TABLE command.
CREATE DISKSTORE
Disk stores provide disk storage for tables and queues that need to overflow or persist (for instance when using
an asynchronous write-behind listener).
Syntax
CREATE DISKSTORE
diskstore_name
[ MAXLOGSIZE integer-constant ]
[ AUTOCOMPACT boolean-constant ]
[ ALLOWFORCECOMPACTION
boolean-constant ]
[ COMPACTIONTHRESHOLD
integer-constant ]
[ TIMEINTERVAL
integer-constant ]
[ WRITEBUFFERSIZE
integer-constant ]
[ QUEUESIZE
integer-constant ]
[ ( 'dir-name' [ integer-constant ] [,'dir-name' [ integer-constant ]
]* ) ]
Description
The tables in the same disk store will share the same disk persistence attributes. A table without a disk store
name belongs to the default disk store.
By default, SQLFire uses the working directory of the member as the default disk store.
MAXLOGSIZE
SQLFire records DML statements in an operation log (oplog) files. This option sets the maximum size in
megabytes that the oplog can become before SQLFire automatically rolls to a new file. This size is the combined
sizes of the .crf and .drf oplog files. When SQLFire creates an oplog file, it immediately reserves this amount
of file space. SQLFire only truncates the unused space on a clean shutdown (for example, sqlf server
stop or sqlf shut-down-all).
The default value is 1 GB.
AUTOCOMPACT
Set this option to "true" (the default) to automatically compact disk files. Set the option to "false" if compaction
is not needed or if you intend to manually compact disk files using the sqlf utility.
SQLFire performs compaction by removing "garbage" data that DML statements generate in the oplog file.
465
SQL Language Reference