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。
相关主题
5/10/2014