DB2 中的 DEFAULTS 关键字

顾名思义，在创建表、要素类、栅格数据集以及索引时，默认情况下使用 DEFAULTS 配置关键字下的设置。如果在地理数据库中创建数据时未指定其他关键字，或者指定的关键字缺少某些必要参数，则将使用 DEFAULTS 关键字中的值。

需要提供在尖括号 (<>) 中显示的信息，并移除 # 符号取消关联 TABLESPACE 行的注释。对于归属于 DEFAULTS 关键字的参数，所设置的参数值应适用于地理数据库中的多数数据。

第一组 DEFAULTS 参数用于 DB2 for Linux、DB2 for UNIX 和 DB2 for Windows。

##DEFAULTS  A_INDEX_ROWID	"" A_INDEX_SHAPE     	"" A_INDEX_STATEID	"" A_INDEX_USER	"" #A_STORAGE	"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> LONG IN <TABLESPACE>" BLK_BLOB_OPTION "LOGGED NOT COMPACT" BLK_INDEX_COMPOSITE		"" #BLK_STORAGE "IN <TABLESPACE> LONG IN <TABLESPACE>" #AUX_STORAGE "IN <TABLESPACE>" #BND_STORAGE "IN <TABLESPACE>" #RAS_STORAGE "IN <TABLESPACE>" D_INDEX_DELETED_AT	"" D_INDEX_STATE_ROWID	"" #D_STORAGE	"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" ST_GEOM_STORAGE_INLINE "" UI_TEXT "" #XML_DOC_STORAGE         "IN <TABLESPACE>" XML_DOC_LOB_SIZE          "1M" XML_DOC_VAL_LOB_SIZE      "1M" XML_DOC_UNCOMPRESSED_TYPE "" #XML_IDX_STORAGE         "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_IDXDIRECTORY    "" XML_IDX_FULLTEXT_WKDIRECTORY     "" XML_IDX_FULLTEXT_LANGUAGE        ""  XML_IDX_FULLTEXT_CCSID           "" XMLCOLUMN_STORAGE			"DB_XML" #XMLDB_DOC_STORAGE_INLINE        "INLINE LENGTH <IN BYTES>" #XMLDB_DOC_STORAGE_TABLESPACE    "LONG IN <TABLESPACE>" XMLDB_DOC_COMPRESSED             "NO" XMLDB_IDX_TAG_INVALID_VALUES     "IGNORE INVALID VALUES" XMLDB_INDEX_TAG                  "YES" XMLDB_INDEX_FULLTEXT             "NO"  END

下面这组 DEFAULTS 参数用于 DB2 for z/OS：

##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" ST_GEOM_STORAGE_INLINE "" 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           "" XMLCOLUMN_STORAGE                ""  END

注意:

XML 参数不影响 DB2 for z/OS 中的地理数据库，因为此时这些地理数据库不支持 XML。