Altering the contents of the DBTUNE table after it has been created

If you want to alter the contents of the DBTUNE table after it has been created—for instance, you want to create a new configuration keyword or alter the parameters of an existing keyword— use the sdedbtune administration command. You use different operations with the sdedbtune command depending on what you want to change.

If you want to change the value of a parameter that already exists in the DBTUNE table, use the alter operation.

sdedbtune –o alter –k <configuration keyword>
–P <parameter_name> –v <configuration_string_value>
[–i <service>] [–D <database>] –u <user_name>
[–p <password>] [–N] [–q]

To delete one parameter from a parameter group or delete a configuration keyword and all its parameters, you must use the delete_data operation. Before deleting a configuration keyword, be sure the keyword is truly no longer needed by other users or applications, such as an ArcIMS map service.

sdedbtune –o delete_data –k <keyword>
[–P <parameter_name>] [–i <service>] [–s <server_name>]
[–D <database>] –u <user_name> [–p <password>] [–N] [–q]

To delete one parameter from a configuration keyword, you would specify both the keyword and the parameter in the command string (provide values for both –k and –P). To delete a configuration keyword and all the parameters that are part of that keyword, you only need to specify the keyword in the command.

For ArcSDE 9.3 and later releases, if you need to add a new parameter to a keyword, use the sdedbtune command with the insert operation. This operation inserts one parameter at a time. For instance, in the following example, a UI_TEXT parameter is added to a custom keyword, RASTER:

sdedbtune -o insert -k RASTER -P UI_TEXT -v 'Use for raster data' -i 5000 -u sde

Remember that you can only insert valid configuration parameters. See the configuration parameter topic for your database management system (DBMS) for a list of valid configuration parameters.

DB2_DBTUNE_configuration_parametersInformix_DBTUNE_configuration_parametersOracle_DBTUNE_configuration_parametersPostgreSQL_DBTUNE_configuration_parametersSQL_Server_DBTUNE_configuration_parameters

If you need to add a new keyword with multiple parameters to the DBTUNE table or if you are using ArcSDE 9.1 or an earlier release, it is necessary to export, edit, then import the contents of the DBTUNE table. The following are the steps to accomplish this.

Note:

For details on using the sdedbtune command to administer the DBTUNE table, see sdedbtune or the Administration Command Reference provided with your ArcSDE component installation.

Steps:

1. Export the DBTUNE table to a text file using the sdedbtune –o export command. For ArcSDE 9.2 and later releases, you can export the contents of the DBTUNE table to a file in a directory you specify. If you do not specify a directory, the file is exported to the directory you are in when you issue the command. In ArcSDE 9.1 and earlier releases, the sdedbtune administration tool always exports the file into the etc directory of the ArcSDE home directory; you cannot relocate the file to another directory with a qualifying path.
2. Make a backup copy of your text file.
3. Edit the exported text file with a UNIX file-based editor, such as vi, or a Windows file-based editor, such as Notepad, and save your changes.
4. Import the edited file to the DBTUNE table using the sdedbtune –o import command.