sdeconfig

The sdeconfig command manages the server configuration file and the contents of the SERVER_CONFIG table (sde_server_config in SQL Server and PostgreSQL databases).

Usage syntax

sdeconfig -o alter -v <parameter_Name=Value,...>
[-i {<service> | <port#> | <direct connection>}]
[-s <server_name>] [-D <database_name>] [-N] [-q]
-u <ArcSDE_admin_user> [-p <ArcSDE_admin_password>]

sdeconfig -o import -f <SERVER_Info file>
[-i {<service> | <port#> | <direct connection>}]
[-s <server_name>] [-D <database_name>] [-N] [-q]
-u <ArcSDE_admin_user> [-p <ArcSDE_admin_password>]

sdeconfig -o export -f <SERVER_Info file>
[-i {<service> | <port#> | <direct connection>}]
[-s <server_name>] [-D <database_name>]
-u <DB_user_name> [-p <DB_user_password>] [-N] [-q]

sdeconfig -o list [-P <parameter_Name>]
[-i {<service> | <port#> | <direct connection>}]
[-s <server_name>] [-D <database_name>]
-u <DB_user_name> [-p <DB_user_password>] [-N] [-q]

sdeconfig -h

sdeconfig -?

Operations

Operation	Description	Examples
import	Imports the entire configuration file into the SERVER_CONFIG (or sde_server_config) table for the specified database, replacing the existing contents	Import the configuration file
export	Exports the entire contents of the SERVER_CONFIG (or sde_server_config) table to the specified configuration file	Export contents of the SERVER_CONFIG table
list	Lists the value of a specified server configuration parameter	List parameter values
alter	Alters the value of the specified configuration parameter	Alter the parameters in the SERVER_CONFIG table

Options

Options	Description
-D	Database name (not supported in Oracle)
-f	The path to and name of the server configuration file
-h or -?	Use either of these options to see the usage and options for the command. Note: If using a C shell, use -h or "-\?".
-i	ArcSDE service name, port number, or direct connection information (default: esri_sde or 5151)
-s	ArcSDE server host name (default: localhost)
-N	No verification is performed; the operation begins immediately after being invoked.
-o	Operation
-p	DBMS user password for ArcSDE administrator (for list and export, can be password of a nonadministrative DBMS user.)
-P	The name of a server configuration parameter to be listed
-q	Quiet—all titles and warnings are suppressed.
-u	DBMS user name for ArcSDE administrator (for list and export, can be a nonadministrative DBMS user)
-v	The value to assign to a server configuration parameter formatted as <property name>=<value>

Discussion

The sdeconfig command allows you to edit and view the values of the server configuration parameters that are stored in the SERVER_CONFIG table. The server configuration parameters are read by client applications upon connection to an ArcSDE server. They are not reread until the application connects again.

Use the export operation to write the parameters to a file. The values of the parameters can be edited using an ASCII text editor. Use the import operation to write the parameters back to the SERVER_CONFIG table. The alter operation allows you to change a single server configuration parameter value. The list operation displays the value of a specified parameter.

The following table lists the default values that will be written to the file if you have not altered any of the parameter values.

Parameter name	Default value	Units
ALLOWSESSIONLOGFILE	Oracle, DB2, Informix, and PostgreSQL = FALSE SQL Server = TRUE
ATTRBUFSIZE	50,000	(100 rows with 500 bytes of attribute data each)
AUTOCOMMIT	1,000	updates
AUTH_KEY	No default value; value assigned during geodatabase postinstallation setup
BLOBMEM	1,000,000
CONNECTIONS (change requires restart of ArcSDE service)	48	connections
DEFAULTPRECISION	64	bit
DETECT8XNULLSHAPE (Oracle only)	FALSE
DISABLEAUTOREG (not used with SQL Server)	TRUE
ERRLOGMODE	TIC
HOLDLOGPOOLTABLES	TRUE
INT64TYPES	TRUE
LARGEIDBLOCK	0
LAYERAUTOLOCKING	FALSE
LOGFILEPOOLSIZE	0
MAXARRAYBYTES	550,000	array bytes
MAXARRAYSIZE	100	rows
MAXBLOBSIZE	-1 (SE_UNLIMITED_BLOBSIZE)	bytes
MAXBUFSIZE	65536	bytes
MAXDISTINCT	512
MAXGRIDSPERFEAT	8,000	grids
MAXINITIALFEATS	10,000	features
MAXSTANDALONELOGS	0
MAXTIMEDIFF	1,800	seconds
MINBUFOBJECTS	512	rows
MINBUFSIZE	16384	bytes
PRECISION10 (Oracle only - deprecated)	FALSE
PROCSTATS	-1
RASTERBUFSIZE	204,800	bytes
READONLY	FALSE
SHAPEPTSBUFSIZE	400,000	bytes
SMALLIDBLOCK	16
STATEAUTOLOCKING	FALSE
STATUS	1
STREAMPOOLSIZE	6	allocated stream resources
TCPKEEPALIVE	FALSE
TEMP	\tmp
THRESHOLD (not used with SQL Server)	0
TLMINTERVAL	1
TRIMLOCKINGTYPE (Oracle only)	ONLY DURING COMPRESS

For further explanation of settings for configuration parameters, see the ArcGIS Desktop or ArcGIS Server help. Search for the topic "ArcSDE initialization parameters".

Examples

Alter the parameters in the SERVER_CONFIG table

Rather than export and import all the configuration parameters, the alter operation allows you to edit the values of a list of one or more parameters. The -v option requires that the parameter name be followed directly by the equal sign and the value. There must not be any white space surrounding the equal sign; if there is, a syntax error will result.

sdeconfig -o alter -u bob -p cat -N -q -v procstats=5

Successfully altered SERVER_CONFIG Table.

Export contents of SERVER_CONFIG table

The export operation exports the entire contents of the SERVER_CONFIG table to the specified configuration file.

sdeconfig -o export -u bob -p cat -f config.txt -N -q

Successfully exported to file config.txt on server jolex

Note: You don't need administrative privileges to export the SERVER_CONFIG table.

Import the configuration file

The import operation allows you to import the parameters listed in a configuration file to the SERVER_CONFIG table. The contents of the table are completely replaced by the contents of the file. If the file does not contain a parameter, a default value is inserted for the missing parameter. While reading the file, if a parameter is encountered that is not recognized, the parameter is ignored. Therefore, misspelled parameter names will be ignored.

sdeconfig -o import -u sde -p sde -f config.txt -N -q

Successfully imported SERVER_CONFIG Table.

List parameter values

Using the list operation, you either list all the parameter values of the SERVER_CONFIG table or just one. If the parameter cannot be found, you will receive a warning that the parameter does not exist and a list of all the parameters contained within the table. The example below lists the value for parameter PROCSTATS.

sdeconfig -o list -u bob -p cat -N -q -P procstats

PROCSTATS -1

Note: Any DBMS user can run the list operation.

Home