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:
-
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.
Note:The ArcSDE administrator can still connect to the geodatabase even when it is paused.
- At an MS-DOS command prompt (Windows) or shell prompt (UNIX/Linux), type the sdemon command with the pause operation.
Related Topics
8/19/2013