Altering SERVER_CONFIG parameters

Use the sdeconfig command to change the values of parameters in the SERVER_CONFIG (sde_server_config in PostgreSQL and SQL Server databases) after the geodatabase has been created.

For most implementations, the SERVER_CONFIG default parameters should suffice. However, if you need to alter the value of one parameter, use the alter operation.

NoteNote:

Beginning with ArcGIS 10.1, the ArcSDE commands must be downloaded from the Esri Customer Care Portal and separately installed.

Steps:
  1. Open an MS-DOS command prompt (Windows) or shell prompt (UNIX or Linux).
  2. Type the sdeconfig command with the alter operation. Specify the parameter name and new value using the –v option.
    sdeconfig -o alter -v RASTERBUFSIZE=350000 
    -i 2222 -s myserver\sqlinstance -D mygdb -u sde
    
11/6/2014