ArcSDE DBTUNE File & Configuration

ArcSDE DBTUNE File & Configuration

ArcSDE optimization and configuration through its parameters can achieve through dbtune.sde file configuration before or after ArcSDE post installation. Dbtune file can be found under the SDEHOME/etc directory, contains the default object storage parameters for ArcSDE geodatabases. We can specify the configuration parameters to optimize the ArcSDE installation as per the requirement when we executes the ArcSDE sdesetup command or ArcSDE Post installation wizard. If a DBA forgot to define the ArcSDE SDE configuration parameters post installation wizard or command will gets execute with default values.

All these configurations gets updated or stored in ArcSDE DBTUNE table. From time to time as per our requirements we can update or modify the DBTUNE settings. All these settings needs to be defined in DBTUNE file and than through ArcSDE Command we can make an update in the DBTUNE table. DBTUNE table is a kind of a lookup table, whenever we create or add any data ArcSDE looks for the configuration defined in the DBTUNE table.

http://webhelp.esri.com/arcgisserver/9.3.1/java/geodatabases/dbtune