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

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

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