Can I kill Direct Connections using the sdemon -o kill command?


Yes, from ArcSDE 10.0 you can now use the sdemon command with the kill operation to drop direct connections to an ArcSDE geodatabases. In previous releases (9.3.1 and prior), the kill operation could only be used to drop ArcSDE service connections.

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

sdemon –o kill –t {all | <pid>} [–D <database_name>] [-s <datasource>]
-i <direct_connect_string> –u <user_name> –p <password>

The functionality of the DBMS is used to drop the direct connection. Thus, the database requires elevated permissions to perform this operation; therefore, the ArcSDE administrator (sde user) needs additional permissions granted to drop direct connections.

Please find below additional permissions needed per DBMS, by the sde user to kill direct connections to the geodatabase using the sdemon command.

Oracle:
ALTER SYSTEM
SELECT_CATALOG_ROLE

Alternatively, the sde user could be added to the DBA role to kill direct connections.

SQL Server:
The SDE user in an sde-schema geodatabase must be added to the processadmin fixed server role.

DB2:
DBADM authority
SYSMON authority – Add the ArcSDE administrator user to an operating system group and grant SYSMON to the group.
SYSCTRL or SYSADM authority

Informix
CONNECT to sysadmin

PostgreSQL:
Currently not supported.

Tania T.

2 thoughts on “Can I kill Direct Connections using the sdemon -o kill command?

  1. Kata Wallner

    Hi,

    I have an Oracle database and added SELECT_CATALOG_ROLE and ALTER SYSTEM to my SDE user but it still doesn’t let me to kill direct connections with sdemon utility. Could you please help?

    Thanks.
    Kata

    Reply
    1. Tania T Post author

      Hi Kate.
      What is the exact syntax and error message that your receive, when you run the sdemon -o kill command?

      Regards,
      Tania

      Reply

Got something to say?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s