Adding a configuration keyword to the geodatabase in PostgreSQL for the product library 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_pl.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_pl.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_pl.txt
   
   ##DATA_DICTIONARY
   B_INDEX_ROWID           "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE prodlib_sde_dict_index"
   B_INDEX_USER            "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE prodlib_sde_dict_index"
   B_STORAGE               "TABLESPACE prodlib_sde_dict"
   MVTABLES_MODIFIED_INDEX "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE prodlib_sde_dict_index"
   MVTABLES_MODIFIED_TABLE "TABLESPACE prodlib_sde_dict"
   STATE_LINEAGES_INDEX    "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE prodlib_sde_dict_index"
   STATE_LINEAGES_TABLE	"TABLESPACE prodlib_sde_dict"
   STATES_INDEX            "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE prodlib_sde_dict_index"
   STATES_TABLE		"TABLESPACE prodlib_sde_dict"
   VERSIONS_INDEX          "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE prodlib_sde_dict_index"
   VERSIONS_TABLE		"TABLESPACE prodlib_sde_dict"
   XML_INDEX_TAGS_TABLE    "TABLESPACE prodlib_sde_dict"
   XML_INDEX_TAGS_INDEX    "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE prodlib_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 prodlib_Aindex"  
   A_INDEX_STATEID	       "WITH (FILLFACTOR = 75) TABLESPACE prodlib_Aindex" 
   A_INDEX_USER           "WITH (FILLFACTOR = 75) TABLESPACE prodlib_Aindex"
   A_INDEX_XML            "WITH (FILLFACTOR = 75) TABLESPACE prodlib_Aindex"
   A_INDEX_RASTER         "WITH (FILLFACTOR = 75) TABLESPACE prodlib_Aindex"
   A_STORAGE              "TABLESPACE prodlib_Adata"
   B_INDEX_ROWID          "WITH (FILLFACTOR = 75) TABLESPACE prodlib_Bindex"
   B_INDEX_USER           "WITH (FILLFACTOR = 75) TABLESPACE prodlib_Bindex"
   B_INDEX_XML            "WITH (FILLFACTOR = 75) TABLESPACE prodlib_Bindex"
   B_INDEX_RASTER         "WITH (FILLFACTOR = 90) TABLESPACE prodlib_Bindex"
   B_INDEX_TO_DATE        "WITH (FILLFACTOR = 75) TABLESPACE prodlib_Bindex"
   B_STORAGE              "TABLESPACE prodlib_Bdata"
   D_INDEX_ALL            "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE prodlib_Dindex"
   D_INDEX_DELETED_AT     "WITH (FILLFACTOR = 75) TABLESPACE prodlib_Dindex"
   D_STORAGE              "TABLESPACE prodlib_Ddata"
   RAS_STORAGE            "TABLESPACE prodlib_Bdata"
   RAS_INDEX_ID           "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE prodlib_Bindex"
   BND_STORAGE            "TABLESPACE prodlib_Bdata"
   BND_INDEX_ID           "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE prodlib_Bindex"
   BND_INDEX_COMPOSITE    "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE prodlib_Bindex"
   AUX_STORAGE            "TABLESPACE prodlib_Bdata"
   AUX_INDEX_COMPOSITE    "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE prodlib_Bindex"
   BLK_STORAGE            "TABLESPACE prodlib_Bdata"
   BLK_INDEX_COMPOSITE    "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE prodlib_Bindex"
   XML_DOC_INDEX          "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE prodlib_Bindex"
   XML_DOC_STORAGE        "TABLESPACE prodlib_Bdata"
   #XML_DOC_UNCOMPRESSED_TYPE  "BINARY"
   XML_IDX_INDEX_DOUBLE   "WITH (FILLFACTOR = 75) TABLESPACE prodlib_Bindex"
   XML_IDX_INDEX_ID       "WITH (FILLFACTOR = 75) TABLESPACE prodlib_Bindex"
   XML_IDX_INDEX_PK       "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE prodlib_Bindex"
   XML_IDX_INDEX_STRING   "WITH (FILLFACTOR = 75) TABLESPACE prodlib_Bindex"
   XML_IDX_INDEX_TAG      "WITH (FILLFACTOR = 75) TABLESPACE prodlib_Bindex"
   XML_IDX_STORAGE        "TABLESPACE prodlib_Bindex"
   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
   

4. Import the modified dbtune_pl.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_pl.txt, and click Open.
   6. Click OK on the Import Geodatabase Configuration Keywords dialog box.