ArcGIS Server Banner

Removing ArcSDE service user processes

Removing ArcSDE service user processes

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

About removing ArcSDE user processes

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

Removing a user session with the sdemon command immediately disconnects the user. If the session is terminated before the user issues a COMMIT on a large transaction (the unit of work has not been saved in the database), all of the user's changes are lost. Removing a user session should be done as a last resort, such as when a user session is no longer responding to the application or when a user abnormally aborts an operation while processing a request and the process has hung.

The tasks you perform to remove ArcSDE sessions are the same on both Windows and UNIX. To terminate ArcSDE user processes, list all connected ArcSDE users with sdemon, locate the process identifier, use the sdemon command with the kill option to remove the process or processes, and check to see that the correct user processes were removed by listing the connected users again.

For details on how to use the sdemon administration command, consult the Administration Command Reference.

How to remove ArcSDE user processes

Remove a single ArcSDE user session

  1. Locate the PID for the ArcSDE session to be terminated with the sdemon command.
  2. sdemon –o info –I users 
    
ArcSDE Instance esri_sde Registered Server Tasks on lewis at Wed Jun 20 08:23:04 2007
    
PID 	User  		Host:OS 	  		Started
    
6942 	joe   		bingo:Win32:XDR 		Thu May 26 12:12:31
    10262 	happy 		b2c2:Win32:XDR  		Fri May 27 06:50:40
    10294	meyer 		empty:Win32:XDE 		Fri May 27 07:31:12

  3. Issue the sdemon command with the kill operation and the PID. When prompted, confirm that you want to kill the process by typing "y".
  4. sdemon –o kill –t 6942
    
Please enter ArcSDE DBA password:
    
ArcSDE Instance esri_sde Process Management on lewis at Wed Jun 20 08:23:41 2007
    
Kill Server Task 6942? ARE YOU SURE (Y/N)?:y

  5. Verify that the process has been terminated.
  6. $ sdemon –o info –I users
    
ArcSDE Instance esri_sde Registered Server Tasks on lewis at Wed Jun 20 08:24:00 2007
    
PID 	User 		Host:OS 			Started
    
10262 	happy 		b2c2:Win32:XDR  		Fri May 27 06:50:40
    10294	meyer 		empty:Win32:XDE 		Fri May 27 07:31:12

Remove all ArcSDE user sessions

  1. Type the sdemon –o command with the kill operation and -t all option.
  2. sdemon –o kill –t all

  3. Verify that all user processes have been terminated.
  4. sdemon –o info –I users 
    
ArcSDE Instance esri_sde Registered Server Tasks on lewis at Wed Jun 20 12:27:04 2007
    
PID 	User 		Host:OS 			Started
    
There are no ArcSDE users logged in.

See Also

  • Stopping an ArcSDE service