Preventing users from connecting to a geodatabase

You can use the sdemon command to pause the geodatabase. Doing so alters the value of the STATUS parameter in the sde_server_config table, changing the STATUS to 2 (paused), thereby preventing new connections from being made to the geodatabase.

The syntax for the sdemon command with the pause operation is as follows:

sdemon –o pause {[–i <service> | <port#>] [–s <server_name>] | [–H <sde_directory>]}
[–p <ArcSDE_admin_password>]

Contents in brackets ( [ ] ) are optional. See the sdemon command in the ArcSDE Administration Command reference for more information.

Steps:
  1. Use one of the following methods to prevent users from connecting to the geodatabase.
    • At an MS-DOS command prompt (Windows) or shell prompt (UNIX/Linux), type the sdemon command with the pause operation.
      sdemon –o pause –p nevermind –s squirrel –i 6543 
      
      ArcSDE I/O Manager is paused, no further connections will be allowed
    • Use the sdeconfig command to alter the CONNECTIONS value, setting it to a value low enough so only the existing connections remain.
      sdeconfig -o alter -v CONNECTIONS=1
      -i sde:sqlserver:server1\ssdb -s server1 -D mygdb
      -u sde -p ykaens

    When another user tries to make a connection, the message "Maximum number of connections to instance exceeded" is returned, and the connection is denied.

    NoteNote:

    The ArcSDE administrator can still connect to the geodatabase even when it is paused.

Related Topics


11/18/2013