1.0

ContentsNullableLengthTypeColumn Name
A system type that describes the
table, conglomerate, constraint,
and privilege that is the provider
false2,147,483,647org.apache.derby. catalog.
DependableFinder
This class is not part of the
public API.
PROVIDERFINDER
SYSDISKSTORES system table
Contains information about all disk stores created in the SQLFire cluster.
See CREATE DISKSTORE on page 438.
ContentsTypeColumn Name
The unique identifier of the disk store.VARCHARNAME
The maximum size, in megabytes, of a single oplog file in the disk store.BIGINTMAXLOGSIZE
Specifies whether SQLFire automatically compacts log files in this disk store.CHARAUTOCOMPACT
Specifies whether the disk store permists online compaction of log files using the sqlf
utility.
CHARALLOWFORCECOMPACTION
The threshold after which an oplog file is eligible for compaction. Specified as a percentage
value from 0–100.
INTCOMPACTIONTHRESHOLD
The maximum number of milliseconds that can elapse before SQLFire asynchronously
flushes data to disk .
BIGINTTIMEINTERVAL
The size of the buffer SQLFire uses to store operations when writing to the disk store.INTWRITEBUFFERSIZE
The maximum number of row operations that SQLFire can asynchronously queue for writing
to the disk store.
INTQUEUESIZE
The directory names that hold disk store oplog files, and the maximum size in megabytes
that each directory can store.
VARCHARDIR_PATH_SIZE
SYSFILES system table
The SYSFILES table describes jar files stored in the database.
The following table shows the contents of the SYSFILES system table.
Table 19: SYSFILES system table
ContentsNullableLengthTypeColumn Name
Unique identifier for the jar filefalse36CHARFILEID
ID of the jar file's schema (join
with
SYSSCHEMAS.SCHEMAID)
false36CHARSCHEMAID
SQL name of the jar filefalse128VARCHARFILENAME
Generation number for the file.
When jar files are replaced, their
false19BIGINTGENERATIONID
615
System Tables