Adding a configuration keyword to the DBTUNE table in SQL Server for the BIS workspace (Bathymetry Solution)

在创建数据文件之后，修改 DBTUNE 以加入新的配置关键字。根据此新关键字，数据和数据库对象将存储在之前定义的文件组位置中。DBTUNE 表存储在 SQL Server 中的 sde 用户下。要修改 DBTUNE，有必要将 DBTUNE 导出至文本文件中，并在文本文件中进行修改。在对文本文件进行更新后，从文本文件中导入新的 DBTUNE。

如果您只在您的站点上使用直接连接，那么您可能尚未安装 ArcSDE。需要安装 ArcSDE，如果尚未安装，则应获取 sdedbtune 和 sdeconfig 工具。

注:

对示例进行复制和粘贴可能会导致语法错误。

步骤:

1. From the command prompt, export the dbtune file before making any modifications.

   The <sql_server_instance_name> is the same as the SQL Server server name for a default instance of SQL Server and <server name>\<instance> for a named instance of SQL Server.

   cd %SDEHOME%
       cd etc
       sdedbtune -o export -f dbtune_exp.sde -u sde -p sde -i sde:sqlserver:<sql_server_instance_name> -s <server> -D bisdb
   

2. Copy dbtune_exp.sde to dbtune_bis.sde.
3. Using a file-based editor, modify the ##DEFAULTS configuration keywords to control in which FileGroup the tables and indexes will be created.

   If your database only stores the BIS repository, the dbtune_bis.sde file can be opened in a text editor where you can manually edit the ##DEFAULTS configuration keyword; otherwise, create a new configuration keyword using the following example.

   dbtune_bis.sde
   
   ##DEFAULTS
   A_CLUSTER_RASTER           0
   A_CLUSTER_ROWID            0
   A_CLUSTER_SHAPE            1
   A_CLUSTER_STATEID          0
   A_CLUSTER_USER             0
   A_CLUSTER_XML              0
   A_INDEX_RASTER             "WITH FILLFACTOR = 75 ON BIS_AINDEX"
   A_INDEX_ROWID              "WITH FILLFACTOR = 75 ON BIS_AINDEX"
   A_INDEX_SHAPE              "WITH FILLFACTOR = 75 ON BIS_AINDEX"
   A_INDEX_STATEID            "WITH FILLFACTOR = 75 ON BIS_AINDEX"
   A_INDEX_USER               "WITH FILLFACTOR = 75 ON BIS_AINDEX"
   A_INDEX_XML                "WITH FILLFACTOR = 75 ON BIS_AINDEX"
   A_MS_SPINDEX               "GRIDS = (MEDIUM, MEDIUM, MEDIUM, MEDIUM), CELLS_PER_OBJECT = 16"
   A_OUT_OF_ROW               0
   A_STORAGE                  "ON BIS_ADATA"
   AUX_CLUSTER_COMPOSITE      1
   AUX_INDEX_COMPOSITE        "WITH FILLFACTOR = 75 ON BIS_RASTER_INDEX"
   AUX_STORAGE                "ON BIS_RASTER"
   B_CLUSTER_RASTER           0
   B_CLUSTER_ROWID            0
   B_CLUSTER_SHAPE            1
   B_CLUSTER_TO_DATE          0
   B_CLUSTER_USER             0
   B_CLUSTER_XML              0
   B_INDEX_RASTER             "WITH FILLFACTOR = 75 ON BIS_BINDEX"
   B_INDEX_ROWID              "WITH FILLFACTOR = 75 ON BIS_BINDEX"
   B_INDEX_SHAPE              "WITH FILLFACTOR = 75 ON BIS_BINDEX"
   B_INDEX_TO_DATE            "WITH FILLFACTOR = 75 ON BIS_BINDEX"
   B_INDEX_USER               "WITH FILLFACTOR = 75 ON BIS_BINDEX"
   B_INDEX_XML                "WITH FILLFACTOR = 75 ON BIS_BINDEX"
   B_MS_SPINDEX               "GRIDS = (MEDIUM, MEDIUM, MEDIUM, MEDIUM), CELLS_PER_OBJECT = 16"
   B_OUT_OF_ROW               0
   B_STORAGE                  "ON BIS_BDATA"
   BLK_CLUSTER_COMPOSITE      1
   BLK_INDEX_COMPOSITE        "WITH FILLFACTOR = 75 ON BIS_RASTER_INDEX"
   BLK_OUT_OF_ROW             0
   BLK_STORAGE                "ON BIS_RASTER"
   BND_CLUSTER_COMPOSITE      0
   BND_CLUSTER_ID             0
   BND_INDEX_COMPOSITE        "WITH FILLFACTOR = 75 ON BIS_RASTER_INDEX"
   BND_INDEX_ID               "WITH FILLFACTOR = 75 ON BIS_RASTER_INDEX"
   BND_STORAGE                "ON BIS_RASTER"
   COLLATION_NAME             ""
   CROSS_DB_QUERY_FILTER      0
   D_CLUSTER_ALL              0
   D_CLUSTER_DELETED_AT       1
   D_INDEX_ALL                "WITH FILLFACTOR = 75 ON BIS_DINDEX"
   D_INDEX_DELETED_AT         "WITH FILLFACTOR = 75 ON BIS_DINDEX"
   D_STORAGE                  "ON BIS_DDATA"
   F_CLUSTER_FID              1
   F_INDEX_AREA               "WITH FILLFACTOR = 75 ON BIS_FINDEX"
   F_INDEX_FID                "WITH FILLFACTOR = 75 ON BIS_FINDEX"
   F_INDEX_LEN                "WITH FILLFACTOR = 75 ON BIS_FINDEX"
   F_OUT_OF_ROW               0
   F_STORAGE                  "ON BIS_FDATA"
   GEOM_SRID_CHECK            1
   GEOMETRY_STORAGE           "GEOMETRY"
   GEOMTAB_OUT_OF_ROW         0
   GEOMTAB_PK                 "WITH FILLFACTOR = 75 ON BIS_FINDEX"
   GEOMTAB_STORAGE            "ON BIS_FDATA"
   I_STORAGE                  "ON BIS_FDATA"
   NUM_DEFAULT_CURSORS        -1
   PERMISSION_CACHE_THRESHOLD 250
   RAS_CLUSTER_ID             1
   RAS_INDEX_ID               "WITH FILLFACTOR = 75 ON BIS_RASTER_INDEX"
   RAS_STORAGE                "ON BIS_RASTER"
   RASTER_STORAGE             "BINARY"
   S_CLUSTER_ALL              1
   S_CLUSTER_SP_FID           0
   S_INDEX_ALL                "WITH FILLFACTOR = 75 ON BIS_SINDEX"
   S_INDEX_SP_FID             "WITH FILLFACTOR = 75 ON BIS_SINDEX"
   S_STORAGE                  "ON BIS_SDATA"
   UI_TEXT                    "User Interface text for DEFAULTS"
   UNICODE_STRING             "TRUE"
   XML_COLUMN_STORAGE         "DB_XML"
   XML_DOC_INDEX              "WITH FILLFACTOR = 75 ON BIS_XMLDOCINDEX"
   XML_DOC_OUT_OF_ROW         0
   XML_DOC_STORAGE            "ON BIS_XMLDOC"
   XML_DOC_UNCOMPRESSED_TYPE  "BINARY"
   XML_IDX_CLUSTER_DOUBLE     0
   XML_IDX_CLUSTER_ID         0
   XML_IDX_CLUSTER_PK         1
   XML_IDX_CLUSTER_STRING     0
   XML_IDX_CLUSTER_TAG        0
   XML_IDX_FULLTEXT_CAT       "SDE_DEFAULT_CAT"
   XML_IDX_FULLTEXT_LANGUAGE  ""
   XML_IDX_FULLTEXT_TIMESTAMP 1
   XML_IDX_FULLTEXT_UPDATE_METHOD "CHANGE_TRACKING BACKGROUND"
   XML_IDX_INDEX_DOUBLE       "WITH FILLFACTOR = 75 ON BIS_XMLDOCINDEX"
   XML_IDX_INDEX_ID           "WITH FILLFACTOR = 75 ON BIS_XMLDOCINDEX"
   XML_IDX_INDEX_PK           "WITH FILLFACTOR = 75 ON BIS_XMLDOCINDEX"
   XML_IDX_INDEX_STRING       "WITH FILLFACTOR = 75 ON BIS_XMLDOCINDEX"
   XML_IDX_INDEX_TAG          "WITH FILLFACTOR = 75 ON BIS_XMLDOCINDEX"
   XML_IDX_OUT_OF_ROW         0
   XML_IDX_STORAGE            "ON BIS_XMLDOCINDEX"
   END
   

4. From the command prompt, import the modified dbtune_bis.sde file.

   sdedbtune -o import -f dbtune_bis.sde -u sde -p sde -i sde:sqlserver:<sql_server_instance_name> -s <server> -D bisdb