The DEFAULTS keyword in DB2

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.

You need to supply the information shown in angle brackets (<>) and uncomment the associated TABLESPACE lines by removing the # sign. The parameters grouped under the DEFAULTS keyword should be set to values that apply to most of the data in your geodatabase.

The first set of DEFAULTS parameters are for DB2 for on Linux, UNIX, and 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

The following set of DEFAULTS parameters are for 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

NoteNote:

XML parameters do not affect geodatabases on DB2 for z/OS, since XML is not supported for these geodatabases at this time.

Related Topics


8/19/2013