Available with Production Mapping license.
After data files have been created, the DBTUNE table needs to be updated to include a new configuration keyword. The configuration keyword specifies the table spaces that store the data for the workspace. Follow the steps below to add a new configuration keyword to the DBTUNE table.
-
Export the DBTUNE table before making any modifications.
- Start ArcCatalog.
- Click the ArcToolbox button
on the Standard toolbar.
- Expand Data Management Tools > Geodatabase Administration.
- Double-click Export Geodatabase Configuration Keywords.
The Export Geodatabase Configuration Keywords dialog box appears.
- Click the browse button for the Input Database Connection parameter and browse to the connection file for the enterprise, workgroup, or desktop geodatabase you want to export.
- Click the browse button for the Output File parameter and browse to the path you want to export the file to.
- Name the file dbtune_exp.txt and click Save.
- Click OK on the Export Geodatabase Configuration Keywords dialog box.
- Make a copy of dbtune_exp.txt to dbtune_pm.txt.
- Using a file-based editor, modify the DBTUNE ##DEFAULTS configuration keywords to specify the tablespaces to create the tables and indexes in.
dbtune_pm.txt ##DATA_DICTIONARY B_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_sde_dict_index" B_INDEX_USER "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_sde_dict_index" B_STORAGE "TABLESPACE pm_sde_dict" MVTABLES_MODIFIED_INDEX "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_sde_dict_index" MVTABLES_MODIFIED_TABLE "TABLESPACE pm_sde_dict" STATE_LINEAGES_INDEX "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_sde_dict_index" STATE_LINEAGES_TABLE "TABLESPACE pm_sde_dict" STATES_INDEX "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_sde_dict_index" STATES_TABLE "TABLESPACE pm_sde_dict" VERSIONS_INDEX "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_sde_dict_index" VERSIONS_TABLE "TABLESPACE pm_sde_dict" XML_INDEX_TAGS_TABLE "TABLESPACE pm_sde_dict" XML_INDEX_TAGS_INDEX "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_sde_dict_index" END ##DEFAULTS GEOMETRY_STORAGE "ST_GEOMETRY" RASTER_STORAGE "BINARY" UI_TEXT "User Interface text for DEFAULTS" A_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Aindex" A_INDEX_STATEID "WITH (FILLFACTOR = 75) TABLESPACE pm_Aindex" A_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Aindex" A_INDEX_XML "WITH (FILLFACTOR = 75) TABLESPACE pm_Aindex" A_INDEX_RASTER "WITH (FILLFACTOR = 75) TABLESPACE pm_Aindex" A_STORAGE "TABLESPACE pm_Adata" B_INDEX_ROWID "WITH (FILLFACTOR = 75) TABLESPACE pm_Bindex" B_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Bindex" B_INDEX_XML "WITH (FILLFACTOR = 75) TABLESPACE pm_Bindex" B_INDEX_RASTER "WITH (FILLFACTOR = 90) TABLESPACE pm_Bindex" B_INDEX_TO_DATE "WITH (FILLFACTOR = 75) TABLESPACE pm_Bindex" B_STORAGE "TABLESPACE pm_Bdata" D_INDEX_ALL "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Dindex" D_INDEX_DELETED_AT "WITH (FILLFACTOR = 75) TABLESPACE pm_Dindex" D_STORAGE "TABLESPACE pm_Ddata" RAS_STORAGE "TABLESPACE pm_Raster" RAS_INDEX_ID "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE pm_Raster_index" BND_STORAGE "TABLESPACE pm_Raster" BND_INDEX_ID "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE pm_Raster_index" BND_INDEX_COMPOSITE "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE pm_Raster_index" AUX_STORAGE "TABLESPACE pm_Raster" AUX_INDEX_COMPOSITE "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE pm_Raster_index" BLK_STORAGE "TABLESPACE pm_Raster_Blk" BLK_INDEX_COMPOSITE "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE pm_Raster_Blk_index" XML_DOC_INDEX "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Xml_index" XML_DOC_STORAGE "TABLESPACE pm_Xml_doc" #XML_DOC_UNCOMPRESSED_TYPE "BINARY" XML_IDX_INDEX_DOUBLE "WITH (FILLFACTOR = 75) TABLESPACE pm_Xml_index" XML_IDX_INDEX_ID "WITH (FILLFACTOR = 75) TABLESPACE pm_Xml_index" XML_IDX_INDEX_PK "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Xml_index" XML_IDX_INDEX_STRING "WITH (FILLFACTOR = 75) TABLESPACE pm_Xml_index" XML_IDX_INDEX_TAG "WITH (FILLFACTOR = 75) TABLESPACE pm_Xml_index" XML_IDX_STORAGE "TABLESPACE pm_Xml_index" XML_IDX_FULLTEXT_UPDATE_METHOD "AUTOMATIC" #XML_COLUMN_STORAGE - "SDE_XML" or "DB_XML" #XML_COLUMN_STORAGE "DB_XML" END ##DEFAULTS_ARCHIVE GEOMETRY_STORAGE "ST_GEOMETRY" RASTER_STORAGE "BINARY" UI_TEXT "User Interface text for DEFAULTS" A_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Aindex" A_INDEX_STATEID "WITH (FILLFACTOR = 75) TABLESPACE pm_Aindex" A_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Aindex" A_INDEX_XML "WITH (FILLFACTOR = 75) TABLESPACE pm_Aindex" A_INDEX_RASTER "WITH (FILLFACTOR = 75) TABLESPACE pm_Aindex" A_STORAGE "TABLESPACE pm_Adata" B_INDEX_ROWID "WITH (FILLFACTOR = 75) TABLESPACE pm_Archive_Bindex" B_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Archive_Bindex" B_INDEX_XML "WITH (FILLFACTOR = 75) TABLESPACE pm_Archive_Bindex" B_INDEX_RASTER "WITH (FILLFACTOR = 90) TABLESPACE pm_Archive_Bindex" B_INDEX_TO_DATE "WITH (FILLFACTOR = 75) TABLESPACE pm_Archive_Bindex" B_STORAGE "TABLESPACE pm_Archive_Bdata" D_INDEX_ALL "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Dindex" D_INDEX_DELETED_AT "WITH (FILLFACTOR = 75) TABLESPACE pm_Dindex" D_STORAGE "TABLESPACE pm_Ddata" RAS_STORAGE "TABLESPACE pm_Raster" RAS_INDEX_ID "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE pm_Raster_index" BND_STORAGE "TABLESPACE pm_Raster" BND_INDEX_ID "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE pm_Raster_index" BND_INDEX_COMPOSITE "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE pm_Raster_index" AUX_STORAGE "TABLESPACE pm_Raster" AUX_INDEX_COMPOSITE "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE pm_Raster_index" BLK_STORAGE "TABLESPACE pm_Raster_Blk" BLK_INDEX_COMPOSITE "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE pm_Raster_Blk_index" XML_DOC_INDEX "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Xml_index" XML_DOC_STORAGE "TABLESPACE pm_Xml_doc" #XML_DOC_UNCOMPRESSED_TYPE "BINARY" XML_IDX_INDEX_DOUBLE "WITH (FILLFACTOR = 75) TABLESPACE pm_Xml_index" XML_IDX_INDEX_ID "WITH (FILLFACTOR = 75) TABLESPACE pm_Xml_index" XML_IDX_INDEX_PK "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Xml_index" XML_IDX_INDEX_STRING "WITH (FILLFACTOR = 75) TABLESPACE pm_Xml_index" XML_IDX_INDEX_TAG "WITH (FILLFACTOR = 75) TABLESPACE pm_Xml_index" XML_IDX_STORAGE "TABLESPACE pm_Xml_index" XML_IDX_FULLTEXT_UPDATE_METHOD "AUTOMATIC" #XML_COLUMN_STORAGE - "SDE_XML" or "DB_XML" #XML_COLUMN_STORAGE "DB_XML" END ##PG_GEOMETRY GEOMETRY_STORAGE "PG_GEOMETRY" UI_TEXT "User Interface text description" END ##LOGFILE_DEFAULTS LD_INDEX_ALL "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_sde_log_index " LD_STORAGE "TABLESPACE pm_sde_log" LF_INDEX_ID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_sde_log_index " LF_INDEX_NAME "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_sde_log_index " LF_STORAGE "TABLESPACE pm_sde_log" SESSION_INDEX "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_sde_log_index " SESSION_STORAGE "TABLESPACE pm_sde_log" SESSION_TEMP_TABLE 1 END ##NETWORK_DEFAULTS UI_NETWORK_TEXT "The network default configuration" COMMENT "The base system initialization parameters for NETWORK_DEFAULTS" A_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Net_Aindex" A_INDEX_STATEID "WITH (FILLFACTOR = 75) TABLESPACE pm_Net_Aindex" A_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Net_Aindex" A_STORAGE "TABLESPACE pm_Net_Adata" B_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Net_Bindex" B_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Net_Bindex" B_STORAGE "TABLESPACE pm_Net_Bdata" D_INDEX_ALL "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Net_Dindex" D_INDEX_DELETED_AT "WITH (FILLFACTOR = 75) TABLESPACE pm_Net_Dindex" D_STORAGE "TABLESPACE pm_Net_Ddata" END ##NETWORK_DEFAULTS::DESC A_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Net_Aindex" A_INDEX_STATEID "WITH (FILLFACTOR = 75) TABLESPACE pm_Net_Aindex" A_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Net_Aindex" A_STORAGE "TABLESPACE pm_Net_Adata" B_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Net_Bindex" B_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Net_Bindex" B_STORAGE "TABLESPACE pm_Net_Bdata" D_INDEX_ALL "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Net_Dindex" D_INDEX_DELETED_AT "WITH (FILLFACTOR = 75) TABLESPACE pm_Net_Dindex" D_STORAGE "TABLESPACE pm_Net_Ddata" END ##NETWORK_DEFAULTS::NETWORK A_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Net_Aindex" A_INDEX_STATEID "WITH (FILLFACTOR = 75) TABLESPACE pm_Net_Aindex" A_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Net_Aindex" A_STORAGE "TABLESPACE pm_Net_Adata" B_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Net_Bindex" B_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Net_Bindex" B_STORAGE "TABLESPACE pm_Net_Bdata" D_INDEX_ALL "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Net_Dindex" D_INDEX_DELETED_AT "WITH (FILLFACTOR = 75) TABLESPACE pm_Net_Dindex" D_STORAGE "TABLESPACE pm_Net_Ddata" END ##TOPOLOGY_DEFAULTS A_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Topo_Aindex" A_INDEX_STATEID "WITH (FILLFACTOR = 75) TABLESPACE pm_Topo_Aindex" A_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Topo_Aindex" A_STORAGE "TABLESPACE pm_Topo_Adata" B_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Topo_Bindex" B_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Topo_Bindex" B_STORAGE "TABLESPACE pm_Topo_Bdata" D_INDEX_ALL "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Topo_Dindex" D_INDEX_DELETED_AT "WITH (FILLFACTOR = 75) TABLESPACE pm_Topo_Dindex" D_STORAGE "TABLESPACE pm_Topo_Ddata" END ##TOPOLOGY_DEFAULTS::DIRTYAREAS A_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Topo_Aindex" A_INDEX_STATEID "WITH (FILLFACTOR = 75) TABLESPACE pm_Topo_Aindex" A_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Topo_Aindex" A_STORAGE "TABLESPACE pm_Topo_Adata" B_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Topo_Bindex" B_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Topo_Bindex" B_STORAGE "TABLESPACE pm_Topo_Bdata" D_INDEX_ALL "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Topo_Dindex" D_INDEX_DELETED_AT "WITH (FILLFACTOR = 75) TABLESPACE pm_Topo_Dindex" D_STORAGE "TABLESPACE pm_Topo_Ddata" END ##TERRAIN_DEFAULTS UI_TERRAIN_TEXT "The terrain default configuration" A_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Terrain_Aindex" A_INDEX_STATEID "WITH (FILLFACTOR = 75) TABLESPACE pm_Terrain_Aindex" A_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Terrain_Aindex" A_STORAGE "TABLESPACE pm_Terrain_Adata" B_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Terrain_Bindex" B_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Terrain_Bindex" B_STORAGE "TABLESPACE pm_Terrain_Bdata" D_INDEX_ALL "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Terrain_Dindex" D_INDEX_DELETED_AT "WITH (FILLFACTOR = 75) TABLESPACE pm_Terrain_Dindex" D_STORAGE "TABLESPACE pm_Terrain_Ddata" END ##TERRAIN_DEFAULTS::EMBEDDED A_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Terrain_Aindex" A_INDEX_STATEID "WITH (FILLFACTOR = 75) TABLESPACE pm_Terrain_Aindex" A_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Terrain_Aindex" A_STORAGE "TABLESPACE pm_Terrain_Adata" B_INDEX_ROWID "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Terrain_Bindex" B_INDEX_USER "WITH (FILLFACTOR = 75) TABLESPACE pm_Terrain_Bindex" B_STORAGE "TABLESPACE pm_Terrain_Bdata" D_INDEX_ALL "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE pm_Terrain_Dindex" D_INDEX_DELETED_AT "WITH (FILLFACTOR = 75) TABLESPACE pm_Terrain_Dindex" D_STORAGE "TABLESPACE pm_Terrain_Ddata" END
- Import the modified dbtune_pm.txt file using ArcCatalog or ArcMap.
- In the ArcToolbox window, expand Data Management Tools > Geodatabase Administration.
- Double-click Import Geodatabase Configuration Keywords.
The Import Geodatabase Configuration Keywords dialog box appears.
- Click the browse button next to the Input Database Connection parameter, and browse to the path where the file will be imported.
- Click the browse button for the Input File parameter, and browse to the path where the file will be imported.
- Name the file dbtune_pm.txt, and click Open.
- Click OK on the Import Geodatabase Configuration Keywords dialog box.