Adding a configuration keyword to the geodatabase in PostgreSQL for the Production Mapping workspace

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.

1. Export the DBTUNE table before making any modifications.
   1. Start ArcCatalog.

      Tip:

      You can also export using ArcMap.

   2. Click the ArcToolbox button on the Standard toolbar.
   3. Expand Data Management Tools > Geodatabase Administration.
   4. Double-click Export Geodatabase Configuration Keywords.

      The Export Geodatabase Configuration Keywords dialog box appears.

   5. 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.
   6. Click the browse button for the Output File parameter and browse to the path you want to export the file to.
   7. Name the file dbtune_exp.txt and click Save.
   8. Click OK on the Export Geodatabase Configuration Keywords dialog box.
2. Make a copy of dbtune_exp.txt to dbtune_pm.txt.
3. Using a file-based editor, modify the DBTUNE ##DEFAULTS configuration keywords to specify the tablespaces to create the tables and indexes in.

   Note:

   • If your database only stores the product library repository, the dbtune_pm.txt file can be opened in a text editor and manually edited; otherwise, create a new configuration keyword (##PRODLIB) using the following DBTUNE ##DEFAULTS example.
   • Copying and pasting the examples may cause syntax errors.

   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
   

4. Import the modified dbtune_pm.txt file using ArcCatalog or ArcMap.
   1. In the ArcToolbox window, expand Data Management Tools > Geodatabase Administration.
   2. Double-click Import Geodatabase Configuration Keywords.

      The Import Geodatabase Configuration Keywords dialog box appears.

   3. Click the browse button next to the Input Database Connection parameter, and browse to the path where the file will be imported.
   4. Click the browse button for the Input File parameter, and browse to the path where the file will be imported.
   5. Name the file dbtune_pm.txt, and click Open.
   6. Click OK on the Import Geodatabase Configuration Keywords dialog box.