What are DBTUNE configuration keywords and parameters?

Configuration keywords are words or phrases that are used to group together parameters and parameter values (called config_strings in the SDE_dbtune table). The parameters and their associated values specify how data and database objects, such as tables, indexes, feature classes, network classes, and raster columns, are stored in the database.

Configuration keywords and parameters always go together; you cannot specify just a parameter without its keyword, and a keyword that contains no parameters is useless.

Configuration keywords provide a convenient way to define multiple storage settings at once. One configuration keyword groups together multiple parameters. By specifying a particular keyword, you are actually specifying the whole group of parameters and settings grouped under the keyword.

You specify a configuration keyword in the following situations:

ArcSDE searches the SDE_dbtune table for the specified configuration keyword. Then it reads the parameter name–value pairs associated with the specified configuration keyword. The necessary configuration strings are incorporated in the CREATE TABLE or CREATE INDEX statement ArcSDE submits to the database.

The DBTUNE table is populated with default configuration keywords and parameters when the geodatabase is created. New keywords can be created, values for existing parameters can be altered, and keywords and parameters can be removed from the table using the sdedbtune administration command. To obtain an installation of the ArcSDE administration commands and their documentation, contact Esri Customer Service.

Unlike configuration keywords, which you can create yourself, there are specific, standard parameter names and values you must use; you cannot invent new ones. However, most parameters have multiple values you can use. See SQL Server DBTUNE configuration parameters for a list and descriptions of valid configuration parameters.

Related Topics

8/21/2013