Displaying connected sessions
To discover what users are currently connected to the geodatabase, you can use the sdemon command with the info operation and the users or users_long option.
The syntax for this is as follows:
sdemon –o info –I {users | users_long} [-q] {[–i <service> | <port#>] [–s <server_name>] | [–H <sde_directory>]}
When you specify the users option, the sdemon –o info command returns the following information, with each returned row representing one connection:
- S-ID—The SDE-ID of the server
- S-PID—The operating system-level process ID of the server
- User—The name of the user under which the connection was made
- Conn—The type of connection; AS = ArcSDE service or DC = direct connection
- Client:OS—The name of the connecting client machine, the operating system it is running, and whether or not an external data representation (XDR) connection is used
- Started—The date and time the connection was initiated
When you specify the users_long option, the information is returned in a list per each connection. The following information is returned:
- Server task ID—The SDE-ID of the server
- Server task PID—The operating system-level process ID of the server
- Connection type—The type of connection: AppSrvr = ArcSDE service or Direct = direct connection
- User name—The name of the user under which the connection was made
- Client machine—The name of the connecting client machine
- Client OS—The operating system of the connecting client machine
- XDR—Indicates whether the client and server machines are of the same byte order (If they are the same, XDR = no; if they differ, XDR = yes.)
- Start time—The date and time the connection was initiated
Steps:
- Open an MS-DOS (Windows) or shell (UNIX or Linux) command prompt on a computer on which you have access to the ArcSDE administration commands.
-
Issue the sdemon command with the info operation and users or users_long option.
sdemon –o info –I users –i 6000 –s myserver S-ID S-PID User Conn Client:OS Started 546 68821 RJP AS hundehutte:Win32 Mon Oct 27 07:32:56 2008 547 44790 PERRITA DC halter:Win32:XDR Mon Oct 27 08:11:05 2008
sdemon –o info –I users_long –i 6000 –s myserver Server task ID: 546 Server task PID: 68821 Connection type: AppSrvr User name: RJP Client machine: hundehutte Client OS: Win32 XDR: no Start time: Mon Oct 27 07:32:56 2008 Server task ID: 547 Server task PID: 44790 Connection type: Direct User name: Perrita Client machine: halter Client OS: Win32 XDR: yes Start time: Mon Oct 27 08:11:05 2008
Tip:To see which users are connected to a geodatabase in a user's schema, you must specify the schema name with the -i option. For example, for a geodatabase in the schema maxp in the previous example, specify -i 6000:maxp.
8/19/2013