Altering the contents of the DBTUNE table

If you want to alter the contents of the DBTUNE table—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.

To obtain the sdedbtune command, download the ArcSDE application server installation from the Esri Customer Care portal. This installation includes the administration command line tools, as well as the command line tool documentation. See the command line tool documentation for syntax, definitions, and examples.

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.

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.

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, it is easier to export, edit, then import the contents of the DBTUNE table. The following are the steps to accomplish this.

Steps:

1. Export the DBTUNE table to a text file using the sdedbtune –o export command.
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.