ArcGIS Server Banner

Pausing and resuming an ArcSDE service

Pausing and resuming an ArcSDE service

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

About pausing and resuming an ArcSDE service

NOTE: Applies to geodatabases created with an ArcGIS Server Enterprise license only

The ArcSDE service has three modes—running, paused, and stopped. While running mode is the productive state, there will be times when you need to pause the service or shut it down, for example, to do routine maintenance work.

When the service is running, client applications can log in and access the database.

When the service is paused, current application connections continue but additional application requests to connect are denied. This allows current users to complete work before the service shuts down. New connection attempts made after the service is paused will receive the following error message:

"Failed to connect to database.

SDE not accepting connection requests"

If you were to check the status of a paused service, the connection mode would be Paused/Block Connections.

Pausing the service also prevents new direct connections from being made to the geodatabase. This occurs because pausing the service also changes the status in the SERVER_CONFIG table to indicate the geodatabase is not accepting connections. The status is changed back when the service is resumed.

How to pause and resume an ArcSDE service

Pause and resume an ArcSDE service on Windows

  1. Open the Administrative Tools.
  2. Open the Services menu.
  3. Highlight the ArcSDE service and click the pause or restart button on the toolbar, or right-click the service and choose Pause or Restart from the context menu.

Pause and resume a local ArcSDE service using sdemon

  1. To pause an ArcSDE service, type the sdemon command and specify the pause option.
  2. sdemon –o pause –p nevermind
    ArcSDE I/O Manager is paused, no further connections will be allowed

  3. To resume a paused ArcSDE service, type the sdemon command and specify the resume option.
  4. sdemon –o resume –p nevermind
    ArcSDE I/O Manager is Resuming, new connections will now be allowed

Tips

  • The sdemon command can be used to pause and resume a local ArcSDE service on both UNIX and Windows platforms.
  • Windows users must have power user or administrator group permissions to pause, resume, or shut down a local or remote ArcSDE service.
  • The ArcSDE Administration Command Reference is provided with ArcSDE. You can also download a PDF version of the file from the Geodatabase Resource Center.

Remotely pause and resume an ArcSDE service

On UNIX or Windows servers, use the sdemon command to remotely pause and resume an ArcSDE service by including the remote server and service name with the command options.

sdemon -o pause -p abc123 -s squirrel -i esri_sde

sdemon -o resume -p abc123 -s squirrel -i esri_sde

Tip

  • Windows users must have power user or administrator group permissions to pause, resume, or shut down a local or remote ArcSDE service.

See Also

  • Starting an ArcSDE service
  • Stopping an ArcSDE service