Hinzufügen eines Konfigurationsschlüsselwortes zur DBTUNE-Tabelle in SQL Server für den Reviewer-Workspace

After creating the data files, modify the DBTUNE to include a new configuration keyword. Based on this new keyword, the data and database objects will be stored in the FileGroups location that was previously defined. The DBTUNE table is stored under the sde user in SQL Server. To modify the DBTUNE, it's necessary to export the DBTUNE into a text file and make modifications in the text file. After the updates to the text file are made, import the new DBTUNE from the text file.

If you only use direct connections at your site, you may not have installed ArcSDE. You need to install ArcSDE, if you haven't already, to get the sdedbtune and sdeconfig tools.

Hinweis:

Copying and pasting the examples may cause syntax errors.

Schritte:

1. Exportieren Sie die Datei "dbtune" über die Eingabeaufforderung, bevor Sie Änderungen vornehmen.

   Der <database_name> ist der localhost-Name\Instanzname.

   cd %SDEHOME%
   cd etc
   sdedbtune -o export -f dbtune_exp.sde -u sde -p sde -i sde:sqlserver:<database_name> -s <localhost> -D revdb
   

2. Kopieren Sie "dbtune_exp.sde" in "dbtune_rev.sde".
3. Ändern Sie die ##DEFAULTS-Konfigurationsschlüsselwörter mit einem dateibasierten Editor, um zu steuern, in welcher FileGroup die Tabellen und Indizes erstellt werden.
   Hinweis:

   Wenn in Ihrer Datenbank nur das Reviewer-Repository gespeichert ist, kann die Datei "dbtune_rev.sde" in einem Texteditor geöffnet werden, in dem Sie das Konfigurationsschlüsselwort "##DEFAULTS" manuell bearbeiten können. Andernfalls erstellen Sie ein neues Konfigurationsschlüsselwort anhand des folgenden Beispiels.

   dbtune_rev.sde
   
   ##DEFAULTS
   A_INDEX_RASTER	"WITH FILLFACTOR = 75 ON REV_AINDEX"
   A_INDEX_ROWID	"WITH FILLFACTOR = 75 ON REV_AINDEX"
   A_INDEX_SHAPE	"WITH FILLFACTOR = 75 ON REV_AINDEX"
   A_INDEX_STATEID	"WITH FILLFACTOR = 75 ON REV_AINDEX"
   A_INDEX_USER	"WITH FILLFACTOR = 75 ON REV_AINDEX"
   A_INDEX_XML	"WITH FILLFACTOR = 75 ON REV_AINDEX"
   A_STORAGE	"ON REV_ADATA"
   B_INDEX_RASTER	"WITH FILLFACTOR = 75 ON REV_BINDEX"
   B_INDEX_ROWID	"WITH FILLFACTOR = 75 ON REV_BINDEX"
   B_INDEX_SHAPE	"WITH FILLFACTOR = 75 ON REV_BINDEX"
   B_INDEX_TO_DATE	"WITH FILLFACTOR = 75 ON REV_BINDEX"
   B_INDEX_USER	"WITH FILLFACTOR = 75 ON REV_BINDEX"
   B_INDEX_XML	"WITH FILLFACTOR = 75 ON REV_BINDEX"
   B_STORAGE	"ON REV_BDATA"
   D_INDEX_ALL	"WITH FILLFACTOR = 75 ON REV_DINDEX"
   D_INDEX_DELETED_AT	"WITH FILLFACTOR = 75 ON REV_DINDEX"
   D_STORAGE	"ON REV_DDATA"
   F_INDEX_AREA	"WITH FILLFACTOR = 75 ON REV_FINDEX"
   F_INDEX_FID	"WITH FILLFACTOR = 75 ON REV_FINDEX"
   F_INDEX_LEN	"WITH FILLFACTOR = 75 ON REV_FINDEX"
   F_STORAGE	"ON REV_FDATA"
   GEOMETRY_STORAGE	"GEOMETRY"
   GEOMTAB_PK	"WITH FILLFACTOR = 75 ON REV_FINDEX"
   GEOMTAB_STORAGE	"ON REV_FDATA"
   I_STORAGE	"ON REV_FDATA"
   S_INDEX_ALL	"WITH FILLFACTOR = 75 ON REV_SINDEX"
   S_INDEX_SP_FID	"WITH FILLFACTOR = 75 ON REV_SINDEX"
   S_STORAGE	"ON REV_SDATA"
   END
   

4. Importieren Sie die Datei "dbtune_rev.sde" über die Eingabeaufforderung.

   sdedbtune -o import -f dbtune_rev.sde -u sde -p sde -i sde:sqlserver:<server> -s <server> -D revdb