DB2 DEFAULTS keyword |
|
Release 9.3 |
##DEFAULTS
A_INDEX_ROWID ""
A_INDEX_SHAPE ""
A_INDEX_STATEID ""
A_INDEX_USER ""
#A_STORAGE "IN <TABLESPACE> INDEX IN <TABLESPACE> LONG IN <TABLESPACE>"
B_INDEX_ROWID ""
B_INDEX_SHAPE ""
B_INDEX_TO_DATE ""
B_INDEX_USER ""
B_RUNSTATS "YES"
#B_STORAGE "IN <TABLESPACE> INDEX IN <TABLESPACE> LONG IN <TABLESPACE>"
BLK_INDEX_COMPOSITE ""
#BLK_STORAGE "IN <TABLESPACE> INDEX IN <TABLESPACE> LONG IN <TABLESPACE>"
#AUX_STORAGE "IN <TABLESPACE> INDEX IN <TABLESPACE>"
#BND_STORAGE "IN <TABLESPACE> INDEX IN <TABLESPACE>"
#RAS_STORAGE "IN <TABLESPACE> INDEX IN <TABLESPACE>"
D_INDEX_DELETED_AT ""
D_INDEX_STATE_ROWID ""
#D_STORAGE "IN <TABLESPACE> INDEX IN <TABLESPACE> LONG IN <TABLESPACE>"
BLOB_OPTION "LOGGED NOT COMPACT"
BLOB_SIZE "1M"
CLOB_OPTION "LOGGED NOT COMPACT"
CLOB_SIZE "32K"
#MAX_CACHED_CURSORS "80"
#XML_DOC_STORAGE "IN <TABLESPACE> INDEX IN <TABLESPACE>"
XML_DOC_LOB_SIZE "1M"
XML_DOC_VAL_LOB_SIZE "1M"
XML_DOC_UNCOMPRESSED_TYPE ""
#XML_IDX_STORAGE "IN <TABLESPACE> INDEX IN <TABLESPACE>"
XML_IDX_INDEX_ID ""
XML_IDX_INDEX_TAG ""
XML_IDX_INDEX_DOUBLE ""
XML_IDX_INDEX_STRING ""
XML_IDX_FULLTEXT_UPD_FREQUENCY ""
XML_IDX_FULLTEXT_UPD_MINIMUM ""
XML_IDX_FULLTEXT_UPD_COMMIT ""
XML_FULLTEXT_IDX_IDXDIRECTORY ""
XML_IDX_FULLTEXT_WKDIRECTORY ""
XML_IDX_FULLTEXT_LANGUAGE ""
XML_IDX_FULLTEXT_CCSID ""
END
##DEFAULTS
A_INDEX_ROWID ""
A_INDEX_SHAPE ""
A_INDEX_STATEID ""
A_INDEX_USER ""
#A_STORAGE "IN DATABASE <DATABASE NAME>"
B_INDEX_ROWID ""
B_INDEX_SHAPE ""
B_INDEX_USER ""
B_RUNSTATS "NO"
#B_STORAGE "IN DATABASE <DATABASE NAME>"
#BLK_STORAGE "IN DATABASE <DATABASE NAME>"
#AUX_STORAGE "IN DATABASE <DATABASE NAME>"
#BND_STORAGE "IN DATABASE <DATABASE NAME>"
#RAS_STORAGE "IN DATABASE <DATABASE NAME>"
BLK_BLOB_OPTION ""
BLK_INDEX_COMPOSITE ""
D_INDEX_DELETED_AT ""
D_INDEX_STATE_ROWID ""
#D_STORAGE "IN DATABASE <DATABASE NAME>"
BLOB_OPTION ""
BLOB_SIZE "1M"
CLOB_OPTION ""
CLOB_SIZE "32K"
#MAX_CACHED_CURSORS "80"
UI_TEXT ""
XML_DOC_STORAGE ""
XML_DOC_LOB_SIZE "1M"
XML_DOC_VAL_LOB_SIZE "1M"
XML_DOC_UNCOMPRESSED_TYPE ""
XML_IDX_STORAGE ""
XML_IDX_INDEX_ID ""
XML_IDX_INDEX_TAG ""
XML_IDX_INDEX_DOUBLE ""
XML_IDX_INDEX_STRING ""
XML_IDX_FULLTEXT_UPD_FREQUENCY ""
XML_IDX_FULLTEXT_UPD_MINIMUM ""
XML_IDX_FULLTEXT_UPD_COMMIT ""
XML_IDX_FULLTEXT_IDXDIRECTORY ""
XML_IDX_FULLTEXT_WKDIRECTORY ""
XML_IDX_FULLTEXT_LANGUAGE ""
XML_IDX_FULLTEXT_CCSID ""
END
NOTE: XML parameters do not affect geodatabases on DB2 for z/OS, since XML is not supported for these geodatabases at this time.