Informix DEFAULTS keyword
Informix DEFAULTS keyword
|
| Release 9.3 |
   |
Note:This topic was updated for 9.3.1.
As the name indicates, the settings under the DEFAULTS configuration keyword are used by default when you create tables, feature classes, raster datasets, and indexes. If you do not specify a different keyword when data is created in the geodatabase, or if you specify a keyword that is missing some necessary parameters, values from the DEFAULTS keyword are used.
The parameters grouped under the DEFAULTS keyword should be set to values that apply to most of the data in your geodatabase. The following values are what are present in the dbtune table if you do not customize it.
##DEFAULTS
UI_TEXT "DEFAULTS"
B_STORAGE "EXTENT SIZE 16 NEXT SIZE 16 LOCK M
B_INDEX_ROWID "FILLFACTOR 90"
B_INDEX_TO_DATE "FILLFACTOR 90"
B_INDEX_USER "FILLFACTOR 90"
B_RTREE ""
A_STORAGE "EXTENT SIZE 16 NEXT SIZE 16 LOCK MODE ROW"
A_INDEX_ROWID "FILLFACTOR 90"
A_INDEX_STATEID "FILLFACTOR 90"
A_INDEX_USER "FILLFACTOR 90"
A_RTREE ""
D_STORAGE "EXTENT SIZE 16 NEXT SIZE 16 LOCK MODE ROW"
D_INDEX_DELETED_AT "FILLFACTOR"
D_INDEX_STATE_ROWID "FILLFACTOR"
S_STORAGE ""
RAS_STORAGE "EXTENT SIZE 16 NEXT SIZE 16 LOCK MODE ROW"
RAS_INDEX_ID "FILLFACTOR 90"
BND_STORAGE "EXTENT SIZE 16 NEXT SIZE 16 LOCK MODE ROW"
BND_INDEX_COMPOSITE "FILLFACTOR 90"
BND_INDEX_ID "FILLFACTOR 90"
AUX_STORAGE "EXTENT SIZE 16 NEXT SIZE 16 LOCK MODE ROW"
AUX_INDEX_COMPOSITE "FILLFACTOR 90"
BLK_STORAGE "EXTENT SIZE 16 NEXT SIZE 16 LOCK MODE ROW"
BLK_LOB_STORAGE ""
BLK_INDEX_COMPOSITE "FILLFACTOR 90"
USE_EXCLUSIVE_LOCKING "TRUE"
MAX_CACHED_CURSORS "80"
XML_DOC_STORAGE "EXTENT SIZE 16 NEXT SIZE 16 LOCK MODE ROW"
XML_DOC_LOB_STORAGE ""
XML_DOC_VAL_LOB_STORAGE ""
XML_IDX_STORAGE "EXTENT SIZE 16 NEXT SIZE 16 LOCK MODE ROW"
XML_IDX_TEXT_TAG_STORAGE ""
XML_IDX_INDEX_ID "FILLFACTOR 90"
XML_IDX_INDEX_TAG "FILLFACTOR 90"
XML_IDX_INDEX_DOUBLE "FILLFACTOR 90"
XML_IDX_INDEX_STRING "FILLFACTOR 90"
XML_IDX_FULLTEXT_TYPE ""
XML_IDX_FULLTEXT_PARAMS ""
XML_IDX_FULLTEXT_STORAGE ""
END
