The DATA_DICTIONARY keyword in DB2

The DATA_DICTIONARY keyword contains parameters that determine the storage settings for specific ArcSDE geodatabase system tables.

CautionCaution:

Changes made to the parameters in this keyword must be made before the geodatabase is created. See Altering the dbtune file before creating the geodatabase for instructions.

The following is a sample of the default entries in the dbtune.sde file for the DATA_DICTIONARY keyword in a DB2 for Linux, UNIX, or Windows database.

##DATA_DICTIONARY
B_INDEX_ROWID	 ""
B_INDEX_USER	 ""
#B_STORAGE       "IN <TABLESPACE> LONG IN <TABLESPACE>"
#STATES_TABLE    "IN <TABLESPACE>"
STATES_INDEX     ""
#STATE_LINEAGES_TABLE    "IN <TABLESPACE>"
#VERSIONS_TABLE          "IN <TABLESPACE>"
VERSIONS_INDEX           ""
#MVTABLES_MODIFIED_TABLE "IN <TABLESPACE>"
MVTABLES_MODIFIED_INDEX  ""
#XML_INDEX_TAGS_TABLE    "IN <TABLESPACE>"
XML_INDEX_TAGS_INDEX     ""
END

Uncomment the B_STORAGE, STATES_TABLE, STATE_LINEAGES_TABLE, VERSIONS_TABLE, MVTABLES_MODIFIED_TABLE, and XML_INDEX_TAGS_TABLE lines by removing the pound sign (#). Replace <TABLESPACE> in each of those lines with the name of the tablespaces in which you want the specific table and index to be stored. An altered DATA_DICTIONARY entry might look like this example:

##DATA_DICTIONARY
B_INDEX_ROWID	 ""
B_INDEX_USER	 ""
B_STORAGE       "IN SDE INDEX LONG IN SDELOBS"
#STATES_TABLE    "IN EDITS"
STATES_INDEX     ""
#STATE_LINEAGES_TABLE    "IN EDITS"
#VERSIONS_TABLE          "IN EDITS"
VERSIONS_INDEX           ""
#MVTABLES_MODIFIED_TABLE "IN EDITS"
MVTABLES_MODIFIED_INDEX  ""
#XML_INDEX_TAGS_TABLE    "IN SDE"
END

The following is a sample of the default entries in the dbtune.sde.zos file for the DATA_DICTIONARY keyword in a DB2 for z/OS database:

##DATA_DICTIONARY
B_INDEX_ROWID	 ""
B_INDEX_USER	 ""
#B_STORAGE       "IN DATABASE <REPOSITORY DATABASE NAME>"
#STATES_TABLE    "IN DATABASE <REPOSITORY DATABASE NAME>"
STATES_INDEX     ""
#STATE_LINEAGES_TABLE    "IN DATABASE <REPOSITORY DATABASE NAME>"
#VERSIONS_TABLE          "IN DATABASE <REPOSITORY DATABASE NAME>"
VERSIONS_INDEX           ""
#MVTABLES_MODIFIED_TABLE "IN DATABASE <REPOSITORY DATABASE NAME>"
MVTABLES_MODIFIED_INDEX  ""
#XML_INDEX_TAGS_TABLE    "IN DATABASE <REPOSITORY DATABASE NAME>"
XML_INDEX_TAGS_INDEX     ""
END

Uncomment the B_STORAGE, STATES_TABLE, STATE_LINEAGES_TABLE, VERSIONS_TABLE, MVTABLES_MODIFIED_TABLE, and XML_INDEX_TAGS_TABLE lines by removing the pound sign (#). Replace <REPOSITORY DATABASE NAME> in each of those lines with the name of the database in which you want the ArcSDE geodatabase system tables and indexes to be stored. An altered DATA_DICTIONARY entry might look like this example:

##DATA_DICTIONARY
B_INDEX_ROWID	 ""
B_INDEX_USER	 "IN DATABASE SDEREP"
B_STORAGE       "IN DATABASE SDEREP"
STATES_TABLE    "IN DATABASE SDEREP"
STATES_INDEX     "IN DATABASE SDEREP"
STATE_LINEAGES_TABLE    "IN DATABASE SDEREP"
VERSIONS_TABLE          "IN DATABASE SDEREP"
VERSIONS_INDEX           "IN DATABASE SDEREP"
MVTABLES_MODIFIED_TABLE "IN DATABASE SDEREP"
MVTABLES_MODIFIED_INDEX  "IN DATABASE SDEREP"
#XML_INDEX_TAGS_TABLE    "IN DATABASE <REPOSITORY DATABASE NAME>"
XML_INDEX_TAGS_INDEX     ""
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


11/18/2013