Basic ArcSDE commands

Hi All,

Its been long time am writing a post on technical side. Yes, these days (actually months) were very busy with the current project.  Not enough time for personal work even. 😦 . OK. Let me share some basic ArcSDE commands that every developer should aware of.  As a GIS developer (or any developer/programmer) should know atleast one database. Though this is not a mandatory but in GIS context, knowing ArcSDE is very much essential. You cannot claim yourself a spatial developer (a.k.a ESRI Developer) if you are not knowing some basics of ArcSDE (in terms of ESRI).

I just wanted to write share the most useful and often used ArcSDE administration commands . Parameters embraced in <> are defined by user; so, if we have “<servicename>” that would result to “esri_sde”.

To show all SDE instances:

Sdeservice -o list

To show status of a specific sde instance including the number of accepting connections:

Sdemon -o status -i <servicename>

To show who is connected to an ArcSDE service:

Sdemon -o info -I users -i <servicename> -p <sdepassword>

To stop an sde service:

Sdemon -o shutdown -i <servicename> -p <sdepassword>

To start an sde service:

Sdemon -o start -i <servicename> -p <sdepassword>

To start an sde service remotely:

sdemon -o start -p <sdepassword> -s <servername> -i <servicename>

NOTE: ArcSDE administrator should be in the Windows admins group/power users group on the remote server.

To kill all connections to an sde service:

Sdemon -o kill -t all -i <servicename>

To kill a direct connect to an sde database:

Ths can be done either by restarting SQL Server database engine or by using SQL Server Activity Monitor, tracing the locked processes, and killing those processes. These things are being done on the SQL Server level, because direct connection has nothing to do with sde services – all users connect directly to the SQL Server database engine bypassing sde.

To shut down a stalled giomgr process (go to %sdehome%\tools and then run):

Killp <giomgr_process_ID>

NOTE: Process ID (PID) can be seen in the Windows Task Manager. Click Select Columns button on the Processes tab from the View menu. Then select properties you want to appear as column headings and then click OK.

To get list of layers and their properties from a specific sde service:

Sdelayer -o describe -i <servicename>

To get the list of current locks for a certain sde service:

sdemon -o info -I locks -i <servicename>

For further references : You can visit ESRI ArcSDE Manual  and many useful blogs like

http://bingluo.blogspot.com  [Spatial DBA] lot of useful tips and tracks.

Hope this helps you.

Advertisements

Tags: , ,

3 Responses to “Basic ArcSDE commands”

  1. satya Says:

    Very nice tips

  2. Jon Says:

    Thank you very much for putting this together, love this page. Got it bookmarked, always go back to it.

  3. Luciana Says:

    Hello,
    how to unlock a table ?

Leave a Reply

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


%d bloggers like this: